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.PQH_TJR_DEL dependencies on PQH_TJR_SHD

Line 52: (p_rec in pqh_tjr_shd.g_rec_type

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

Line 75: pqh_tjr_shd.constraint_error

71: Exception
72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated
74: --
75: pqh_tjr_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 pqh_tjr_shd.g_rec_type) is

110: -- Internal Row Handler Use Only.
111: --
112: -- {End Of Comments}
113: -- ----------------------------------------------------------------------------
114: Procedure pre_delete(p_rec in pqh_tjr_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 pqh_tjr_shd.g_rec_type) is

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

Line 168: => pqh_tjr_shd.g_old_rec.position_transaction_id

164: pqh_tjr_rkd.after_delete
165: (p_txn_job_requirement_id
166: => p_rec.txn_job_requirement_id
167: ,p_position_transaction_id_o
168: => pqh_tjr_shd.g_old_rec.position_transaction_id
169: ,p_job_requirement_id_o
170: => pqh_tjr_shd.g_old_rec.job_requirement_id
171: ,p_business_group_id_o
172: => pqh_tjr_shd.g_old_rec.business_group_id

Line 170: => pqh_tjr_shd.g_old_rec.job_requirement_id

166: => p_rec.txn_job_requirement_id
167: ,p_position_transaction_id_o
168: => pqh_tjr_shd.g_old_rec.position_transaction_id
169: ,p_job_requirement_id_o
170: => pqh_tjr_shd.g_old_rec.job_requirement_id
171: ,p_business_group_id_o
172: => pqh_tjr_shd.g_old_rec.business_group_id
173: ,p_analysis_criteria_id_o
174: => pqh_tjr_shd.g_old_rec.analysis_criteria_id

Line 172: => pqh_tjr_shd.g_old_rec.business_group_id

168: => pqh_tjr_shd.g_old_rec.position_transaction_id
169: ,p_job_requirement_id_o
170: => pqh_tjr_shd.g_old_rec.job_requirement_id
171: ,p_business_group_id_o
172: => pqh_tjr_shd.g_old_rec.business_group_id
173: ,p_analysis_criteria_id_o
174: => pqh_tjr_shd.g_old_rec.analysis_criteria_id
175: ,p_date_from_o
176: => pqh_tjr_shd.g_old_rec.date_from

Line 174: => pqh_tjr_shd.g_old_rec.analysis_criteria_id

170: => pqh_tjr_shd.g_old_rec.job_requirement_id
171: ,p_business_group_id_o
172: => pqh_tjr_shd.g_old_rec.business_group_id
173: ,p_analysis_criteria_id_o
174: => pqh_tjr_shd.g_old_rec.analysis_criteria_id
175: ,p_date_from_o
176: => pqh_tjr_shd.g_old_rec.date_from
177: ,p_date_to_o
178: => pqh_tjr_shd.g_old_rec.date_to

Line 176: => pqh_tjr_shd.g_old_rec.date_from

172: => pqh_tjr_shd.g_old_rec.business_group_id
173: ,p_analysis_criteria_id_o
174: => pqh_tjr_shd.g_old_rec.analysis_criteria_id
175: ,p_date_from_o
176: => pqh_tjr_shd.g_old_rec.date_from
177: ,p_date_to_o
178: => pqh_tjr_shd.g_old_rec.date_to
179: ,p_essential_o
180: => pqh_tjr_shd.g_old_rec.essential

Line 178: => pqh_tjr_shd.g_old_rec.date_to

174: => pqh_tjr_shd.g_old_rec.analysis_criteria_id
175: ,p_date_from_o
176: => pqh_tjr_shd.g_old_rec.date_from
177: ,p_date_to_o
178: => pqh_tjr_shd.g_old_rec.date_to
179: ,p_essential_o
180: => pqh_tjr_shd.g_old_rec.essential
181: ,p_job_id_o
182: => pqh_tjr_shd.g_old_rec.job_id

Line 180: => pqh_tjr_shd.g_old_rec.essential

176: => pqh_tjr_shd.g_old_rec.date_from
177: ,p_date_to_o
178: => pqh_tjr_shd.g_old_rec.date_to
179: ,p_essential_o
180: => pqh_tjr_shd.g_old_rec.essential
181: ,p_job_id_o
182: => pqh_tjr_shd.g_old_rec.job_id
183: ,p_object_version_number_o
184: => pqh_tjr_shd.g_old_rec.object_version_number

Line 182: => pqh_tjr_shd.g_old_rec.job_id

178: => pqh_tjr_shd.g_old_rec.date_to
179: ,p_essential_o
180: => pqh_tjr_shd.g_old_rec.essential
181: ,p_job_id_o
182: => pqh_tjr_shd.g_old_rec.job_id
183: ,p_object_version_number_o
184: => pqh_tjr_shd.g_old_rec.object_version_number
185: ,p_request_id_o
186: => pqh_tjr_shd.g_old_rec.request_id

Line 184: => pqh_tjr_shd.g_old_rec.object_version_number

180: => pqh_tjr_shd.g_old_rec.essential
181: ,p_job_id_o
182: => pqh_tjr_shd.g_old_rec.job_id
183: ,p_object_version_number_o
184: => pqh_tjr_shd.g_old_rec.object_version_number
185: ,p_request_id_o
186: => pqh_tjr_shd.g_old_rec.request_id
187: ,p_program_application_id_o
188: => pqh_tjr_shd.g_old_rec.program_application_id

Line 186: => pqh_tjr_shd.g_old_rec.request_id

182: => pqh_tjr_shd.g_old_rec.job_id
183: ,p_object_version_number_o
184: => pqh_tjr_shd.g_old_rec.object_version_number
185: ,p_request_id_o
186: => pqh_tjr_shd.g_old_rec.request_id
187: ,p_program_application_id_o
188: => pqh_tjr_shd.g_old_rec.program_application_id
189: ,p_program_id_o
190: => pqh_tjr_shd.g_old_rec.program_id

Line 188: => pqh_tjr_shd.g_old_rec.program_application_id

184: => pqh_tjr_shd.g_old_rec.object_version_number
185: ,p_request_id_o
186: => pqh_tjr_shd.g_old_rec.request_id
187: ,p_program_application_id_o
188: => pqh_tjr_shd.g_old_rec.program_application_id
189: ,p_program_id_o
190: => pqh_tjr_shd.g_old_rec.program_id
191: ,p_program_update_date_o
192: => pqh_tjr_shd.g_old_rec.program_update_date

Line 190: => pqh_tjr_shd.g_old_rec.program_id

186: => pqh_tjr_shd.g_old_rec.request_id
187: ,p_program_application_id_o
188: => pqh_tjr_shd.g_old_rec.program_application_id
189: ,p_program_id_o
190: => pqh_tjr_shd.g_old_rec.program_id
191: ,p_program_update_date_o
192: => pqh_tjr_shd.g_old_rec.program_update_date
193: ,p_attribute_category_o
194: => pqh_tjr_shd.g_old_rec.attribute_category

Line 192: => pqh_tjr_shd.g_old_rec.program_update_date

188: => pqh_tjr_shd.g_old_rec.program_application_id
189: ,p_program_id_o
190: => pqh_tjr_shd.g_old_rec.program_id
191: ,p_program_update_date_o
192: => pqh_tjr_shd.g_old_rec.program_update_date
193: ,p_attribute_category_o
194: => pqh_tjr_shd.g_old_rec.attribute_category
195: ,p_attribute1_o
196: => pqh_tjr_shd.g_old_rec.attribute1

Line 194: => pqh_tjr_shd.g_old_rec.attribute_category

190: => pqh_tjr_shd.g_old_rec.program_id
191: ,p_program_update_date_o
192: => pqh_tjr_shd.g_old_rec.program_update_date
193: ,p_attribute_category_o
194: => pqh_tjr_shd.g_old_rec.attribute_category
195: ,p_attribute1_o
196: => pqh_tjr_shd.g_old_rec.attribute1
197: ,p_attribute2_o
198: => pqh_tjr_shd.g_old_rec.attribute2

Line 196: => pqh_tjr_shd.g_old_rec.attribute1

192: => pqh_tjr_shd.g_old_rec.program_update_date
193: ,p_attribute_category_o
194: => pqh_tjr_shd.g_old_rec.attribute_category
195: ,p_attribute1_o
196: => pqh_tjr_shd.g_old_rec.attribute1
197: ,p_attribute2_o
198: => pqh_tjr_shd.g_old_rec.attribute2
199: ,p_attribute3_o
200: => pqh_tjr_shd.g_old_rec.attribute3

Line 198: => pqh_tjr_shd.g_old_rec.attribute2

194: => pqh_tjr_shd.g_old_rec.attribute_category
195: ,p_attribute1_o
196: => pqh_tjr_shd.g_old_rec.attribute1
197: ,p_attribute2_o
198: => pqh_tjr_shd.g_old_rec.attribute2
199: ,p_attribute3_o
200: => pqh_tjr_shd.g_old_rec.attribute3
201: ,p_attribute4_o
202: => pqh_tjr_shd.g_old_rec.attribute4

Line 200: => pqh_tjr_shd.g_old_rec.attribute3

196: => pqh_tjr_shd.g_old_rec.attribute1
197: ,p_attribute2_o
198: => pqh_tjr_shd.g_old_rec.attribute2
199: ,p_attribute3_o
200: => pqh_tjr_shd.g_old_rec.attribute3
201: ,p_attribute4_o
202: => pqh_tjr_shd.g_old_rec.attribute4
203: ,p_attribute5_o
204: => pqh_tjr_shd.g_old_rec.attribute5

Line 202: => pqh_tjr_shd.g_old_rec.attribute4

198: => pqh_tjr_shd.g_old_rec.attribute2
199: ,p_attribute3_o
200: => pqh_tjr_shd.g_old_rec.attribute3
201: ,p_attribute4_o
202: => pqh_tjr_shd.g_old_rec.attribute4
203: ,p_attribute5_o
204: => pqh_tjr_shd.g_old_rec.attribute5
205: ,p_attribute6_o
206: => pqh_tjr_shd.g_old_rec.attribute6

Line 204: => pqh_tjr_shd.g_old_rec.attribute5

200: => pqh_tjr_shd.g_old_rec.attribute3
201: ,p_attribute4_o
202: => pqh_tjr_shd.g_old_rec.attribute4
203: ,p_attribute5_o
204: => pqh_tjr_shd.g_old_rec.attribute5
205: ,p_attribute6_o
206: => pqh_tjr_shd.g_old_rec.attribute6
207: ,p_attribute7_o
208: => pqh_tjr_shd.g_old_rec.attribute7

Line 206: => pqh_tjr_shd.g_old_rec.attribute6

202: => pqh_tjr_shd.g_old_rec.attribute4
203: ,p_attribute5_o
204: => pqh_tjr_shd.g_old_rec.attribute5
205: ,p_attribute6_o
206: => pqh_tjr_shd.g_old_rec.attribute6
207: ,p_attribute7_o
208: => pqh_tjr_shd.g_old_rec.attribute7
209: ,p_attribute8_o
210: => pqh_tjr_shd.g_old_rec.attribute8

Line 208: => pqh_tjr_shd.g_old_rec.attribute7

204: => pqh_tjr_shd.g_old_rec.attribute5
205: ,p_attribute6_o
206: => pqh_tjr_shd.g_old_rec.attribute6
207: ,p_attribute7_o
208: => pqh_tjr_shd.g_old_rec.attribute7
209: ,p_attribute8_o
210: => pqh_tjr_shd.g_old_rec.attribute8
211: ,p_attribute9_o
212: => pqh_tjr_shd.g_old_rec.attribute9

Line 210: => pqh_tjr_shd.g_old_rec.attribute8

206: => pqh_tjr_shd.g_old_rec.attribute6
207: ,p_attribute7_o
208: => pqh_tjr_shd.g_old_rec.attribute7
209: ,p_attribute8_o
210: => pqh_tjr_shd.g_old_rec.attribute8
211: ,p_attribute9_o
212: => pqh_tjr_shd.g_old_rec.attribute9
213: ,p_attribute10_o
214: => pqh_tjr_shd.g_old_rec.attribute10

Line 212: => pqh_tjr_shd.g_old_rec.attribute9

208: => pqh_tjr_shd.g_old_rec.attribute7
209: ,p_attribute8_o
210: => pqh_tjr_shd.g_old_rec.attribute8
211: ,p_attribute9_o
212: => pqh_tjr_shd.g_old_rec.attribute9
213: ,p_attribute10_o
214: => pqh_tjr_shd.g_old_rec.attribute10
215: ,p_attribute11_o
216: => pqh_tjr_shd.g_old_rec.attribute11

Line 214: => pqh_tjr_shd.g_old_rec.attribute10

210: => pqh_tjr_shd.g_old_rec.attribute8
211: ,p_attribute9_o
212: => pqh_tjr_shd.g_old_rec.attribute9
213: ,p_attribute10_o
214: => pqh_tjr_shd.g_old_rec.attribute10
215: ,p_attribute11_o
216: => pqh_tjr_shd.g_old_rec.attribute11
217: ,p_attribute12_o
218: => pqh_tjr_shd.g_old_rec.attribute12

Line 216: => pqh_tjr_shd.g_old_rec.attribute11

212: => pqh_tjr_shd.g_old_rec.attribute9
213: ,p_attribute10_o
214: => pqh_tjr_shd.g_old_rec.attribute10
215: ,p_attribute11_o
216: => pqh_tjr_shd.g_old_rec.attribute11
217: ,p_attribute12_o
218: => pqh_tjr_shd.g_old_rec.attribute12
219: ,p_attribute13_o
220: => pqh_tjr_shd.g_old_rec.attribute13

Line 218: => pqh_tjr_shd.g_old_rec.attribute12

214: => pqh_tjr_shd.g_old_rec.attribute10
215: ,p_attribute11_o
216: => pqh_tjr_shd.g_old_rec.attribute11
217: ,p_attribute12_o
218: => pqh_tjr_shd.g_old_rec.attribute12
219: ,p_attribute13_o
220: => pqh_tjr_shd.g_old_rec.attribute13
221: ,p_attribute14_o
222: => pqh_tjr_shd.g_old_rec.attribute14

Line 220: => pqh_tjr_shd.g_old_rec.attribute13

216: => pqh_tjr_shd.g_old_rec.attribute11
217: ,p_attribute12_o
218: => pqh_tjr_shd.g_old_rec.attribute12
219: ,p_attribute13_o
220: => pqh_tjr_shd.g_old_rec.attribute13
221: ,p_attribute14_o
222: => pqh_tjr_shd.g_old_rec.attribute14
223: ,p_attribute15_o
224: => pqh_tjr_shd.g_old_rec.attribute15

Line 222: => pqh_tjr_shd.g_old_rec.attribute14

218: => pqh_tjr_shd.g_old_rec.attribute12
219: ,p_attribute13_o
220: => pqh_tjr_shd.g_old_rec.attribute13
221: ,p_attribute14_o
222: => pqh_tjr_shd.g_old_rec.attribute14
223: ,p_attribute15_o
224: => pqh_tjr_shd.g_old_rec.attribute15
225: ,p_attribute16_o
226: => pqh_tjr_shd.g_old_rec.attribute16

Line 224: => pqh_tjr_shd.g_old_rec.attribute15

220: => pqh_tjr_shd.g_old_rec.attribute13
221: ,p_attribute14_o
222: => pqh_tjr_shd.g_old_rec.attribute14
223: ,p_attribute15_o
224: => pqh_tjr_shd.g_old_rec.attribute15
225: ,p_attribute16_o
226: => pqh_tjr_shd.g_old_rec.attribute16
227: ,p_attribute17_o
228: => pqh_tjr_shd.g_old_rec.attribute17

Line 226: => pqh_tjr_shd.g_old_rec.attribute16

222: => pqh_tjr_shd.g_old_rec.attribute14
223: ,p_attribute15_o
224: => pqh_tjr_shd.g_old_rec.attribute15
225: ,p_attribute16_o
226: => pqh_tjr_shd.g_old_rec.attribute16
227: ,p_attribute17_o
228: => pqh_tjr_shd.g_old_rec.attribute17
229: ,p_attribute18_o
230: => pqh_tjr_shd.g_old_rec.attribute18

Line 228: => pqh_tjr_shd.g_old_rec.attribute17

224: => pqh_tjr_shd.g_old_rec.attribute15
225: ,p_attribute16_o
226: => pqh_tjr_shd.g_old_rec.attribute16
227: ,p_attribute17_o
228: => pqh_tjr_shd.g_old_rec.attribute17
229: ,p_attribute18_o
230: => pqh_tjr_shd.g_old_rec.attribute18
231: ,p_attribute19_o
232: => pqh_tjr_shd.g_old_rec.attribute19

Line 230: => pqh_tjr_shd.g_old_rec.attribute18

226: => pqh_tjr_shd.g_old_rec.attribute16
227: ,p_attribute17_o
228: => pqh_tjr_shd.g_old_rec.attribute17
229: ,p_attribute18_o
230: => pqh_tjr_shd.g_old_rec.attribute18
231: ,p_attribute19_o
232: => pqh_tjr_shd.g_old_rec.attribute19
233: ,p_attribute20_o
234: => pqh_tjr_shd.g_old_rec.attribute20

Line 232: => pqh_tjr_shd.g_old_rec.attribute19

228: => pqh_tjr_shd.g_old_rec.attribute17
229: ,p_attribute18_o
230: => pqh_tjr_shd.g_old_rec.attribute18
231: ,p_attribute19_o
232: => pqh_tjr_shd.g_old_rec.attribute19
233: ,p_attribute20_o
234: => pqh_tjr_shd.g_old_rec.attribute20
235: ,p_comments_o
236: => pqh_tjr_shd.g_old_rec.comments

Line 234: => pqh_tjr_shd.g_old_rec.attribute20

230: => pqh_tjr_shd.g_old_rec.attribute18
231: ,p_attribute19_o
232: => pqh_tjr_shd.g_old_rec.attribute19
233: ,p_attribute20_o
234: => pqh_tjr_shd.g_old_rec.attribute20
235: ,p_comments_o
236: => pqh_tjr_shd.g_old_rec.comments
237: );
238: --

Line 236: => pqh_tjr_shd.g_old_rec.comments

232: => pqh_tjr_shd.g_old_rec.attribute19
233: ,p_attribute20_o
234: => pqh_tjr_shd.g_old_rec.attribute20
235: ,p_comments_o
236: => pqh_tjr_shd.g_old_rec.comments
237: );
238: --
239: exception
240: --

Line 256: (p_rec in pqh_tjr_shd.g_rec_type

252: -- ----------------------------------------------------------------------------
253: -- |---------------------------------< del >----------------------------------|
254: -- ----------------------------------------------------------------------------
255: Procedure del
256: (p_rec in pqh_tjr_shd.g_rec_type
257: ) is
258: --
259: l_proc varchar2(72) := g_package||'del';
260: --

Line 266: pqh_tjr_shd.lck

262: hr_utility.set_location('Entering:'||l_proc, 5);
263: --
264: -- We must lock the row which we need to delete.
265: --
266: pqh_tjr_shd.lck
267: (p_rec.txn_job_requirement_id
268: ,p_rec.object_version_number
269: );
270: --

Line 297: l_rec pqh_tjr_shd.g_rec_type;

293: (p_txn_job_requirement_id in number
294: ,p_object_version_number in number
295: ) is
296: --
297: l_rec pqh_tjr_shd.g_rec_type;
298: l_proc varchar2(72) := g_package||'del';
299: --
300: Begin
301: hr_utility.set_location('Entering:'||l_proc, 5);