DBA Data[Home] [Help]

APPS.OKC_CONTEXT dependencies on HR_OPERATING_UNITS

Line 41: l_default_org_id hr_operating_units.organization_id%TYPE;

37: **/
38:
39:
40: l_business_group_id NUMBER;
41: l_default_org_id hr_operating_units.organization_id%TYPE;
42: l_default_ou_name hr_operating_units.name%TYPE;
43: l_ou_count NUMBER;
44: l_org_id hr_operating_units.organization_id%TYPE;
45:

Line 42: l_default_ou_name hr_operating_units.name%TYPE;

38:
39:
40: l_business_group_id NUMBER;
41: l_default_org_id hr_operating_units.organization_id%TYPE;
42: l_default_ou_name hr_operating_units.name%TYPE;
43: l_ou_count NUMBER;
44: l_org_id hr_operating_units.organization_id%TYPE;
45:
46:

Line 44: l_org_id hr_operating_units.organization_id%TYPE;

40: l_business_group_id NUMBER;
41: l_default_org_id hr_operating_units.organization_id%TYPE;
42: l_default_ou_name hr_operating_units.name%TYPE;
43: l_ou_count NUMBER;
44: l_org_id hr_operating_units.organization_id%TYPE;
45:
46:
47: BEGIN
48: -- Sets the org_id to a context namespace attribute.

Line 131: l_org_id hr_operating_units.organization_id%TYPE;

127:
128: **/
129:
130: l_business_group_id NUMBER;
131: l_org_id hr_operating_units.organization_id%TYPE;
132:
133: BEGIN
134: DBMS_SESSION.SET_CONTEXT('OKC_CONTEXT','CHR_ID',p_chr_id); -- bug#2155926
135: