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:
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:
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.
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: