APPS.HR_LOCATIONS_PKG dependencies on HR_LOCATIONS

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 196: from hr_locations l

192: v_location_id number;
193: --
194: cursor csr_location_exists is
195: SELECT l.location_id
196: from hr_locations l
197: where upper(l.location_code) = upper(p_location_code)
198: and (l.location_id <> p_location_id or
199: p_location_id is null)
200: AND (l.inventory_organization_id = p_inventory_organization_id

Line 304: CURSOR C IS SELECT rowid FROM hr_locations

300: X_Loc_Information18 VARCHAR2,
301: X_Loc_Information19 VARCHAR2,
302: X_Loc_Information20 VARCHAR2
303: ) IS
304: CURSOR C IS SELECT rowid FROM hr_locations
305: WHERE location_id = X_Location_Id;
306: --
307: CURSOR C2 IS SELECT hr_locations_s.nextval FROM sys.dual;
308: BEGIN

Line 307: CURSOR C2 IS SELECT hr_locations_s.nextval FROM sys.dual;

303: ) IS
304: CURSOR C IS SELECT rowid FROM hr_locations
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,

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 325: INSERT INTO hr_locations(

321: X_Location_Id,
322: X_Ship_To_Location_Id,
323: X_Location_Code);
324: --
325: INSERT INTO hr_locations(
326: location_id,
327: entered_by,
328: location_code,
329: address_line_1,

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 578: FROM hr_locations

574: X_Loc_Information20 VARCHAR2
575: ) IS
576: CURSOR C IS
577: SELECT *
578: FROM hr_locations
579: WHERE rowid = chartorowid(X_Rowid)
580: FOR UPDATE of Location_Id NOWAIT;
581: Recinfo C%ROWTYPE;
582: BEGIN

Line 1005: UPDATE hr_locations

1001: X_Location_Id,
1002: X_Ship_To_Location_Id,
1003: X_Location_Code);
1004: --
1005: UPDATE hr_locations
1006: SET
1007: location_id = X_Location_Id,
1008: entered_by = X_Entered_By,
1009: location_code = X_Location_Code,

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;