eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_REQ_DEL dependencies on PER_REQ_SHD

Line 52: (p_rec in per_req_shd.g_rec_type

48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml
52: (p_rec in per_req_shd.g_rec_type
53: ) is
54: --
55: l_proc varchar2(72) := g_package||'delete_dml';
56: --

Line 75: per_req_shd.constraint_error

71: Exception
72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated
74: --
75: per_req_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: --
79: Raise;

Line 114: Procedure pre_delete(p_rec in per_req_shd.g_rec_type) is

110: -- Internal Row Handler Use Only.
111: --
112: -- {End Of Comments}
113: -- ----------------------------------------------------------------------------
114: Procedure pre_delete(p_rec in per_req_shd.g_rec_type) is
115: --
116: l_proc varchar2(72) := g_package||'pre_delete';
117: --
118: Begin

Line 156: Procedure post_delete(p_rec in per_req_shd.g_rec_type) is

152: -- Internal Row Handler Use Only.
153: --
154: -- {End Of Comments}
155: -- -----------------------------------------------------------------------------
156: Procedure post_delete(p_rec in per_req_shd.g_rec_type) is
157: --
158: l_proc varchar2(72) := g_package||'post_delete';
159: --
160: Begin

Line 168: => per_req_shd.g_old_rec.business_group_id

164: per_req_rkd.after_delete
165: (p_requisition_id
166: => p_rec.requisition_id
167: ,p_business_group_id_o
168: => per_req_shd.g_old_rec.business_group_id
169: ,p_person_id_o
170: => per_req_shd.g_old_rec.person_id
171: ,p_date_from_o
172: => per_req_shd.g_old_rec.date_from

Line 170: => per_req_shd.g_old_rec.person_id

166: => p_rec.requisition_id
167: ,p_business_group_id_o
168: => per_req_shd.g_old_rec.business_group_id
169: ,p_person_id_o
170: => per_req_shd.g_old_rec.person_id
171: ,p_date_from_o
172: => per_req_shd.g_old_rec.date_from
173: ,p_name_o
174: => per_req_shd.g_old_rec.name

Line 172: => per_req_shd.g_old_rec.date_from

168: => per_req_shd.g_old_rec.business_group_id
169: ,p_person_id_o
170: => per_req_shd.g_old_rec.person_id
171: ,p_date_from_o
172: => per_req_shd.g_old_rec.date_from
173: ,p_name_o
174: => per_req_shd.g_old_rec.name
175: ,p_comments_o
176: => per_req_shd.g_old_rec.comments

Line 174: => per_req_shd.g_old_rec.name

170: => per_req_shd.g_old_rec.person_id
171: ,p_date_from_o
172: => per_req_shd.g_old_rec.date_from
173: ,p_name_o
174: => per_req_shd.g_old_rec.name
175: ,p_comments_o
176: => per_req_shd.g_old_rec.comments
177: ,p_date_to_o
178: => per_req_shd.g_old_rec.date_to

Line 176: => per_req_shd.g_old_rec.comments

172: => per_req_shd.g_old_rec.date_from
173: ,p_name_o
174: => per_req_shd.g_old_rec.name
175: ,p_comments_o
176: => per_req_shd.g_old_rec.comments
177: ,p_date_to_o
178: => per_req_shd.g_old_rec.date_to
179: ,p_description_o
180: => per_req_shd.g_old_rec.description

Line 178: => per_req_shd.g_old_rec.date_to

174: => per_req_shd.g_old_rec.name
175: ,p_comments_o
176: => per_req_shd.g_old_rec.comments
177: ,p_date_to_o
178: => per_req_shd.g_old_rec.date_to
179: ,p_description_o
180: => per_req_shd.g_old_rec.description
181: ,p_request_id_o
182: => per_req_shd.g_old_rec.request_id

Line 180: => per_req_shd.g_old_rec.description

176: => per_req_shd.g_old_rec.comments
177: ,p_date_to_o
178: => per_req_shd.g_old_rec.date_to
179: ,p_description_o
180: => per_req_shd.g_old_rec.description
181: ,p_request_id_o
182: => per_req_shd.g_old_rec.request_id
183: ,p_program_application_id_o
184: => per_req_shd.g_old_rec.program_application_id

Line 182: => per_req_shd.g_old_rec.request_id

178: => per_req_shd.g_old_rec.date_to
179: ,p_description_o
180: => per_req_shd.g_old_rec.description
181: ,p_request_id_o
182: => per_req_shd.g_old_rec.request_id
183: ,p_program_application_id_o
184: => per_req_shd.g_old_rec.program_application_id
185: ,p_program_id_o
186: => per_req_shd.g_old_rec.program_id

Line 184: => per_req_shd.g_old_rec.program_application_id

180: => per_req_shd.g_old_rec.description
181: ,p_request_id_o
182: => per_req_shd.g_old_rec.request_id
183: ,p_program_application_id_o
184: => per_req_shd.g_old_rec.program_application_id
185: ,p_program_id_o
186: => per_req_shd.g_old_rec.program_id
187: ,p_program_update_date_o
188: => per_req_shd.g_old_rec.program_update_date

Line 186: => per_req_shd.g_old_rec.program_id

182: => per_req_shd.g_old_rec.request_id
183: ,p_program_application_id_o
184: => per_req_shd.g_old_rec.program_application_id
185: ,p_program_id_o
186: => per_req_shd.g_old_rec.program_id
187: ,p_program_update_date_o
188: => per_req_shd.g_old_rec.program_update_date
189: ,p_attribute_category_o
190: => per_req_shd.g_old_rec.attribute_category

Line 188: => per_req_shd.g_old_rec.program_update_date

184: => per_req_shd.g_old_rec.program_application_id
185: ,p_program_id_o
186: => per_req_shd.g_old_rec.program_id
187: ,p_program_update_date_o
188: => per_req_shd.g_old_rec.program_update_date
189: ,p_attribute_category_o
190: => per_req_shd.g_old_rec.attribute_category
191: ,p_attribute1_o
192: => per_req_shd.g_old_rec.attribute1

Line 190: => per_req_shd.g_old_rec.attribute_category

186: => per_req_shd.g_old_rec.program_id
187: ,p_program_update_date_o
188: => per_req_shd.g_old_rec.program_update_date
189: ,p_attribute_category_o
190: => per_req_shd.g_old_rec.attribute_category
191: ,p_attribute1_o
192: => per_req_shd.g_old_rec.attribute1
193: ,p_attribute2_o
194: => per_req_shd.g_old_rec.attribute2

Line 192: => per_req_shd.g_old_rec.attribute1

188: => per_req_shd.g_old_rec.program_update_date
189: ,p_attribute_category_o
190: => per_req_shd.g_old_rec.attribute_category
191: ,p_attribute1_o
192: => per_req_shd.g_old_rec.attribute1
193: ,p_attribute2_o
194: => per_req_shd.g_old_rec.attribute2
195: ,p_attribute3_o
196: => per_req_shd.g_old_rec.attribute3

Line 194: => per_req_shd.g_old_rec.attribute2

190: => per_req_shd.g_old_rec.attribute_category
191: ,p_attribute1_o
192: => per_req_shd.g_old_rec.attribute1
193: ,p_attribute2_o
194: => per_req_shd.g_old_rec.attribute2
195: ,p_attribute3_o
196: => per_req_shd.g_old_rec.attribute3
197: ,p_attribute4_o
198: => per_req_shd.g_old_rec.attribute4

Line 196: => per_req_shd.g_old_rec.attribute3

192: => per_req_shd.g_old_rec.attribute1
193: ,p_attribute2_o
194: => per_req_shd.g_old_rec.attribute2
195: ,p_attribute3_o
196: => per_req_shd.g_old_rec.attribute3
197: ,p_attribute4_o
198: => per_req_shd.g_old_rec.attribute4
199: ,p_attribute5_o
200: => per_req_shd.g_old_rec.attribute5

Line 198: => per_req_shd.g_old_rec.attribute4

194: => per_req_shd.g_old_rec.attribute2
195: ,p_attribute3_o
196: => per_req_shd.g_old_rec.attribute3
197: ,p_attribute4_o
198: => per_req_shd.g_old_rec.attribute4
199: ,p_attribute5_o
200: => per_req_shd.g_old_rec.attribute5
201: ,p_attribute6_o
202: => per_req_shd.g_old_rec.attribute6

Line 200: => per_req_shd.g_old_rec.attribute5

196: => per_req_shd.g_old_rec.attribute3
197: ,p_attribute4_o
198: => per_req_shd.g_old_rec.attribute4
199: ,p_attribute5_o
200: => per_req_shd.g_old_rec.attribute5
201: ,p_attribute6_o
202: => per_req_shd.g_old_rec.attribute6
203: ,p_attribute7_o
204: => per_req_shd.g_old_rec.attribute7

Line 202: => per_req_shd.g_old_rec.attribute6

198: => per_req_shd.g_old_rec.attribute4
199: ,p_attribute5_o
200: => per_req_shd.g_old_rec.attribute5
201: ,p_attribute6_o
202: => per_req_shd.g_old_rec.attribute6
203: ,p_attribute7_o
204: => per_req_shd.g_old_rec.attribute7
205: ,p_attribute8_o
206: => per_req_shd.g_old_rec.attribute8

Line 204: => per_req_shd.g_old_rec.attribute7

200: => per_req_shd.g_old_rec.attribute5
201: ,p_attribute6_o
202: => per_req_shd.g_old_rec.attribute6
203: ,p_attribute7_o
204: => per_req_shd.g_old_rec.attribute7
205: ,p_attribute8_o
206: => per_req_shd.g_old_rec.attribute8
207: ,p_attribute9_o
208: => per_req_shd.g_old_rec.attribute9

Line 206: => per_req_shd.g_old_rec.attribute8

202: => per_req_shd.g_old_rec.attribute6
203: ,p_attribute7_o
204: => per_req_shd.g_old_rec.attribute7
205: ,p_attribute8_o
206: => per_req_shd.g_old_rec.attribute8
207: ,p_attribute9_o
208: => per_req_shd.g_old_rec.attribute9
209: ,p_attribute10_o
210: => per_req_shd.g_old_rec.attribute10

Line 208: => per_req_shd.g_old_rec.attribute9

204: => per_req_shd.g_old_rec.attribute7
205: ,p_attribute8_o
206: => per_req_shd.g_old_rec.attribute8
207: ,p_attribute9_o
208: => per_req_shd.g_old_rec.attribute9
209: ,p_attribute10_o
210: => per_req_shd.g_old_rec.attribute10
211: ,p_attribute11_o
212: => per_req_shd.g_old_rec.attribute11

Line 210: => per_req_shd.g_old_rec.attribute10

206: => per_req_shd.g_old_rec.attribute8
207: ,p_attribute9_o
208: => per_req_shd.g_old_rec.attribute9
209: ,p_attribute10_o
210: => per_req_shd.g_old_rec.attribute10
211: ,p_attribute11_o
212: => per_req_shd.g_old_rec.attribute11
213: ,p_attribute12_o
214: => per_req_shd.g_old_rec.attribute12

Line 212: => per_req_shd.g_old_rec.attribute11

208: => per_req_shd.g_old_rec.attribute9
209: ,p_attribute10_o
210: => per_req_shd.g_old_rec.attribute10
211: ,p_attribute11_o
212: => per_req_shd.g_old_rec.attribute11
213: ,p_attribute12_o
214: => per_req_shd.g_old_rec.attribute12
215: ,p_attribute13_o
216: => per_req_shd.g_old_rec.attribute13

Line 214: => per_req_shd.g_old_rec.attribute12

210: => per_req_shd.g_old_rec.attribute10
211: ,p_attribute11_o
212: => per_req_shd.g_old_rec.attribute11
213: ,p_attribute12_o
214: => per_req_shd.g_old_rec.attribute12
215: ,p_attribute13_o
216: => per_req_shd.g_old_rec.attribute13
217: ,p_attribute14_o
218: => per_req_shd.g_old_rec.attribute14

Line 216: => per_req_shd.g_old_rec.attribute13

212: => per_req_shd.g_old_rec.attribute11
213: ,p_attribute12_o
214: => per_req_shd.g_old_rec.attribute12
215: ,p_attribute13_o
216: => per_req_shd.g_old_rec.attribute13
217: ,p_attribute14_o
218: => per_req_shd.g_old_rec.attribute14
219: ,p_attribute15_o
220: => per_req_shd.g_old_rec.attribute15

Line 218: => per_req_shd.g_old_rec.attribute14

214: => per_req_shd.g_old_rec.attribute12
215: ,p_attribute13_o
216: => per_req_shd.g_old_rec.attribute13
217: ,p_attribute14_o
218: => per_req_shd.g_old_rec.attribute14
219: ,p_attribute15_o
220: => per_req_shd.g_old_rec.attribute15
221: ,p_attribute16_o
222: => per_req_shd.g_old_rec.attribute16

Line 220: => per_req_shd.g_old_rec.attribute15

216: => per_req_shd.g_old_rec.attribute13
217: ,p_attribute14_o
218: => per_req_shd.g_old_rec.attribute14
219: ,p_attribute15_o
220: => per_req_shd.g_old_rec.attribute15
221: ,p_attribute16_o
222: => per_req_shd.g_old_rec.attribute16
223: ,p_attribute17_o
224: => per_req_shd.g_old_rec.attribute17

Line 222: => per_req_shd.g_old_rec.attribute16

218: => per_req_shd.g_old_rec.attribute14
219: ,p_attribute15_o
220: => per_req_shd.g_old_rec.attribute15
221: ,p_attribute16_o
222: => per_req_shd.g_old_rec.attribute16
223: ,p_attribute17_o
224: => per_req_shd.g_old_rec.attribute17
225: ,p_attribute18_o
226: => per_req_shd.g_old_rec.attribute18

Line 224: => per_req_shd.g_old_rec.attribute17

220: => per_req_shd.g_old_rec.attribute15
221: ,p_attribute16_o
222: => per_req_shd.g_old_rec.attribute16
223: ,p_attribute17_o
224: => per_req_shd.g_old_rec.attribute17
225: ,p_attribute18_o
226: => per_req_shd.g_old_rec.attribute18
227: ,p_attribute19_o
228: => per_req_shd.g_old_rec.attribute19

Line 226: => per_req_shd.g_old_rec.attribute18

222: => per_req_shd.g_old_rec.attribute16
223: ,p_attribute17_o
224: => per_req_shd.g_old_rec.attribute17
225: ,p_attribute18_o
226: => per_req_shd.g_old_rec.attribute18
227: ,p_attribute19_o
228: => per_req_shd.g_old_rec.attribute19
229: ,p_attribute20_o
230: => per_req_shd.g_old_rec.attribute20

Line 228: => per_req_shd.g_old_rec.attribute19

224: => per_req_shd.g_old_rec.attribute17
225: ,p_attribute18_o
226: => per_req_shd.g_old_rec.attribute18
227: ,p_attribute19_o
228: => per_req_shd.g_old_rec.attribute19
229: ,p_attribute20_o
230: => per_req_shd.g_old_rec.attribute20
231: ,p_object_version_number_o
232: => per_req_shd.g_old_rec.object_version_number

Line 230: => per_req_shd.g_old_rec.attribute20

226: => per_req_shd.g_old_rec.attribute18
227: ,p_attribute19_o
228: => per_req_shd.g_old_rec.attribute19
229: ,p_attribute20_o
230: => per_req_shd.g_old_rec.attribute20
231: ,p_object_version_number_o
232: => per_req_shd.g_old_rec.object_version_number
233: );
234: --

Line 232: => per_req_shd.g_old_rec.object_version_number

228: => per_req_shd.g_old_rec.attribute19
229: ,p_attribute20_o
230: => per_req_shd.g_old_rec.attribute20
231: ,p_object_version_number_o
232: => per_req_shd.g_old_rec.object_version_number
233: );
234: --
235: exception
236: --

Line 252: (p_rec in per_req_shd.g_rec_type

248: -- ----------------------------------------------------------------------------
249: -- |---------------------------------< del >----------------------------------|
250: -- ----------------------------------------------------------------------------
251: Procedure del
252: (p_rec in per_req_shd.g_rec_type
253: ) is
254: --
255: l_proc varchar2(72) := g_package||'del';
256: --

Line 262: per_req_shd.lck

258: hr_utility.set_location('Entering:'||l_proc, 5);
259: --
260: -- We must lock the row which we need to delete.
261: --
262: per_req_shd.lck
263: (p_rec.requisition_id
264: ,p_rec.object_version_number
265: );
266: --

Line 293: l_rec per_req_shd.g_rec_type;

289: (p_requisition_id in number
290: ,p_object_version_number in number
291: ) is
292: --
293: l_rec per_req_shd.g_rec_type;
294: l_proc varchar2(72) := g_package||'del';
295: --
296: Begin
297: hr_utility.set_location('Entering:'||l_proc, 5);