[Home] [Help]
TRIGGER: APPS.JL_BR_AR_BANK_TRANS_STORE_VARS
Source
Description
JL_BR_AR_BANK_TRANS_STORE_VARS
AFTER INSERT ON jl_br_ar_ret_interface_all
FOR EACH ROW
Type
AFTER EACH ROW
Event
INSERT
Column
When
((sys_context('JG','JGZZ_COUNTRY_CODE') in ('BR')) OR
(to_char(new.org_id) <> nvl(sys_context('JG','JGZZ_ORG_ID'),'XX')))
AND new.register_type = 0
Referencing
REFERENCING NEW AS NEW OLD AS OLD
Body
DECLARE
l_country_code VARCHAR2(100);
BEGIN
IF (to_char(:new.org_id) <> nvl(sys_context('JG','JGZZ_ORG_ID'),'XX')) THEN
l_country_code := JG_ZZ_SHARED_PKG.GET_COUNTRY(:new.org_id,NULL,NULL);
JG_CONTEXT.name_value('JGZZ_COUNTRY_CODE',l_country_code);
JG_CONTEXT.name_value('JGZZ_ORG_ID',to_char(:new.org_id));
END IF;
IF (sys_context('JG','JGZZ_COUNTRY_CODE') = 'BR') THEN
JL_BR_AR_VARIABLES.company_code := :new.company_code;
JL_BR_AR_VARIABLES.company_name := :new.company_name;
JL_BR_AR_VARIABLES.generation_date := :new.generation_date;
JL_BR_AR_VARIABLES.bank_number := :new.bank_number;
END IF;
END;