DBA Data[Home] [Help]

APPS.ZX_VTX_USER_PKG dependencies on OE_SYS_PARAMETERS

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

1773: IF MO_GLOBAL.get_current_org_id <> nvl(l_org_id, -1) THEN
1774: MO_GLOBAL.Set_Policy_Context('S', l_org_id);
1775: END IF;
1776: */
1777: l_master_org_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID', l_org_id);
1778:
1779: BEGIN
1780: SELECT segment1
1781: INTO arp_product_code_tab(i)

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

2066: IF MO_GLOBAL.get_current_org_id <> nvl(l_org_id, -1) THEN
2067: MO_GLOBAL.Set_Policy_Context('S', l_org_id);
2068: END IF;
2069: */
2070: l_master_org_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID', l_org_id);
2071:
2072: SELECT lc.loc_information13,lc.loc_information14
2073: INTO l_sfr_geocode,l_sfr_in_out_flag
2074: FROM hr_locations_all lc, hr_organization_units hr