APPS.PER_REQUISITIONS_PKG dependencies on PER_REQUISITIONS

Line 1: PACKAGE BODY PER_REQUISITIONS_PKG as

1: PACKAGE BODY PER_REQUISITIONS_PKG as
2: /* $Header: pereq01t.pkb 115.3 2003/01/27 15:53:35 irgonzal ship $ */
3: --
4: /* +======================================================================+
5: | Copyright (c) 1993 Oracle Corporation |

Line 10: PER_REQUISITIONS_PKG

6: | Redwood Shores, California, USA |
7: | All rights reserved. |
8: +=======================================================================
9: Name
10: PER_REQUISITIONS_PKG
11: Purpose
12: Supports the REQUISITION block in the form PERWSVAC (Define Requisition
13: and Vacancy).
14: Notes

Line 44: FROM per_requisitions r

40: P_rowid VARCHAR2) IS
41:
42: CURSOR name_exists IS
43: SELECT 1
44: FROM per_requisitions r
45: WHERE r.NAME = p_Name
46: AND r.business_group_id + 0 = P_business_group_id
47: AND (P_rowid <> r.rowid
48: or P_rowid is NULL);

Line 193: PER_REQUISITIONS PR

189:
190: CURSOR C_check_references IS
191: SELECT PR.NAME
192: FROM PER_VACANCIES PV,
193: PER_REQUISITIONS PR
194: WHERE PV.REQUISITION_ID = P_requisition_id
195: AND PR.REQUISITION_ID = P_requisition_id
196: AND PR.business_group_id + 0 = P_Business_group_id
197: AND PV.business_group_id + 0 = P_Business_group_id;

Line 248: FROM PER_REQUISITIONS

244: X_Attribute19 VARCHAR2,
245: X_Attribute20 VARCHAR2)
246: IS
247: CURSOR C IS SELECT rowid
248: FROM PER_REQUISITIONS
249: WHERE requisition_id = X_Requisition_Id;
250: --
251: CURSOR C2 IS SELECT per_requisitions_s.nextval
252: FROM sys.dual;

Line 251: CURSOR C2 IS SELECT per_requisitions_s.nextval

247: CURSOR C IS SELECT rowid
248: FROM PER_REQUISITIONS
249: WHERE requisition_id = X_Requisition_Id;
250: --
251: CURSOR C2 IS SELECT per_requisitions_s.nextval
252: FROM sys.dual;
253: BEGIN
254:
255: if (X_Requisition_Id is NULL) then

Line 260: INSERT INTO PER_REQUISITIONS

256: OPEN C2;
257: FETCH C2 INTO X_Requisition_Id;
258: CLOSE C2;
259: end if;
260: INSERT INTO PER_REQUISITIONS
261: ( requisition_id,
262: business_group_id,
263: person_id,
264: date_from,

Line 327: 'per_requisitions_pkg.insert_row');

323: if (C%NOTFOUND) then
324: CLOSE C;
325: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
326: hr_utility.set_message_token('PROCEDURE',
327: 'per_requisitions_pkg.insert_row');
328: hr_utility.set_message_token('STEP','1');
329: hr_utility.raise_error;
330: end if;
331: CLOSE C;

Line 378: FROM PER_REQUISITIONS

374: X_Attribute20 VARCHAR2)
375: IS
376: CURSOR C IS
377: SELECT *
378: FROM PER_REQUISITIONS
379: WHERE rowid = X_Rowid
380: FOR UPDATE of Requisition_Id NOWAIT;
381: Recinfo C%ROWTYPE;
382:

Line 562: UPDATE PER_REQUISITIONS

558: X_Attribute20 VARCHAR2)
559:
560: IS
561: BEGIN
562: UPDATE PER_REQUISITIONS
563: SET
564: requisition_id = X_Requisition_Id,
565: business_group_id = X_Business_Group_Id,
566: person_id = X_Person_Id,

Line 598: 'per_requisitions_pkg.update_row');

594:
595: if (SQL%NOTFOUND) then
596: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
597: hr_utility.set_message_token('PROCEDURE',
598: 'per_requisitions_pkg.update_row');
599: hr_utility.set_message_token('STEP','1');
600: hr_utility.raise_error;
601: end if;
602:

Line 619: DELETE FROM PER_REQUISITIONS

615: -----------------------------------------------------------------------------
616: --
617: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
618: BEGIN
619: DELETE FROM PER_REQUISITIONS
620: WHERE rowid = X_Rowid;
621:
622: if (SQL%NOTFOUND) then
623: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 625: 'per_requisitions_pkg.delete_row');

621:
622: if (SQL%NOTFOUND) then
623: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
624: hr_utility.set_message_token('PROCEDURE',
625: 'per_requisitions_pkg.delete_row');
626: hr_utility.set_message_token('STEP','1');
627: hr_utility.raise_error;
628: end if;
629: END Delete_Row;

Line 631: END PER_REQUISITIONS_PKG;

627: hr_utility.raise_error;
628: end if;
629: END Delete_Row;
630:
631: END PER_REQUISITIONS_PKG;