APPS.PQH_CPD_DEL dependencies on PQH_CPD_SHD

Line 53: (p_rec in pqh_cpd_shd.g_rec_type

49: --
50: -- {End Of Comments}
51: -- ----------------------------------------------------------------------------
52: Procedure delete_dml
53: (p_rec in pqh_cpd_shd.g_rec_type
54: ) is
55: --
56: l_proc varchar2(72);
57: --

Line 64: pqh_cpd_shd.g_api_dml := true; -- Set the api dml status

60: l_proc := g_package||'delete_dml';
61: hr_utility.set_location('Entering:'||l_proc, 5);
62: end if;
63: --
64: pqh_cpd_shd.g_api_dml := true; -- Set the api dml status
65: --
66: -- Delete the pqh_corps_definitions row.
67: --
68: delete from pqh_corps_definitions

Line 71: pqh_cpd_shd.g_api_dml := false; -- Unset the api dml status

67: --
68: delete from pqh_corps_definitions
69: where corps_definition_id = p_rec.corps_definition_id;
70: --
71: pqh_cpd_shd.g_api_dml := false; -- Unset the api dml status
72: --
73: if g_debug then
74: hr_utility.set_location(' Leaving:'||l_proc, 10);
75: end if;

Line 80: pqh_cpd_shd.g_api_dml := false; -- Unset the api dml status

76: --
77: Exception
78: When hr_api.child_integrity_violated then
79: -- Child integrity has been violated
80: pqh_cpd_shd.g_api_dml := false; -- Unset the api dml status
81: pqh_cpd_shd.constraint_error
82: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
83: When Others Then
84: pqh_cpd_shd.g_api_dml := false; -- Unset the api dml status

Line 81: pqh_cpd_shd.constraint_error

77: Exception
78: When hr_api.child_integrity_violated then
79: -- Child integrity has been violated
80: pqh_cpd_shd.g_api_dml := false; -- Unset the api dml status
81: pqh_cpd_shd.constraint_error
82: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
83: When Others Then
84: pqh_cpd_shd.g_api_dml := false; -- Unset the api dml status
85: Raise;

Line 84: pqh_cpd_shd.g_api_dml := false; -- Unset the api dml status

80: pqh_cpd_shd.g_api_dml := false; -- Unset the api dml status
81: pqh_cpd_shd.constraint_error
82: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
83: When Others Then
84: pqh_cpd_shd.g_api_dml := false; -- Unset the api dml status
85: Raise;
86: End delete_dml;
87: --
88: -- ----------------------------------------------------------------------------

Line 120: Procedure pre_delete(p_rec in pqh_cpd_shd.g_rec_type) is

116: -- Internal Row Handler Use Only.
117: --
118: -- {End Of Comments}
119: -- ----------------------------------------------------------------------------
120: Procedure pre_delete(p_rec in pqh_cpd_shd.g_rec_type) is
121: --
122: l_proc varchar2(72);
123: --
124: Begin

Line 167: Procedure post_delete(p_rec in pqh_cpd_shd.g_rec_type) is

163: -- Internal Row Handler Use Only.
164: --
165: -- {End Of Comments}
166: -- -----------------------------------------------------------------------------
167: Procedure post_delete(p_rec in pqh_cpd_shd.g_rec_type) is
168: --
169: l_proc varchar2(72) := g_package||'post_delete';
170: --
171: Begin

Line 182: => pqh_cpd_shd.g_old_rec.business_group_id

178: pqh_cpd_rkd.after_delete
179: (p_corps_definition_id
180: => p_rec.corps_definition_id
181: ,p_business_group_id_o
182: => pqh_cpd_shd.g_old_rec.business_group_id
183: ,p_name_o
184: => pqh_cpd_shd.g_old_rec.name
185: ,p_status_cd_o
186: => pqh_cpd_shd.g_old_rec.status_cd

Line 184: => pqh_cpd_shd.g_old_rec.name

180: => p_rec.corps_definition_id
181: ,p_business_group_id_o
182: => pqh_cpd_shd.g_old_rec.business_group_id
183: ,p_name_o
184: => pqh_cpd_shd.g_old_rec.name
185: ,p_status_cd_o
186: => pqh_cpd_shd.g_old_rec.status_cd
187: ,p_retirement_age_o
188: => pqh_cpd_shd.g_old_rec.retirement_age

Line 186: => pqh_cpd_shd.g_old_rec.status_cd

182: => pqh_cpd_shd.g_old_rec.business_group_id
183: ,p_name_o
184: => pqh_cpd_shd.g_old_rec.name
185: ,p_status_cd_o
186: => pqh_cpd_shd.g_old_rec.status_cd
187: ,p_retirement_age_o
188: => pqh_cpd_shd.g_old_rec.retirement_age
189: ,p_category_cd_o
190: => pqh_cpd_shd.g_old_rec.category_cd

Line 188: => pqh_cpd_shd.g_old_rec.retirement_age

184: => pqh_cpd_shd.g_old_rec.name
185: ,p_status_cd_o
186: => pqh_cpd_shd.g_old_rec.status_cd
187: ,p_retirement_age_o
188: => pqh_cpd_shd.g_old_rec.retirement_age
189: ,p_category_cd_o
190: => pqh_cpd_shd.g_old_rec.category_cd
191: ,p_recruitment_end_date_o
192: => pqh_cpd_shd.g_old_rec.recruitment_end_date

Line 190: => pqh_cpd_shd.g_old_rec.category_cd

186: => pqh_cpd_shd.g_old_rec.status_cd
187: ,p_retirement_age_o
188: => pqh_cpd_shd.g_old_rec.retirement_age
189: ,p_category_cd_o
190: => pqh_cpd_shd.g_old_rec.category_cd
191: ,p_recruitment_end_date_o
192: => pqh_cpd_shd.g_old_rec.recruitment_end_date
193: ,p_corps_type_cd_o
194: => pqh_cpd_shd.g_old_rec.corps_type_cd

Line 192: => pqh_cpd_shd.g_old_rec.recruitment_end_date

188: => pqh_cpd_shd.g_old_rec.retirement_age
189: ,p_category_cd_o
190: => pqh_cpd_shd.g_old_rec.category_cd
191: ,p_recruitment_end_date_o
192: => pqh_cpd_shd.g_old_rec.recruitment_end_date
193: ,p_corps_type_cd_o
194: => pqh_cpd_shd.g_old_rec.corps_type_cd
195: ,p_starting_grade_step_id_o
196: => pqh_cpd_shd.g_old_rec.starting_grade_step_id

Line 194: => pqh_cpd_shd.g_old_rec.corps_type_cd

190: => pqh_cpd_shd.g_old_rec.category_cd
191: ,p_recruitment_end_date_o
192: => pqh_cpd_shd.g_old_rec.recruitment_end_date
193: ,p_corps_type_cd_o
194: => pqh_cpd_shd.g_old_rec.corps_type_cd
195: ,p_starting_grade_step_id_o
196: => pqh_cpd_shd.g_old_rec.starting_grade_step_id
197: ,p_task_desc_o
198: => pqh_cpd_shd.g_old_rec.task_desc

Line 196: => pqh_cpd_shd.g_old_rec.starting_grade_step_id

192: => pqh_cpd_shd.g_old_rec.recruitment_end_date
193: ,p_corps_type_cd_o
194: => pqh_cpd_shd.g_old_rec.corps_type_cd
195: ,p_starting_grade_step_id_o
196: => pqh_cpd_shd.g_old_rec.starting_grade_step_id
197: ,p_task_desc_o
198: => pqh_cpd_shd.g_old_rec.task_desc
199: ,p_secondment_threshold_o
200: => pqh_cpd_shd.g_old_rec.secondment_threshold

Line 198: => pqh_cpd_shd.g_old_rec.task_desc

194: => pqh_cpd_shd.g_old_rec.corps_type_cd
195: ,p_starting_grade_step_id_o
196: => pqh_cpd_shd.g_old_rec.starting_grade_step_id
197: ,p_task_desc_o
198: => pqh_cpd_shd.g_old_rec.task_desc
199: ,p_secondment_threshold_o
200: => pqh_cpd_shd.g_old_rec.secondment_threshold
201: ,p_normal_hours_o
202: => pqh_cpd_shd.g_old_rec.normal_hours

Line 200: => pqh_cpd_shd.g_old_rec.secondment_threshold

196: => pqh_cpd_shd.g_old_rec.starting_grade_step_id
197: ,p_task_desc_o
198: => pqh_cpd_shd.g_old_rec.task_desc
199: ,p_secondment_threshold_o
200: => pqh_cpd_shd.g_old_rec.secondment_threshold
201: ,p_normal_hours_o
202: => pqh_cpd_shd.g_old_rec.normal_hours
203: ,p_normal_hours_frequency_o
204: => pqh_cpd_shd.g_old_rec.normal_hours_frequency

Line 202: => pqh_cpd_shd.g_old_rec.normal_hours

198: => pqh_cpd_shd.g_old_rec.task_desc
199: ,p_secondment_threshold_o
200: => pqh_cpd_shd.g_old_rec.secondment_threshold
201: ,p_normal_hours_o
202: => pqh_cpd_shd.g_old_rec.normal_hours
203: ,p_normal_hours_frequency_o
204: => pqh_cpd_shd.g_old_rec.normal_hours_frequency
205: ,p_minimum_hours_o
206: => pqh_cpd_shd.g_old_rec.minimum_hours

Line 204: => pqh_cpd_shd.g_old_rec.normal_hours_frequency

200: => pqh_cpd_shd.g_old_rec.secondment_threshold
201: ,p_normal_hours_o
202: => pqh_cpd_shd.g_old_rec.normal_hours
203: ,p_normal_hours_frequency_o
204: => pqh_cpd_shd.g_old_rec.normal_hours_frequency
205: ,p_minimum_hours_o
206: => pqh_cpd_shd.g_old_rec.minimum_hours
207: ,p_minimum_hours_frequency_o
208: => pqh_cpd_shd.g_old_rec.minimum_hours_frequency

Line 206: => pqh_cpd_shd.g_old_rec.minimum_hours

202: => pqh_cpd_shd.g_old_rec.normal_hours
203: ,p_normal_hours_frequency_o
204: => pqh_cpd_shd.g_old_rec.normal_hours_frequency
205: ,p_minimum_hours_o
206: => pqh_cpd_shd.g_old_rec.minimum_hours
207: ,p_minimum_hours_frequency_o
208: => pqh_cpd_shd.g_old_rec.minimum_hours_frequency
209: ,p_attribute1_o
210: => pqh_cpd_shd.g_old_rec.attribute1

Line 208: => pqh_cpd_shd.g_old_rec.minimum_hours_frequency

204: => pqh_cpd_shd.g_old_rec.normal_hours_frequency
205: ,p_minimum_hours_o
206: => pqh_cpd_shd.g_old_rec.minimum_hours
207: ,p_minimum_hours_frequency_o
208: => pqh_cpd_shd.g_old_rec.minimum_hours_frequency
209: ,p_attribute1_o
210: => pqh_cpd_shd.g_old_rec.attribute1
211: ,p_attribute2_o
212: => pqh_cpd_shd.g_old_rec.attribute2

Line 210: => pqh_cpd_shd.g_old_rec.attribute1

206: => pqh_cpd_shd.g_old_rec.minimum_hours
207: ,p_minimum_hours_frequency_o
208: => pqh_cpd_shd.g_old_rec.minimum_hours_frequency
209: ,p_attribute1_o
210: => pqh_cpd_shd.g_old_rec.attribute1
211: ,p_attribute2_o
212: => pqh_cpd_shd.g_old_rec.attribute2
213: ,p_attribute3_o
214: => pqh_cpd_shd.g_old_rec.attribute3

Line 212: => pqh_cpd_shd.g_old_rec.attribute2

208: => pqh_cpd_shd.g_old_rec.minimum_hours_frequency
209: ,p_attribute1_o
210: => pqh_cpd_shd.g_old_rec.attribute1
211: ,p_attribute2_o
212: => pqh_cpd_shd.g_old_rec.attribute2
213: ,p_attribute3_o
214: => pqh_cpd_shd.g_old_rec.attribute3
215: ,p_attribute4_o
216: => pqh_cpd_shd.g_old_rec.attribute4

Line 214: => pqh_cpd_shd.g_old_rec.attribute3

210: => pqh_cpd_shd.g_old_rec.attribute1
211: ,p_attribute2_o
212: => pqh_cpd_shd.g_old_rec.attribute2
213: ,p_attribute3_o
214: => pqh_cpd_shd.g_old_rec.attribute3
215: ,p_attribute4_o
216: => pqh_cpd_shd.g_old_rec.attribute4
217: ,p_attribute5_o
218: => pqh_cpd_shd.g_old_rec.attribute5

Line 216: => pqh_cpd_shd.g_old_rec.attribute4

212: => pqh_cpd_shd.g_old_rec.attribute2
213: ,p_attribute3_o
214: => pqh_cpd_shd.g_old_rec.attribute3
215: ,p_attribute4_o
216: => pqh_cpd_shd.g_old_rec.attribute4
217: ,p_attribute5_o
218: => pqh_cpd_shd.g_old_rec.attribute5
219: ,p_attribute6_o
220: => pqh_cpd_shd.g_old_rec.attribute6

Line 218: => pqh_cpd_shd.g_old_rec.attribute5

214: => pqh_cpd_shd.g_old_rec.attribute3
215: ,p_attribute4_o
216: => pqh_cpd_shd.g_old_rec.attribute4
217: ,p_attribute5_o
218: => pqh_cpd_shd.g_old_rec.attribute5
219: ,p_attribute6_o
220: => pqh_cpd_shd.g_old_rec.attribute6
221: ,p_attribute7_o
222: => pqh_cpd_shd.g_old_rec.attribute7

Line 220: => pqh_cpd_shd.g_old_rec.attribute6

216: => pqh_cpd_shd.g_old_rec.attribute4
217: ,p_attribute5_o
218: => pqh_cpd_shd.g_old_rec.attribute5
219: ,p_attribute6_o
220: => pqh_cpd_shd.g_old_rec.attribute6
221: ,p_attribute7_o
222: => pqh_cpd_shd.g_old_rec.attribute7
223: ,p_attribute8_o
224: => pqh_cpd_shd.g_old_rec.attribute8

Line 222: => pqh_cpd_shd.g_old_rec.attribute7

218: => pqh_cpd_shd.g_old_rec.attribute5
219: ,p_attribute6_o
220: => pqh_cpd_shd.g_old_rec.attribute6
221: ,p_attribute7_o
222: => pqh_cpd_shd.g_old_rec.attribute7
223: ,p_attribute8_o
224: => pqh_cpd_shd.g_old_rec.attribute8
225: ,p_attribute9_o
226: => pqh_cpd_shd.g_old_rec.attribute9

Line 224: => pqh_cpd_shd.g_old_rec.attribute8

220: => pqh_cpd_shd.g_old_rec.attribute6
221: ,p_attribute7_o
222: => pqh_cpd_shd.g_old_rec.attribute7
223: ,p_attribute8_o
224: => pqh_cpd_shd.g_old_rec.attribute8
225: ,p_attribute9_o
226: => pqh_cpd_shd.g_old_rec.attribute9
227: ,p_attribute10_o
228: => pqh_cpd_shd.g_old_rec.attribute10

Line 226: => pqh_cpd_shd.g_old_rec.attribute9

222: => pqh_cpd_shd.g_old_rec.attribute7
223: ,p_attribute8_o
224: => pqh_cpd_shd.g_old_rec.attribute8
225: ,p_attribute9_o
226: => pqh_cpd_shd.g_old_rec.attribute9
227: ,p_attribute10_o
228: => pqh_cpd_shd.g_old_rec.attribute10
229: ,p_attribute11_o
230: => pqh_cpd_shd.g_old_rec.attribute11

Line 228: => pqh_cpd_shd.g_old_rec.attribute10

224: => pqh_cpd_shd.g_old_rec.attribute8
225: ,p_attribute9_o
226: => pqh_cpd_shd.g_old_rec.attribute9
227: ,p_attribute10_o
228: => pqh_cpd_shd.g_old_rec.attribute10
229: ,p_attribute11_o
230: => pqh_cpd_shd.g_old_rec.attribute11
231: ,p_attribute12_o
232: => pqh_cpd_shd.g_old_rec.attribute12

Line 230: => pqh_cpd_shd.g_old_rec.attribute11

226: => pqh_cpd_shd.g_old_rec.attribute9
227: ,p_attribute10_o
228: => pqh_cpd_shd.g_old_rec.attribute10
229: ,p_attribute11_o
230: => pqh_cpd_shd.g_old_rec.attribute11
231: ,p_attribute12_o
232: => pqh_cpd_shd.g_old_rec.attribute12
233: ,p_attribute13_o
234: => pqh_cpd_shd.g_old_rec.attribute13

Line 232: => pqh_cpd_shd.g_old_rec.attribute12

228: => pqh_cpd_shd.g_old_rec.attribute10
229: ,p_attribute11_o
230: => pqh_cpd_shd.g_old_rec.attribute11
231: ,p_attribute12_o
232: => pqh_cpd_shd.g_old_rec.attribute12
233: ,p_attribute13_o
234: => pqh_cpd_shd.g_old_rec.attribute13
235: ,p_attribute14_o
236: => pqh_cpd_shd.g_old_rec.attribute14

Line 234: => pqh_cpd_shd.g_old_rec.attribute13

230: => pqh_cpd_shd.g_old_rec.attribute11
231: ,p_attribute12_o
232: => pqh_cpd_shd.g_old_rec.attribute12
233: ,p_attribute13_o
234: => pqh_cpd_shd.g_old_rec.attribute13
235: ,p_attribute14_o
236: => pqh_cpd_shd.g_old_rec.attribute14
237: ,p_attribute15_o
238: => pqh_cpd_shd.g_old_rec.attribute15

Line 236: => pqh_cpd_shd.g_old_rec.attribute14

232: => pqh_cpd_shd.g_old_rec.attribute12
233: ,p_attribute13_o
234: => pqh_cpd_shd.g_old_rec.attribute13
235: ,p_attribute14_o
236: => pqh_cpd_shd.g_old_rec.attribute14
237: ,p_attribute15_o
238: => pqh_cpd_shd.g_old_rec.attribute15
239: ,p_attribute16_o
240: => pqh_cpd_shd.g_old_rec.attribute16

Line 238: => pqh_cpd_shd.g_old_rec.attribute15

234: => pqh_cpd_shd.g_old_rec.attribute13
235: ,p_attribute14_o
236: => pqh_cpd_shd.g_old_rec.attribute14
237: ,p_attribute15_o
238: => pqh_cpd_shd.g_old_rec.attribute15
239: ,p_attribute16_o
240: => pqh_cpd_shd.g_old_rec.attribute16
241: ,p_attribute17_o
242: => pqh_cpd_shd.g_old_rec.attribute17

Line 240: => pqh_cpd_shd.g_old_rec.attribute16

236: => pqh_cpd_shd.g_old_rec.attribute14
237: ,p_attribute15_o
238: => pqh_cpd_shd.g_old_rec.attribute15
239: ,p_attribute16_o
240: => pqh_cpd_shd.g_old_rec.attribute16
241: ,p_attribute17_o
242: => pqh_cpd_shd.g_old_rec.attribute17
243: ,p_attribute18_o
244: => pqh_cpd_shd.g_old_rec.attribute18

Line 242: => pqh_cpd_shd.g_old_rec.attribute17

238: => pqh_cpd_shd.g_old_rec.attribute15
239: ,p_attribute16_o
240: => pqh_cpd_shd.g_old_rec.attribute16
241: ,p_attribute17_o
242: => pqh_cpd_shd.g_old_rec.attribute17
243: ,p_attribute18_o
244: => pqh_cpd_shd.g_old_rec.attribute18
245: ,p_attribute19_o
246: => pqh_cpd_shd.g_old_rec.attribute19

Line 244: => pqh_cpd_shd.g_old_rec.attribute18

240: => pqh_cpd_shd.g_old_rec.attribute16
241: ,p_attribute17_o
242: => pqh_cpd_shd.g_old_rec.attribute17
243: ,p_attribute18_o
244: => pqh_cpd_shd.g_old_rec.attribute18
245: ,p_attribute19_o
246: => pqh_cpd_shd.g_old_rec.attribute19
247: ,p_attribute20_o
248: => pqh_cpd_shd.g_old_rec.attribute20

Line 246: => pqh_cpd_shd.g_old_rec.attribute19

242: => pqh_cpd_shd.g_old_rec.attribute17
243: ,p_attribute18_o
244: => pqh_cpd_shd.g_old_rec.attribute18
245: ,p_attribute19_o
246: => pqh_cpd_shd.g_old_rec.attribute19
247: ,p_attribute20_o
248: => pqh_cpd_shd.g_old_rec.attribute20
249: ,p_attribute21_o
250: => pqh_cpd_shd.g_old_rec.attribute21

Line 248: => pqh_cpd_shd.g_old_rec.attribute20

244: => pqh_cpd_shd.g_old_rec.attribute18
245: ,p_attribute19_o
246: => pqh_cpd_shd.g_old_rec.attribute19
247: ,p_attribute20_o
248: => pqh_cpd_shd.g_old_rec.attribute20
249: ,p_attribute21_o
250: => pqh_cpd_shd.g_old_rec.attribute21
251: ,p_attribute22_o
252: => pqh_cpd_shd.g_old_rec.attribute22

Line 250: => pqh_cpd_shd.g_old_rec.attribute21

246: => pqh_cpd_shd.g_old_rec.attribute19
247: ,p_attribute20_o
248: => pqh_cpd_shd.g_old_rec.attribute20
249: ,p_attribute21_o
250: => pqh_cpd_shd.g_old_rec.attribute21
251: ,p_attribute22_o
252: => pqh_cpd_shd.g_old_rec.attribute22
253: ,p_attribute23_o
254: => pqh_cpd_shd.g_old_rec.attribute23

Line 252: => pqh_cpd_shd.g_old_rec.attribute22

248: => pqh_cpd_shd.g_old_rec.attribute20
249: ,p_attribute21_o
250: => pqh_cpd_shd.g_old_rec.attribute21
251: ,p_attribute22_o
252: => pqh_cpd_shd.g_old_rec.attribute22
253: ,p_attribute23_o
254: => pqh_cpd_shd.g_old_rec.attribute23
255: ,p_attribute24_o
256: => pqh_cpd_shd.g_old_rec.attribute24

Line 254: => pqh_cpd_shd.g_old_rec.attribute23

250: => pqh_cpd_shd.g_old_rec.attribute21
251: ,p_attribute22_o
252: => pqh_cpd_shd.g_old_rec.attribute22
253: ,p_attribute23_o
254: => pqh_cpd_shd.g_old_rec.attribute23
255: ,p_attribute24_o
256: => pqh_cpd_shd.g_old_rec.attribute24
257: ,p_attribute25_o
258: => pqh_cpd_shd.g_old_rec.attribute25

Line 256: => pqh_cpd_shd.g_old_rec.attribute24

252: => pqh_cpd_shd.g_old_rec.attribute22
253: ,p_attribute23_o
254: => pqh_cpd_shd.g_old_rec.attribute23
255: ,p_attribute24_o
256: => pqh_cpd_shd.g_old_rec.attribute24
257: ,p_attribute25_o
258: => pqh_cpd_shd.g_old_rec.attribute25
259: ,p_attribute26_o
260: => pqh_cpd_shd.g_old_rec.attribute26

Line 258: => pqh_cpd_shd.g_old_rec.attribute25

254: => pqh_cpd_shd.g_old_rec.attribute23
255: ,p_attribute24_o
256: => pqh_cpd_shd.g_old_rec.attribute24
257: ,p_attribute25_o
258: => pqh_cpd_shd.g_old_rec.attribute25
259: ,p_attribute26_o
260: => pqh_cpd_shd.g_old_rec.attribute26
261: ,p_attribute27_o
262: => pqh_cpd_shd.g_old_rec.attribute27

Line 260: => pqh_cpd_shd.g_old_rec.attribute26

256: => pqh_cpd_shd.g_old_rec.attribute24
257: ,p_attribute25_o
258: => pqh_cpd_shd.g_old_rec.attribute25
259: ,p_attribute26_o
260: => pqh_cpd_shd.g_old_rec.attribute26
261: ,p_attribute27_o
262: => pqh_cpd_shd.g_old_rec.attribute27
263: ,p_attribute28_o
264: => pqh_cpd_shd.g_old_rec.attribute28

Line 262: => pqh_cpd_shd.g_old_rec.attribute27

258: => pqh_cpd_shd.g_old_rec.attribute25
259: ,p_attribute26_o
260: => pqh_cpd_shd.g_old_rec.attribute26
261: ,p_attribute27_o
262: => pqh_cpd_shd.g_old_rec.attribute27
263: ,p_attribute28_o
264: => pqh_cpd_shd.g_old_rec.attribute28
265: ,p_attribute29_o
266: => pqh_cpd_shd.g_old_rec.attribute29

Line 264: => pqh_cpd_shd.g_old_rec.attribute28

260: => pqh_cpd_shd.g_old_rec.attribute26
261: ,p_attribute27_o
262: => pqh_cpd_shd.g_old_rec.attribute27
263: ,p_attribute28_o
264: => pqh_cpd_shd.g_old_rec.attribute28
265: ,p_attribute29_o
266: => pqh_cpd_shd.g_old_rec.attribute29
267: ,p_attribute30_o
268: => pqh_cpd_shd.g_old_rec.attribute30

Line 266: => pqh_cpd_shd.g_old_rec.attribute29

262: => pqh_cpd_shd.g_old_rec.attribute27
263: ,p_attribute28_o
264: => pqh_cpd_shd.g_old_rec.attribute28
265: ,p_attribute29_o
266: => pqh_cpd_shd.g_old_rec.attribute29
267: ,p_attribute30_o
268: => pqh_cpd_shd.g_old_rec.attribute30
269: ,p_attribute_category_o
270: => pqh_cpd_shd.g_old_rec.attribute_category

Line 268: => pqh_cpd_shd.g_old_rec.attribute30

264: => pqh_cpd_shd.g_old_rec.attribute28
265: ,p_attribute29_o
266: => pqh_cpd_shd.g_old_rec.attribute29
267: ,p_attribute30_o
268: => pqh_cpd_shd.g_old_rec.attribute30
269: ,p_attribute_category_o
270: => pqh_cpd_shd.g_old_rec.attribute_category
271: ,p_object_version_number_o
272: => pqh_cpd_shd.g_old_rec.object_version_number

Line 270: => pqh_cpd_shd.g_old_rec.attribute_category

266: => pqh_cpd_shd.g_old_rec.attribute29
267: ,p_attribute30_o
268: => pqh_cpd_shd.g_old_rec.attribute30
269: ,p_attribute_category_o
270: => pqh_cpd_shd.g_old_rec.attribute_category
271: ,p_object_version_number_o
272: => pqh_cpd_shd.g_old_rec.object_version_number
273: ,p_type_of_ps_o
274: => pqh_cpd_shd.g_old_rec.type_of_ps

Line 272: => pqh_cpd_shd.g_old_rec.object_version_number

268: => pqh_cpd_shd.g_old_rec.attribute30
269: ,p_attribute_category_o
270: => pqh_cpd_shd.g_old_rec.attribute_category
271: ,p_object_version_number_o
272: => pqh_cpd_shd.g_old_rec.object_version_number
273: ,p_type_of_ps_o
274: => pqh_cpd_shd.g_old_rec.type_of_ps
275: ,p_date_from_o
276: => pqh_cpd_shd.g_old_rec.date_from

Line 274: => pqh_cpd_shd.g_old_rec.type_of_ps

270: => pqh_cpd_shd.g_old_rec.attribute_category
271: ,p_object_version_number_o
272: => pqh_cpd_shd.g_old_rec.object_version_number
273: ,p_type_of_ps_o
274: => pqh_cpd_shd.g_old_rec.type_of_ps
275: ,p_date_from_o
276: => pqh_cpd_shd.g_old_rec.date_from
277: ,p_date_to_o
278: => pqh_cpd_shd.g_old_rec.date_to

Line 276: => pqh_cpd_shd.g_old_rec.date_from

272: => pqh_cpd_shd.g_old_rec.object_version_number
273: ,p_type_of_ps_o
274: => pqh_cpd_shd.g_old_rec.type_of_ps
275: ,p_date_from_o
276: => pqh_cpd_shd.g_old_rec.date_from
277: ,p_date_to_o
278: => pqh_cpd_shd.g_old_rec.date_to
279: ,p_primary_prof_field_id_o
280: => pqh_cpd_shd.g_old_rec.primary_prof_field_id

Line 278: => pqh_cpd_shd.g_old_rec.date_to

274: => pqh_cpd_shd.g_old_rec.type_of_ps
275: ,p_date_from_o
276: => pqh_cpd_shd.g_old_rec.date_from
277: ,p_date_to_o
278: => pqh_cpd_shd.g_old_rec.date_to
279: ,p_primary_prof_field_id_o
280: => pqh_cpd_shd.g_old_rec.primary_prof_field_id
281: ,p_starting_grade_id_o
282: => pqh_cpd_shd.g_old_rec.starting_grade_id

Line 280: => pqh_cpd_shd.g_old_rec.primary_prof_field_id

276: => pqh_cpd_shd.g_old_rec.date_from
277: ,p_date_to_o
278: => pqh_cpd_shd.g_old_rec.date_to
279: ,p_primary_prof_field_id_o
280: => pqh_cpd_shd.g_old_rec.primary_prof_field_id
281: ,p_starting_grade_id_o
282: => pqh_cpd_shd.g_old_rec.starting_grade_id
283: ,p_ben_pgm_id_o
284: => pqh_cpd_shd.g_old_rec.ben_pgm_id

Line 282: => pqh_cpd_shd.g_old_rec.starting_grade_id

278: => pqh_cpd_shd.g_old_rec.date_to
279: ,p_primary_prof_field_id_o
280: => pqh_cpd_shd.g_old_rec.primary_prof_field_id
281: ,p_starting_grade_id_o
282: => pqh_cpd_shd.g_old_rec.starting_grade_id
283: ,p_ben_pgm_id_o
284: => pqh_cpd_shd.g_old_rec.ben_pgm_id
285: ,p_probation_period_o
286: => pqh_cpd_shd.g_old_rec.probation_period

Line 284: => pqh_cpd_shd.g_old_rec.ben_pgm_id

280: => pqh_cpd_shd.g_old_rec.primary_prof_field_id
281: ,p_starting_grade_id_o
282: => pqh_cpd_shd.g_old_rec.starting_grade_id
283: ,p_ben_pgm_id_o
284: => pqh_cpd_shd.g_old_rec.ben_pgm_id
285: ,p_probation_period_o
286: => pqh_cpd_shd.g_old_rec.probation_period
287: ,p_probation_units_o
288: => pqh_cpd_shd.g_old_rec.probation_units

Line 286: => pqh_cpd_shd.g_old_rec.probation_period

282: => pqh_cpd_shd.g_old_rec.starting_grade_id
283: ,p_ben_pgm_id_o
284: => pqh_cpd_shd.g_old_rec.ben_pgm_id
285: ,p_probation_period_o
286: => pqh_cpd_shd.g_old_rec.probation_period
287: ,p_probation_units_o
288: => pqh_cpd_shd.g_old_rec.probation_units
289: );
290: --

Line 288: => pqh_cpd_shd.g_old_rec.probation_units

284: => pqh_cpd_shd.g_old_rec.ben_pgm_id
285: ,p_probation_period_o
286: => pqh_cpd_shd.g_old_rec.probation_period
287: ,p_probation_units_o
288: => pqh_cpd_shd.g_old_rec.probation_units
289: );
290: --
291: exception
292: --

Line 310: (p_rec in pqh_cpd_shd.g_rec_type

306: -- ----------------------------------------------------------------------------
307: -- |---------------------------------< del >----------------------------------|
308: -- ----------------------------------------------------------------------------
309: Procedure del
310: (p_rec in pqh_cpd_shd.g_rec_type
311: ) is
312: --
313: l_proc varchar2(72) := g_package||'del';
314: --

Line 323: pqh_cpd_shd.lck

319: end if;
320: --
321: -- We must lock the row which we need to delete.
322: --
323: pqh_cpd_shd.lck
324: (p_rec.corps_definition_id
325: ,p_rec.object_version_number
326: );
327: --

Line 360: l_rec pqh_cpd_shd.g_rec_type;

356: (p_corps_definition_id in number
357: ,p_object_version_number in number
358: ) is
359: --
360: l_rec pqh_cpd_shd.g_rec_type;
361: l_proc varchar2(72) := g_package||'del';
362: --
363: Begin
364: g_debug := hr_utility.debug_enabled;