DBA Data[Home] [Help]

APPS.ZX_VTX_USER_PKG dependencies on OE_SYS_PARAMETERS

Line 1631: l_master_org_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID', l_org_id);

1627: IF MO_GLOBAL.get_current_org_id <> nvl(l_org_id, -1) THEN
1628: MO_GLOBAL.Set_Policy_Context('S', l_org_id);
1629: END IF;
1630: */
1631: l_master_org_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID', l_org_id);
1632:
1633: BEGIN
1634: SELECT segment1
1635: INTO arp_product_code_tab(i)

Line 1920: l_master_org_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID', l_org_id);

1916: IF MO_GLOBAL.get_current_org_id <> nvl(l_org_id, -1) THEN
1917: MO_GLOBAL.Set_Policy_Context('S', l_org_id);
1918: END IF;
1919: */
1920: l_master_org_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID', l_org_id);
1921:
1922: SELECT lc.loc_information13,lc.loc_information14
1923: INTO l_sfr_geocode,l_sfr_in_out_flag
1924: FROM hr_locations_all lc, hr_organization_units hr