APPS.PAY_US_INS_ORG_INFO_PKG dependencies on PAY_US_INS_ORG_INFO_PKG

Line 1: PACKAGE BODY pay_us_ins_org_info_pkg AS

1: PACKAGE BODY pay_us_ins_org_info_pkg AS
2: /* $Header: pyusiorg.pkb 115.1 99/07/17 06:44:44 porting shi $ */
3: FUNCTION insert_org_information
4: ( P_ORGANIZATION_ID NUMBER
5: ,P_ORG_INFORMATION_CONTEXT VARCHAR2

Line 40: hr_utility.set_location('pay_us_ins_org_info_pkg.insert_org_information',1);

36: begin
37: --
38: hr_utility.trace('Entered insert_org_information');
39: --
40: hr_utility.set_location('pay_us_ins_org_info_pkg.insert_org_information',1);
41: if p_organization_id IS NULL
42: OR p_org_information_context IS NULL
43: OR p_org_information1 IS NULL
44: then

Line 51: hr_utility.set_location('pay_us_ins_org_info_pkg.insert_org_information',5);

47: hr_utility.set_message_token('STEP','1');
48: hr_utility.raise_error;
49: end if;
50: --
51: hr_utility.set_location('pay_us_ins_org_info_pkg.insert_org_information',5);
52: SELECT organization_id
53: INTO l_organization_id
54: FROM hr_all_organization_units
55: WHERE organization_id = p_organization_id;

Line 57: hr_utility.set_location('pay_us_ins_org_info_pkg.insert_org_information',8);

53: INTO l_organization_id
54: FROM hr_all_organization_units
55: WHERE organization_id = p_organization_id;
56: --
57: hr_utility.set_location('pay_us_ins_org_info_pkg.insert_org_information',8);
58: if p_org_information_context = 'CLASS' then
59: SELECT lookup_code
60: INTO l_org_information1
61: FROM hr_lookups

Line 77: hr_utility.set_location('pay_us_ins_org_info_pkg.insert_org_information',10);

73: hr_utility.trace('p_org_information_context '||p_org_information_context);
74: hr_utility.trace('l_organization_id '||to_char(l_organization_id));
75: --
76: --
77: hr_utility.set_location('pay_us_ins_org_info_pkg.insert_org_information',10);
78: SELECT 'x' INTO l_dummy from dual;
79: -- SELECT oit.org_information_type
80: -- INTO l_org_information_type
81: -- FROM hr_organization_information hoi

Line 102: hr_utility.set_location('pay_us_ins_org_info_pkg.insert_org_information',15);

98: --
99: end if;
100: --
101: begin
102: hr_utility.set_location('pay_us_ins_org_info_pkg.insert_org_information',15);
103: SELECT 'Y'
104: INTO l_check
105: FROM hr_organization_information
106: WHERE organization_id = l_organization_id

Line 120: hr_utility.set_location('pay_us_ins_org_info_pkg.insert_org_information',20);

116: --
117: exception when NO_DATA_FOUND then null;
118: end;
119: --
120: hr_utility.set_location('pay_us_ins_org_info_pkg.insert_org_information',20);
121: SELECT hr_organization_information_s.nextval
122: INTO l_org_information_id
123: FROM sys.dual;
124: --

Line 131: hr_utility.set_location('pay_us_ins_org_info_pkg.insert_org_information',25);

127: hr_utility.trace('l_organization_id is ' || to_char(l_organization_id));
128: hr_utility.trace('l_org_information1 is ' || l_org_information1);
129: hr_utility.trace('l_org_information_type is ' || l_org_information_type);
130: hr_utility.trace('l_check is ' || l_check);
131: hr_utility.set_location('pay_us_ins_org_info_pkg.insert_org_information',25);
132: INSERT INTO HR_ORGANIZATION_INFORMATION
133: (org_information_id
134: ,organization_id
135: ,attribute_category

Line 194: hr_utility.set_location('pay_us_ins_org_info_pkg.insert_org_information',30);

190: ,hou.creation_date
191: FROM hr_organization_units hou
192: WHERE hou.organization_id = p_organization_id;
193: --
194: hr_utility.set_location('pay_us_ins_org_info_pkg.insert_org_information',30);
195: hr_utility.trace('before return');
196: return l_org_information_id;
197: hr_utility.trace('after return');
198: --

Line 203: end pay_us_ins_org_info_pkg;

199: --
200: end insert_org_information;
201: --
202: --
203: end pay_us_ins_org_info_pkg;