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.BEN_PCR_DEL dependencies on BEN_PCR_SHD

Line 54: (p_rec in out nocopy ben_pcr_shd.g_rec_type,

50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure dt_delete_dml
54: (p_rec in out nocopy ben_pcr_shd.g_rec_type,
55: p_effective_date in date,
56: p_datetrack_mode in varchar2,
57: p_validation_start_date in date,
58: p_validation_end_date in date) is

Line 66: ben_pcr_shd.g_api_dml := true; -- Set the api dml status

62: Begin
63: hr_utility.set_location('Entering:'||l_proc, 5);
64: If (p_datetrack_mode = 'DELETE_NEXT_CHANGE') then
65: hr_utility.set_location(l_proc, 10);
66: ben_pcr_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Delete the where the effective start date is equal
69: -- to the validation end date.
70: --

Line 75: ben_pcr_shd.g_api_dml := false; -- Unset the api dml status

71: delete from ben_per_cm_trgr_f
72: where per_cm_trgr_id = p_rec.per_cm_trgr_id
73: and effective_start_date = p_validation_start_date;
74: --
75: ben_pcr_shd.g_api_dml := false; -- Unset the api dml status
76: Else
77: hr_utility.set_location(l_proc, 15);
78: ben_pcr_shd.g_api_dml := true; -- Set the api dml status
79: --

Line 78: ben_pcr_shd.g_api_dml := true; -- Set the api dml status

74: --
75: ben_pcr_shd.g_api_dml := false; -- Unset the api dml status
76: Else
77: hr_utility.set_location(l_proc, 15);
78: ben_pcr_shd.g_api_dml := true; -- Set the api dml status
79: --
80: -- Delete the row(s) where the effective start date is greater than
81: -- or equal to the validation start date.
82: --

Line 87: ben_pcr_shd.g_api_dml := false; -- Unset the api dml status

83: delete from ben_per_cm_trgr_f
84: where per_cm_trgr_id = p_rec.per_cm_trgr_id
85: and effective_start_date >= p_validation_start_date;
86: --
87: ben_pcr_shd.g_api_dml := false; -- Unset the api dml status
88: End If;
89: --
90: hr_utility.set_location(' Leaving:'||l_proc, 20);
91: --

Line 94: ben_pcr_shd.g_api_dml := false; -- Unset the api dml status

90: hr_utility.set_location(' Leaving:'||l_proc, 20);
91: --
92: Exception
93: When Others Then
94: ben_pcr_shd.g_api_dml := false; -- Unset the api dml status
95: Raise;
96: End dt_delete_dml;
97: --
98: -- ----------------------------------------------------------------------------

Line 102: (p_rec in out nocopy ben_pcr_shd.g_rec_type,

98: -- ----------------------------------------------------------------------------
99: -- |------------------------------< delete_dml >------------------------------|
100: -- ----------------------------------------------------------------------------
101: Procedure delete_dml
102: (p_rec in out nocopy ben_pcr_shd.g_rec_type,
103: p_effective_date in date,
104: p_datetrack_mode in varchar2,
105: p_validation_start_date in date,
106: p_validation_end_date in date) is

Line 156: (p_rec in out nocopy ben_pcr_shd.g_rec_type,

152: --
153: -- {End Of Comments}
154: -- ----------------------------------------------------------------------------
155: Procedure dt_pre_delete
156: (p_rec in out nocopy ben_pcr_shd.g_rec_type,
157: p_effective_date in date,
158: p_datetrack_mode in varchar2,
159: p_validation_start_date in date,
160: p_validation_end_date in date) is

Line 169: p_rec.effective_start_date := ben_pcr_shd.g_old_rec.effective_start_date;

165: hr_utility.set_location('Entering:'||l_proc, 5);
166: --
167: If (p_datetrack_mode <> 'ZAP') then
168: --
169: p_rec.effective_start_date := ben_pcr_shd.g_old_rec.effective_start_date;
170: --
171: If (p_datetrack_mode = 'DELETE') then
172: p_rec.effective_end_date := p_validation_start_date - 1;
173: Else

Line 179: ben_pcr_shd.upd_effective_end_date

175: End If;
176: --
177: -- Update the current effective end date record
178: --
179: ben_pcr_shd.upd_effective_end_date
180: (p_effective_date => p_effective_date,
181: p_base_key_value => p_rec.per_cm_trgr_id,
182: p_new_effective_end_date => p_rec.effective_end_date,
183: p_validation_start_date => p_validation_start_date,

Line 227: (p_rec in out nocopy ben_pcr_shd.g_rec_type,

223: --
224: -- {End Of Comments}
225: -- ----------------------------------------------------------------------------
226: Procedure pre_delete
227: (p_rec in out nocopy ben_pcr_shd.g_rec_type,
228: p_effective_date in date,
229: p_datetrack_mode in varchar2,
230: p_validation_start_date in date,
231: p_validation_end_date in date) is

Line 285: (p_rec in ben_pcr_shd.g_rec_type,

281: --
282: -- {End Of Comments}
283: -- ----------------------------------------------------------------------------
284: Procedure post_delete
285: (p_rec in ben_pcr_shd.g_rec_type,
286: p_effective_date in date,
287: p_datetrack_mode in varchar2,
288: p_validation_start_date in date,
289: p_validation_end_date in date) is

Line 309: ,p_effective_start_date_o =>ben_pcr_shd.g_old_rec.effective_start_date

305: ,p_validation_start_date =>p_validation_start_date
306: ,p_validation_end_date =>p_validation_end_date
307: ,p_effective_start_date =>p_rec.effective_start_date
308: ,p_effective_end_date =>p_rec.effective_end_date
309: ,p_effective_start_date_o =>ben_pcr_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_pcr_shd.g_old_rec.effective_end_date
311: ,p_cm_trgr_id_o =>ben_pcr_shd.g_old_rec.cm_trgr_id
312: ,p_per_cm_id_o =>ben_pcr_shd.g_old_rec.per_cm_id
313: ,p_business_group_id_o =>ben_pcr_shd.g_old_rec.business_group_id

Line 310: ,p_effective_end_date_o =>ben_pcr_shd.g_old_rec.effective_end_date

306: ,p_validation_end_date =>p_validation_end_date
307: ,p_effective_start_date =>p_rec.effective_start_date
308: ,p_effective_end_date =>p_rec.effective_end_date
309: ,p_effective_start_date_o =>ben_pcr_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_pcr_shd.g_old_rec.effective_end_date
311: ,p_cm_trgr_id_o =>ben_pcr_shd.g_old_rec.cm_trgr_id
312: ,p_per_cm_id_o =>ben_pcr_shd.g_old_rec.per_cm_id
313: ,p_business_group_id_o =>ben_pcr_shd.g_old_rec.business_group_id
314: ,p_pcr_attribute_category_o =>ben_pcr_shd.g_old_rec.pcr_attribute_category

Line 311: ,p_cm_trgr_id_o =>ben_pcr_shd.g_old_rec.cm_trgr_id

307: ,p_effective_start_date =>p_rec.effective_start_date
308: ,p_effective_end_date =>p_rec.effective_end_date
309: ,p_effective_start_date_o =>ben_pcr_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_pcr_shd.g_old_rec.effective_end_date
311: ,p_cm_trgr_id_o =>ben_pcr_shd.g_old_rec.cm_trgr_id
312: ,p_per_cm_id_o =>ben_pcr_shd.g_old_rec.per_cm_id
313: ,p_business_group_id_o =>ben_pcr_shd.g_old_rec.business_group_id
314: ,p_pcr_attribute_category_o =>ben_pcr_shd.g_old_rec.pcr_attribute_category
315: ,p_pcr_attribute1_o =>ben_pcr_shd.g_old_rec.pcr_attribute1

Line 312: ,p_per_cm_id_o =>ben_pcr_shd.g_old_rec.per_cm_id

308: ,p_effective_end_date =>p_rec.effective_end_date
309: ,p_effective_start_date_o =>ben_pcr_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_pcr_shd.g_old_rec.effective_end_date
311: ,p_cm_trgr_id_o =>ben_pcr_shd.g_old_rec.cm_trgr_id
312: ,p_per_cm_id_o =>ben_pcr_shd.g_old_rec.per_cm_id
313: ,p_business_group_id_o =>ben_pcr_shd.g_old_rec.business_group_id
314: ,p_pcr_attribute_category_o =>ben_pcr_shd.g_old_rec.pcr_attribute_category
315: ,p_pcr_attribute1_o =>ben_pcr_shd.g_old_rec.pcr_attribute1
316: ,p_pcr_attribute2_o =>ben_pcr_shd.g_old_rec.pcr_attribute2

Line 313: ,p_business_group_id_o =>ben_pcr_shd.g_old_rec.business_group_id

309: ,p_effective_start_date_o =>ben_pcr_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_pcr_shd.g_old_rec.effective_end_date
311: ,p_cm_trgr_id_o =>ben_pcr_shd.g_old_rec.cm_trgr_id
312: ,p_per_cm_id_o =>ben_pcr_shd.g_old_rec.per_cm_id
313: ,p_business_group_id_o =>ben_pcr_shd.g_old_rec.business_group_id
314: ,p_pcr_attribute_category_o =>ben_pcr_shd.g_old_rec.pcr_attribute_category
315: ,p_pcr_attribute1_o =>ben_pcr_shd.g_old_rec.pcr_attribute1
316: ,p_pcr_attribute2_o =>ben_pcr_shd.g_old_rec.pcr_attribute2
317: ,p_pcr_attribute3_o =>ben_pcr_shd.g_old_rec.pcr_attribute3

Line 314: ,p_pcr_attribute_category_o =>ben_pcr_shd.g_old_rec.pcr_attribute_category

310: ,p_effective_end_date_o =>ben_pcr_shd.g_old_rec.effective_end_date
311: ,p_cm_trgr_id_o =>ben_pcr_shd.g_old_rec.cm_trgr_id
312: ,p_per_cm_id_o =>ben_pcr_shd.g_old_rec.per_cm_id
313: ,p_business_group_id_o =>ben_pcr_shd.g_old_rec.business_group_id
314: ,p_pcr_attribute_category_o =>ben_pcr_shd.g_old_rec.pcr_attribute_category
315: ,p_pcr_attribute1_o =>ben_pcr_shd.g_old_rec.pcr_attribute1
316: ,p_pcr_attribute2_o =>ben_pcr_shd.g_old_rec.pcr_attribute2
317: ,p_pcr_attribute3_o =>ben_pcr_shd.g_old_rec.pcr_attribute3
318: ,p_pcr_attribute4_o =>ben_pcr_shd.g_old_rec.pcr_attribute4

Line 315: ,p_pcr_attribute1_o =>ben_pcr_shd.g_old_rec.pcr_attribute1

311: ,p_cm_trgr_id_o =>ben_pcr_shd.g_old_rec.cm_trgr_id
312: ,p_per_cm_id_o =>ben_pcr_shd.g_old_rec.per_cm_id
313: ,p_business_group_id_o =>ben_pcr_shd.g_old_rec.business_group_id
314: ,p_pcr_attribute_category_o =>ben_pcr_shd.g_old_rec.pcr_attribute_category
315: ,p_pcr_attribute1_o =>ben_pcr_shd.g_old_rec.pcr_attribute1
316: ,p_pcr_attribute2_o =>ben_pcr_shd.g_old_rec.pcr_attribute2
317: ,p_pcr_attribute3_o =>ben_pcr_shd.g_old_rec.pcr_attribute3
318: ,p_pcr_attribute4_o =>ben_pcr_shd.g_old_rec.pcr_attribute4
319: ,p_pcr_attribute5_o =>ben_pcr_shd.g_old_rec.pcr_attribute5

Line 316: ,p_pcr_attribute2_o =>ben_pcr_shd.g_old_rec.pcr_attribute2

312: ,p_per_cm_id_o =>ben_pcr_shd.g_old_rec.per_cm_id
313: ,p_business_group_id_o =>ben_pcr_shd.g_old_rec.business_group_id
314: ,p_pcr_attribute_category_o =>ben_pcr_shd.g_old_rec.pcr_attribute_category
315: ,p_pcr_attribute1_o =>ben_pcr_shd.g_old_rec.pcr_attribute1
316: ,p_pcr_attribute2_o =>ben_pcr_shd.g_old_rec.pcr_attribute2
317: ,p_pcr_attribute3_o =>ben_pcr_shd.g_old_rec.pcr_attribute3
318: ,p_pcr_attribute4_o =>ben_pcr_shd.g_old_rec.pcr_attribute4
319: ,p_pcr_attribute5_o =>ben_pcr_shd.g_old_rec.pcr_attribute5
320: ,p_pcr_attribute6_o =>ben_pcr_shd.g_old_rec.pcr_attribute6

Line 317: ,p_pcr_attribute3_o =>ben_pcr_shd.g_old_rec.pcr_attribute3

313: ,p_business_group_id_o =>ben_pcr_shd.g_old_rec.business_group_id
314: ,p_pcr_attribute_category_o =>ben_pcr_shd.g_old_rec.pcr_attribute_category
315: ,p_pcr_attribute1_o =>ben_pcr_shd.g_old_rec.pcr_attribute1
316: ,p_pcr_attribute2_o =>ben_pcr_shd.g_old_rec.pcr_attribute2
317: ,p_pcr_attribute3_o =>ben_pcr_shd.g_old_rec.pcr_attribute3
318: ,p_pcr_attribute4_o =>ben_pcr_shd.g_old_rec.pcr_attribute4
319: ,p_pcr_attribute5_o =>ben_pcr_shd.g_old_rec.pcr_attribute5
320: ,p_pcr_attribute6_o =>ben_pcr_shd.g_old_rec.pcr_attribute6
321: ,p_pcr_attribute7_o =>ben_pcr_shd.g_old_rec.pcr_attribute7

Line 318: ,p_pcr_attribute4_o =>ben_pcr_shd.g_old_rec.pcr_attribute4

314: ,p_pcr_attribute_category_o =>ben_pcr_shd.g_old_rec.pcr_attribute_category
315: ,p_pcr_attribute1_o =>ben_pcr_shd.g_old_rec.pcr_attribute1
316: ,p_pcr_attribute2_o =>ben_pcr_shd.g_old_rec.pcr_attribute2
317: ,p_pcr_attribute3_o =>ben_pcr_shd.g_old_rec.pcr_attribute3
318: ,p_pcr_attribute4_o =>ben_pcr_shd.g_old_rec.pcr_attribute4
319: ,p_pcr_attribute5_o =>ben_pcr_shd.g_old_rec.pcr_attribute5
320: ,p_pcr_attribute6_o =>ben_pcr_shd.g_old_rec.pcr_attribute6
321: ,p_pcr_attribute7_o =>ben_pcr_shd.g_old_rec.pcr_attribute7
322: ,p_pcr_attribute8_o =>ben_pcr_shd.g_old_rec.pcr_attribute8

Line 319: ,p_pcr_attribute5_o =>ben_pcr_shd.g_old_rec.pcr_attribute5

315: ,p_pcr_attribute1_o =>ben_pcr_shd.g_old_rec.pcr_attribute1
316: ,p_pcr_attribute2_o =>ben_pcr_shd.g_old_rec.pcr_attribute2
317: ,p_pcr_attribute3_o =>ben_pcr_shd.g_old_rec.pcr_attribute3
318: ,p_pcr_attribute4_o =>ben_pcr_shd.g_old_rec.pcr_attribute4
319: ,p_pcr_attribute5_o =>ben_pcr_shd.g_old_rec.pcr_attribute5
320: ,p_pcr_attribute6_o =>ben_pcr_shd.g_old_rec.pcr_attribute6
321: ,p_pcr_attribute7_o =>ben_pcr_shd.g_old_rec.pcr_attribute7
322: ,p_pcr_attribute8_o =>ben_pcr_shd.g_old_rec.pcr_attribute8
323: ,p_pcr_attribute9_o =>ben_pcr_shd.g_old_rec.pcr_attribute9

Line 320: ,p_pcr_attribute6_o =>ben_pcr_shd.g_old_rec.pcr_attribute6

316: ,p_pcr_attribute2_o =>ben_pcr_shd.g_old_rec.pcr_attribute2
317: ,p_pcr_attribute3_o =>ben_pcr_shd.g_old_rec.pcr_attribute3
318: ,p_pcr_attribute4_o =>ben_pcr_shd.g_old_rec.pcr_attribute4
319: ,p_pcr_attribute5_o =>ben_pcr_shd.g_old_rec.pcr_attribute5
320: ,p_pcr_attribute6_o =>ben_pcr_shd.g_old_rec.pcr_attribute6
321: ,p_pcr_attribute7_o =>ben_pcr_shd.g_old_rec.pcr_attribute7
322: ,p_pcr_attribute8_o =>ben_pcr_shd.g_old_rec.pcr_attribute8
323: ,p_pcr_attribute9_o =>ben_pcr_shd.g_old_rec.pcr_attribute9
324: ,p_pcr_attribute10_o =>ben_pcr_shd.g_old_rec.pcr_attribute10

Line 321: ,p_pcr_attribute7_o =>ben_pcr_shd.g_old_rec.pcr_attribute7

317: ,p_pcr_attribute3_o =>ben_pcr_shd.g_old_rec.pcr_attribute3
318: ,p_pcr_attribute4_o =>ben_pcr_shd.g_old_rec.pcr_attribute4
319: ,p_pcr_attribute5_o =>ben_pcr_shd.g_old_rec.pcr_attribute5
320: ,p_pcr_attribute6_o =>ben_pcr_shd.g_old_rec.pcr_attribute6
321: ,p_pcr_attribute7_o =>ben_pcr_shd.g_old_rec.pcr_attribute7
322: ,p_pcr_attribute8_o =>ben_pcr_shd.g_old_rec.pcr_attribute8
323: ,p_pcr_attribute9_o =>ben_pcr_shd.g_old_rec.pcr_attribute9
324: ,p_pcr_attribute10_o =>ben_pcr_shd.g_old_rec.pcr_attribute10
325: ,p_pcr_attribute11_o =>ben_pcr_shd.g_old_rec.pcr_attribute11

Line 322: ,p_pcr_attribute8_o =>ben_pcr_shd.g_old_rec.pcr_attribute8

318: ,p_pcr_attribute4_o =>ben_pcr_shd.g_old_rec.pcr_attribute4
319: ,p_pcr_attribute5_o =>ben_pcr_shd.g_old_rec.pcr_attribute5
320: ,p_pcr_attribute6_o =>ben_pcr_shd.g_old_rec.pcr_attribute6
321: ,p_pcr_attribute7_o =>ben_pcr_shd.g_old_rec.pcr_attribute7
322: ,p_pcr_attribute8_o =>ben_pcr_shd.g_old_rec.pcr_attribute8
323: ,p_pcr_attribute9_o =>ben_pcr_shd.g_old_rec.pcr_attribute9
324: ,p_pcr_attribute10_o =>ben_pcr_shd.g_old_rec.pcr_attribute10
325: ,p_pcr_attribute11_o =>ben_pcr_shd.g_old_rec.pcr_attribute11
326: ,p_pcr_attribute12_o =>ben_pcr_shd.g_old_rec.pcr_attribute12

Line 323: ,p_pcr_attribute9_o =>ben_pcr_shd.g_old_rec.pcr_attribute9

319: ,p_pcr_attribute5_o =>ben_pcr_shd.g_old_rec.pcr_attribute5
320: ,p_pcr_attribute6_o =>ben_pcr_shd.g_old_rec.pcr_attribute6
321: ,p_pcr_attribute7_o =>ben_pcr_shd.g_old_rec.pcr_attribute7
322: ,p_pcr_attribute8_o =>ben_pcr_shd.g_old_rec.pcr_attribute8
323: ,p_pcr_attribute9_o =>ben_pcr_shd.g_old_rec.pcr_attribute9
324: ,p_pcr_attribute10_o =>ben_pcr_shd.g_old_rec.pcr_attribute10
325: ,p_pcr_attribute11_o =>ben_pcr_shd.g_old_rec.pcr_attribute11
326: ,p_pcr_attribute12_o =>ben_pcr_shd.g_old_rec.pcr_attribute12
327: ,p_pcr_attribute13_o =>ben_pcr_shd.g_old_rec.pcr_attribute13

Line 324: ,p_pcr_attribute10_o =>ben_pcr_shd.g_old_rec.pcr_attribute10

320: ,p_pcr_attribute6_o =>ben_pcr_shd.g_old_rec.pcr_attribute6
321: ,p_pcr_attribute7_o =>ben_pcr_shd.g_old_rec.pcr_attribute7
322: ,p_pcr_attribute8_o =>ben_pcr_shd.g_old_rec.pcr_attribute8
323: ,p_pcr_attribute9_o =>ben_pcr_shd.g_old_rec.pcr_attribute9
324: ,p_pcr_attribute10_o =>ben_pcr_shd.g_old_rec.pcr_attribute10
325: ,p_pcr_attribute11_o =>ben_pcr_shd.g_old_rec.pcr_attribute11
326: ,p_pcr_attribute12_o =>ben_pcr_shd.g_old_rec.pcr_attribute12
327: ,p_pcr_attribute13_o =>ben_pcr_shd.g_old_rec.pcr_attribute13
328: ,p_pcr_attribute14_o =>ben_pcr_shd.g_old_rec.pcr_attribute14

Line 325: ,p_pcr_attribute11_o =>ben_pcr_shd.g_old_rec.pcr_attribute11

321: ,p_pcr_attribute7_o =>ben_pcr_shd.g_old_rec.pcr_attribute7
322: ,p_pcr_attribute8_o =>ben_pcr_shd.g_old_rec.pcr_attribute8
323: ,p_pcr_attribute9_o =>ben_pcr_shd.g_old_rec.pcr_attribute9
324: ,p_pcr_attribute10_o =>ben_pcr_shd.g_old_rec.pcr_attribute10
325: ,p_pcr_attribute11_o =>ben_pcr_shd.g_old_rec.pcr_attribute11
326: ,p_pcr_attribute12_o =>ben_pcr_shd.g_old_rec.pcr_attribute12
327: ,p_pcr_attribute13_o =>ben_pcr_shd.g_old_rec.pcr_attribute13
328: ,p_pcr_attribute14_o =>ben_pcr_shd.g_old_rec.pcr_attribute14
329: ,p_pcr_attribute15_o =>ben_pcr_shd.g_old_rec.pcr_attribute15

Line 326: ,p_pcr_attribute12_o =>ben_pcr_shd.g_old_rec.pcr_attribute12

322: ,p_pcr_attribute8_o =>ben_pcr_shd.g_old_rec.pcr_attribute8
323: ,p_pcr_attribute9_o =>ben_pcr_shd.g_old_rec.pcr_attribute9
324: ,p_pcr_attribute10_o =>ben_pcr_shd.g_old_rec.pcr_attribute10
325: ,p_pcr_attribute11_o =>ben_pcr_shd.g_old_rec.pcr_attribute11
326: ,p_pcr_attribute12_o =>ben_pcr_shd.g_old_rec.pcr_attribute12
327: ,p_pcr_attribute13_o =>ben_pcr_shd.g_old_rec.pcr_attribute13
328: ,p_pcr_attribute14_o =>ben_pcr_shd.g_old_rec.pcr_attribute14
329: ,p_pcr_attribute15_o =>ben_pcr_shd.g_old_rec.pcr_attribute15
330: ,p_pcr_attribute16_o =>ben_pcr_shd.g_old_rec.pcr_attribute16

Line 327: ,p_pcr_attribute13_o =>ben_pcr_shd.g_old_rec.pcr_attribute13

323: ,p_pcr_attribute9_o =>ben_pcr_shd.g_old_rec.pcr_attribute9
324: ,p_pcr_attribute10_o =>ben_pcr_shd.g_old_rec.pcr_attribute10
325: ,p_pcr_attribute11_o =>ben_pcr_shd.g_old_rec.pcr_attribute11
326: ,p_pcr_attribute12_o =>ben_pcr_shd.g_old_rec.pcr_attribute12
327: ,p_pcr_attribute13_o =>ben_pcr_shd.g_old_rec.pcr_attribute13
328: ,p_pcr_attribute14_o =>ben_pcr_shd.g_old_rec.pcr_attribute14
329: ,p_pcr_attribute15_o =>ben_pcr_shd.g_old_rec.pcr_attribute15
330: ,p_pcr_attribute16_o =>ben_pcr_shd.g_old_rec.pcr_attribute16
331: ,p_pcr_attribute17_o =>ben_pcr_shd.g_old_rec.pcr_attribute17

Line 328: ,p_pcr_attribute14_o =>ben_pcr_shd.g_old_rec.pcr_attribute14

324: ,p_pcr_attribute10_o =>ben_pcr_shd.g_old_rec.pcr_attribute10
325: ,p_pcr_attribute11_o =>ben_pcr_shd.g_old_rec.pcr_attribute11
326: ,p_pcr_attribute12_o =>ben_pcr_shd.g_old_rec.pcr_attribute12
327: ,p_pcr_attribute13_o =>ben_pcr_shd.g_old_rec.pcr_attribute13
328: ,p_pcr_attribute14_o =>ben_pcr_shd.g_old_rec.pcr_attribute14
329: ,p_pcr_attribute15_o =>ben_pcr_shd.g_old_rec.pcr_attribute15
330: ,p_pcr_attribute16_o =>ben_pcr_shd.g_old_rec.pcr_attribute16
331: ,p_pcr_attribute17_o =>ben_pcr_shd.g_old_rec.pcr_attribute17
332: ,p_pcr_attribute18_o =>ben_pcr_shd.g_old_rec.pcr_attribute18

Line 329: ,p_pcr_attribute15_o =>ben_pcr_shd.g_old_rec.pcr_attribute15

325: ,p_pcr_attribute11_o =>ben_pcr_shd.g_old_rec.pcr_attribute11
326: ,p_pcr_attribute12_o =>ben_pcr_shd.g_old_rec.pcr_attribute12
327: ,p_pcr_attribute13_o =>ben_pcr_shd.g_old_rec.pcr_attribute13
328: ,p_pcr_attribute14_o =>ben_pcr_shd.g_old_rec.pcr_attribute14
329: ,p_pcr_attribute15_o =>ben_pcr_shd.g_old_rec.pcr_attribute15
330: ,p_pcr_attribute16_o =>ben_pcr_shd.g_old_rec.pcr_attribute16
331: ,p_pcr_attribute17_o =>ben_pcr_shd.g_old_rec.pcr_attribute17
332: ,p_pcr_attribute18_o =>ben_pcr_shd.g_old_rec.pcr_attribute18
333: ,p_pcr_attribute19_o =>ben_pcr_shd.g_old_rec.pcr_attribute19

Line 330: ,p_pcr_attribute16_o =>ben_pcr_shd.g_old_rec.pcr_attribute16

326: ,p_pcr_attribute12_o =>ben_pcr_shd.g_old_rec.pcr_attribute12
327: ,p_pcr_attribute13_o =>ben_pcr_shd.g_old_rec.pcr_attribute13
328: ,p_pcr_attribute14_o =>ben_pcr_shd.g_old_rec.pcr_attribute14
329: ,p_pcr_attribute15_o =>ben_pcr_shd.g_old_rec.pcr_attribute15
330: ,p_pcr_attribute16_o =>ben_pcr_shd.g_old_rec.pcr_attribute16
331: ,p_pcr_attribute17_o =>ben_pcr_shd.g_old_rec.pcr_attribute17
332: ,p_pcr_attribute18_o =>ben_pcr_shd.g_old_rec.pcr_attribute18
333: ,p_pcr_attribute19_o =>ben_pcr_shd.g_old_rec.pcr_attribute19
334: ,p_pcr_attribute20_o =>ben_pcr_shd.g_old_rec.pcr_attribute20

Line 331: ,p_pcr_attribute17_o =>ben_pcr_shd.g_old_rec.pcr_attribute17

327: ,p_pcr_attribute13_o =>ben_pcr_shd.g_old_rec.pcr_attribute13
328: ,p_pcr_attribute14_o =>ben_pcr_shd.g_old_rec.pcr_attribute14
329: ,p_pcr_attribute15_o =>ben_pcr_shd.g_old_rec.pcr_attribute15
330: ,p_pcr_attribute16_o =>ben_pcr_shd.g_old_rec.pcr_attribute16
331: ,p_pcr_attribute17_o =>ben_pcr_shd.g_old_rec.pcr_attribute17
332: ,p_pcr_attribute18_o =>ben_pcr_shd.g_old_rec.pcr_attribute18
333: ,p_pcr_attribute19_o =>ben_pcr_shd.g_old_rec.pcr_attribute19
334: ,p_pcr_attribute20_o =>ben_pcr_shd.g_old_rec.pcr_attribute20
335: ,p_pcr_attribute21_o =>ben_pcr_shd.g_old_rec.pcr_attribute21

Line 332: ,p_pcr_attribute18_o =>ben_pcr_shd.g_old_rec.pcr_attribute18

328: ,p_pcr_attribute14_o =>ben_pcr_shd.g_old_rec.pcr_attribute14
329: ,p_pcr_attribute15_o =>ben_pcr_shd.g_old_rec.pcr_attribute15
330: ,p_pcr_attribute16_o =>ben_pcr_shd.g_old_rec.pcr_attribute16
331: ,p_pcr_attribute17_o =>ben_pcr_shd.g_old_rec.pcr_attribute17
332: ,p_pcr_attribute18_o =>ben_pcr_shd.g_old_rec.pcr_attribute18
333: ,p_pcr_attribute19_o =>ben_pcr_shd.g_old_rec.pcr_attribute19
334: ,p_pcr_attribute20_o =>ben_pcr_shd.g_old_rec.pcr_attribute20
335: ,p_pcr_attribute21_o =>ben_pcr_shd.g_old_rec.pcr_attribute21
336: ,p_pcr_attribute22_o =>ben_pcr_shd.g_old_rec.pcr_attribute22

Line 333: ,p_pcr_attribute19_o =>ben_pcr_shd.g_old_rec.pcr_attribute19

329: ,p_pcr_attribute15_o =>ben_pcr_shd.g_old_rec.pcr_attribute15
330: ,p_pcr_attribute16_o =>ben_pcr_shd.g_old_rec.pcr_attribute16
331: ,p_pcr_attribute17_o =>ben_pcr_shd.g_old_rec.pcr_attribute17
332: ,p_pcr_attribute18_o =>ben_pcr_shd.g_old_rec.pcr_attribute18
333: ,p_pcr_attribute19_o =>ben_pcr_shd.g_old_rec.pcr_attribute19
334: ,p_pcr_attribute20_o =>ben_pcr_shd.g_old_rec.pcr_attribute20
335: ,p_pcr_attribute21_o =>ben_pcr_shd.g_old_rec.pcr_attribute21
336: ,p_pcr_attribute22_o =>ben_pcr_shd.g_old_rec.pcr_attribute22
337: ,p_pcr_attribute23_o =>ben_pcr_shd.g_old_rec.pcr_attribute23

Line 334: ,p_pcr_attribute20_o =>ben_pcr_shd.g_old_rec.pcr_attribute20

330: ,p_pcr_attribute16_o =>ben_pcr_shd.g_old_rec.pcr_attribute16
331: ,p_pcr_attribute17_o =>ben_pcr_shd.g_old_rec.pcr_attribute17
332: ,p_pcr_attribute18_o =>ben_pcr_shd.g_old_rec.pcr_attribute18
333: ,p_pcr_attribute19_o =>ben_pcr_shd.g_old_rec.pcr_attribute19
334: ,p_pcr_attribute20_o =>ben_pcr_shd.g_old_rec.pcr_attribute20
335: ,p_pcr_attribute21_o =>ben_pcr_shd.g_old_rec.pcr_attribute21
336: ,p_pcr_attribute22_o =>ben_pcr_shd.g_old_rec.pcr_attribute22
337: ,p_pcr_attribute23_o =>ben_pcr_shd.g_old_rec.pcr_attribute23
338: ,p_pcr_attribute24_o =>ben_pcr_shd.g_old_rec.pcr_attribute24

Line 335: ,p_pcr_attribute21_o =>ben_pcr_shd.g_old_rec.pcr_attribute21

331: ,p_pcr_attribute17_o =>ben_pcr_shd.g_old_rec.pcr_attribute17
332: ,p_pcr_attribute18_o =>ben_pcr_shd.g_old_rec.pcr_attribute18
333: ,p_pcr_attribute19_o =>ben_pcr_shd.g_old_rec.pcr_attribute19
334: ,p_pcr_attribute20_o =>ben_pcr_shd.g_old_rec.pcr_attribute20
335: ,p_pcr_attribute21_o =>ben_pcr_shd.g_old_rec.pcr_attribute21
336: ,p_pcr_attribute22_o =>ben_pcr_shd.g_old_rec.pcr_attribute22
337: ,p_pcr_attribute23_o =>ben_pcr_shd.g_old_rec.pcr_attribute23
338: ,p_pcr_attribute24_o =>ben_pcr_shd.g_old_rec.pcr_attribute24
339: ,p_pcr_attribute25_o =>ben_pcr_shd.g_old_rec.pcr_attribute25

Line 336: ,p_pcr_attribute22_o =>ben_pcr_shd.g_old_rec.pcr_attribute22

332: ,p_pcr_attribute18_o =>ben_pcr_shd.g_old_rec.pcr_attribute18
333: ,p_pcr_attribute19_o =>ben_pcr_shd.g_old_rec.pcr_attribute19
334: ,p_pcr_attribute20_o =>ben_pcr_shd.g_old_rec.pcr_attribute20
335: ,p_pcr_attribute21_o =>ben_pcr_shd.g_old_rec.pcr_attribute21
336: ,p_pcr_attribute22_o =>ben_pcr_shd.g_old_rec.pcr_attribute22
337: ,p_pcr_attribute23_o =>ben_pcr_shd.g_old_rec.pcr_attribute23
338: ,p_pcr_attribute24_o =>ben_pcr_shd.g_old_rec.pcr_attribute24
339: ,p_pcr_attribute25_o =>ben_pcr_shd.g_old_rec.pcr_attribute25
340: ,p_pcr_attribute26_o =>ben_pcr_shd.g_old_rec.pcr_attribute26

Line 337: ,p_pcr_attribute23_o =>ben_pcr_shd.g_old_rec.pcr_attribute23

333: ,p_pcr_attribute19_o =>ben_pcr_shd.g_old_rec.pcr_attribute19
334: ,p_pcr_attribute20_o =>ben_pcr_shd.g_old_rec.pcr_attribute20
335: ,p_pcr_attribute21_o =>ben_pcr_shd.g_old_rec.pcr_attribute21
336: ,p_pcr_attribute22_o =>ben_pcr_shd.g_old_rec.pcr_attribute22
337: ,p_pcr_attribute23_o =>ben_pcr_shd.g_old_rec.pcr_attribute23
338: ,p_pcr_attribute24_o =>ben_pcr_shd.g_old_rec.pcr_attribute24
339: ,p_pcr_attribute25_o =>ben_pcr_shd.g_old_rec.pcr_attribute25
340: ,p_pcr_attribute26_o =>ben_pcr_shd.g_old_rec.pcr_attribute26
341: ,p_pcr_attribute27_o =>ben_pcr_shd.g_old_rec.pcr_attribute27

Line 338: ,p_pcr_attribute24_o =>ben_pcr_shd.g_old_rec.pcr_attribute24

334: ,p_pcr_attribute20_o =>ben_pcr_shd.g_old_rec.pcr_attribute20
335: ,p_pcr_attribute21_o =>ben_pcr_shd.g_old_rec.pcr_attribute21
336: ,p_pcr_attribute22_o =>ben_pcr_shd.g_old_rec.pcr_attribute22
337: ,p_pcr_attribute23_o =>ben_pcr_shd.g_old_rec.pcr_attribute23
338: ,p_pcr_attribute24_o =>ben_pcr_shd.g_old_rec.pcr_attribute24
339: ,p_pcr_attribute25_o =>ben_pcr_shd.g_old_rec.pcr_attribute25
340: ,p_pcr_attribute26_o =>ben_pcr_shd.g_old_rec.pcr_attribute26
341: ,p_pcr_attribute27_o =>ben_pcr_shd.g_old_rec.pcr_attribute27
342: ,p_pcr_attribute28_o =>ben_pcr_shd.g_old_rec.pcr_attribute28

Line 339: ,p_pcr_attribute25_o =>ben_pcr_shd.g_old_rec.pcr_attribute25

335: ,p_pcr_attribute21_o =>ben_pcr_shd.g_old_rec.pcr_attribute21
336: ,p_pcr_attribute22_o =>ben_pcr_shd.g_old_rec.pcr_attribute22
337: ,p_pcr_attribute23_o =>ben_pcr_shd.g_old_rec.pcr_attribute23
338: ,p_pcr_attribute24_o =>ben_pcr_shd.g_old_rec.pcr_attribute24
339: ,p_pcr_attribute25_o =>ben_pcr_shd.g_old_rec.pcr_attribute25
340: ,p_pcr_attribute26_o =>ben_pcr_shd.g_old_rec.pcr_attribute26
341: ,p_pcr_attribute27_o =>ben_pcr_shd.g_old_rec.pcr_attribute27
342: ,p_pcr_attribute28_o =>ben_pcr_shd.g_old_rec.pcr_attribute28
343: ,p_pcr_attribute29_o =>ben_pcr_shd.g_old_rec.pcr_attribute29

Line 340: ,p_pcr_attribute26_o =>ben_pcr_shd.g_old_rec.pcr_attribute26

336: ,p_pcr_attribute22_o =>ben_pcr_shd.g_old_rec.pcr_attribute22
337: ,p_pcr_attribute23_o =>ben_pcr_shd.g_old_rec.pcr_attribute23
338: ,p_pcr_attribute24_o =>ben_pcr_shd.g_old_rec.pcr_attribute24
339: ,p_pcr_attribute25_o =>ben_pcr_shd.g_old_rec.pcr_attribute25
340: ,p_pcr_attribute26_o =>ben_pcr_shd.g_old_rec.pcr_attribute26
341: ,p_pcr_attribute27_o =>ben_pcr_shd.g_old_rec.pcr_attribute27
342: ,p_pcr_attribute28_o =>ben_pcr_shd.g_old_rec.pcr_attribute28
343: ,p_pcr_attribute29_o =>ben_pcr_shd.g_old_rec.pcr_attribute29
344: ,p_pcr_attribute30_o =>ben_pcr_shd.g_old_rec.pcr_attribute30

Line 341: ,p_pcr_attribute27_o =>ben_pcr_shd.g_old_rec.pcr_attribute27

337: ,p_pcr_attribute23_o =>ben_pcr_shd.g_old_rec.pcr_attribute23
338: ,p_pcr_attribute24_o =>ben_pcr_shd.g_old_rec.pcr_attribute24
339: ,p_pcr_attribute25_o =>ben_pcr_shd.g_old_rec.pcr_attribute25
340: ,p_pcr_attribute26_o =>ben_pcr_shd.g_old_rec.pcr_attribute26
341: ,p_pcr_attribute27_o =>ben_pcr_shd.g_old_rec.pcr_attribute27
342: ,p_pcr_attribute28_o =>ben_pcr_shd.g_old_rec.pcr_attribute28
343: ,p_pcr_attribute29_o =>ben_pcr_shd.g_old_rec.pcr_attribute29
344: ,p_pcr_attribute30_o =>ben_pcr_shd.g_old_rec.pcr_attribute30
345: ,p_request_id_o =>ben_pcr_shd.g_old_rec.request_id

Line 342: ,p_pcr_attribute28_o =>ben_pcr_shd.g_old_rec.pcr_attribute28

338: ,p_pcr_attribute24_o =>ben_pcr_shd.g_old_rec.pcr_attribute24
339: ,p_pcr_attribute25_o =>ben_pcr_shd.g_old_rec.pcr_attribute25
340: ,p_pcr_attribute26_o =>ben_pcr_shd.g_old_rec.pcr_attribute26
341: ,p_pcr_attribute27_o =>ben_pcr_shd.g_old_rec.pcr_attribute27
342: ,p_pcr_attribute28_o =>ben_pcr_shd.g_old_rec.pcr_attribute28
343: ,p_pcr_attribute29_o =>ben_pcr_shd.g_old_rec.pcr_attribute29
344: ,p_pcr_attribute30_o =>ben_pcr_shd.g_old_rec.pcr_attribute30
345: ,p_request_id_o =>ben_pcr_shd.g_old_rec.request_id
346: ,p_program_application_id_o =>ben_pcr_shd.g_old_rec.program_application_id

Line 343: ,p_pcr_attribute29_o =>ben_pcr_shd.g_old_rec.pcr_attribute29

339: ,p_pcr_attribute25_o =>ben_pcr_shd.g_old_rec.pcr_attribute25
340: ,p_pcr_attribute26_o =>ben_pcr_shd.g_old_rec.pcr_attribute26
341: ,p_pcr_attribute27_o =>ben_pcr_shd.g_old_rec.pcr_attribute27
342: ,p_pcr_attribute28_o =>ben_pcr_shd.g_old_rec.pcr_attribute28
343: ,p_pcr_attribute29_o =>ben_pcr_shd.g_old_rec.pcr_attribute29
344: ,p_pcr_attribute30_o =>ben_pcr_shd.g_old_rec.pcr_attribute30
345: ,p_request_id_o =>ben_pcr_shd.g_old_rec.request_id
346: ,p_program_application_id_o =>ben_pcr_shd.g_old_rec.program_application_id
347: ,p_program_id_o =>ben_pcr_shd.g_old_rec.program_id

Line 344: ,p_pcr_attribute30_o =>ben_pcr_shd.g_old_rec.pcr_attribute30

340: ,p_pcr_attribute26_o =>ben_pcr_shd.g_old_rec.pcr_attribute26
341: ,p_pcr_attribute27_o =>ben_pcr_shd.g_old_rec.pcr_attribute27
342: ,p_pcr_attribute28_o =>ben_pcr_shd.g_old_rec.pcr_attribute28
343: ,p_pcr_attribute29_o =>ben_pcr_shd.g_old_rec.pcr_attribute29
344: ,p_pcr_attribute30_o =>ben_pcr_shd.g_old_rec.pcr_attribute30
345: ,p_request_id_o =>ben_pcr_shd.g_old_rec.request_id
346: ,p_program_application_id_o =>ben_pcr_shd.g_old_rec.program_application_id
347: ,p_program_id_o =>ben_pcr_shd.g_old_rec.program_id
348: ,p_program_update_date_o =>ben_pcr_shd.g_old_rec.program_update_date

Line 345: ,p_request_id_o =>ben_pcr_shd.g_old_rec.request_id

341: ,p_pcr_attribute27_o =>ben_pcr_shd.g_old_rec.pcr_attribute27
342: ,p_pcr_attribute28_o =>ben_pcr_shd.g_old_rec.pcr_attribute28
343: ,p_pcr_attribute29_o =>ben_pcr_shd.g_old_rec.pcr_attribute29
344: ,p_pcr_attribute30_o =>ben_pcr_shd.g_old_rec.pcr_attribute30
345: ,p_request_id_o =>ben_pcr_shd.g_old_rec.request_id
346: ,p_program_application_id_o =>ben_pcr_shd.g_old_rec.program_application_id
347: ,p_program_id_o =>ben_pcr_shd.g_old_rec.program_id
348: ,p_program_update_date_o =>ben_pcr_shd.g_old_rec.program_update_date
349: ,p_object_version_number_o =>ben_pcr_shd.g_old_rec.object_version_number

Line 346: ,p_program_application_id_o =>ben_pcr_shd.g_old_rec.program_application_id

342: ,p_pcr_attribute28_o =>ben_pcr_shd.g_old_rec.pcr_attribute28
343: ,p_pcr_attribute29_o =>ben_pcr_shd.g_old_rec.pcr_attribute29
344: ,p_pcr_attribute30_o =>ben_pcr_shd.g_old_rec.pcr_attribute30
345: ,p_request_id_o =>ben_pcr_shd.g_old_rec.request_id
346: ,p_program_application_id_o =>ben_pcr_shd.g_old_rec.program_application_id
347: ,p_program_id_o =>ben_pcr_shd.g_old_rec.program_id
348: ,p_program_update_date_o =>ben_pcr_shd.g_old_rec.program_update_date
349: ,p_object_version_number_o =>ben_pcr_shd.g_old_rec.object_version_number
350: );

Line 347: ,p_program_id_o =>ben_pcr_shd.g_old_rec.program_id

343: ,p_pcr_attribute29_o =>ben_pcr_shd.g_old_rec.pcr_attribute29
344: ,p_pcr_attribute30_o =>ben_pcr_shd.g_old_rec.pcr_attribute30
345: ,p_request_id_o =>ben_pcr_shd.g_old_rec.request_id
346: ,p_program_application_id_o =>ben_pcr_shd.g_old_rec.program_application_id
347: ,p_program_id_o =>ben_pcr_shd.g_old_rec.program_id
348: ,p_program_update_date_o =>ben_pcr_shd.g_old_rec.program_update_date
349: ,p_object_version_number_o =>ben_pcr_shd.g_old_rec.object_version_number
350: );
351: --

Line 348: ,p_program_update_date_o =>ben_pcr_shd.g_old_rec.program_update_date

344: ,p_pcr_attribute30_o =>ben_pcr_shd.g_old_rec.pcr_attribute30
345: ,p_request_id_o =>ben_pcr_shd.g_old_rec.request_id
346: ,p_program_application_id_o =>ben_pcr_shd.g_old_rec.program_application_id
347: ,p_program_id_o =>ben_pcr_shd.g_old_rec.program_id
348: ,p_program_update_date_o =>ben_pcr_shd.g_old_rec.program_update_date
349: ,p_object_version_number_o =>ben_pcr_shd.g_old_rec.object_version_number
350: );
351: --
352: exception

Line 349: ,p_object_version_number_o =>ben_pcr_shd.g_old_rec.object_version_number

345: ,p_request_id_o =>ben_pcr_shd.g_old_rec.request_id
346: ,p_program_application_id_o =>ben_pcr_shd.g_old_rec.program_application_id
347: ,p_program_id_o =>ben_pcr_shd.g_old_rec.program_id
348: ,p_program_update_date_o =>ben_pcr_shd.g_old_rec.program_update_date
349: ,p_object_version_number_o =>ben_pcr_shd.g_old_rec.object_version_number
350: );
351: --
352: exception
353: --

Line 373: p_rec in out nocopy ben_pcr_shd.g_rec_type,

369: -- |---------------------------------< del >----------------------------------|
370: -- ----------------------------------------------------------------------------
371: Procedure del
372: (
373: p_rec in out nocopy ben_pcr_shd.g_rec_type,
374: p_effective_date in date,
375: p_datetrack_mode in varchar2
376: ) is
377: --

Line 391: ben_pcr_shd.lck

387: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
388: --
389: -- We must lock the row which we need to delete.
390: --
391: ben_pcr_shd.lck
392: (p_effective_date => p_effective_date,
393: p_datetrack_mode => p_datetrack_mode,
394: p_per_cm_trgr_id => p_rec.per_cm_trgr_id,
395: p_object_version_number => p_rec.object_version_number,

Line 449: l_rec ben_pcr_shd.g_rec_type;

445: p_effective_date in date,
446: p_datetrack_mode in varchar2
447: ) is
448: --
449: l_rec ben_pcr_shd.g_rec_type;
450: l_proc varchar2(72) := g_package||'del';
451: --
452: Begin
453: hr_utility.set_location('Entering:'||l_proc, 5);