APPS.HR_LOCATIONS_PKG dependencies on HR_LOCATIONS_PKG

Line 1: PACKAGE BODY HR_LOCATIONS_PKG as

1: PACKAGE BODY HR_LOCATIONS_PKG as
2: /* $Header: peloc01t.pkb 115.5 2002/12/06 11:27:29 pkakar ship $ */
3:
4: /*-----------------------------------------------------------------------------
5: -- Name --

Line 157: hr_utility.set_location('hr_locations_pkg.get_start_data',1);

153: AND FDFC.ENABLED_FLAG = 'Y';
154: --
155: begin
156: --
157: hr_utility.set_location('hr_locations_pkg.get_start_data',1);
158: --
159: if p_resp_appl_id is not null then
160: open c4;
161: --

Line 168: hr_utility.set_location('hr_locations_pkg.get_start_data',2);

164: close c4;
165: --
166: end if;
167: --
168: hr_utility.set_location('hr_locations_pkg.get_start_data',2);
169: --
170: open c5;
171: --
172: fetch c5 into p_country,

Line 309: hr_locations_pkg.validate_insert_location

305: WHERE location_id = X_Location_Id;
306: --
307: CURSOR C2 IS SELECT hr_locations_s.nextval FROM sys.dual;
308: BEGIN
309: hr_locations_pkg.validate_insert_location
310: (X_Location_code,
311: X_Location_id,
312: X_Inventory_Organization_Id );
313: if (X_Location_Id is NULL) then

Line 494: 'hr_locations_pkg.insert_row');

490: if (C%NOTFOUND) then
491: CLOSE C;
492: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
493: hr_utility.set_message_token('PROCEDURE',
494: 'hr_locations_pkg.insert_row');
495: hr_utility.set_message_token('STEP','2');
496: hr_utility.raise_error;
497: end if;
498: CLOSE C;

Line 1089: 'hr_locations_pkg.update_row');

1085: --
1086: if (SQL%NOTFOUND) then
1087: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1088: hr_utility.set_message_token('PROCEDURE',
1089: 'hr_locations_pkg.update_row');
1090: hr_utility.set_message_token('STEP','1');
1091: hr_utility.raise_error;
1092: end if;
1093: --

Line 1096: END HR_LOCATIONS_PKG;

1092: end if;
1093: --
1094: END Update_Row;
1095: --
1096: END HR_LOCATIONS_PKG;