10: IF (to_char(:new.org_id) <> nvl(sys_context('JG','JGZZ_ORG_ID'),'XX')) THEN
11:
12: l_country_code := JG_ZZ_SHARED_PKG.GET_COUNTRY(:new.org_id,NULL,NULL);
13:
14: JG_CONTEXT.name_value('JGZZ_COUNTRY_CODE',l_country_code);
15:
16: JG_CONTEXT.name_value('JGZZ_ORG_ID',to_char(:new.org_id));
17:
18: END IF;
12: l_country_code := JG_ZZ_SHARED_PKG.GET_COUNTRY(:new.org_id,NULL,NULL);
13:
14: JG_CONTEXT.name_value('JGZZ_COUNTRY_CODE',l_country_code);
15:
16: JG_CONTEXT.name_value('JGZZ_ORG_ID',to_char(:new.org_id));
17:
18: END IF;
19:
20: IF (sys_context('JG','JGZZ_COUNTRY_CODE') = 'BR') THEN