--created by Putra Soliman, 20 Juni 2016
CREATE OR REPLACE FUNCTION fs_create_master_document_custom_indocom(bigint,character varying)
  RETURNS VOID AS
$BODY$
DECLARE
    pUserId     ALIAS FOR $1;
    pDatetime   ALIAS FOR $2;
BEGIN
    PERFORM fs_create_master_document(pUserId,pDatetime);

    DELETE FROM t_combo_value WHERE combo_id = 'SCHEME' AND code_group IN ('rma');
    DELETE FROM t_combo_value WHERE combo_id = 'DOCACTIVITYGL' AND code_group IN ('rma');

    PERFORM fs_insert_doc_attribute(1011,'RA01','Return Merchandise Authorization','RA01','/org/jleaf/erp/rma/web/inputProductUsageForService.jsf','STOCK.ADJ.QTY','INV','rma', pDatetime, pUserId);
    PERFORM fs_insert_doc_attribute(377,'FA77','Sales Order From DGB','FA77','/org/jleaf/erp/sls/web/inputSalesOrderFromDgb.jsf','','','sls', pDatetime, pUserId);

    -- init data untuk combo constant PROCESSNAME dan REPROCESSNAME
    DELETE FROM t_combo_value WHERE combo_id IN ('PROCESSNAME','REPROCESSNAME') AND code_group IN ('rma');

    PERFORM fs_insert_combo_process_reprocess('sv_submit_product_usage_for_service', 'Submit Product Usage For Service', 'rma', pDatetime, pUserId);
    PERFORM fs_insert_combo_process_reprocess('sl_submit_so_from_dgb', 'Submit Sales Order From DGB', 'sls', pDatetime, pUserId);

    -- init combo value LINEQUEUE for ERP CUSTOM INDOCOM

    DELETE FROM t_combo_value WHERE combo_id = 'LINEQUEUE' AND code_group IN ('rma');

    INSERT INTO t_combo_value(combo_id, code, prop_key, code_group, sort_no, create_datetime, create_user_id, update_datetime, update_user_id, version)
    VALUES  ('LINEQUEUE','RmaLineQueue','RMA Line Queue','rma', f_get_next_sort_no_combo_value('LINEQUEUE'), pDatetime, pUserId, pDatetime, pUserId, 0);
END;
$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100;
  /