DBA Data[Home] [Help]

APPS.BEN_PCP_UPD dependencies on BEN_PCP_SHD

Line 55: (p_rec in out nocopy ben_pcp_shd.g_rec_type

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

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

62: --
63: -- Increment the object version
64: p_rec.object_version_number := p_rec.object_version_number + 1;
65: --
66: ben_pcp_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Update the ben_pl_pcp Row
69: --
70: update ben_pl_pcp

Line 119: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status

115: ,pcp_attribute30 = p_rec.pcp_attribute30
116: ,object_version_number = p_rec.object_version_number
117: where pl_pcp_id = p_rec.pl_pcp_id;
118: --
119: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status
120: --
121: hr_utility.set_location(' Leaving:'||l_proc, 10);
122: --
123: Exception

Line 126: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status

122: --
123: Exception
124: When hr_api.check_integrity_violated Then
125: -- A check constraint has been violated
126: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status
127: ben_pcp_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: When hr_api.parent_integrity_violated Then
130: -- Parent integrity has been violated

Line 127: ben_pcp_shd.constraint_error

123: Exception
124: When hr_api.check_integrity_violated Then
125: -- A check constraint has been violated
126: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status
127: ben_pcp_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: When hr_api.parent_integrity_violated Then
130: -- Parent integrity has been violated
131: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status

Line 131: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status

127: ben_pcp_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: When hr_api.parent_integrity_violated Then
130: -- Parent integrity has been violated
131: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status
132: ben_pcp_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When hr_api.unique_integrity_violated Then
135: -- Unique integrity has been violated

Line 132: ben_pcp_shd.constraint_error

128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: When hr_api.parent_integrity_violated Then
130: -- Parent integrity has been violated
131: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status
132: ben_pcp_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When hr_api.unique_integrity_violated Then
135: -- Unique integrity has been violated
136: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status

Line 136: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status

132: ben_pcp_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When hr_api.unique_integrity_violated Then
135: -- Unique integrity has been violated
136: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status
137: ben_pcp_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When Others Then
140: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status

Line 137: ben_pcp_shd.constraint_error

133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When hr_api.unique_integrity_violated Then
135: -- Unique integrity has been violated
136: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status
137: ben_pcp_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When Others Then
140: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status
141: Raise;

Line 140: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status

136: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status
137: ben_pcp_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When Others Then
140: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status
141: Raise;
142: End update_dml;
143: --
144: -- ----------------------------------------------------------------------------

Line 177: (p_rec in ben_pcp_shd.g_rec_type

173: --
174: -- {End Of Comments}
175: -- ----------------------------------------------------------------------------
176: Procedure pre_update
177: (p_rec in ben_pcp_shd.g_rec_type
178: ) is
179: --
180: l_proc varchar2(72) := g_package||'pre_update';
181: --

Line 221: (p_rec in ben_pcp_shd.g_rec_type

217: --
218: -- {End Of Comments}
219: -- ----------------------------------------------------------------------------
220: Procedure post_update
221: (p_rec in ben_pcp_shd.g_rec_type
222: ) is
223: --
224: l_proc varchar2(72) := g_package||'post_update';
225: --

Line 322: => ben_pcp_shd.g_old_rec.pl_id

318: => p_rec.pcp_attribute30
319: ,p_object_version_number
320: => p_rec.object_version_number
321: ,p_pl_id_o
322: => ben_pcp_shd.g_old_rec.pl_id
323: ,p_business_group_id_o
324: => ben_pcp_shd.g_old_rec.business_group_id
325: ,p_pcp_strt_dt_cd_o
326: => ben_pcp_shd.g_old_rec.pcp_strt_dt_cd

Line 324: => ben_pcp_shd.g_old_rec.business_group_id

320: => p_rec.object_version_number
321: ,p_pl_id_o
322: => ben_pcp_shd.g_old_rec.pl_id
323: ,p_business_group_id_o
324: => ben_pcp_shd.g_old_rec.business_group_id
325: ,p_pcp_strt_dt_cd_o
326: => ben_pcp_shd.g_old_rec.pcp_strt_dt_cd
327: ,p_pcp_dsgn_cd_o
328: => ben_pcp_shd.g_old_rec.pcp_dsgn_cd

Line 326: => ben_pcp_shd.g_old_rec.pcp_strt_dt_cd

322: => ben_pcp_shd.g_old_rec.pl_id
323: ,p_business_group_id_o
324: => ben_pcp_shd.g_old_rec.business_group_id
325: ,p_pcp_strt_dt_cd_o
326: => ben_pcp_shd.g_old_rec.pcp_strt_dt_cd
327: ,p_pcp_dsgn_cd_o
328: => ben_pcp_shd.g_old_rec.pcp_dsgn_cd
329: ,p_pcp_dpnt_dsgn_cd_o
330: => ben_pcp_shd.g_old_rec.pcp_dpnt_dsgn_cd

Line 328: => ben_pcp_shd.g_old_rec.pcp_dsgn_cd

324: => ben_pcp_shd.g_old_rec.business_group_id
325: ,p_pcp_strt_dt_cd_o
326: => ben_pcp_shd.g_old_rec.pcp_strt_dt_cd
327: ,p_pcp_dsgn_cd_o
328: => ben_pcp_shd.g_old_rec.pcp_dsgn_cd
329: ,p_pcp_dpnt_dsgn_cd_o
330: => ben_pcp_shd.g_old_rec.pcp_dpnt_dsgn_cd
331: ,p_pcp_rpstry_flag_o
332: => ben_pcp_shd.g_old_rec.pcp_rpstry_flag

Line 330: => ben_pcp_shd.g_old_rec.pcp_dpnt_dsgn_cd

326: => ben_pcp_shd.g_old_rec.pcp_strt_dt_cd
327: ,p_pcp_dsgn_cd_o
328: => ben_pcp_shd.g_old_rec.pcp_dsgn_cd
329: ,p_pcp_dpnt_dsgn_cd_o
330: => ben_pcp_shd.g_old_rec.pcp_dpnt_dsgn_cd
331: ,p_pcp_rpstry_flag_o
332: => ben_pcp_shd.g_old_rec.pcp_rpstry_flag
333: ,p_pcp_can_keep_flag_o
334: => ben_pcp_shd.g_old_rec.pcp_can_keep_flag

Line 332: => ben_pcp_shd.g_old_rec.pcp_rpstry_flag

328: => ben_pcp_shd.g_old_rec.pcp_dsgn_cd
329: ,p_pcp_dpnt_dsgn_cd_o
330: => ben_pcp_shd.g_old_rec.pcp_dpnt_dsgn_cd
331: ,p_pcp_rpstry_flag_o
332: => ben_pcp_shd.g_old_rec.pcp_rpstry_flag
333: ,p_pcp_can_keep_flag_o
334: => ben_pcp_shd.g_old_rec.pcp_can_keep_flag
335: ,p_pcp_radius_o
336: => ben_pcp_shd.g_old_rec.pcp_radius

Line 334: => ben_pcp_shd.g_old_rec.pcp_can_keep_flag

330: => ben_pcp_shd.g_old_rec.pcp_dpnt_dsgn_cd
331: ,p_pcp_rpstry_flag_o
332: => ben_pcp_shd.g_old_rec.pcp_rpstry_flag
333: ,p_pcp_can_keep_flag_o
334: => ben_pcp_shd.g_old_rec.pcp_can_keep_flag
335: ,p_pcp_radius_o
336: => ben_pcp_shd.g_old_rec.pcp_radius
337: ,p_pcp_radius_uom_o
338: => ben_pcp_shd.g_old_rec.pcp_radius_uom

Line 336: => ben_pcp_shd.g_old_rec.pcp_radius

332: => ben_pcp_shd.g_old_rec.pcp_rpstry_flag
333: ,p_pcp_can_keep_flag_o
334: => ben_pcp_shd.g_old_rec.pcp_can_keep_flag
335: ,p_pcp_radius_o
336: => ben_pcp_shd.g_old_rec.pcp_radius
337: ,p_pcp_radius_uom_o
338: => ben_pcp_shd.g_old_rec.pcp_radius_uom
339: ,p_pcp_radius_warn_flag_o
340: => ben_pcp_shd.g_old_rec.pcp_radius_warn_flag

Line 338: => ben_pcp_shd.g_old_rec.pcp_radius_uom

334: => ben_pcp_shd.g_old_rec.pcp_can_keep_flag
335: ,p_pcp_radius_o
336: => ben_pcp_shd.g_old_rec.pcp_radius
337: ,p_pcp_radius_uom_o
338: => ben_pcp_shd.g_old_rec.pcp_radius_uom
339: ,p_pcp_radius_warn_flag_o
340: => ben_pcp_shd.g_old_rec.pcp_radius_warn_flag
341: ,p_pcp_num_chgs_o
342: => ben_pcp_shd.g_old_rec.pcp_num_chgs

Line 340: => ben_pcp_shd.g_old_rec.pcp_radius_warn_flag

336: => ben_pcp_shd.g_old_rec.pcp_radius
337: ,p_pcp_radius_uom_o
338: => ben_pcp_shd.g_old_rec.pcp_radius_uom
339: ,p_pcp_radius_warn_flag_o
340: => ben_pcp_shd.g_old_rec.pcp_radius_warn_flag
341: ,p_pcp_num_chgs_o
342: => ben_pcp_shd.g_old_rec.pcp_num_chgs
343: ,p_pcp_num_chgs_uom_o
344: => ben_pcp_shd.g_old_rec.pcp_num_chgs_uom

Line 342: => ben_pcp_shd.g_old_rec.pcp_num_chgs

338: => ben_pcp_shd.g_old_rec.pcp_radius_uom
339: ,p_pcp_radius_warn_flag_o
340: => ben_pcp_shd.g_old_rec.pcp_radius_warn_flag
341: ,p_pcp_num_chgs_o
342: => ben_pcp_shd.g_old_rec.pcp_num_chgs
343: ,p_pcp_num_chgs_uom_o
344: => ben_pcp_shd.g_old_rec.pcp_num_chgs_uom
345: ,p_pcp_attribute_category_o
346: => ben_pcp_shd.g_old_rec.pcp_attribute_category

Line 344: => ben_pcp_shd.g_old_rec.pcp_num_chgs_uom

340: => ben_pcp_shd.g_old_rec.pcp_radius_warn_flag
341: ,p_pcp_num_chgs_o
342: => ben_pcp_shd.g_old_rec.pcp_num_chgs
343: ,p_pcp_num_chgs_uom_o
344: => ben_pcp_shd.g_old_rec.pcp_num_chgs_uom
345: ,p_pcp_attribute_category_o
346: => ben_pcp_shd.g_old_rec.pcp_attribute_category
347: ,p_pcp_attribute1_o
348: => ben_pcp_shd.g_old_rec.pcp_attribute1

Line 346: => ben_pcp_shd.g_old_rec.pcp_attribute_category

342: => ben_pcp_shd.g_old_rec.pcp_num_chgs
343: ,p_pcp_num_chgs_uom_o
344: => ben_pcp_shd.g_old_rec.pcp_num_chgs_uom
345: ,p_pcp_attribute_category_o
346: => ben_pcp_shd.g_old_rec.pcp_attribute_category
347: ,p_pcp_attribute1_o
348: => ben_pcp_shd.g_old_rec.pcp_attribute1
349: ,p_pcp_attribute2_o
350: => ben_pcp_shd.g_old_rec.pcp_attribute2

Line 348: => ben_pcp_shd.g_old_rec.pcp_attribute1

344: => ben_pcp_shd.g_old_rec.pcp_num_chgs_uom
345: ,p_pcp_attribute_category_o
346: => ben_pcp_shd.g_old_rec.pcp_attribute_category
347: ,p_pcp_attribute1_o
348: => ben_pcp_shd.g_old_rec.pcp_attribute1
349: ,p_pcp_attribute2_o
350: => ben_pcp_shd.g_old_rec.pcp_attribute2
351: ,p_pcp_attribute3_o
352: => ben_pcp_shd.g_old_rec.pcp_attribute3

Line 350: => ben_pcp_shd.g_old_rec.pcp_attribute2

346: => ben_pcp_shd.g_old_rec.pcp_attribute_category
347: ,p_pcp_attribute1_o
348: => ben_pcp_shd.g_old_rec.pcp_attribute1
349: ,p_pcp_attribute2_o
350: => ben_pcp_shd.g_old_rec.pcp_attribute2
351: ,p_pcp_attribute3_o
352: => ben_pcp_shd.g_old_rec.pcp_attribute3
353: ,p_pcp_attribute4_o
354: => ben_pcp_shd.g_old_rec.pcp_attribute4

Line 352: => ben_pcp_shd.g_old_rec.pcp_attribute3

348: => ben_pcp_shd.g_old_rec.pcp_attribute1
349: ,p_pcp_attribute2_o
350: => ben_pcp_shd.g_old_rec.pcp_attribute2
351: ,p_pcp_attribute3_o
352: => ben_pcp_shd.g_old_rec.pcp_attribute3
353: ,p_pcp_attribute4_o
354: => ben_pcp_shd.g_old_rec.pcp_attribute4
355: ,p_pcp_attribute5_o
356: => ben_pcp_shd.g_old_rec.pcp_attribute5

Line 354: => ben_pcp_shd.g_old_rec.pcp_attribute4

350: => ben_pcp_shd.g_old_rec.pcp_attribute2
351: ,p_pcp_attribute3_o
352: => ben_pcp_shd.g_old_rec.pcp_attribute3
353: ,p_pcp_attribute4_o
354: => ben_pcp_shd.g_old_rec.pcp_attribute4
355: ,p_pcp_attribute5_o
356: => ben_pcp_shd.g_old_rec.pcp_attribute5
357: ,p_pcp_attribute6_o
358: => ben_pcp_shd.g_old_rec.pcp_attribute6

Line 356: => ben_pcp_shd.g_old_rec.pcp_attribute5

352: => ben_pcp_shd.g_old_rec.pcp_attribute3
353: ,p_pcp_attribute4_o
354: => ben_pcp_shd.g_old_rec.pcp_attribute4
355: ,p_pcp_attribute5_o
356: => ben_pcp_shd.g_old_rec.pcp_attribute5
357: ,p_pcp_attribute6_o
358: => ben_pcp_shd.g_old_rec.pcp_attribute6
359: ,p_pcp_attribute7_o
360: => ben_pcp_shd.g_old_rec.pcp_attribute7

Line 358: => ben_pcp_shd.g_old_rec.pcp_attribute6

354: => ben_pcp_shd.g_old_rec.pcp_attribute4
355: ,p_pcp_attribute5_o
356: => ben_pcp_shd.g_old_rec.pcp_attribute5
357: ,p_pcp_attribute6_o
358: => ben_pcp_shd.g_old_rec.pcp_attribute6
359: ,p_pcp_attribute7_o
360: => ben_pcp_shd.g_old_rec.pcp_attribute7
361: ,p_pcp_attribute8_o
362: => ben_pcp_shd.g_old_rec.pcp_attribute8

Line 360: => ben_pcp_shd.g_old_rec.pcp_attribute7

356: => ben_pcp_shd.g_old_rec.pcp_attribute5
357: ,p_pcp_attribute6_o
358: => ben_pcp_shd.g_old_rec.pcp_attribute6
359: ,p_pcp_attribute7_o
360: => ben_pcp_shd.g_old_rec.pcp_attribute7
361: ,p_pcp_attribute8_o
362: => ben_pcp_shd.g_old_rec.pcp_attribute8
363: ,p_pcp_attribute9_o
364: => ben_pcp_shd.g_old_rec.pcp_attribute9

Line 362: => ben_pcp_shd.g_old_rec.pcp_attribute8

358: => ben_pcp_shd.g_old_rec.pcp_attribute6
359: ,p_pcp_attribute7_o
360: => ben_pcp_shd.g_old_rec.pcp_attribute7
361: ,p_pcp_attribute8_o
362: => ben_pcp_shd.g_old_rec.pcp_attribute8
363: ,p_pcp_attribute9_o
364: => ben_pcp_shd.g_old_rec.pcp_attribute9
365: ,p_pcp_attribute10_o
366: => ben_pcp_shd.g_old_rec.pcp_attribute10

Line 364: => ben_pcp_shd.g_old_rec.pcp_attribute9

360: => ben_pcp_shd.g_old_rec.pcp_attribute7
361: ,p_pcp_attribute8_o
362: => ben_pcp_shd.g_old_rec.pcp_attribute8
363: ,p_pcp_attribute9_o
364: => ben_pcp_shd.g_old_rec.pcp_attribute9
365: ,p_pcp_attribute10_o
366: => ben_pcp_shd.g_old_rec.pcp_attribute10
367: ,p_pcp_attribute11_o
368: => ben_pcp_shd.g_old_rec.pcp_attribute11

Line 366: => ben_pcp_shd.g_old_rec.pcp_attribute10

362: => ben_pcp_shd.g_old_rec.pcp_attribute8
363: ,p_pcp_attribute9_o
364: => ben_pcp_shd.g_old_rec.pcp_attribute9
365: ,p_pcp_attribute10_o
366: => ben_pcp_shd.g_old_rec.pcp_attribute10
367: ,p_pcp_attribute11_o
368: => ben_pcp_shd.g_old_rec.pcp_attribute11
369: ,p_pcp_attribute12_o
370: => ben_pcp_shd.g_old_rec.pcp_attribute12

Line 368: => ben_pcp_shd.g_old_rec.pcp_attribute11

364: => ben_pcp_shd.g_old_rec.pcp_attribute9
365: ,p_pcp_attribute10_o
366: => ben_pcp_shd.g_old_rec.pcp_attribute10
367: ,p_pcp_attribute11_o
368: => ben_pcp_shd.g_old_rec.pcp_attribute11
369: ,p_pcp_attribute12_o
370: => ben_pcp_shd.g_old_rec.pcp_attribute12
371: ,p_pcp_attribute13_o
372: => ben_pcp_shd.g_old_rec.pcp_attribute13

Line 370: => ben_pcp_shd.g_old_rec.pcp_attribute12

366: => ben_pcp_shd.g_old_rec.pcp_attribute10
367: ,p_pcp_attribute11_o
368: => ben_pcp_shd.g_old_rec.pcp_attribute11
369: ,p_pcp_attribute12_o
370: => ben_pcp_shd.g_old_rec.pcp_attribute12
371: ,p_pcp_attribute13_o
372: => ben_pcp_shd.g_old_rec.pcp_attribute13
373: ,p_pcp_attribute14_o
374: => ben_pcp_shd.g_old_rec.pcp_attribute14

Line 372: => ben_pcp_shd.g_old_rec.pcp_attribute13

368: => ben_pcp_shd.g_old_rec.pcp_attribute11
369: ,p_pcp_attribute12_o
370: => ben_pcp_shd.g_old_rec.pcp_attribute12
371: ,p_pcp_attribute13_o
372: => ben_pcp_shd.g_old_rec.pcp_attribute13
373: ,p_pcp_attribute14_o
374: => ben_pcp_shd.g_old_rec.pcp_attribute14
375: ,p_pcp_attribute15_o
376: => ben_pcp_shd.g_old_rec.pcp_attribute15

Line 374: => ben_pcp_shd.g_old_rec.pcp_attribute14

370: => ben_pcp_shd.g_old_rec.pcp_attribute12
371: ,p_pcp_attribute13_o
372: => ben_pcp_shd.g_old_rec.pcp_attribute13
373: ,p_pcp_attribute14_o
374: => ben_pcp_shd.g_old_rec.pcp_attribute14
375: ,p_pcp_attribute15_o
376: => ben_pcp_shd.g_old_rec.pcp_attribute15
377: ,p_pcp_attribute16_o
378: => ben_pcp_shd.g_old_rec.pcp_attribute16

Line 376: => ben_pcp_shd.g_old_rec.pcp_attribute15

372: => ben_pcp_shd.g_old_rec.pcp_attribute13
373: ,p_pcp_attribute14_o
374: => ben_pcp_shd.g_old_rec.pcp_attribute14
375: ,p_pcp_attribute15_o
376: => ben_pcp_shd.g_old_rec.pcp_attribute15
377: ,p_pcp_attribute16_o
378: => ben_pcp_shd.g_old_rec.pcp_attribute16
379: ,p_pcp_attribute17_o
380: => ben_pcp_shd.g_old_rec.pcp_attribute17

Line 378: => ben_pcp_shd.g_old_rec.pcp_attribute16

374: => ben_pcp_shd.g_old_rec.pcp_attribute14
375: ,p_pcp_attribute15_o
376: => ben_pcp_shd.g_old_rec.pcp_attribute15
377: ,p_pcp_attribute16_o
378: => ben_pcp_shd.g_old_rec.pcp_attribute16
379: ,p_pcp_attribute17_o
380: => ben_pcp_shd.g_old_rec.pcp_attribute17
381: ,p_pcp_attribute18_o
382: => ben_pcp_shd.g_old_rec.pcp_attribute18

Line 380: => ben_pcp_shd.g_old_rec.pcp_attribute17

376: => ben_pcp_shd.g_old_rec.pcp_attribute15
377: ,p_pcp_attribute16_o
378: => ben_pcp_shd.g_old_rec.pcp_attribute16
379: ,p_pcp_attribute17_o
380: => ben_pcp_shd.g_old_rec.pcp_attribute17
381: ,p_pcp_attribute18_o
382: => ben_pcp_shd.g_old_rec.pcp_attribute18
383: ,p_pcp_attribute19_o
384: => ben_pcp_shd.g_old_rec.pcp_attribute19

Line 382: => ben_pcp_shd.g_old_rec.pcp_attribute18

378: => ben_pcp_shd.g_old_rec.pcp_attribute16
379: ,p_pcp_attribute17_o
380: => ben_pcp_shd.g_old_rec.pcp_attribute17
381: ,p_pcp_attribute18_o
382: => ben_pcp_shd.g_old_rec.pcp_attribute18
383: ,p_pcp_attribute19_o
384: => ben_pcp_shd.g_old_rec.pcp_attribute19
385: ,p_pcp_attribute20_o
386: => ben_pcp_shd.g_old_rec.pcp_attribute20

Line 384: => ben_pcp_shd.g_old_rec.pcp_attribute19

380: => ben_pcp_shd.g_old_rec.pcp_attribute17
381: ,p_pcp_attribute18_o
382: => ben_pcp_shd.g_old_rec.pcp_attribute18
383: ,p_pcp_attribute19_o
384: => ben_pcp_shd.g_old_rec.pcp_attribute19
385: ,p_pcp_attribute20_o
386: => ben_pcp_shd.g_old_rec.pcp_attribute20
387: ,p_pcp_attribute21_o
388: => ben_pcp_shd.g_old_rec.pcp_attribute21

Line 386: => ben_pcp_shd.g_old_rec.pcp_attribute20

382: => ben_pcp_shd.g_old_rec.pcp_attribute18
383: ,p_pcp_attribute19_o
384: => ben_pcp_shd.g_old_rec.pcp_attribute19
385: ,p_pcp_attribute20_o
386: => ben_pcp_shd.g_old_rec.pcp_attribute20
387: ,p_pcp_attribute21_o
388: => ben_pcp_shd.g_old_rec.pcp_attribute21
389: ,p_pcp_attribute22_o
390: => ben_pcp_shd.g_old_rec.pcp_attribute22

Line 388: => ben_pcp_shd.g_old_rec.pcp_attribute21

384: => ben_pcp_shd.g_old_rec.pcp_attribute19
385: ,p_pcp_attribute20_o
386: => ben_pcp_shd.g_old_rec.pcp_attribute20
387: ,p_pcp_attribute21_o
388: => ben_pcp_shd.g_old_rec.pcp_attribute21
389: ,p_pcp_attribute22_o
390: => ben_pcp_shd.g_old_rec.pcp_attribute22
391: ,p_pcp_attribute23_o
392: => ben_pcp_shd.g_old_rec.pcp_attribute23

Line 390: => ben_pcp_shd.g_old_rec.pcp_attribute22

386: => ben_pcp_shd.g_old_rec.pcp_attribute20
387: ,p_pcp_attribute21_o
388: => ben_pcp_shd.g_old_rec.pcp_attribute21
389: ,p_pcp_attribute22_o
390: => ben_pcp_shd.g_old_rec.pcp_attribute22
391: ,p_pcp_attribute23_o
392: => ben_pcp_shd.g_old_rec.pcp_attribute23
393: ,p_pcp_attribute24_o
394: => ben_pcp_shd.g_old_rec.pcp_attribute24

Line 392: => ben_pcp_shd.g_old_rec.pcp_attribute23

388: => ben_pcp_shd.g_old_rec.pcp_attribute21
389: ,p_pcp_attribute22_o
390: => ben_pcp_shd.g_old_rec.pcp_attribute22
391: ,p_pcp_attribute23_o
392: => ben_pcp_shd.g_old_rec.pcp_attribute23
393: ,p_pcp_attribute24_o
394: => ben_pcp_shd.g_old_rec.pcp_attribute24
395: ,p_pcp_attribute25_o
396: => ben_pcp_shd.g_old_rec.pcp_attribute25

Line 394: => ben_pcp_shd.g_old_rec.pcp_attribute24

390: => ben_pcp_shd.g_old_rec.pcp_attribute22
391: ,p_pcp_attribute23_o
392: => ben_pcp_shd.g_old_rec.pcp_attribute23
393: ,p_pcp_attribute24_o
394: => ben_pcp_shd.g_old_rec.pcp_attribute24
395: ,p_pcp_attribute25_o
396: => ben_pcp_shd.g_old_rec.pcp_attribute25
397: ,p_pcp_attribute26_o
398: => ben_pcp_shd.g_old_rec.pcp_attribute26

Line 396: => ben_pcp_shd.g_old_rec.pcp_attribute25

392: => ben_pcp_shd.g_old_rec.pcp_attribute23
393: ,p_pcp_attribute24_o
394: => ben_pcp_shd.g_old_rec.pcp_attribute24
395: ,p_pcp_attribute25_o
396: => ben_pcp_shd.g_old_rec.pcp_attribute25
397: ,p_pcp_attribute26_o
398: => ben_pcp_shd.g_old_rec.pcp_attribute26
399: ,p_pcp_attribute27_o
400: => ben_pcp_shd.g_old_rec.pcp_attribute27

Line 398: => ben_pcp_shd.g_old_rec.pcp_attribute26

394: => ben_pcp_shd.g_old_rec.pcp_attribute24
395: ,p_pcp_attribute25_o
396: => ben_pcp_shd.g_old_rec.pcp_attribute25
397: ,p_pcp_attribute26_o
398: => ben_pcp_shd.g_old_rec.pcp_attribute26
399: ,p_pcp_attribute27_o
400: => ben_pcp_shd.g_old_rec.pcp_attribute27
401: ,p_pcp_attribute28_o
402: => ben_pcp_shd.g_old_rec.pcp_attribute28

Line 400: => ben_pcp_shd.g_old_rec.pcp_attribute27

396: => ben_pcp_shd.g_old_rec.pcp_attribute25
397: ,p_pcp_attribute26_o
398: => ben_pcp_shd.g_old_rec.pcp_attribute26
399: ,p_pcp_attribute27_o
400: => ben_pcp_shd.g_old_rec.pcp_attribute27
401: ,p_pcp_attribute28_o
402: => ben_pcp_shd.g_old_rec.pcp_attribute28
403: ,p_pcp_attribute29_o
404: => ben_pcp_shd.g_old_rec.pcp_attribute29

Line 402: => ben_pcp_shd.g_old_rec.pcp_attribute28

398: => ben_pcp_shd.g_old_rec.pcp_attribute26
399: ,p_pcp_attribute27_o
400: => ben_pcp_shd.g_old_rec.pcp_attribute27
401: ,p_pcp_attribute28_o
402: => ben_pcp_shd.g_old_rec.pcp_attribute28
403: ,p_pcp_attribute29_o
404: => ben_pcp_shd.g_old_rec.pcp_attribute29
405: ,p_pcp_attribute30_o
406: => ben_pcp_shd.g_old_rec.pcp_attribute30

Line 404: => ben_pcp_shd.g_old_rec.pcp_attribute29

400: => ben_pcp_shd.g_old_rec.pcp_attribute27
401: ,p_pcp_attribute28_o
402: => ben_pcp_shd.g_old_rec.pcp_attribute28
403: ,p_pcp_attribute29_o
404: => ben_pcp_shd.g_old_rec.pcp_attribute29
405: ,p_pcp_attribute30_o
406: => ben_pcp_shd.g_old_rec.pcp_attribute30
407: ,p_object_version_number_o
408: => ben_pcp_shd.g_old_rec.object_version_number

Line 406: => ben_pcp_shd.g_old_rec.pcp_attribute30

402: => ben_pcp_shd.g_old_rec.pcp_attribute28
403: ,p_pcp_attribute29_o
404: => ben_pcp_shd.g_old_rec.pcp_attribute29
405: ,p_pcp_attribute30_o
406: => ben_pcp_shd.g_old_rec.pcp_attribute30
407: ,p_object_version_number_o
408: => ben_pcp_shd.g_old_rec.object_version_number
409: );
410: --

Line 408: => ben_pcp_shd.g_old_rec.object_version_number

404: => ben_pcp_shd.g_old_rec.pcp_attribute29
405: ,p_pcp_attribute30_o
406: => ben_pcp_shd.g_old_rec.pcp_attribute30
407: ,p_object_version_number_o
408: => ben_pcp_shd.g_old_rec.object_version_number
409: );
410: --
411: exception
412: --

Line 468: (p_rec in out nocopy ben_pcp_shd.g_rec_type

464: --
465: -- {End Of Comments}
466: -- ----------------------------------------------------------------------------
467: Procedure convert_defs
468: (p_rec in out nocopy ben_pcp_shd.g_rec_type
469: ) is
470: --
471: Begin
472: --

Line 480: ben_pcp_shd.g_old_rec.pl_id;

476: -- is being used then we must set to the 'current' argument value.
477: --
478: If (p_rec.pl_id = hr_api.g_number) then
479: p_rec.pl_id :=
480: ben_pcp_shd.g_old_rec.pl_id;
481: End If;
482: If (p_rec.business_group_id = hr_api.g_number) then
483: p_rec.business_group_id :=
484: ben_pcp_shd.g_old_rec.business_group_id;

Line 484: ben_pcp_shd.g_old_rec.business_group_id;

480: ben_pcp_shd.g_old_rec.pl_id;
481: End If;
482: If (p_rec.business_group_id = hr_api.g_number) then
483: p_rec.business_group_id :=
484: ben_pcp_shd.g_old_rec.business_group_id;
485: End If;
486: If (p_rec.pcp_strt_dt_cd = hr_api.g_varchar2) then
487: p_rec.pcp_strt_dt_cd :=
488: ben_pcp_shd.g_old_rec.pcp_strt_dt_cd;

Line 488: ben_pcp_shd.g_old_rec.pcp_strt_dt_cd;

484: ben_pcp_shd.g_old_rec.business_group_id;
485: End If;
486: If (p_rec.pcp_strt_dt_cd = hr_api.g_varchar2) then
487: p_rec.pcp_strt_dt_cd :=
488: ben_pcp_shd.g_old_rec.pcp_strt_dt_cd;
489: End If;
490: If (p_rec.pcp_dsgn_cd = hr_api.g_varchar2) then
491: p_rec.pcp_dsgn_cd :=
492: ben_pcp_shd.g_old_rec.pcp_dsgn_cd;

Line 492: ben_pcp_shd.g_old_rec.pcp_dsgn_cd;

488: ben_pcp_shd.g_old_rec.pcp_strt_dt_cd;
489: End If;
490: If (p_rec.pcp_dsgn_cd = hr_api.g_varchar2) then
491: p_rec.pcp_dsgn_cd :=
492: ben_pcp_shd.g_old_rec.pcp_dsgn_cd;
493: End If;
494: If (p_rec.pcp_dpnt_dsgn_cd = hr_api.g_varchar2) then
495: p_rec.pcp_dpnt_dsgn_cd :=
496: ben_pcp_shd.g_old_rec.pcp_dpnt_dsgn_cd;

Line 496: ben_pcp_shd.g_old_rec.pcp_dpnt_dsgn_cd;

492: ben_pcp_shd.g_old_rec.pcp_dsgn_cd;
493: End If;
494: If (p_rec.pcp_dpnt_dsgn_cd = hr_api.g_varchar2) then
495: p_rec.pcp_dpnt_dsgn_cd :=
496: ben_pcp_shd.g_old_rec.pcp_dpnt_dsgn_cd;
497: End If;
498: If (p_rec.pcp_rpstry_flag = hr_api.g_varchar2) then
499: p_rec.pcp_rpstry_flag :=
500: ben_pcp_shd.g_old_rec.pcp_rpstry_flag;

Line 500: ben_pcp_shd.g_old_rec.pcp_rpstry_flag;

496: ben_pcp_shd.g_old_rec.pcp_dpnt_dsgn_cd;
497: End If;
498: If (p_rec.pcp_rpstry_flag = hr_api.g_varchar2) then
499: p_rec.pcp_rpstry_flag :=
500: ben_pcp_shd.g_old_rec.pcp_rpstry_flag;
501: End If;
502: If (p_rec.pcp_can_keep_flag = hr_api.g_varchar2) then
503: p_rec.pcp_can_keep_flag :=
504: ben_pcp_shd.g_old_rec.pcp_can_keep_flag;

Line 504: ben_pcp_shd.g_old_rec.pcp_can_keep_flag;

500: ben_pcp_shd.g_old_rec.pcp_rpstry_flag;
501: End If;
502: If (p_rec.pcp_can_keep_flag = hr_api.g_varchar2) then
503: p_rec.pcp_can_keep_flag :=
504: ben_pcp_shd.g_old_rec.pcp_can_keep_flag;
505: End If;
506: If (p_rec.pcp_radius = hr_api.g_number) then
507: p_rec.pcp_radius :=
508: ben_pcp_shd.g_old_rec.pcp_radius;

Line 508: ben_pcp_shd.g_old_rec.pcp_radius;

504: ben_pcp_shd.g_old_rec.pcp_can_keep_flag;
505: End If;
506: If (p_rec.pcp_radius = hr_api.g_number) then
507: p_rec.pcp_radius :=
508: ben_pcp_shd.g_old_rec.pcp_radius;
509: End If;
510: If (p_rec.pcp_radius_uom = hr_api.g_varchar2) then
511: p_rec.pcp_radius_uom :=
512: ben_pcp_shd.g_old_rec.pcp_radius_uom;

Line 512: ben_pcp_shd.g_old_rec.pcp_radius_uom;

508: ben_pcp_shd.g_old_rec.pcp_radius;
509: End If;
510: If (p_rec.pcp_radius_uom = hr_api.g_varchar2) then
511: p_rec.pcp_radius_uom :=
512: ben_pcp_shd.g_old_rec.pcp_radius_uom;
513: End If;
514: If (p_rec.pcp_radius_warn_flag = hr_api.g_varchar2) then
515: p_rec.pcp_radius_warn_flag :=
516: ben_pcp_shd.g_old_rec.pcp_radius_warn_flag;

Line 516: ben_pcp_shd.g_old_rec.pcp_radius_warn_flag;

512: ben_pcp_shd.g_old_rec.pcp_radius_uom;
513: End If;
514: If (p_rec.pcp_radius_warn_flag = hr_api.g_varchar2) then
515: p_rec.pcp_radius_warn_flag :=
516: ben_pcp_shd.g_old_rec.pcp_radius_warn_flag;
517: End If;
518: If (p_rec.pcp_num_chgs = hr_api.g_number) then
519: p_rec.pcp_num_chgs :=
520: ben_pcp_shd.g_old_rec.pcp_num_chgs;

Line 520: ben_pcp_shd.g_old_rec.pcp_num_chgs;

516: ben_pcp_shd.g_old_rec.pcp_radius_warn_flag;
517: End If;
518: If (p_rec.pcp_num_chgs = hr_api.g_number) then
519: p_rec.pcp_num_chgs :=
520: ben_pcp_shd.g_old_rec.pcp_num_chgs;
521: End If;
522: If (p_rec.pcp_num_chgs_uom = hr_api.g_varchar2) then
523: p_rec.pcp_num_chgs_uom :=
524: ben_pcp_shd.g_old_rec.pcp_num_chgs_uom;

Line 524: ben_pcp_shd.g_old_rec.pcp_num_chgs_uom;

520: ben_pcp_shd.g_old_rec.pcp_num_chgs;
521: End If;
522: If (p_rec.pcp_num_chgs_uom = hr_api.g_varchar2) then
523: p_rec.pcp_num_chgs_uom :=
524: ben_pcp_shd.g_old_rec.pcp_num_chgs_uom;
525: End If;
526: If (p_rec.pcp_attribute_category = hr_api.g_varchar2) then
527: p_rec.pcp_attribute_category :=
528: ben_pcp_shd.g_old_rec.pcp_attribute_category;

Line 528: ben_pcp_shd.g_old_rec.pcp_attribute_category;

524: ben_pcp_shd.g_old_rec.pcp_num_chgs_uom;
525: End If;
526: If (p_rec.pcp_attribute_category = hr_api.g_varchar2) then
527: p_rec.pcp_attribute_category :=
528: ben_pcp_shd.g_old_rec.pcp_attribute_category;
529: End If;
530: If (p_rec.pcp_attribute1 = hr_api.g_varchar2) then
531: p_rec.pcp_attribute1 :=
532: ben_pcp_shd.g_old_rec.pcp_attribute1;

Line 532: ben_pcp_shd.g_old_rec.pcp_attribute1;

528: ben_pcp_shd.g_old_rec.pcp_attribute_category;
529: End If;
530: If (p_rec.pcp_attribute1 = hr_api.g_varchar2) then
531: p_rec.pcp_attribute1 :=
532: ben_pcp_shd.g_old_rec.pcp_attribute1;
533: End If;
534: If (p_rec.pcp_attribute2 = hr_api.g_varchar2) then
535: p_rec.pcp_attribute2 :=
536: ben_pcp_shd.g_old_rec.pcp_attribute2;

Line 536: ben_pcp_shd.g_old_rec.pcp_attribute2;

532: ben_pcp_shd.g_old_rec.pcp_attribute1;
533: End If;
534: If (p_rec.pcp_attribute2 = hr_api.g_varchar2) then
535: p_rec.pcp_attribute2 :=
536: ben_pcp_shd.g_old_rec.pcp_attribute2;
537: End If;
538: If (p_rec.pcp_attribute3 = hr_api.g_varchar2) then
539: p_rec.pcp_attribute3 :=
540: ben_pcp_shd.g_old_rec.pcp_attribute3;

Line 540: ben_pcp_shd.g_old_rec.pcp_attribute3;

536: ben_pcp_shd.g_old_rec.pcp_attribute2;
537: End If;
538: If (p_rec.pcp_attribute3 = hr_api.g_varchar2) then
539: p_rec.pcp_attribute3 :=
540: ben_pcp_shd.g_old_rec.pcp_attribute3;
541: End If;
542: If (p_rec.pcp_attribute4 = hr_api.g_varchar2) then
543: p_rec.pcp_attribute4 :=
544: ben_pcp_shd.g_old_rec.pcp_attribute4;

Line 544: ben_pcp_shd.g_old_rec.pcp_attribute4;

540: ben_pcp_shd.g_old_rec.pcp_attribute3;
541: End If;
542: If (p_rec.pcp_attribute4 = hr_api.g_varchar2) then
543: p_rec.pcp_attribute4 :=
544: ben_pcp_shd.g_old_rec.pcp_attribute4;
545: End If;
546: If (p_rec.pcp_attribute5 = hr_api.g_varchar2) then
547: p_rec.pcp_attribute5 :=
548: ben_pcp_shd.g_old_rec.pcp_attribute5;

Line 548: ben_pcp_shd.g_old_rec.pcp_attribute5;

544: ben_pcp_shd.g_old_rec.pcp_attribute4;
545: End If;
546: If (p_rec.pcp_attribute5 = hr_api.g_varchar2) then
547: p_rec.pcp_attribute5 :=
548: ben_pcp_shd.g_old_rec.pcp_attribute5;
549: End If;
550: If (p_rec.pcp_attribute6 = hr_api.g_varchar2) then
551: p_rec.pcp_attribute6 :=
552: ben_pcp_shd.g_old_rec.pcp_attribute6;

Line 552: ben_pcp_shd.g_old_rec.pcp_attribute6;

548: ben_pcp_shd.g_old_rec.pcp_attribute5;
549: End If;
550: If (p_rec.pcp_attribute6 = hr_api.g_varchar2) then
551: p_rec.pcp_attribute6 :=
552: ben_pcp_shd.g_old_rec.pcp_attribute6;
553: End If;
554: If (p_rec.pcp_attribute7 = hr_api.g_varchar2) then
555: p_rec.pcp_attribute7 :=
556: ben_pcp_shd.g_old_rec.pcp_attribute7;

Line 556: ben_pcp_shd.g_old_rec.pcp_attribute7;

552: ben_pcp_shd.g_old_rec.pcp_attribute6;
553: End If;
554: If (p_rec.pcp_attribute7 = hr_api.g_varchar2) then
555: p_rec.pcp_attribute7 :=
556: ben_pcp_shd.g_old_rec.pcp_attribute7;
557: End If;
558: If (p_rec.pcp_attribute8 = hr_api.g_varchar2) then
559: p_rec.pcp_attribute8 :=
560: ben_pcp_shd.g_old_rec.pcp_attribute8;

Line 560: ben_pcp_shd.g_old_rec.pcp_attribute8;

556: ben_pcp_shd.g_old_rec.pcp_attribute7;
557: End If;
558: If (p_rec.pcp_attribute8 = hr_api.g_varchar2) then
559: p_rec.pcp_attribute8 :=
560: ben_pcp_shd.g_old_rec.pcp_attribute8;
561: End If;
562: If (p_rec.pcp_attribute9 = hr_api.g_varchar2) then
563: p_rec.pcp_attribute9 :=
564: ben_pcp_shd.g_old_rec.pcp_attribute9;

Line 564: ben_pcp_shd.g_old_rec.pcp_attribute9;

560: ben_pcp_shd.g_old_rec.pcp_attribute8;
561: End If;
562: If (p_rec.pcp_attribute9 = hr_api.g_varchar2) then
563: p_rec.pcp_attribute9 :=
564: ben_pcp_shd.g_old_rec.pcp_attribute9;
565: End If;
566: If (p_rec.pcp_attribute10 = hr_api.g_varchar2) then
567: p_rec.pcp_attribute10 :=
568: ben_pcp_shd.g_old_rec.pcp_attribute10;

Line 568: ben_pcp_shd.g_old_rec.pcp_attribute10;

564: ben_pcp_shd.g_old_rec.pcp_attribute9;
565: End If;
566: If (p_rec.pcp_attribute10 = hr_api.g_varchar2) then
567: p_rec.pcp_attribute10 :=
568: ben_pcp_shd.g_old_rec.pcp_attribute10;
569: End If;
570: If (p_rec.pcp_attribute11 = hr_api.g_varchar2) then
571: p_rec.pcp_attribute11 :=
572: ben_pcp_shd.g_old_rec.pcp_attribute11;

Line 572: ben_pcp_shd.g_old_rec.pcp_attribute11;

568: ben_pcp_shd.g_old_rec.pcp_attribute10;
569: End If;
570: If (p_rec.pcp_attribute11 = hr_api.g_varchar2) then
571: p_rec.pcp_attribute11 :=
572: ben_pcp_shd.g_old_rec.pcp_attribute11;
573: End If;
574: If (p_rec.pcp_attribute12 = hr_api.g_varchar2) then
575: p_rec.pcp_attribute12 :=
576: ben_pcp_shd.g_old_rec.pcp_attribute12;

Line 576: ben_pcp_shd.g_old_rec.pcp_attribute12;

572: ben_pcp_shd.g_old_rec.pcp_attribute11;
573: End If;
574: If (p_rec.pcp_attribute12 = hr_api.g_varchar2) then
575: p_rec.pcp_attribute12 :=
576: ben_pcp_shd.g_old_rec.pcp_attribute12;
577: End If;
578: If (p_rec.pcp_attribute13 = hr_api.g_varchar2) then
579: p_rec.pcp_attribute13 :=
580: ben_pcp_shd.g_old_rec.pcp_attribute13;

Line 580: ben_pcp_shd.g_old_rec.pcp_attribute13;

576: ben_pcp_shd.g_old_rec.pcp_attribute12;
577: End If;
578: If (p_rec.pcp_attribute13 = hr_api.g_varchar2) then
579: p_rec.pcp_attribute13 :=
580: ben_pcp_shd.g_old_rec.pcp_attribute13;
581: End If;
582: If (p_rec.pcp_attribute14 = hr_api.g_varchar2) then
583: p_rec.pcp_attribute14 :=
584: ben_pcp_shd.g_old_rec.pcp_attribute14;

Line 584: ben_pcp_shd.g_old_rec.pcp_attribute14;

580: ben_pcp_shd.g_old_rec.pcp_attribute13;
581: End If;
582: If (p_rec.pcp_attribute14 = hr_api.g_varchar2) then
583: p_rec.pcp_attribute14 :=
584: ben_pcp_shd.g_old_rec.pcp_attribute14;
585: End If;
586: If (p_rec.pcp_attribute15 = hr_api.g_varchar2) then
587: p_rec.pcp_attribute15 :=
588: ben_pcp_shd.g_old_rec.pcp_attribute15;

Line 588: ben_pcp_shd.g_old_rec.pcp_attribute15;

584: ben_pcp_shd.g_old_rec.pcp_attribute14;
585: End If;
586: If (p_rec.pcp_attribute15 = hr_api.g_varchar2) then
587: p_rec.pcp_attribute15 :=
588: ben_pcp_shd.g_old_rec.pcp_attribute15;
589: End If;
590: If (p_rec.pcp_attribute16 = hr_api.g_varchar2) then
591: p_rec.pcp_attribute16 :=
592: ben_pcp_shd.g_old_rec.pcp_attribute16;

Line 592: ben_pcp_shd.g_old_rec.pcp_attribute16;

588: ben_pcp_shd.g_old_rec.pcp_attribute15;
589: End If;
590: If (p_rec.pcp_attribute16 = hr_api.g_varchar2) then
591: p_rec.pcp_attribute16 :=
592: ben_pcp_shd.g_old_rec.pcp_attribute16;
593: End If;
594: If (p_rec.pcp_attribute17 = hr_api.g_varchar2) then
595: p_rec.pcp_attribute17 :=
596: ben_pcp_shd.g_old_rec.pcp_attribute17;

Line 596: ben_pcp_shd.g_old_rec.pcp_attribute17;

592: ben_pcp_shd.g_old_rec.pcp_attribute16;
593: End If;
594: If (p_rec.pcp_attribute17 = hr_api.g_varchar2) then
595: p_rec.pcp_attribute17 :=
596: ben_pcp_shd.g_old_rec.pcp_attribute17;
597: End If;
598: If (p_rec.pcp_attribute18 = hr_api.g_varchar2) then
599: p_rec.pcp_attribute18 :=
600: ben_pcp_shd.g_old_rec.pcp_attribute18;

Line 600: ben_pcp_shd.g_old_rec.pcp_attribute18;

596: ben_pcp_shd.g_old_rec.pcp_attribute17;
597: End If;
598: If (p_rec.pcp_attribute18 = hr_api.g_varchar2) then
599: p_rec.pcp_attribute18 :=
600: ben_pcp_shd.g_old_rec.pcp_attribute18;
601: End If;
602: If (p_rec.pcp_attribute19 = hr_api.g_varchar2) then
603: p_rec.pcp_attribute19 :=
604: ben_pcp_shd.g_old_rec.pcp_attribute19;

Line 604: ben_pcp_shd.g_old_rec.pcp_attribute19;

600: ben_pcp_shd.g_old_rec.pcp_attribute18;
601: End If;
602: If (p_rec.pcp_attribute19 = hr_api.g_varchar2) then
603: p_rec.pcp_attribute19 :=
604: ben_pcp_shd.g_old_rec.pcp_attribute19;
605: End If;
606: If (p_rec.pcp_attribute20 = hr_api.g_varchar2) then
607: p_rec.pcp_attribute20 :=
608: ben_pcp_shd.g_old_rec.pcp_attribute20;

Line 608: ben_pcp_shd.g_old_rec.pcp_attribute20;

604: ben_pcp_shd.g_old_rec.pcp_attribute19;
605: End If;
606: If (p_rec.pcp_attribute20 = hr_api.g_varchar2) then
607: p_rec.pcp_attribute20 :=
608: ben_pcp_shd.g_old_rec.pcp_attribute20;
609: End If;
610: If (p_rec.pcp_attribute21 = hr_api.g_varchar2) then
611: p_rec.pcp_attribute21 :=
612: ben_pcp_shd.g_old_rec.pcp_attribute21;

Line 612: ben_pcp_shd.g_old_rec.pcp_attribute21;

608: ben_pcp_shd.g_old_rec.pcp_attribute20;
609: End If;
610: If (p_rec.pcp_attribute21 = hr_api.g_varchar2) then
611: p_rec.pcp_attribute21 :=
612: ben_pcp_shd.g_old_rec.pcp_attribute21;
613: End If;
614: If (p_rec.pcp_attribute22 = hr_api.g_varchar2) then
615: p_rec.pcp_attribute22 :=
616: ben_pcp_shd.g_old_rec.pcp_attribute22;

Line 616: ben_pcp_shd.g_old_rec.pcp_attribute22;

612: ben_pcp_shd.g_old_rec.pcp_attribute21;
613: End If;
614: If (p_rec.pcp_attribute22 = hr_api.g_varchar2) then
615: p_rec.pcp_attribute22 :=
616: ben_pcp_shd.g_old_rec.pcp_attribute22;
617: End If;
618: If (p_rec.pcp_attribute23 = hr_api.g_varchar2) then
619: p_rec.pcp_attribute23 :=
620: ben_pcp_shd.g_old_rec.pcp_attribute23;

Line 620: ben_pcp_shd.g_old_rec.pcp_attribute23;

616: ben_pcp_shd.g_old_rec.pcp_attribute22;
617: End If;
618: If (p_rec.pcp_attribute23 = hr_api.g_varchar2) then
619: p_rec.pcp_attribute23 :=
620: ben_pcp_shd.g_old_rec.pcp_attribute23;
621: End If;
622: If (p_rec.pcp_attribute24 = hr_api.g_varchar2) then
623: p_rec.pcp_attribute24 :=
624: ben_pcp_shd.g_old_rec.pcp_attribute24;

Line 624: ben_pcp_shd.g_old_rec.pcp_attribute24;

620: ben_pcp_shd.g_old_rec.pcp_attribute23;
621: End If;
622: If (p_rec.pcp_attribute24 = hr_api.g_varchar2) then
623: p_rec.pcp_attribute24 :=
624: ben_pcp_shd.g_old_rec.pcp_attribute24;
625: End If;
626: If (p_rec.pcp_attribute25 = hr_api.g_varchar2) then
627: p_rec.pcp_attribute25 :=
628: ben_pcp_shd.g_old_rec.pcp_attribute25;

Line 628: ben_pcp_shd.g_old_rec.pcp_attribute25;

624: ben_pcp_shd.g_old_rec.pcp_attribute24;
625: End If;
626: If (p_rec.pcp_attribute25 = hr_api.g_varchar2) then
627: p_rec.pcp_attribute25 :=
628: ben_pcp_shd.g_old_rec.pcp_attribute25;
629: End If;
630: If (p_rec.pcp_attribute26 = hr_api.g_varchar2) then
631: p_rec.pcp_attribute26 :=
632: ben_pcp_shd.g_old_rec.pcp_attribute26;

Line 632: ben_pcp_shd.g_old_rec.pcp_attribute26;

628: ben_pcp_shd.g_old_rec.pcp_attribute25;
629: End If;
630: If (p_rec.pcp_attribute26 = hr_api.g_varchar2) then
631: p_rec.pcp_attribute26 :=
632: ben_pcp_shd.g_old_rec.pcp_attribute26;
633: End If;
634: If (p_rec.pcp_attribute27 = hr_api.g_varchar2) then
635: p_rec.pcp_attribute27 :=
636: ben_pcp_shd.g_old_rec.pcp_attribute27;

Line 636: ben_pcp_shd.g_old_rec.pcp_attribute27;

632: ben_pcp_shd.g_old_rec.pcp_attribute26;
633: End If;
634: If (p_rec.pcp_attribute27 = hr_api.g_varchar2) then
635: p_rec.pcp_attribute27 :=
636: ben_pcp_shd.g_old_rec.pcp_attribute27;
637: End If;
638: If (p_rec.pcp_attribute28 = hr_api.g_varchar2) then
639: p_rec.pcp_attribute28 :=
640: ben_pcp_shd.g_old_rec.pcp_attribute28;

Line 640: ben_pcp_shd.g_old_rec.pcp_attribute28;

636: ben_pcp_shd.g_old_rec.pcp_attribute27;
637: End If;
638: If (p_rec.pcp_attribute28 = hr_api.g_varchar2) then
639: p_rec.pcp_attribute28 :=
640: ben_pcp_shd.g_old_rec.pcp_attribute28;
641: End If;
642: If (p_rec.pcp_attribute29 = hr_api.g_varchar2) then
643: p_rec.pcp_attribute29 :=
644: ben_pcp_shd.g_old_rec.pcp_attribute29;

Line 644: ben_pcp_shd.g_old_rec.pcp_attribute29;

640: ben_pcp_shd.g_old_rec.pcp_attribute28;
641: End If;
642: If (p_rec.pcp_attribute29 = hr_api.g_varchar2) then
643: p_rec.pcp_attribute29 :=
644: ben_pcp_shd.g_old_rec.pcp_attribute29;
645: End If;
646: If (p_rec.pcp_attribute30 = hr_api.g_varchar2) then
647: p_rec.pcp_attribute30 :=
648: ben_pcp_shd.g_old_rec.pcp_attribute30;

Line 648: ben_pcp_shd.g_old_rec.pcp_attribute30;

644: ben_pcp_shd.g_old_rec.pcp_attribute29;
645: End If;
646: If (p_rec.pcp_attribute30 = hr_api.g_varchar2) then
647: p_rec.pcp_attribute30 :=
648: ben_pcp_shd.g_old_rec.pcp_attribute30;
649: End If;
650: --
651: End convert_defs;
652: --

Line 658: p_rec in out nocopy ben_pcp_shd.g_rec_type )

654: -- |---------------------------------< upd >----------------------------------|
655: -- ----------------------------------------------------------------------------
656: Procedure upd
657: (p_effective_date in date,
658: p_rec in out nocopy ben_pcp_shd.g_rec_type )
659: is
660: --
661: l_proc varchar2(72) := g_package||'upd';
662: --

Line 668: ben_pcp_shd.lck

664: hr_utility.set_location('Entering:'||l_proc, 5);
665: --
666: -- We must lock the row which we need to update.
667: --
668: ben_pcp_shd.lck
669: (p_rec.pl_pcp_id
670: ,p_rec.object_version_number
671: );
672: --

Line 751: l_rec ben_pcp_shd.g_rec_type;

747: ,p_pcp_attribute29 in varchar2 default hr_api.g_varchar2
748: ,p_pcp_attribute30 in varchar2 default hr_api.g_varchar2
749: ) is
750: --
751: l_rec ben_pcp_shd.g_rec_type;
752: l_proc varchar2(72) := g_package||'upd';
753: --
754: Begin
755: hr_utility.set_location('Entering:'||l_proc, 5);

Line 761: ben_pcp_shd.convert_args

757: -- Call conversion function to turn arguments into the
758: -- l_rec structure.
759: --
760: l_rec :=
761: ben_pcp_shd.convert_args
762: (p_pl_pcp_id
763: ,p_pl_id
764: ,p_business_group_id
765: ,p_pcp_strt_dt_cd