[Home] [Help]
PACKAGE: APPS.PER_REQUISITIONS_PKG
Source
1 PACKAGE PER_REQUISITIONS_PKG AUTHID CURRENT_USER as
2 /* $Header: pereq01t.pkh 115.1 2003/01/27 18:51:52 irgonzal ship $ */
3 --
4 /* +=======================================================================+
5 | Copyright (c) 1993 Oracle Corporation |
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 REquistion
13 and Vacancy).
14 Notes
15
16 History
17 13-Apr-94 H.Minton 40.0 Date created.
18 02-FEB-95 D.Kerr 70.4 Removed WHO columns
19
20 27-JAN-03 irgonzal 115.1 Fixed gscc errors.
21
22 =============================================================================*/
23 --
24 --
25 -----------------------------------------------------------------------------
26 -- Name --
27 -- Check_Unique_Name --
28 -- Purpose --
29 -- checks that the requisition name is unique. Called from the client --
30 -- side package REQUISITION_ITEMS from the procedure 'name'. Called --
31 -- on WHEN-VALIDATE-ITEM from Name. --
32 -- --
33 -----------------------------------------------------------------------------
34 --
35 PROCEDURE Check_Unique_Name(P_Name VARCHAR2,
36 P_Business_group_id NUMBER,
37 P_rowid VARCHAR2);
38 --
39 -----------------------------------------------------------------------------
40 --
41 -----------------------------------------------------------------------------
42 -- Name --
43 -- Chk_date_from --
44 -- Purpose --
45 -- checks that the requisition date_from is within the vacancy date_from --
46 -- for the same requisition_id. --
47 -----------------------------------------------------------------------------
48 --
49 PROCEDURE Chk_date_from(P_Date_from DATE,
50 P_Business_Group_Id NUMBER,
51 P_Requisition_Id NUMBER);
52 --
53 -----------------------------------------------------------------------------
54 -- Name --
55 -- Date_from_raised_by --
56 -- Purpose --
57 -- checks that the requisition date_from does not invalidate the person --
58 -- who raised the requisition. --
59 -----------------------------------------------------------------------------
60 --
61 PROCEDURE Date_from_raised_by(P_Person_id NUMBER,
62 P_Business_Group_Id NUMBER,
63 P_Date_from DATE);
64 -----------------------------------------------------------------------------
65 --
66 -----------------------------------------------------------------------------
67 -- Name --
68 -- Date_to_in_vac_dates --
69 -- Purpose --
70 -- checks that the requisition date_to does not invalidate the vacancy --
71 -- child records. --
72 -----------------------------------------------------------------------------
73 --
74 PROCEDURE Date_to_in_vac_dates(P_Requisition_id NUMBER,
75 P_Business_Group_Id NUMBER,
76 P_Date_to DATE);
77 -----------------------------------------------------------------------------
78 -- Name --
79 -- Check_References --
80 -- Purpose --
81 -- checks that deletes cannot take place of a requisition if --
82 -- there are any child vacancies.
83 -----------------------------------------------------------------------------
84 PROCEDURE Check_References(P_requisition_id NUMBER,
85 P_Business_group_id NUMBER);
86 --
87 ------------------------------------------------------------------------------
88 PROCEDURE Insert_Row(X_Rowid IN OUT nocopy VARCHAR2,
89 X_Requisition_Id IN OUT nocopy NUMBER,
90 X_Business_Group_Id NUMBER,
91 X_Person_Id NUMBER,
92 X_Date_From DATE,
93 X_Name VARCHAR2,
94 X_Comments VARCHAR2,
95 X_Date_To DATE,
96 X_Description VARCHAR2,
97 X_Attribute_Category VARCHAR2,
98 X_Attribute1 VARCHAR2,
99 X_Attribute2 VARCHAR2,
100 X_Attribute3 VARCHAR2,
101 X_Attribute4 VARCHAR2,
102 X_Attribute5 VARCHAR2,
103 X_Attribute6 VARCHAR2,
104 X_Attribute7 VARCHAR2,
105 X_Attribute8 VARCHAR2,
106 X_Attribute9 VARCHAR2,
107 X_Attribute10 VARCHAR2,
108 X_Attribute11 VARCHAR2,
109 X_Attribute12 VARCHAR2,
110 X_Attribute13 VARCHAR2,
111 X_Attribute14 VARCHAR2,
112 X_Attribute15 VARCHAR2,
113 X_Attribute16 VARCHAR2,
114 X_Attribute17 VARCHAR2,
115 X_Attribute18 VARCHAR2,
116 X_Attribute19 VARCHAR2,
117 X_Attribute20 VARCHAR2
118 );
119 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
120 X_Requisition_Id NUMBER,
121 X_Business_Group_Id NUMBER,
122 X_Person_Id NUMBER,
123 X_Date_From DATE,
124 X_Name VARCHAR2,
125 X_Comments VARCHAR2,
126 X_Date_To DATE,
127 X_Description VARCHAR2,
128 X_Attribute_Category VARCHAR2,
129 X_Attribute1 VARCHAR2,
130 X_Attribute2 VARCHAR2,
131 X_Attribute3 VARCHAR2,
132 X_Attribute4 VARCHAR2,
133 X_Attribute5 VARCHAR2,
134 X_Attribute6 VARCHAR2,
135 X_Attribute7 VARCHAR2,
136 X_Attribute8 VARCHAR2,
137 X_Attribute9 VARCHAR2,
138 X_Attribute10 VARCHAR2,
139 X_Attribute11 VARCHAR2,
140 X_Attribute12 VARCHAR2,
141 X_Attribute13 VARCHAR2,
142 X_Attribute14 VARCHAR2,
143 X_Attribute15 VARCHAR2,
144 X_Attribute16 VARCHAR2,
145 X_Attribute17 VARCHAR2,
146 X_Attribute18 VARCHAR2,
147 X_Attribute19 VARCHAR2,
148 X_Attribute20 VARCHAR2
149 );
150
151 PROCEDURE Update_Row(X_Rowid VARCHAR2,
152 X_Requisition_Id NUMBER,
153 X_Business_Group_Id NUMBER,
154 X_Person_Id NUMBER,
155 X_Date_From DATE,
156 X_Name VARCHAR2,
157 X_Comments VARCHAR2,
158 X_Date_To DATE,
159 X_Description VARCHAR2,
160 X_Attribute_Category VARCHAR2,
161 X_Attribute1 VARCHAR2,
162 X_Attribute2 VARCHAR2,
163 X_Attribute3 VARCHAR2,
164 X_Attribute4 VARCHAR2,
165 X_Attribute5 VARCHAR2,
166 X_Attribute6 VARCHAR2,
167 X_Attribute7 VARCHAR2,
168 X_Attribute8 VARCHAR2,
169 X_Attribute9 VARCHAR2,
170 X_Attribute10 VARCHAR2,
171 X_Attribute11 VARCHAR2,
172 X_Attribute12 VARCHAR2,
173 X_Attribute13 VARCHAR2,
174 X_Attribute14 VARCHAR2,
175 X_Attribute15 VARCHAR2,
176 X_Attribute16 VARCHAR2,
177 X_Attribute17 VARCHAR2,
178 X_Attribute18 VARCHAR2,
179 X_Attribute19 VARCHAR2,
180 X_Attribute20 VARCHAR2
181 );
182
183 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
184
185 END PER_REQUISITIONS_PKG;