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_CWG_UPD dependencies on BEN_CWG_SHD

Line 55: (p_rec in out nocopy ben_cwg_shd.g_rec_type

51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy ben_cwg_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --

Line 120: ben_cwg_shd.constraint_error

116: Exception
117: When hr_api.check_integrity_violated Then
118: -- A check constraint has been violated
119: --
120: ben_cwg_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.parent_integrity_violated Then
123: -- Parent integrity has been violated
124: --

Line 125: ben_cwg_shd.constraint_error

121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.parent_integrity_violated Then
123: -- Parent integrity has been violated
124: --
125: ben_cwg_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.unique_integrity_violated Then
128: -- Unique integrity has been violated
129: --

Line 130: ben_cwg_shd.constraint_error

126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.unique_integrity_violated Then
128: -- Unique integrity has been violated
129: --
130: ben_cwg_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When Others Then
133: --
134: Raise;

Line 170: (p_rec in ben_cwg_shd.g_rec_type

166: --
167: -- {End Of Comments}
168: -- ----------------------------------------------------------------------------
169: Procedure pre_update
170: (p_rec in ben_cwg_shd.g_rec_type
171: ) is
172: --
173: l_proc varchar2(72) := g_package||'pre_update';
174: --

Line 215: ,p_rec in ben_cwg_shd.g_rec_type

211: -- {End Of Comments}
212: -- ----------------------------------------------------------------------------
213: Procedure post_update
214: (p_effective_date in date
215: ,p_rec in ben_cwg_shd.g_rec_type
216: ) is
217: --
218: l_proc varchar2(72) := g_package||'post_update';
219: --

Line 300: => ben_cwg_shd.g_old_rec.business_group_id

296: ,p_hidden_cd => p_rec.hidden_cd
297: ,p_object_version_number
298: => p_rec.object_version_number
299: ,p_business_group_id_o
300: => ben_cwg_shd.g_old_rec.business_group_id
301: ,p_pl_id_o
302: => ben_cwg_shd.g_old_rec.pl_id
303: ,p_ordr_num_o
304: => ben_cwg_shd.g_old_rec.ordr_num

Line 302: => ben_cwg_shd.g_old_rec.pl_id

298: => p_rec.object_version_number
299: ,p_business_group_id_o
300: => ben_cwg_shd.g_old_rec.business_group_id
301: ,p_pl_id_o
302: => ben_cwg_shd.g_old_rec.pl_id
303: ,p_ordr_num_o
304: => ben_cwg_shd.g_old_rec.ordr_num
305: ,p_wksht_grp_cd_o
306: => ben_cwg_shd.g_old_rec.wksht_grp_cd

Line 304: => ben_cwg_shd.g_old_rec.ordr_num

300: => ben_cwg_shd.g_old_rec.business_group_id
301: ,p_pl_id_o
302: => ben_cwg_shd.g_old_rec.pl_id
303: ,p_ordr_num_o
304: => ben_cwg_shd.g_old_rec.ordr_num
305: ,p_wksht_grp_cd_o
306: => ben_cwg_shd.g_old_rec.wksht_grp_cd
307: ,p_label_o
308: => ben_cwg_shd.g_old_rec.label

Line 306: => ben_cwg_shd.g_old_rec.wksht_grp_cd

302: => ben_cwg_shd.g_old_rec.pl_id
303: ,p_ordr_num_o
304: => ben_cwg_shd.g_old_rec.ordr_num
305: ,p_wksht_grp_cd_o
306: => ben_cwg_shd.g_old_rec.wksht_grp_cd
307: ,p_label_o
308: => ben_cwg_shd.g_old_rec.label
309: ,p_cwg_attribute_category_o
310: => ben_cwg_shd.g_old_rec.cwg_attribute_category

Line 308: => ben_cwg_shd.g_old_rec.label

304: => ben_cwg_shd.g_old_rec.ordr_num
305: ,p_wksht_grp_cd_o
306: => ben_cwg_shd.g_old_rec.wksht_grp_cd
307: ,p_label_o
308: => ben_cwg_shd.g_old_rec.label
309: ,p_cwg_attribute_category_o
310: => ben_cwg_shd.g_old_rec.cwg_attribute_category
311: ,p_cwg_attribute1_o
312: => ben_cwg_shd.g_old_rec.cwg_attribute1

Line 310: => ben_cwg_shd.g_old_rec.cwg_attribute_category

306: => ben_cwg_shd.g_old_rec.wksht_grp_cd
307: ,p_label_o
308: => ben_cwg_shd.g_old_rec.label
309: ,p_cwg_attribute_category_o
310: => ben_cwg_shd.g_old_rec.cwg_attribute_category
311: ,p_cwg_attribute1_o
312: => ben_cwg_shd.g_old_rec.cwg_attribute1
313: ,p_cwg_attribute2_o
314: => ben_cwg_shd.g_old_rec.cwg_attribute2

Line 312: => ben_cwg_shd.g_old_rec.cwg_attribute1

308: => ben_cwg_shd.g_old_rec.label
309: ,p_cwg_attribute_category_o
310: => ben_cwg_shd.g_old_rec.cwg_attribute_category
311: ,p_cwg_attribute1_o
312: => ben_cwg_shd.g_old_rec.cwg_attribute1
313: ,p_cwg_attribute2_o
314: => ben_cwg_shd.g_old_rec.cwg_attribute2
315: ,p_cwg_attribute3_o
316: => ben_cwg_shd.g_old_rec.cwg_attribute3

Line 314: => ben_cwg_shd.g_old_rec.cwg_attribute2

310: => ben_cwg_shd.g_old_rec.cwg_attribute_category
311: ,p_cwg_attribute1_o
312: => ben_cwg_shd.g_old_rec.cwg_attribute1
313: ,p_cwg_attribute2_o
314: => ben_cwg_shd.g_old_rec.cwg_attribute2
315: ,p_cwg_attribute3_o
316: => ben_cwg_shd.g_old_rec.cwg_attribute3
317: ,p_cwg_attribute4_o
318: => ben_cwg_shd.g_old_rec.cwg_attribute4

Line 316: => ben_cwg_shd.g_old_rec.cwg_attribute3

312: => ben_cwg_shd.g_old_rec.cwg_attribute1
313: ,p_cwg_attribute2_o
314: => ben_cwg_shd.g_old_rec.cwg_attribute2
315: ,p_cwg_attribute3_o
316: => ben_cwg_shd.g_old_rec.cwg_attribute3
317: ,p_cwg_attribute4_o
318: => ben_cwg_shd.g_old_rec.cwg_attribute4
319: ,p_cwg_attribute5_o
320: => ben_cwg_shd.g_old_rec.cwg_attribute5

Line 318: => ben_cwg_shd.g_old_rec.cwg_attribute4

314: => ben_cwg_shd.g_old_rec.cwg_attribute2
315: ,p_cwg_attribute3_o
316: => ben_cwg_shd.g_old_rec.cwg_attribute3
317: ,p_cwg_attribute4_o
318: => ben_cwg_shd.g_old_rec.cwg_attribute4
319: ,p_cwg_attribute5_o
320: => ben_cwg_shd.g_old_rec.cwg_attribute5
321: ,p_cwg_attribute6_o
322: => ben_cwg_shd.g_old_rec.cwg_attribute6

Line 320: => ben_cwg_shd.g_old_rec.cwg_attribute5

316: => ben_cwg_shd.g_old_rec.cwg_attribute3
317: ,p_cwg_attribute4_o
318: => ben_cwg_shd.g_old_rec.cwg_attribute4
319: ,p_cwg_attribute5_o
320: => ben_cwg_shd.g_old_rec.cwg_attribute5
321: ,p_cwg_attribute6_o
322: => ben_cwg_shd.g_old_rec.cwg_attribute6
323: ,p_cwg_attribute7_o
324: => ben_cwg_shd.g_old_rec.cwg_attribute7

Line 322: => ben_cwg_shd.g_old_rec.cwg_attribute6

318: => ben_cwg_shd.g_old_rec.cwg_attribute4
319: ,p_cwg_attribute5_o
320: => ben_cwg_shd.g_old_rec.cwg_attribute5
321: ,p_cwg_attribute6_o
322: => ben_cwg_shd.g_old_rec.cwg_attribute6
323: ,p_cwg_attribute7_o
324: => ben_cwg_shd.g_old_rec.cwg_attribute7
325: ,p_cwg_attribute8_o
326: => ben_cwg_shd.g_old_rec.cwg_attribute8

Line 324: => ben_cwg_shd.g_old_rec.cwg_attribute7

320: => ben_cwg_shd.g_old_rec.cwg_attribute5
321: ,p_cwg_attribute6_o
322: => ben_cwg_shd.g_old_rec.cwg_attribute6
323: ,p_cwg_attribute7_o
324: => ben_cwg_shd.g_old_rec.cwg_attribute7
325: ,p_cwg_attribute8_o
326: => ben_cwg_shd.g_old_rec.cwg_attribute8
327: ,p_cwg_attribute9_o
328: => ben_cwg_shd.g_old_rec.cwg_attribute9

Line 326: => ben_cwg_shd.g_old_rec.cwg_attribute8

322: => ben_cwg_shd.g_old_rec.cwg_attribute6
323: ,p_cwg_attribute7_o
324: => ben_cwg_shd.g_old_rec.cwg_attribute7
325: ,p_cwg_attribute8_o
326: => ben_cwg_shd.g_old_rec.cwg_attribute8
327: ,p_cwg_attribute9_o
328: => ben_cwg_shd.g_old_rec.cwg_attribute9
329: ,p_cwg_attribute10_o
330: => ben_cwg_shd.g_old_rec.cwg_attribute10

Line 328: => ben_cwg_shd.g_old_rec.cwg_attribute9

324: => ben_cwg_shd.g_old_rec.cwg_attribute7
325: ,p_cwg_attribute8_o
326: => ben_cwg_shd.g_old_rec.cwg_attribute8
327: ,p_cwg_attribute9_o
328: => ben_cwg_shd.g_old_rec.cwg_attribute9
329: ,p_cwg_attribute10_o
330: => ben_cwg_shd.g_old_rec.cwg_attribute10
331: ,p_cwg_attribute11_o
332: => ben_cwg_shd.g_old_rec.cwg_attribute11

Line 330: => ben_cwg_shd.g_old_rec.cwg_attribute10

326: => ben_cwg_shd.g_old_rec.cwg_attribute8
327: ,p_cwg_attribute9_o
328: => ben_cwg_shd.g_old_rec.cwg_attribute9
329: ,p_cwg_attribute10_o
330: => ben_cwg_shd.g_old_rec.cwg_attribute10
331: ,p_cwg_attribute11_o
332: => ben_cwg_shd.g_old_rec.cwg_attribute11
333: ,p_cwg_attribute12_o
334: => ben_cwg_shd.g_old_rec.cwg_attribute12

Line 332: => ben_cwg_shd.g_old_rec.cwg_attribute11

328: => ben_cwg_shd.g_old_rec.cwg_attribute9
329: ,p_cwg_attribute10_o
330: => ben_cwg_shd.g_old_rec.cwg_attribute10
331: ,p_cwg_attribute11_o
332: => ben_cwg_shd.g_old_rec.cwg_attribute11
333: ,p_cwg_attribute12_o
334: => ben_cwg_shd.g_old_rec.cwg_attribute12
335: ,p_cwg_attribute13_o
336: => ben_cwg_shd.g_old_rec.cwg_attribute13

Line 334: => ben_cwg_shd.g_old_rec.cwg_attribute12

330: => ben_cwg_shd.g_old_rec.cwg_attribute10
331: ,p_cwg_attribute11_o
332: => ben_cwg_shd.g_old_rec.cwg_attribute11
333: ,p_cwg_attribute12_o
334: => ben_cwg_shd.g_old_rec.cwg_attribute12
335: ,p_cwg_attribute13_o
336: => ben_cwg_shd.g_old_rec.cwg_attribute13
337: ,p_cwg_attribute14_o
338: => ben_cwg_shd.g_old_rec.cwg_attribute14

Line 336: => ben_cwg_shd.g_old_rec.cwg_attribute13

332: => ben_cwg_shd.g_old_rec.cwg_attribute11
333: ,p_cwg_attribute12_o
334: => ben_cwg_shd.g_old_rec.cwg_attribute12
335: ,p_cwg_attribute13_o
336: => ben_cwg_shd.g_old_rec.cwg_attribute13
337: ,p_cwg_attribute14_o
338: => ben_cwg_shd.g_old_rec.cwg_attribute14
339: ,p_cwg_attribute15_o
340: => ben_cwg_shd.g_old_rec.cwg_attribute15

Line 338: => ben_cwg_shd.g_old_rec.cwg_attribute14

334: => ben_cwg_shd.g_old_rec.cwg_attribute12
335: ,p_cwg_attribute13_o
336: => ben_cwg_shd.g_old_rec.cwg_attribute13
337: ,p_cwg_attribute14_o
338: => ben_cwg_shd.g_old_rec.cwg_attribute14
339: ,p_cwg_attribute15_o
340: => ben_cwg_shd.g_old_rec.cwg_attribute15
341: ,p_cwg_attribute16_o
342: => ben_cwg_shd.g_old_rec.cwg_attribute16

Line 340: => ben_cwg_shd.g_old_rec.cwg_attribute15

336: => ben_cwg_shd.g_old_rec.cwg_attribute13
337: ,p_cwg_attribute14_o
338: => ben_cwg_shd.g_old_rec.cwg_attribute14
339: ,p_cwg_attribute15_o
340: => ben_cwg_shd.g_old_rec.cwg_attribute15
341: ,p_cwg_attribute16_o
342: => ben_cwg_shd.g_old_rec.cwg_attribute16
343: ,p_cwg_attribute17_o
344: => ben_cwg_shd.g_old_rec.cwg_attribute17

Line 342: => ben_cwg_shd.g_old_rec.cwg_attribute16

338: => ben_cwg_shd.g_old_rec.cwg_attribute14
339: ,p_cwg_attribute15_o
340: => ben_cwg_shd.g_old_rec.cwg_attribute15
341: ,p_cwg_attribute16_o
342: => ben_cwg_shd.g_old_rec.cwg_attribute16
343: ,p_cwg_attribute17_o
344: => ben_cwg_shd.g_old_rec.cwg_attribute17
345: ,p_cwg_attribute18_o
346: => ben_cwg_shd.g_old_rec.cwg_attribute18

Line 344: => ben_cwg_shd.g_old_rec.cwg_attribute17

340: => ben_cwg_shd.g_old_rec.cwg_attribute15
341: ,p_cwg_attribute16_o
342: => ben_cwg_shd.g_old_rec.cwg_attribute16
343: ,p_cwg_attribute17_o
344: => ben_cwg_shd.g_old_rec.cwg_attribute17
345: ,p_cwg_attribute18_o
346: => ben_cwg_shd.g_old_rec.cwg_attribute18
347: ,p_cwg_attribute19_o
348: => ben_cwg_shd.g_old_rec.cwg_attribute19

Line 346: => ben_cwg_shd.g_old_rec.cwg_attribute18

342: => ben_cwg_shd.g_old_rec.cwg_attribute16
343: ,p_cwg_attribute17_o
344: => ben_cwg_shd.g_old_rec.cwg_attribute17
345: ,p_cwg_attribute18_o
346: => ben_cwg_shd.g_old_rec.cwg_attribute18
347: ,p_cwg_attribute19_o
348: => ben_cwg_shd.g_old_rec.cwg_attribute19
349: ,p_cwg_attribute20_o
350: => ben_cwg_shd.g_old_rec.cwg_attribute20

Line 348: => ben_cwg_shd.g_old_rec.cwg_attribute19

344: => ben_cwg_shd.g_old_rec.cwg_attribute17
345: ,p_cwg_attribute18_o
346: => ben_cwg_shd.g_old_rec.cwg_attribute18
347: ,p_cwg_attribute19_o
348: => ben_cwg_shd.g_old_rec.cwg_attribute19
349: ,p_cwg_attribute20_o
350: => ben_cwg_shd.g_old_rec.cwg_attribute20
351: ,p_cwg_attribute21_o
352: => ben_cwg_shd.g_old_rec.cwg_attribute21

Line 350: => ben_cwg_shd.g_old_rec.cwg_attribute20

346: => ben_cwg_shd.g_old_rec.cwg_attribute18
347: ,p_cwg_attribute19_o
348: => ben_cwg_shd.g_old_rec.cwg_attribute19
349: ,p_cwg_attribute20_o
350: => ben_cwg_shd.g_old_rec.cwg_attribute20
351: ,p_cwg_attribute21_o
352: => ben_cwg_shd.g_old_rec.cwg_attribute21
353: ,p_cwg_attribute22_o
354: => ben_cwg_shd.g_old_rec.cwg_attribute22

Line 352: => ben_cwg_shd.g_old_rec.cwg_attribute21

348: => ben_cwg_shd.g_old_rec.cwg_attribute19
349: ,p_cwg_attribute20_o
350: => ben_cwg_shd.g_old_rec.cwg_attribute20
351: ,p_cwg_attribute21_o
352: => ben_cwg_shd.g_old_rec.cwg_attribute21
353: ,p_cwg_attribute22_o
354: => ben_cwg_shd.g_old_rec.cwg_attribute22
355: ,p_cwg_attribute23_o
356: => ben_cwg_shd.g_old_rec.cwg_attribute23

Line 354: => ben_cwg_shd.g_old_rec.cwg_attribute22

350: => ben_cwg_shd.g_old_rec.cwg_attribute20
351: ,p_cwg_attribute21_o
352: => ben_cwg_shd.g_old_rec.cwg_attribute21
353: ,p_cwg_attribute22_o
354: => ben_cwg_shd.g_old_rec.cwg_attribute22
355: ,p_cwg_attribute23_o
356: => ben_cwg_shd.g_old_rec.cwg_attribute23
357: ,p_cwg_attribute24_o
358: => ben_cwg_shd.g_old_rec.cwg_attribute24

Line 356: => ben_cwg_shd.g_old_rec.cwg_attribute23

352: => ben_cwg_shd.g_old_rec.cwg_attribute21
353: ,p_cwg_attribute22_o
354: => ben_cwg_shd.g_old_rec.cwg_attribute22
355: ,p_cwg_attribute23_o
356: => ben_cwg_shd.g_old_rec.cwg_attribute23
357: ,p_cwg_attribute24_o
358: => ben_cwg_shd.g_old_rec.cwg_attribute24
359: ,p_cwg_attribute25_o
360: => ben_cwg_shd.g_old_rec.cwg_attribute25

Line 358: => ben_cwg_shd.g_old_rec.cwg_attribute24

354: => ben_cwg_shd.g_old_rec.cwg_attribute22
355: ,p_cwg_attribute23_o
356: => ben_cwg_shd.g_old_rec.cwg_attribute23
357: ,p_cwg_attribute24_o
358: => ben_cwg_shd.g_old_rec.cwg_attribute24
359: ,p_cwg_attribute25_o
360: => ben_cwg_shd.g_old_rec.cwg_attribute25
361: ,p_cwg_attribute26_o
362: => ben_cwg_shd.g_old_rec.cwg_attribute26

Line 360: => ben_cwg_shd.g_old_rec.cwg_attribute25

356: => ben_cwg_shd.g_old_rec.cwg_attribute23
357: ,p_cwg_attribute24_o
358: => ben_cwg_shd.g_old_rec.cwg_attribute24
359: ,p_cwg_attribute25_o
360: => ben_cwg_shd.g_old_rec.cwg_attribute25
361: ,p_cwg_attribute26_o
362: => ben_cwg_shd.g_old_rec.cwg_attribute26
363: ,p_cwg_attribute27_o
364: => ben_cwg_shd.g_old_rec.cwg_attribute27

Line 362: => ben_cwg_shd.g_old_rec.cwg_attribute26

358: => ben_cwg_shd.g_old_rec.cwg_attribute24
359: ,p_cwg_attribute25_o
360: => ben_cwg_shd.g_old_rec.cwg_attribute25
361: ,p_cwg_attribute26_o
362: => ben_cwg_shd.g_old_rec.cwg_attribute26
363: ,p_cwg_attribute27_o
364: => ben_cwg_shd.g_old_rec.cwg_attribute27
365: ,p_cwg_attribute28_o
366: => ben_cwg_shd.g_old_rec.cwg_attribute28

Line 364: => ben_cwg_shd.g_old_rec.cwg_attribute27

360: => ben_cwg_shd.g_old_rec.cwg_attribute25
361: ,p_cwg_attribute26_o
362: => ben_cwg_shd.g_old_rec.cwg_attribute26
363: ,p_cwg_attribute27_o
364: => ben_cwg_shd.g_old_rec.cwg_attribute27
365: ,p_cwg_attribute28_o
366: => ben_cwg_shd.g_old_rec.cwg_attribute28
367: ,p_cwg_attribute29_o
368: => ben_cwg_shd.g_old_rec.cwg_attribute29

Line 366: => ben_cwg_shd.g_old_rec.cwg_attribute28

362: => ben_cwg_shd.g_old_rec.cwg_attribute26
363: ,p_cwg_attribute27_o
364: => ben_cwg_shd.g_old_rec.cwg_attribute27
365: ,p_cwg_attribute28_o
366: => ben_cwg_shd.g_old_rec.cwg_attribute28
367: ,p_cwg_attribute29_o
368: => ben_cwg_shd.g_old_rec.cwg_attribute29
369: ,p_cwg_attribute30_o => ben_cwg_shd.g_old_rec.cwg_attribute30
370: ,p_status_cd_o => ben_cwg_shd.g_old_rec.status_cd

Line 368: => ben_cwg_shd.g_old_rec.cwg_attribute29

364: => ben_cwg_shd.g_old_rec.cwg_attribute27
365: ,p_cwg_attribute28_o
366: => ben_cwg_shd.g_old_rec.cwg_attribute28
367: ,p_cwg_attribute29_o
368: => ben_cwg_shd.g_old_rec.cwg_attribute29
369: ,p_cwg_attribute30_o => ben_cwg_shd.g_old_rec.cwg_attribute30
370: ,p_status_cd_o => ben_cwg_shd.g_old_rec.status_cd
371: ,p_hidden_cd_o => ben_cwg_shd.g_old_rec.hidden_cd
372: ,p_object_version_number_o => ben_cwg_shd.g_old_rec.object_version_number

Line 369: ,p_cwg_attribute30_o => ben_cwg_shd.g_old_rec.cwg_attribute30

365: ,p_cwg_attribute28_o
366: => ben_cwg_shd.g_old_rec.cwg_attribute28
367: ,p_cwg_attribute29_o
368: => ben_cwg_shd.g_old_rec.cwg_attribute29
369: ,p_cwg_attribute30_o => ben_cwg_shd.g_old_rec.cwg_attribute30
370: ,p_status_cd_o => ben_cwg_shd.g_old_rec.status_cd
371: ,p_hidden_cd_o => ben_cwg_shd.g_old_rec.hidden_cd
372: ,p_object_version_number_o => ben_cwg_shd.g_old_rec.object_version_number
373: );

Line 370: ,p_status_cd_o => ben_cwg_shd.g_old_rec.status_cd

366: => ben_cwg_shd.g_old_rec.cwg_attribute28
367: ,p_cwg_attribute29_o
368: => ben_cwg_shd.g_old_rec.cwg_attribute29
369: ,p_cwg_attribute30_o => ben_cwg_shd.g_old_rec.cwg_attribute30
370: ,p_status_cd_o => ben_cwg_shd.g_old_rec.status_cd
371: ,p_hidden_cd_o => ben_cwg_shd.g_old_rec.hidden_cd
372: ,p_object_version_number_o => ben_cwg_shd.g_old_rec.object_version_number
373: );
374: --

Line 371: ,p_hidden_cd_o => ben_cwg_shd.g_old_rec.hidden_cd

367: ,p_cwg_attribute29_o
368: => ben_cwg_shd.g_old_rec.cwg_attribute29
369: ,p_cwg_attribute30_o => ben_cwg_shd.g_old_rec.cwg_attribute30
370: ,p_status_cd_o => ben_cwg_shd.g_old_rec.status_cd
371: ,p_hidden_cd_o => ben_cwg_shd.g_old_rec.hidden_cd
372: ,p_object_version_number_o => ben_cwg_shd.g_old_rec.object_version_number
373: );
374: --
375: exception

Line 372: ,p_object_version_number_o => ben_cwg_shd.g_old_rec.object_version_number

368: => ben_cwg_shd.g_old_rec.cwg_attribute29
369: ,p_cwg_attribute30_o => ben_cwg_shd.g_old_rec.cwg_attribute30
370: ,p_status_cd_o => ben_cwg_shd.g_old_rec.status_cd
371: ,p_hidden_cd_o => ben_cwg_shd.g_old_rec.hidden_cd
372: ,p_object_version_number_o => ben_cwg_shd.g_old_rec.object_version_number
373: );
374: --
375: exception
376: --

Line 432: (p_rec in out nocopy ben_cwg_shd.g_rec_type

428: --
429: -- {End Of Comments}
430: -- ----------------------------------------------------------------------------
431: Procedure convert_defs
432: (p_rec in out nocopy ben_cwg_shd.g_rec_type
433: ) is
434: --
435: Begin
436: --

Line 444: ben_cwg_shd.g_old_rec.business_group_id;

440: -- is being used then we must set to the 'current' argument value.
441: --
442: If (p_rec.business_group_id = hr_api.g_number) then
443: p_rec.business_group_id :=
444: ben_cwg_shd.g_old_rec.business_group_id;
445: End If;
446: If (p_rec.pl_id = hr_api.g_number) then
447: p_rec.pl_id :=
448: ben_cwg_shd.g_old_rec.pl_id;

Line 448: ben_cwg_shd.g_old_rec.pl_id;

444: ben_cwg_shd.g_old_rec.business_group_id;
445: End If;
446: If (p_rec.pl_id = hr_api.g_number) then
447: p_rec.pl_id :=
448: ben_cwg_shd.g_old_rec.pl_id;
449: End If;
450: If (p_rec.ordr_num = hr_api.g_number) then
451: p_rec.ordr_num :=
452: ben_cwg_shd.g_old_rec.ordr_num;

Line 452: ben_cwg_shd.g_old_rec.ordr_num;

448: ben_cwg_shd.g_old_rec.pl_id;
449: End If;
450: If (p_rec.ordr_num = hr_api.g_number) then
451: p_rec.ordr_num :=
452: ben_cwg_shd.g_old_rec.ordr_num;
453: End If;
454: If (p_rec.wksht_grp_cd = hr_api.g_varchar2) then
455: p_rec.wksht_grp_cd :=
456: ben_cwg_shd.g_old_rec.wksht_grp_cd;

Line 456: ben_cwg_shd.g_old_rec.wksht_grp_cd;

452: ben_cwg_shd.g_old_rec.ordr_num;
453: End If;
454: If (p_rec.wksht_grp_cd = hr_api.g_varchar2) then
455: p_rec.wksht_grp_cd :=
456: ben_cwg_shd.g_old_rec.wksht_grp_cd;
457: End If;
458: If (p_rec.label = hr_api.g_varchar2) then
459: p_rec.label :=
460: ben_cwg_shd.g_old_rec.label;

Line 460: ben_cwg_shd.g_old_rec.label;

456: ben_cwg_shd.g_old_rec.wksht_grp_cd;
457: End If;
458: If (p_rec.label = hr_api.g_varchar2) then
459: p_rec.label :=
460: ben_cwg_shd.g_old_rec.label;
461: End If;
462: If (p_rec.cwg_attribute_category = hr_api.g_varchar2) then
463: p_rec.cwg_attribute_category :=
464: ben_cwg_shd.g_old_rec.cwg_attribute_category;

Line 464: ben_cwg_shd.g_old_rec.cwg_attribute_category;

460: ben_cwg_shd.g_old_rec.label;
461: End If;
462: If (p_rec.cwg_attribute_category = hr_api.g_varchar2) then
463: p_rec.cwg_attribute_category :=
464: ben_cwg_shd.g_old_rec.cwg_attribute_category;
465: End If;
466: If (p_rec.cwg_attribute1 = hr_api.g_varchar2) then
467: p_rec.cwg_attribute1 :=
468: ben_cwg_shd.g_old_rec.cwg_attribute1;

Line 468: ben_cwg_shd.g_old_rec.cwg_attribute1;

464: ben_cwg_shd.g_old_rec.cwg_attribute_category;
465: End If;
466: If (p_rec.cwg_attribute1 = hr_api.g_varchar2) then
467: p_rec.cwg_attribute1 :=
468: ben_cwg_shd.g_old_rec.cwg_attribute1;
469: End If;
470: If (p_rec.cwg_attribute2 = hr_api.g_varchar2) then
471: p_rec.cwg_attribute2 :=
472: ben_cwg_shd.g_old_rec.cwg_attribute2;

Line 472: ben_cwg_shd.g_old_rec.cwg_attribute2;

468: ben_cwg_shd.g_old_rec.cwg_attribute1;
469: End If;
470: If (p_rec.cwg_attribute2 = hr_api.g_varchar2) then
471: p_rec.cwg_attribute2 :=
472: ben_cwg_shd.g_old_rec.cwg_attribute2;
473: End If;
474: If (p_rec.cwg_attribute3 = hr_api.g_varchar2) then
475: p_rec.cwg_attribute3 :=
476: ben_cwg_shd.g_old_rec.cwg_attribute3;

Line 476: ben_cwg_shd.g_old_rec.cwg_attribute3;

472: ben_cwg_shd.g_old_rec.cwg_attribute2;
473: End If;
474: If (p_rec.cwg_attribute3 = hr_api.g_varchar2) then
475: p_rec.cwg_attribute3 :=
476: ben_cwg_shd.g_old_rec.cwg_attribute3;
477: End If;
478: If (p_rec.cwg_attribute4 = hr_api.g_varchar2) then
479: p_rec.cwg_attribute4 :=
480: ben_cwg_shd.g_old_rec.cwg_attribute4;

Line 480: ben_cwg_shd.g_old_rec.cwg_attribute4;

476: ben_cwg_shd.g_old_rec.cwg_attribute3;
477: End If;
478: If (p_rec.cwg_attribute4 = hr_api.g_varchar2) then
479: p_rec.cwg_attribute4 :=
480: ben_cwg_shd.g_old_rec.cwg_attribute4;
481: End If;
482: If (p_rec.cwg_attribute5 = hr_api.g_varchar2) then
483: p_rec.cwg_attribute5 :=
484: ben_cwg_shd.g_old_rec.cwg_attribute5;

Line 484: ben_cwg_shd.g_old_rec.cwg_attribute5;

480: ben_cwg_shd.g_old_rec.cwg_attribute4;
481: End If;
482: If (p_rec.cwg_attribute5 = hr_api.g_varchar2) then
483: p_rec.cwg_attribute5 :=
484: ben_cwg_shd.g_old_rec.cwg_attribute5;
485: End If;
486: If (p_rec.cwg_attribute6 = hr_api.g_varchar2) then
487: p_rec.cwg_attribute6 :=
488: ben_cwg_shd.g_old_rec.cwg_attribute6;

Line 488: ben_cwg_shd.g_old_rec.cwg_attribute6;

484: ben_cwg_shd.g_old_rec.cwg_attribute5;
485: End If;
486: If (p_rec.cwg_attribute6 = hr_api.g_varchar2) then
487: p_rec.cwg_attribute6 :=
488: ben_cwg_shd.g_old_rec.cwg_attribute6;
489: End If;
490: If (p_rec.cwg_attribute7 = hr_api.g_varchar2) then
491: p_rec.cwg_attribute7 :=
492: ben_cwg_shd.g_old_rec.cwg_attribute7;

Line 492: ben_cwg_shd.g_old_rec.cwg_attribute7;

488: ben_cwg_shd.g_old_rec.cwg_attribute6;
489: End If;
490: If (p_rec.cwg_attribute7 = hr_api.g_varchar2) then
491: p_rec.cwg_attribute7 :=
492: ben_cwg_shd.g_old_rec.cwg_attribute7;
493: End If;
494: If (p_rec.cwg_attribute8 = hr_api.g_varchar2) then
495: p_rec.cwg_attribute8 :=
496: ben_cwg_shd.g_old_rec.cwg_attribute8;

Line 496: ben_cwg_shd.g_old_rec.cwg_attribute8;

492: ben_cwg_shd.g_old_rec.cwg_attribute7;
493: End If;
494: If (p_rec.cwg_attribute8 = hr_api.g_varchar2) then
495: p_rec.cwg_attribute8 :=
496: ben_cwg_shd.g_old_rec.cwg_attribute8;
497: End If;
498: If (p_rec.cwg_attribute9 = hr_api.g_varchar2) then
499: p_rec.cwg_attribute9 :=
500: ben_cwg_shd.g_old_rec.cwg_attribute9;

Line 500: ben_cwg_shd.g_old_rec.cwg_attribute9;

496: ben_cwg_shd.g_old_rec.cwg_attribute8;
497: End If;
498: If (p_rec.cwg_attribute9 = hr_api.g_varchar2) then
499: p_rec.cwg_attribute9 :=
500: ben_cwg_shd.g_old_rec.cwg_attribute9;
501: End If;
502: If (p_rec.cwg_attribute10 = hr_api.g_varchar2) then
503: p_rec.cwg_attribute10 :=
504: ben_cwg_shd.g_old_rec.cwg_attribute10;

Line 504: ben_cwg_shd.g_old_rec.cwg_attribute10;

500: ben_cwg_shd.g_old_rec.cwg_attribute9;
501: End If;
502: If (p_rec.cwg_attribute10 = hr_api.g_varchar2) then
503: p_rec.cwg_attribute10 :=
504: ben_cwg_shd.g_old_rec.cwg_attribute10;
505: End If;
506: If (p_rec.cwg_attribute11 = hr_api.g_varchar2) then
507: p_rec.cwg_attribute11 :=
508: ben_cwg_shd.g_old_rec.cwg_attribute11;

Line 508: ben_cwg_shd.g_old_rec.cwg_attribute11;

504: ben_cwg_shd.g_old_rec.cwg_attribute10;
505: End If;
506: If (p_rec.cwg_attribute11 = hr_api.g_varchar2) then
507: p_rec.cwg_attribute11 :=
508: ben_cwg_shd.g_old_rec.cwg_attribute11;
509: End If;
510: If (p_rec.cwg_attribute12 = hr_api.g_varchar2) then
511: p_rec.cwg_attribute12 :=
512: ben_cwg_shd.g_old_rec.cwg_attribute12;

Line 512: ben_cwg_shd.g_old_rec.cwg_attribute12;

508: ben_cwg_shd.g_old_rec.cwg_attribute11;
509: End If;
510: If (p_rec.cwg_attribute12 = hr_api.g_varchar2) then
511: p_rec.cwg_attribute12 :=
512: ben_cwg_shd.g_old_rec.cwg_attribute12;
513: End If;
514: If (p_rec.cwg_attribute13 = hr_api.g_varchar2) then
515: p_rec.cwg_attribute13 :=
516: ben_cwg_shd.g_old_rec.cwg_attribute13;

Line 516: ben_cwg_shd.g_old_rec.cwg_attribute13;

512: ben_cwg_shd.g_old_rec.cwg_attribute12;
513: End If;
514: If (p_rec.cwg_attribute13 = hr_api.g_varchar2) then
515: p_rec.cwg_attribute13 :=
516: ben_cwg_shd.g_old_rec.cwg_attribute13;
517: End If;
518: If (p_rec.cwg_attribute14 = hr_api.g_varchar2) then
519: p_rec.cwg_attribute14 :=
520: ben_cwg_shd.g_old_rec.cwg_attribute14;

Line 520: ben_cwg_shd.g_old_rec.cwg_attribute14;

516: ben_cwg_shd.g_old_rec.cwg_attribute13;
517: End If;
518: If (p_rec.cwg_attribute14 = hr_api.g_varchar2) then
519: p_rec.cwg_attribute14 :=
520: ben_cwg_shd.g_old_rec.cwg_attribute14;
521: End If;
522: If (p_rec.cwg_attribute15 = hr_api.g_varchar2) then
523: p_rec.cwg_attribute15 :=
524: ben_cwg_shd.g_old_rec.cwg_attribute15;

Line 524: ben_cwg_shd.g_old_rec.cwg_attribute15;

520: ben_cwg_shd.g_old_rec.cwg_attribute14;
521: End If;
522: If (p_rec.cwg_attribute15 = hr_api.g_varchar2) then
523: p_rec.cwg_attribute15 :=
524: ben_cwg_shd.g_old_rec.cwg_attribute15;
525: End If;
526: If (p_rec.cwg_attribute16 = hr_api.g_varchar2) then
527: p_rec.cwg_attribute16 :=
528: ben_cwg_shd.g_old_rec.cwg_attribute16;

Line 528: ben_cwg_shd.g_old_rec.cwg_attribute16;

524: ben_cwg_shd.g_old_rec.cwg_attribute15;
525: End If;
526: If (p_rec.cwg_attribute16 = hr_api.g_varchar2) then
527: p_rec.cwg_attribute16 :=
528: ben_cwg_shd.g_old_rec.cwg_attribute16;
529: End If;
530: If (p_rec.cwg_attribute17 = hr_api.g_varchar2) then
531: p_rec.cwg_attribute17 :=
532: ben_cwg_shd.g_old_rec.cwg_attribute17;

Line 532: ben_cwg_shd.g_old_rec.cwg_attribute17;

528: ben_cwg_shd.g_old_rec.cwg_attribute16;
529: End If;
530: If (p_rec.cwg_attribute17 = hr_api.g_varchar2) then
531: p_rec.cwg_attribute17 :=
532: ben_cwg_shd.g_old_rec.cwg_attribute17;
533: End If;
534: If (p_rec.cwg_attribute18 = hr_api.g_varchar2) then
535: p_rec.cwg_attribute18 :=
536: ben_cwg_shd.g_old_rec.cwg_attribute18;

Line 536: ben_cwg_shd.g_old_rec.cwg_attribute18;

532: ben_cwg_shd.g_old_rec.cwg_attribute17;
533: End If;
534: If (p_rec.cwg_attribute18 = hr_api.g_varchar2) then
535: p_rec.cwg_attribute18 :=
536: ben_cwg_shd.g_old_rec.cwg_attribute18;
537: End If;
538: If (p_rec.cwg_attribute19 = hr_api.g_varchar2) then
539: p_rec.cwg_attribute19 :=
540: ben_cwg_shd.g_old_rec.cwg_attribute19;

Line 540: ben_cwg_shd.g_old_rec.cwg_attribute19;

536: ben_cwg_shd.g_old_rec.cwg_attribute18;
537: End If;
538: If (p_rec.cwg_attribute19 = hr_api.g_varchar2) then
539: p_rec.cwg_attribute19 :=
540: ben_cwg_shd.g_old_rec.cwg_attribute19;
541: End If;
542: If (p_rec.cwg_attribute20 = hr_api.g_varchar2) then
543: p_rec.cwg_attribute20 :=
544: ben_cwg_shd.g_old_rec.cwg_attribute20;

Line 544: ben_cwg_shd.g_old_rec.cwg_attribute20;

540: ben_cwg_shd.g_old_rec.cwg_attribute19;
541: End If;
542: If (p_rec.cwg_attribute20 = hr_api.g_varchar2) then
543: p_rec.cwg_attribute20 :=
544: ben_cwg_shd.g_old_rec.cwg_attribute20;
545: End If;
546: If (p_rec.cwg_attribute21 = hr_api.g_varchar2) then
547: p_rec.cwg_attribute21 :=
548: ben_cwg_shd.g_old_rec.cwg_attribute21;

Line 548: ben_cwg_shd.g_old_rec.cwg_attribute21;

544: ben_cwg_shd.g_old_rec.cwg_attribute20;
545: End If;
546: If (p_rec.cwg_attribute21 = hr_api.g_varchar2) then
547: p_rec.cwg_attribute21 :=
548: ben_cwg_shd.g_old_rec.cwg_attribute21;
549: End If;
550: If (p_rec.cwg_attribute22 = hr_api.g_varchar2) then
551: p_rec.cwg_attribute22 :=
552: ben_cwg_shd.g_old_rec.cwg_attribute22;

Line 552: ben_cwg_shd.g_old_rec.cwg_attribute22;

548: ben_cwg_shd.g_old_rec.cwg_attribute21;
549: End If;
550: If (p_rec.cwg_attribute22 = hr_api.g_varchar2) then
551: p_rec.cwg_attribute22 :=
552: ben_cwg_shd.g_old_rec.cwg_attribute22;
553: End If;
554: If (p_rec.cwg_attribute23 = hr_api.g_varchar2) then
555: p_rec.cwg_attribute23 :=
556: ben_cwg_shd.g_old_rec.cwg_attribute23;

Line 556: ben_cwg_shd.g_old_rec.cwg_attribute23;

552: ben_cwg_shd.g_old_rec.cwg_attribute22;
553: End If;
554: If (p_rec.cwg_attribute23 = hr_api.g_varchar2) then
555: p_rec.cwg_attribute23 :=
556: ben_cwg_shd.g_old_rec.cwg_attribute23;
557: End If;
558: If (p_rec.cwg_attribute24 = hr_api.g_varchar2) then
559: p_rec.cwg_attribute24 :=
560: ben_cwg_shd.g_old_rec.cwg_attribute24;

Line 560: ben_cwg_shd.g_old_rec.cwg_attribute24;

556: ben_cwg_shd.g_old_rec.cwg_attribute23;
557: End If;
558: If (p_rec.cwg_attribute24 = hr_api.g_varchar2) then
559: p_rec.cwg_attribute24 :=
560: ben_cwg_shd.g_old_rec.cwg_attribute24;
561: End If;
562: If (p_rec.cwg_attribute25 = hr_api.g_varchar2) then
563: p_rec.cwg_attribute25 :=
564: ben_cwg_shd.g_old_rec.cwg_attribute25;

Line 564: ben_cwg_shd.g_old_rec.cwg_attribute25;

560: ben_cwg_shd.g_old_rec.cwg_attribute24;
561: End If;
562: If (p_rec.cwg_attribute25 = hr_api.g_varchar2) then
563: p_rec.cwg_attribute25 :=
564: ben_cwg_shd.g_old_rec.cwg_attribute25;
565: End If;
566: If (p_rec.cwg_attribute26 = hr_api.g_varchar2) then
567: p_rec.cwg_attribute26 :=
568: ben_cwg_shd.g_old_rec.cwg_attribute26;

Line 568: ben_cwg_shd.g_old_rec.cwg_attribute26;

564: ben_cwg_shd.g_old_rec.cwg_attribute25;
565: End If;
566: If (p_rec.cwg_attribute26 = hr_api.g_varchar2) then
567: p_rec.cwg_attribute26 :=
568: ben_cwg_shd.g_old_rec.cwg_attribute26;
569: End If;
570: If (p_rec.cwg_attribute27 = hr_api.g_varchar2) then
571: p_rec.cwg_attribute27 :=
572: ben_cwg_shd.g_old_rec.cwg_attribute27;

Line 572: ben_cwg_shd.g_old_rec.cwg_attribute27;

568: ben_cwg_shd.g_old_rec.cwg_attribute26;
569: End If;
570: If (p_rec.cwg_attribute27 = hr_api.g_varchar2) then
571: p_rec.cwg_attribute27 :=
572: ben_cwg_shd.g_old_rec.cwg_attribute27;
573: End If;
574: If (p_rec.cwg_attribute28 = hr_api.g_varchar2) then
575: p_rec.cwg_attribute28 :=
576: ben_cwg_shd.g_old_rec.cwg_attribute28;

Line 576: ben_cwg_shd.g_old_rec.cwg_attribute28;

572: ben_cwg_shd.g_old_rec.cwg_attribute27;
573: End If;
574: If (p_rec.cwg_attribute28 = hr_api.g_varchar2) then
575: p_rec.cwg_attribute28 :=
576: ben_cwg_shd.g_old_rec.cwg_attribute28;
577: End If;
578: If (p_rec.cwg_attribute29 = hr_api.g_varchar2) then
579: p_rec.cwg_attribute29 :=
580: ben_cwg_shd.g_old_rec.cwg_attribute29;

Line 580: ben_cwg_shd.g_old_rec.cwg_attribute29;

576: ben_cwg_shd.g_old_rec.cwg_attribute28;
577: End If;
578: If (p_rec.cwg_attribute29 = hr_api.g_varchar2) then
579: p_rec.cwg_attribute29 :=
580: ben_cwg_shd.g_old_rec.cwg_attribute29;
581: End If;
582: If (p_rec.cwg_attribute30 = hr_api.g_varchar2) then
583: p_rec.cwg_attribute30 :=
584: ben_cwg_shd.g_old_rec.cwg_attribute30;

Line 584: ben_cwg_shd.g_old_rec.cwg_attribute30;

580: ben_cwg_shd.g_old_rec.cwg_attribute29;
581: End If;
582: If (p_rec.cwg_attribute30 = hr_api.g_varchar2) then
583: p_rec.cwg_attribute30 :=
584: ben_cwg_shd.g_old_rec.cwg_attribute30;
585: End If;
586:
587: --
588: If (p_rec.status_cd = hr_api.g_varchar2) then

Line 589: p_rec.status_cd := ben_cwg_shd.g_old_rec.status_cd;

585: End If;
586:
587: --
588: If (p_rec.status_cd = hr_api.g_varchar2) then
589: p_rec.status_cd := ben_cwg_shd.g_old_rec.status_cd;
590: End If;
591:
592: If (p_rec.hidden_cd = hr_api.g_varchar2) then
593: p_rec.hidden_cd := ben_cwg_shd.g_old_rec.hidden_cd;

Line 593: p_rec.hidden_cd := ben_cwg_shd.g_old_rec.hidden_cd;

589: p_rec.status_cd := ben_cwg_shd.g_old_rec.status_cd;
590: End If;
591:
592: If (p_rec.hidden_cd = hr_api.g_varchar2) then
593: p_rec.hidden_cd := ben_cwg_shd.g_old_rec.hidden_cd;
594: End If;
595:
596: End convert_defs;
597: --

Line 603: ,p_rec in out nocopy ben_cwg_shd.g_rec_type

599: -- |---------------------------------< upd >----------------------------------|
600: -- ----------------------------------------------------------------------------
601: Procedure upd
602: (p_effective_date in date
603: ,p_rec in out nocopy ben_cwg_shd.g_rec_type
604: ) is
605: --
606: l_proc varchar2(72) := g_package||'upd';
607: --

Line 613: ben_cwg_shd.lck

609: hr_utility.set_location('Entering:'||l_proc, 5);
610: --
611: -- We must lock the row which we need to update.
612: --
613: ben_cwg_shd.lck
614: (p_rec.cwb_wksht_grp_id
615: ,p_rec.object_version_number
616: );
617: --

Line 697: l_rec ben_cwg_shd.g_rec_type;

693: ,p_status_cd in varchar2 default hr_api.g_varchar2
694: ,p_hidden_cd in varchar2 default hr_api.g_varchar2
695: ) is
696: --
697: l_rec ben_cwg_shd.g_rec_type;
698: l_proc varchar2(72) := g_package||'upd';
699: --
700: Begin
701: hr_utility.set_location('Entering:'||l_proc, 5);

Line 707: ben_cwg_shd.convert_args

703: -- Call conversion function to turn arguments into the
704: -- l_rec structure.
705: --
706: l_rec :=
707: ben_cwg_shd.convert_args
708: (p_cwb_wksht_grp_id
709: ,hr_api.g_number
710: ,hr_api.g_number
711: ,p_ordr_num