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_PTY_UPD dependencies on BEN_PTY_SHD

Line 55: (p_rec in out nocopy ben_pty_shd.g_rec_type

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

Line 66: ben_pty_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_pty_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Update the ben_pl_pcp_typ Row
69: --
70: update ben_pl_pcp_typ

Line 113: ben_pty_shd.g_api_dml := false; -- Unset the api dml status

109: ,pty_attribute30 = p_rec.pty_attribute30
110: ,object_version_number = p_rec.object_version_number
111: where pl_pcp_typ_id = p_rec.pl_pcp_typ_id;
112: --
113: ben_pty_shd.g_api_dml := false; -- Unset the api dml status
114: --
115: hr_utility.set_location(' Leaving:'||l_proc, 10);
116: --
117: Exception

Line 120: ben_pty_shd.g_api_dml := false; -- Unset the api dml status

116: --
117: Exception
118: When hr_api.check_integrity_violated Then
119: -- A check constraint has been violated
120: ben_pty_shd.g_api_dml := false; -- Unset the api dml status
121: ben_pty_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.parent_integrity_violated Then
124: -- Parent integrity has been violated

Line 121: ben_pty_shd.constraint_error

117: Exception
118: When hr_api.check_integrity_violated Then
119: -- A check constraint has been violated
120: ben_pty_shd.g_api_dml := false; -- Unset the api dml status
121: ben_pty_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.parent_integrity_violated Then
124: -- Parent integrity has been violated
125: ben_pty_shd.g_api_dml := false; -- Unset the api dml status

Line 125: ben_pty_shd.g_api_dml := false; -- Unset the api dml status

121: ben_pty_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.parent_integrity_violated Then
124: -- Parent integrity has been violated
125: ben_pty_shd.g_api_dml := false; -- Unset the api dml status
126: ben_pty_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When hr_api.unique_integrity_violated Then
129: -- Unique integrity has been violated

Line 126: ben_pty_shd.constraint_error

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

Line 130: ben_pty_shd.g_api_dml := false; -- Unset the api dml status

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

Line 131: ben_pty_shd.constraint_error

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

Line 134: ben_pty_shd.g_api_dml := false; -- Unset the api dml status

130: ben_pty_shd.g_api_dml := false; -- Unset the api dml status
131: ben_pty_shd.constraint_error
132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
133: When Others Then
134: ben_pty_shd.g_api_dml := false; -- Unset the api dml status
135: Raise;
136: End update_dml;
137: --
138: -- ----------------------------------------------------------------------------

Line 171: (p_rec in ben_pty_shd.g_rec_type

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

Line 215: (p_rec in ben_pty_shd.g_rec_type

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

Line 304: => ben_pty_shd.g_old_rec.pl_pcp_id

300: => p_rec.pty_attribute30
301: ,p_object_version_number
302: => p_rec.object_version_number
303: ,p_pl_pcp_id_o
304: => ben_pty_shd.g_old_rec.pl_pcp_id
305: ,p_business_group_id_o
306: => ben_pty_shd.g_old_rec.business_group_id
307: ,p_pcp_typ_cd_o
308: => ben_pty_shd.g_old_rec.pcp_typ_cd

Line 306: => ben_pty_shd.g_old_rec.business_group_id

302: => p_rec.object_version_number
303: ,p_pl_pcp_id_o
304: => ben_pty_shd.g_old_rec.pl_pcp_id
305: ,p_business_group_id_o
306: => ben_pty_shd.g_old_rec.business_group_id
307: ,p_pcp_typ_cd_o
308: => ben_pty_shd.g_old_rec.pcp_typ_cd
309: ,p_min_age_o
310: => ben_pty_shd.g_old_rec.min_age

Line 308: => ben_pty_shd.g_old_rec.pcp_typ_cd

304: => ben_pty_shd.g_old_rec.pl_pcp_id
305: ,p_business_group_id_o
306: => ben_pty_shd.g_old_rec.business_group_id
307: ,p_pcp_typ_cd_o
308: => ben_pty_shd.g_old_rec.pcp_typ_cd
309: ,p_min_age_o
310: => ben_pty_shd.g_old_rec.min_age
311: ,p_max_age_o
312: => ben_pty_shd.g_old_rec.max_age

Line 310: => ben_pty_shd.g_old_rec.min_age

306: => ben_pty_shd.g_old_rec.business_group_id
307: ,p_pcp_typ_cd_o
308: => ben_pty_shd.g_old_rec.pcp_typ_cd
309: ,p_min_age_o
310: => ben_pty_shd.g_old_rec.min_age
311: ,p_max_age_o
312: => ben_pty_shd.g_old_rec.max_age
313: ,p_gndr_alwd_cd_o
314: => ben_pty_shd.g_old_rec.gndr_alwd_cd

Line 312: => ben_pty_shd.g_old_rec.max_age

308: => ben_pty_shd.g_old_rec.pcp_typ_cd
309: ,p_min_age_o
310: => ben_pty_shd.g_old_rec.min_age
311: ,p_max_age_o
312: => ben_pty_shd.g_old_rec.max_age
313: ,p_gndr_alwd_cd_o
314: => ben_pty_shd.g_old_rec.gndr_alwd_cd
315: ,p_pty_attribute_category_o
316: => ben_pty_shd.g_old_rec.pty_attribute_category

Line 314: => ben_pty_shd.g_old_rec.gndr_alwd_cd

310: => ben_pty_shd.g_old_rec.min_age
311: ,p_max_age_o
312: => ben_pty_shd.g_old_rec.max_age
313: ,p_gndr_alwd_cd_o
314: => ben_pty_shd.g_old_rec.gndr_alwd_cd
315: ,p_pty_attribute_category_o
316: => ben_pty_shd.g_old_rec.pty_attribute_category
317: ,p_pty_attribute1_o
318: => ben_pty_shd.g_old_rec.pty_attribute1

Line 316: => ben_pty_shd.g_old_rec.pty_attribute_category

312: => ben_pty_shd.g_old_rec.max_age
313: ,p_gndr_alwd_cd_o
314: => ben_pty_shd.g_old_rec.gndr_alwd_cd
315: ,p_pty_attribute_category_o
316: => ben_pty_shd.g_old_rec.pty_attribute_category
317: ,p_pty_attribute1_o
318: => ben_pty_shd.g_old_rec.pty_attribute1
319: ,p_pty_attribute2_o
320: => ben_pty_shd.g_old_rec.pty_attribute2

Line 318: => ben_pty_shd.g_old_rec.pty_attribute1

314: => ben_pty_shd.g_old_rec.gndr_alwd_cd
315: ,p_pty_attribute_category_o
316: => ben_pty_shd.g_old_rec.pty_attribute_category
317: ,p_pty_attribute1_o
318: => ben_pty_shd.g_old_rec.pty_attribute1
319: ,p_pty_attribute2_o
320: => ben_pty_shd.g_old_rec.pty_attribute2
321: ,p_pty_attribute3_o
322: => ben_pty_shd.g_old_rec.pty_attribute3

Line 320: => ben_pty_shd.g_old_rec.pty_attribute2

316: => ben_pty_shd.g_old_rec.pty_attribute_category
317: ,p_pty_attribute1_o
318: => ben_pty_shd.g_old_rec.pty_attribute1
319: ,p_pty_attribute2_o
320: => ben_pty_shd.g_old_rec.pty_attribute2
321: ,p_pty_attribute3_o
322: => ben_pty_shd.g_old_rec.pty_attribute3
323: ,p_pty_attribute4_o
324: => ben_pty_shd.g_old_rec.pty_attribute4

Line 322: => ben_pty_shd.g_old_rec.pty_attribute3

318: => ben_pty_shd.g_old_rec.pty_attribute1
319: ,p_pty_attribute2_o
320: => ben_pty_shd.g_old_rec.pty_attribute2
321: ,p_pty_attribute3_o
322: => ben_pty_shd.g_old_rec.pty_attribute3
323: ,p_pty_attribute4_o
324: => ben_pty_shd.g_old_rec.pty_attribute4
325: ,p_pty_attribute5_o
326: => ben_pty_shd.g_old_rec.pty_attribute5

Line 324: => ben_pty_shd.g_old_rec.pty_attribute4

320: => ben_pty_shd.g_old_rec.pty_attribute2
321: ,p_pty_attribute3_o
322: => ben_pty_shd.g_old_rec.pty_attribute3
323: ,p_pty_attribute4_o
324: => ben_pty_shd.g_old_rec.pty_attribute4
325: ,p_pty_attribute5_o
326: => ben_pty_shd.g_old_rec.pty_attribute5
327: ,p_pty_attribute6_o
328: => ben_pty_shd.g_old_rec.pty_attribute6

Line 326: => ben_pty_shd.g_old_rec.pty_attribute5

322: => ben_pty_shd.g_old_rec.pty_attribute3
323: ,p_pty_attribute4_o
324: => ben_pty_shd.g_old_rec.pty_attribute4
325: ,p_pty_attribute5_o
326: => ben_pty_shd.g_old_rec.pty_attribute5
327: ,p_pty_attribute6_o
328: => ben_pty_shd.g_old_rec.pty_attribute6
329: ,p_pty_attribute7_o
330: => ben_pty_shd.g_old_rec.pty_attribute7

Line 328: => ben_pty_shd.g_old_rec.pty_attribute6

324: => ben_pty_shd.g_old_rec.pty_attribute4
325: ,p_pty_attribute5_o
326: => ben_pty_shd.g_old_rec.pty_attribute5
327: ,p_pty_attribute6_o
328: => ben_pty_shd.g_old_rec.pty_attribute6
329: ,p_pty_attribute7_o
330: => ben_pty_shd.g_old_rec.pty_attribute7
331: ,p_pty_attribute8_o
332: => ben_pty_shd.g_old_rec.pty_attribute8

Line 330: => ben_pty_shd.g_old_rec.pty_attribute7

326: => ben_pty_shd.g_old_rec.pty_attribute5
327: ,p_pty_attribute6_o
328: => ben_pty_shd.g_old_rec.pty_attribute6
329: ,p_pty_attribute7_o
330: => ben_pty_shd.g_old_rec.pty_attribute7
331: ,p_pty_attribute8_o
332: => ben_pty_shd.g_old_rec.pty_attribute8
333: ,p_pty_attribute9_o
334: => ben_pty_shd.g_old_rec.pty_attribute9

Line 332: => ben_pty_shd.g_old_rec.pty_attribute8

328: => ben_pty_shd.g_old_rec.pty_attribute6
329: ,p_pty_attribute7_o
330: => ben_pty_shd.g_old_rec.pty_attribute7
331: ,p_pty_attribute8_o
332: => ben_pty_shd.g_old_rec.pty_attribute8
333: ,p_pty_attribute9_o
334: => ben_pty_shd.g_old_rec.pty_attribute9
335: ,p_pty_attribute10_o
336: => ben_pty_shd.g_old_rec.pty_attribute10

Line 334: => ben_pty_shd.g_old_rec.pty_attribute9

330: => ben_pty_shd.g_old_rec.pty_attribute7
331: ,p_pty_attribute8_o
332: => ben_pty_shd.g_old_rec.pty_attribute8
333: ,p_pty_attribute9_o
334: => ben_pty_shd.g_old_rec.pty_attribute9
335: ,p_pty_attribute10_o
336: => ben_pty_shd.g_old_rec.pty_attribute10
337: ,p_pty_attribute11_o
338: => ben_pty_shd.g_old_rec.pty_attribute11

Line 336: => ben_pty_shd.g_old_rec.pty_attribute10

332: => ben_pty_shd.g_old_rec.pty_attribute8
333: ,p_pty_attribute9_o
334: => ben_pty_shd.g_old_rec.pty_attribute9
335: ,p_pty_attribute10_o
336: => ben_pty_shd.g_old_rec.pty_attribute10
337: ,p_pty_attribute11_o
338: => ben_pty_shd.g_old_rec.pty_attribute11
339: ,p_pty_attribute12_o
340: => ben_pty_shd.g_old_rec.pty_attribute12

Line 338: => ben_pty_shd.g_old_rec.pty_attribute11

334: => ben_pty_shd.g_old_rec.pty_attribute9
335: ,p_pty_attribute10_o
336: => ben_pty_shd.g_old_rec.pty_attribute10
337: ,p_pty_attribute11_o
338: => ben_pty_shd.g_old_rec.pty_attribute11
339: ,p_pty_attribute12_o
340: => ben_pty_shd.g_old_rec.pty_attribute12
341: ,p_pty_attribute13_o
342: => ben_pty_shd.g_old_rec.pty_attribute13

Line 340: => ben_pty_shd.g_old_rec.pty_attribute12

336: => ben_pty_shd.g_old_rec.pty_attribute10
337: ,p_pty_attribute11_o
338: => ben_pty_shd.g_old_rec.pty_attribute11
339: ,p_pty_attribute12_o
340: => ben_pty_shd.g_old_rec.pty_attribute12
341: ,p_pty_attribute13_o
342: => ben_pty_shd.g_old_rec.pty_attribute13
343: ,p_pty_attribute14_o
344: => ben_pty_shd.g_old_rec.pty_attribute14

Line 342: => ben_pty_shd.g_old_rec.pty_attribute13

338: => ben_pty_shd.g_old_rec.pty_attribute11
339: ,p_pty_attribute12_o
340: => ben_pty_shd.g_old_rec.pty_attribute12
341: ,p_pty_attribute13_o
342: => ben_pty_shd.g_old_rec.pty_attribute13
343: ,p_pty_attribute14_o
344: => ben_pty_shd.g_old_rec.pty_attribute14
345: ,p_pty_attribute15_o
346: => ben_pty_shd.g_old_rec.pty_attribute15

Line 344: => ben_pty_shd.g_old_rec.pty_attribute14

340: => ben_pty_shd.g_old_rec.pty_attribute12
341: ,p_pty_attribute13_o
342: => ben_pty_shd.g_old_rec.pty_attribute13
343: ,p_pty_attribute14_o
344: => ben_pty_shd.g_old_rec.pty_attribute14
345: ,p_pty_attribute15_o
346: => ben_pty_shd.g_old_rec.pty_attribute15
347: ,p_pty_attribute16_o
348: => ben_pty_shd.g_old_rec.pty_attribute16

Line 346: => ben_pty_shd.g_old_rec.pty_attribute15

342: => ben_pty_shd.g_old_rec.pty_attribute13
343: ,p_pty_attribute14_o
344: => ben_pty_shd.g_old_rec.pty_attribute14
345: ,p_pty_attribute15_o
346: => ben_pty_shd.g_old_rec.pty_attribute15
347: ,p_pty_attribute16_o
348: => ben_pty_shd.g_old_rec.pty_attribute16
349: ,p_pty_attribute17_o
350: => ben_pty_shd.g_old_rec.pty_attribute17

Line 348: => ben_pty_shd.g_old_rec.pty_attribute16

344: => ben_pty_shd.g_old_rec.pty_attribute14
345: ,p_pty_attribute15_o
346: => ben_pty_shd.g_old_rec.pty_attribute15
347: ,p_pty_attribute16_o
348: => ben_pty_shd.g_old_rec.pty_attribute16
349: ,p_pty_attribute17_o
350: => ben_pty_shd.g_old_rec.pty_attribute17
351: ,p_pty_attribute18_o
352: => ben_pty_shd.g_old_rec.pty_attribute18

Line 350: => ben_pty_shd.g_old_rec.pty_attribute17

346: => ben_pty_shd.g_old_rec.pty_attribute15
347: ,p_pty_attribute16_o
348: => ben_pty_shd.g_old_rec.pty_attribute16
349: ,p_pty_attribute17_o
350: => ben_pty_shd.g_old_rec.pty_attribute17
351: ,p_pty_attribute18_o
352: => ben_pty_shd.g_old_rec.pty_attribute18
353: ,p_pty_attribute19_o
354: => ben_pty_shd.g_old_rec.pty_attribute19

Line 352: => ben_pty_shd.g_old_rec.pty_attribute18

348: => ben_pty_shd.g_old_rec.pty_attribute16
349: ,p_pty_attribute17_o
350: => ben_pty_shd.g_old_rec.pty_attribute17
351: ,p_pty_attribute18_o
352: => ben_pty_shd.g_old_rec.pty_attribute18
353: ,p_pty_attribute19_o
354: => ben_pty_shd.g_old_rec.pty_attribute19
355: ,p_pty_attribute20_o
356: => ben_pty_shd.g_old_rec.pty_attribute20

Line 354: => ben_pty_shd.g_old_rec.pty_attribute19

350: => ben_pty_shd.g_old_rec.pty_attribute17
351: ,p_pty_attribute18_o
352: => ben_pty_shd.g_old_rec.pty_attribute18
353: ,p_pty_attribute19_o
354: => ben_pty_shd.g_old_rec.pty_attribute19
355: ,p_pty_attribute20_o
356: => ben_pty_shd.g_old_rec.pty_attribute20
357: ,p_pty_attribute21_o
358: => ben_pty_shd.g_old_rec.pty_attribute21

Line 356: => ben_pty_shd.g_old_rec.pty_attribute20

352: => ben_pty_shd.g_old_rec.pty_attribute18
353: ,p_pty_attribute19_o
354: => ben_pty_shd.g_old_rec.pty_attribute19
355: ,p_pty_attribute20_o
356: => ben_pty_shd.g_old_rec.pty_attribute20
357: ,p_pty_attribute21_o
358: => ben_pty_shd.g_old_rec.pty_attribute21
359: ,p_pty_attribute22_o
360: => ben_pty_shd.g_old_rec.pty_attribute22

Line 358: => ben_pty_shd.g_old_rec.pty_attribute21

354: => ben_pty_shd.g_old_rec.pty_attribute19
355: ,p_pty_attribute20_o
356: => ben_pty_shd.g_old_rec.pty_attribute20
357: ,p_pty_attribute21_o
358: => ben_pty_shd.g_old_rec.pty_attribute21
359: ,p_pty_attribute22_o
360: => ben_pty_shd.g_old_rec.pty_attribute22
361: ,p_pty_attribute23_o
362: => ben_pty_shd.g_old_rec.pty_attribute23

Line 360: => ben_pty_shd.g_old_rec.pty_attribute22

356: => ben_pty_shd.g_old_rec.pty_attribute20
357: ,p_pty_attribute21_o
358: => ben_pty_shd.g_old_rec.pty_attribute21
359: ,p_pty_attribute22_o
360: => ben_pty_shd.g_old_rec.pty_attribute22
361: ,p_pty_attribute23_o
362: => ben_pty_shd.g_old_rec.pty_attribute23
363: ,p_pty_attribute24_o
364: => ben_pty_shd.g_old_rec.pty_attribute24

Line 362: => ben_pty_shd.g_old_rec.pty_attribute23

358: => ben_pty_shd.g_old_rec.pty_attribute21
359: ,p_pty_attribute22_o
360: => ben_pty_shd.g_old_rec.pty_attribute22
361: ,p_pty_attribute23_o
362: => ben_pty_shd.g_old_rec.pty_attribute23
363: ,p_pty_attribute24_o
364: => ben_pty_shd.g_old_rec.pty_attribute24
365: ,p_pty_attribute25_o
366: => ben_pty_shd.g_old_rec.pty_attribute25

Line 364: => ben_pty_shd.g_old_rec.pty_attribute24

360: => ben_pty_shd.g_old_rec.pty_attribute22
361: ,p_pty_attribute23_o
362: => ben_pty_shd.g_old_rec.pty_attribute23
363: ,p_pty_attribute24_o
364: => ben_pty_shd.g_old_rec.pty_attribute24
365: ,p_pty_attribute25_o
366: => ben_pty_shd.g_old_rec.pty_attribute25
367: ,p_pty_attribute26_o
368: => ben_pty_shd.g_old_rec.pty_attribute26

Line 366: => ben_pty_shd.g_old_rec.pty_attribute25

362: => ben_pty_shd.g_old_rec.pty_attribute23
363: ,p_pty_attribute24_o
364: => ben_pty_shd.g_old_rec.pty_attribute24
365: ,p_pty_attribute25_o
366: => ben_pty_shd.g_old_rec.pty_attribute25
367: ,p_pty_attribute26_o
368: => ben_pty_shd.g_old_rec.pty_attribute26
369: ,p_pty_attribute27_o
370: => ben_pty_shd.g_old_rec.pty_attribute27

Line 368: => ben_pty_shd.g_old_rec.pty_attribute26

364: => ben_pty_shd.g_old_rec.pty_attribute24
365: ,p_pty_attribute25_o
366: => ben_pty_shd.g_old_rec.pty_attribute25
367: ,p_pty_attribute26_o
368: => ben_pty_shd.g_old_rec.pty_attribute26
369: ,p_pty_attribute27_o
370: => ben_pty_shd.g_old_rec.pty_attribute27
371: ,p_pty_attribute28_o
372: => ben_pty_shd.g_old_rec.pty_attribute28

Line 370: => ben_pty_shd.g_old_rec.pty_attribute27

366: => ben_pty_shd.g_old_rec.pty_attribute25
367: ,p_pty_attribute26_o
368: => ben_pty_shd.g_old_rec.pty_attribute26
369: ,p_pty_attribute27_o
370: => ben_pty_shd.g_old_rec.pty_attribute27
371: ,p_pty_attribute28_o
372: => ben_pty_shd.g_old_rec.pty_attribute28
373: ,p_pty_attribute29_o
374: => ben_pty_shd.g_old_rec.pty_attribute29

Line 372: => ben_pty_shd.g_old_rec.pty_attribute28

368: => ben_pty_shd.g_old_rec.pty_attribute26
369: ,p_pty_attribute27_o
370: => ben_pty_shd.g_old_rec.pty_attribute27
371: ,p_pty_attribute28_o
372: => ben_pty_shd.g_old_rec.pty_attribute28
373: ,p_pty_attribute29_o
374: => ben_pty_shd.g_old_rec.pty_attribute29
375: ,p_pty_attribute30_o
376: => ben_pty_shd.g_old_rec.pty_attribute30

Line 374: => ben_pty_shd.g_old_rec.pty_attribute29

370: => ben_pty_shd.g_old_rec.pty_attribute27
371: ,p_pty_attribute28_o
372: => ben_pty_shd.g_old_rec.pty_attribute28
373: ,p_pty_attribute29_o
374: => ben_pty_shd.g_old_rec.pty_attribute29
375: ,p_pty_attribute30_o
376: => ben_pty_shd.g_old_rec.pty_attribute30
377: ,p_object_version_number_o
378: => ben_pty_shd.g_old_rec.object_version_number

Line 376: => ben_pty_shd.g_old_rec.pty_attribute30

372: => ben_pty_shd.g_old_rec.pty_attribute28
373: ,p_pty_attribute29_o
374: => ben_pty_shd.g_old_rec.pty_attribute29
375: ,p_pty_attribute30_o
376: => ben_pty_shd.g_old_rec.pty_attribute30
377: ,p_object_version_number_o
378: => ben_pty_shd.g_old_rec.object_version_number
379: );
380: --

Line 378: => ben_pty_shd.g_old_rec.object_version_number

374: => ben_pty_shd.g_old_rec.pty_attribute29
375: ,p_pty_attribute30_o
376: => ben_pty_shd.g_old_rec.pty_attribute30
377: ,p_object_version_number_o
378: => ben_pty_shd.g_old_rec.object_version_number
379: );
380: --
381: exception
382: --

Line 438: (p_rec in out nocopy ben_pty_shd.g_rec_type

434: --
435: -- {End Of Comments}
436: -- ----------------------------------------------------------------------------
437: Procedure convert_defs
438: (p_rec in out nocopy ben_pty_shd.g_rec_type
439: ) is
440: --
441: Begin
442: --

Line 450: ben_pty_shd.g_old_rec.pl_pcp_id;

446: -- is being used then we must set to the 'current' argument value.
447: --
448: If (p_rec.pl_pcp_id = hr_api.g_number) then
449: p_rec.pl_pcp_id :=
450: ben_pty_shd.g_old_rec.pl_pcp_id;
451: End If;
452: If (p_rec.business_group_id = hr_api.g_number) then
453: p_rec.business_group_id :=
454: ben_pty_shd.g_old_rec.business_group_id;

Line 454: ben_pty_shd.g_old_rec.business_group_id;

450: ben_pty_shd.g_old_rec.pl_pcp_id;
451: End If;
452: If (p_rec.business_group_id = hr_api.g_number) then
453: p_rec.business_group_id :=
454: ben_pty_shd.g_old_rec.business_group_id;
455: End If;
456: If (p_rec.pcp_typ_cd = hr_api.g_varchar2) then
457: p_rec.pcp_typ_cd :=
458: ben_pty_shd.g_old_rec.pcp_typ_cd;

Line 458: ben_pty_shd.g_old_rec.pcp_typ_cd;

454: ben_pty_shd.g_old_rec.business_group_id;
455: End If;
456: If (p_rec.pcp_typ_cd = hr_api.g_varchar2) then
457: p_rec.pcp_typ_cd :=
458: ben_pty_shd.g_old_rec.pcp_typ_cd;
459: End If;
460: If (p_rec.min_age = hr_api.g_number) then
461: p_rec.min_age :=
462: ben_pty_shd.g_old_rec.min_age;

Line 462: ben_pty_shd.g_old_rec.min_age;

458: ben_pty_shd.g_old_rec.pcp_typ_cd;
459: End If;
460: If (p_rec.min_age = hr_api.g_number) then
461: p_rec.min_age :=
462: ben_pty_shd.g_old_rec.min_age;
463: End If;
464: If (p_rec.max_age = hr_api.g_number) then
465: p_rec.max_age :=
466: ben_pty_shd.g_old_rec.max_age;

Line 466: ben_pty_shd.g_old_rec.max_age;

462: ben_pty_shd.g_old_rec.min_age;
463: End If;
464: If (p_rec.max_age = hr_api.g_number) then
465: p_rec.max_age :=
466: ben_pty_shd.g_old_rec.max_age;
467: End If;
468: If (p_rec.gndr_alwd_cd = hr_api.g_varchar2) then
469: p_rec.gndr_alwd_cd :=
470: ben_pty_shd.g_old_rec.gndr_alwd_cd;

Line 470: ben_pty_shd.g_old_rec.gndr_alwd_cd;

466: ben_pty_shd.g_old_rec.max_age;
467: End If;
468: If (p_rec.gndr_alwd_cd = hr_api.g_varchar2) then
469: p_rec.gndr_alwd_cd :=
470: ben_pty_shd.g_old_rec.gndr_alwd_cd;
471: End If;
472: If (p_rec.pty_attribute_category = hr_api.g_varchar2) then
473: p_rec.pty_attribute_category :=
474: ben_pty_shd.g_old_rec.pty_attribute_category;

Line 474: ben_pty_shd.g_old_rec.pty_attribute_category;

470: ben_pty_shd.g_old_rec.gndr_alwd_cd;
471: End If;
472: If (p_rec.pty_attribute_category = hr_api.g_varchar2) then
473: p_rec.pty_attribute_category :=
474: ben_pty_shd.g_old_rec.pty_attribute_category;
475: End If;
476: If (p_rec.pty_attribute1 = hr_api.g_varchar2) then
477: p_rec.pty_attribute1 :=
478: ben_pty_shd.g_old_rec.pty_attribute1;

Line 478: ben_pty_shd.g_old_rec.pty_attribute1;

474: ben_pty_shd.g_old_rec.pty_attribute_category;
475: End If;
476: If (p_rec.pty_attribute1 = hr_api.g_varchar2) then
477: p_rec.pty_attribute1 :=
478: ben_pty_shd.g_old_rec.pty_attribute1;
479: End If;
480: If (p_rec.pty_attribute2 = hr_api.g_varchar2) then
481: p_rec.pty_attribute2 :=
482: ben_pty_shd.g_old_rec.pty_attribute2;

Line 482: ben_pty_shd.g_old_rec.pty_attribute2;

478: ben_pty_shd.g_old_rec.pty_attribute1;
479: End If;
480: If (p_rec.pty_attribute2 = hr_api.g_varchar2) then
481: p_rec.pty_attribute2 :=
482: ben_pty_shd.g_old_rec.pty_attribute2;
483: End If;
484: If (p_rec.pty_attribute3 = hr_api.g_varchar2) then
485: p_rec.pty_attribute3 :=
486: ben_pty_shd.g_old_rec.pty_attribute3;

Line 486: ben_pty_shd.g_old_rec.pty_attribute3;

482: ben_pty_shd.g_old_rec.pty_attribute2;
483: End If;
484: If (p_rec.pty_attribute3 = hr_api.g_varchar2) then
485: p_rec.pty_attribute3 :=
486: ben_pty_shd.g_old_rec.pty_attribute3;
487: End If;
488: If (p_rec.pty_attribute4 = hr_api.g_varchar2) then
489: p_rec.pty_attribute4 :=
490: ben_pty_shd.g_old_rec.pty_attribute4;

Line 490: ben_pty_shd.g_old_rec.pty_attribute4;

486: ben_pty_shd.g_old_rec.pty_attribute3;
487: End If;
488: If (p_rec.pty_attribute4 = hr_api.g_varchar2) then
489: p_rec.pty_attribute4 :=
490: ben_pty_shd.g_old_rec.pty_attribute4;
491: End If;
492: If (p_rec.pty_attribute5 = hr_api.g_varchar2) then
493: p_rec.pty_attribute5 :=
494: ben_pty_shd.g_old_rec.pty_attribute5;

Line 494: ben_pty_shd.g_old_rec.pty_attribute5;

490: ben_pty_shd.g_old_rec.pty_attribute4;
491: End If;
492: If (p_rec.pty_attribute5 = hr_api.g_varchar2) then
493: p_rec.pty_attribute5 :=
494: ben_pty_shd.g_old_rec.pty_attribute5;
495: End If;
496: If (p_rec.pty_attribute6 = hr_api.g_varchar2) then
497: p_rec.pty_attribute6 :=
498: ben_pty_shd.g_old_rec.pty_attribute6;

Line 498: ben_pty_shd.g_old_rec.pty_attribute6;

494: ben_pty_shd.g_old_rec.pty_attribute5;
495: End If;
496: If (p_rec.pty_attribute6 = hr_api.g_varchar2) then
497: p_rec.pty_attribute6 :=
498: ben_pty_shd.g_old_rec.pty_attribute6;
499: End If;
500: If (p_rec.pty_attribute7 = hr_api.g_varchar2) then
501: p_rec.pty_attribute7 :=
502: ben_pty_shd.g_old_rec.pty_attribute7;

Line 502: ben_pty_shd.g_old_rec.pty_attribute7;

498: ben_pty_shd.g_old_rec.pty_attribute6;
499: End If;
500: If (p_rec.pty_attribute7 = hr_api.g_varchar2) then
501: p_rec.pty_attribute7 :=
502: ben_pty_shd.g_old_rec.pty_attribute7;
503: End If;
504: If (p_rec.pty_attribute8 = hr_api.g_varchar2) then
505: p_rec.pty_attribute8 :=
506: ben_pty_shd.g_old_rec.pty_attribute8;

Line 506: ben_pty_shd.g_old_rec.pty_attribute8;

502: ben_pty_shd.g_old_rec.pty_attribute7;
503: End If;
504: If (p_rec.pty_attribute8 = hr_api.g_varchar2) then
505: p_rec.pty_attribute8 :=
506: ben_pty_shd.g_old_rec.pty_attribute8;
507: End If;
508: If (p_rec.pty_attribute9 = hr_api.g_varchar2) then
509: p_rec.pty_attribute9 :=
510: ben_pty_shd.g_old_rec.pty_attribute9;

Line 510: ben_pty_shd.g_old_rec.pty_attribute9;

506: ben_pty_shd.g_old_rec.pty_attribute8;
507: End If;
508: If (p_rec.pty_attribute9 = hr_api.g_varchar2) then
509: p_rec.pty_attribute9 :=
510: ben_pty_shd.g_old_rec.pty_attribute9;
511: End If;
512: If (p_rec.pty_attribute10 = hr_api.g_varchar2) then
513: p_rec.pty_attribute10 :=
514: ben_pty_shd.g_old_rec.pty_attribute10;

Line 514: ben_pty_shd.g_old_rec.pty_attribute10;

510: ben_pty_shd.g_old_rec.pty_attribute9;
511: End If;
512: If (p_rec.pty_attribute10 = hr_api.g_varchar2) then
513: p_rec.pty_attribute10 :=
514: ben_pty_shd.g_old_rec.pty_attribute10;
515: End If;
516: If (p_rec.pty_attribute11 = hr_api.g_varchar2) then
517: p_rec.pty_attribute11 :=
518: ben_pty_shd.g_old_rec.pty_attribute11;

Line 518: ben_pty_shd.g_old_rec.pty_attribute11;

514: ben_pty_shd.g_old_rec.pty_attribute10;
515: End If;
516: If (p_rec.pty_attribute11 = hr_api.g_varchar2) then
517: p_rec.pty_attribute11 :=
518: ben_pty_shd.g_old_rec.pty_attribute11;
519: End If;
520: If (p_rec.pty_attribute12 = hr_api.g_varchar2) then
521: p_rec.pty_attribute12 :=
522: ben_pty_shd.g_old_rec.pty_attribute12;

Line 522: ben_pty_shd.g_old_rec.pty_attribute12;

518: ben_pty_shd.g_old_rec.pty_attribute11;
519: End If;
520: If (p_rec.pty_attribute12 = hr_api.g_varchar2) then
521: p_rec.pty_attribute12 :=
522: ben_pty_shd.g_old_rec.pty_attribute12;
523: End If;
524: If (p_rec.pty_attribute13 = hr_api.g_varchar2) then
525: p_rec.pty_attribute13 :=
526: ben_pty_shd.g_old_rec.pty_attribute13;

Line 526: ben_pty_shd.g_old_rec.pty_attribute13;

522: ben_pty_shd.g_old_rec.pty_attribute12;
523: End If;
524: If (p_rec.pty_attribute13 = hr_api.g_varchar2) then
525: p_rec.pty_attribute13 :=
526: ben_pty_shd.g_old_rec.pty_attribute13;
527: End If;
528: If (p_rec.pty_attribute14 = hr_api.g_varchar2) then
529: p_rec.pty_attribute14 :=
530: ben_pty_shd.g_old_rec.pty_attribute14;

Line 530: ben_pty_shd.g_old_rec.pty_attribute14;

526: ben_pty_shd.g_old_rec.pty_attribute13;
527: End If;
528: If (p_rec.pty_attribute14 = hr_api.g_varchar2) then
529: p_rec.pty_attribute14 :=
530: ben_pty_shd.g_old_rec.pty_attribute14;
531: End If;
532: If (p_rec.pty_attribute15 = hr_api.g_varchar2) then
533: p_rec.pty_attribute15 :=
534: ben_pty_shd.g_old_rec.pty_attribute15;

Line 534: ben_pty_shd.g_old_rec.pty_attribute15;

530: ben_pty_shd.g_old_rec.pty_attribute14;
531: End If;
532: If (p_rec.pty_attribute15 = hr_api.g_varchar2) then
533: p_rec.pty_attribute15 :=
534: ben_pty_shd.g_old_rec.pty_attribute15;
535: End If;
536: If (p_rec.pty_attribute16 = hr_api.g_varchar2) then
537: p_rec.pty_attribute16 :=
538: ben_pty_shd.g_old_rec.pty_attribute16;

Line 538: ben_pty_shd.g_old_rec.pty_attribute16;

534: ben_pty_shd.g_old_rec.pty_attribute15;
535: End If;
536: If (p_rec.pty_attribute16 = hr_api.g_varchar2) then
537: p_rec.pty_attribute16 :=
538: ben_pty_shd.g_old_rec.pty_attribute16;
539: End If;
540: If (p_rec.pty_attribute17 = hr_api.g_varchar2) then
541: p_rec.pty_attribute17 :=
542: ben_pty_shd.g_old_rec.pty_attribute17;

Line 542: ben_pty_shd.g_old_rec.pty_attribute17;

538: ben_pty_shd.g_old_rec.pty_attribute16;
539: End If;
540: If (p_rec.pty_attribute17 = hr_api.g_varchar2) then
541: p_rec.pty_attribute17 :=
542: ben_pty_shd.g_old_rec.pty_attribute17;
543: End If;
544: If (p_rec.pty_attribute18 = hr_api.g_varchar2) then
545: p_rec.pty_attribute18 :=
546: ben_pty_shd.g_old_rec.pty_attribute18;

Line 546: ben_pty_shd.g_old_rec.pty_attribute18;

542: ben_pty_shd.g_old_rec.pty_attribute17;
543: End If;
544: If (p_rec.pty_attribute18 = hr_api.g_varchar2) then
545: p_rec.pty_attribute18 :=
546: ben_pty_shd.g_old_rec.pty_attribute18;
547: End If;
548: If (p_rec.pty_attribute19 = hr_api.g_varchar2) then
549: p_rec.pty_attribute19 :=
550: ben_pty_shd.g_old_rec.pty_attribute19;

Line 550: ben_pty_shd.g_old_rec.pty_attribute19;

546: ben_pty_shd.g_old_rec.pty_attribute18;
547: End If;
548: If (p_rec.pty_attribute19 = hr_api.g_varchar2) then
549: p_rec.pty_attribute19 :=
550: ben_pty_shd.g_old_rec.pty_attribute19;
551: End If;
552: If (p_rec.pty_attribute20 = hr_api.g_varchar2) then
553: p_rec.pty_attribute20 :=
554: ben_pty_shd.g_old_rec.pty_attribute20;

Line 554: ben_pty_shd.g_old_rec.pty_attribute20;

550: ben_pty_shd.g_old_rec.pty_attribute19;
551: End If;
552: If (p_rec.pty_attribute20 = hr_api.g_varchar2) then
553: p_rec.pty_attribute20 :=
554: ben_pty_shd.g_old_rec.pty_attribute20;
555: End If;
556: If (p_rec.pty_attribute21 = hr_api.g_varchar2) then
557: p_rec.pty_attribute21 :=
558: ben_pty_shd.g_old_rec.pty_attribute21;

Line 558: ben_pty_shd.g_old_rec.pty_attribute21;

554: ben_pty_shd.g_old_rec.pty_attribute20;
555: End If;
556: If (p_rec.pty_attribute21 = hr_api.g_varchar2) then
557: p_rec.pty_attribute21 :=
558: ben_pty_shd.g_old_rec.pty_attribute21;
559: End If;
560: If (p_rec.pty_attribute22 = hr_api.g_varchar2) then
561: p_rec.pty_attribute22 :=
562: ben_pty_shd.g_old_rec.pty_attribute22;

Line 562: ben_pty_shd.g_old_rec.pty_attribute22;

558: ben_pty_shd.g_old_rec.pty_attribute21;
559: End If;
560: If (p_rec.pty_attribute22 = hr_api.g_varchar2) then
561: p_rec.pty_attribute22 :=
562: ben_pty_shd.g_old_rec.pty_attribute22;
563: End If;
564: If (p_rec.pty_attribute23 = hr_api.g_varchar2) then
565: p_rec.pty_attribute23 :=
566: ben_pty_shd.g_old_rec.pty_attribute23;

Line 566: ben_pty_shd.g_old_rec.pty_attribute23;

562: ben_pty_shd.g_old_rec.pty_attribute22;
563: End If;
564: If (p_rec.pty_attribute23 = hr_api.g_varchar2) then
565: p_rec.pty_attribute23 :=
566: ben_pty_shd.g_old_rec.pty_attribute23;
567: End If;
568: If (p_rec.pty_attribute24 = hr_api.g_varchar2) then
569: p_rec.pty_attribute24 :=
570: ben_pty_shd.g_old_rec.pty_attribute24;

Line 570: ben_pty_shd.g_old_rec.pty_attribute24;

566: ben_pty_shd.g_old_rec.pty_attribute23;
567: End If;
568: If (p_rec.pty_attribute24 = hr_api.g_varchar2) then
569: p_rec.pty_attribute24 :=
570: ben_pty_shd.g_old_rec.pty_attribute24;
571: End If;
572: If (p_rec.pty_attribute25 = hr_api.g_varchar2) then
573: p_rec.pty_attribute25 :=
574: ben_pty_shd.g_old_rec.pty_attribute25;

Line 574: ben_pty_shd.g_old_rec.pty_attribute25;

570: ben_pty_shd.g_old_rec.pty_attribute24;
571: End If;
572: If (p_rec.pty_attribute25 = hr_api.g_varchar2) then
573: p_rec.pty_attribute25 :=
574: ben_pty_shd.g_old_rec.pty_attribute25;
575: End If;
576: If (p_rec.pty_attribute26 = hr_api.g_varchar2) then
577: p_rec.pty_attribute26 :=
578: ben_pty_shd.g_old_rec.pty_attribute26;

Line 578: ben_pty_shd.g_old_rec.pty_attribute26;

574: ben_pty_shd.g_old_rec.pty_attribute25;
575: End If;
576: If (p_rec.pty_attribute26 = hr_api.g_varchar2) then
577: p_rec.pty_attribute26 :=
578: ben_pty_shd.g_old_rec.pty_attribute26;
579: End If;
580: If (p_rec.pty_attribute27 = hr_api.g_varchar2) then
581: p_rec.pty_attribute27 :=
582: ben_pty_shd.g_old_rec.pty_attribute27;

Line 582: ben_pty_shd.g_old_rec.pty_attribute27;

578: ben_pty_shd.g_old_rec.pty_attribute26;
579: End If;
580: If (p_rec.pty_attribute27 = hr_api.g_varchar2) then
581: p_rec.pty_attribute27 :=
582: ben_pty_shd.g_old_rec.pty_attribute27;
583: End If;
584: If (p_rec.pty_attribute28 = hr_api.g_varchar2) then
585: p_rec.pty_attribute28 :=
586: ben_pty_shd.g_old_rec.pty_attribute28;

Line 586: ben_pty_shd.g_old_rec.pty_attribute28;

582: ben_pty_shd.g_old_rec.pty_attribute27;
583: End If;
584: If (p_rec.pty_attribute28 = hr_api.g_varchar2) then
585: p_rec.pty_attribute28 :=
586: ben_pty_shd.g_old_rec.pty_attribute28;
587: End If;
588: If (p_rec.pty_attribute29 = hr_api.g_varchar2) then
589: p_rec.pty_attribute29 :=
590: ben_pty_shd.g_old_rec.pty_attribute29;

Line 590: ben_pty_shd.g_old_rec.pty_attribute29;

586: ben_pty_shd.g_old_rec.pty_attribute28;
587: End If;
588: If (p_rec.pty_attribute29 = hr_api.g_varchar2) then
589: p_rec.pty_attribute29 :=
590: ben_pty_shd.g_old_rec.pty_attribute29;
591: End If;
592: If (p_rec.pty_attribute30 = hr_api.g_varchar2) then
593: p_rec.pty_attribute30 :=
594: ben_pty_shd.g_old_rec.pty_attribute30;

Line 594: ben_pty_shd.g_old_rec.pty_attribute30;

590: ben_pty_shd.g_old_rec.pty_attribute29;
591: End If;
592: If (p_rec.pty_attribute30 = hr_api.g_varchar2) then
593: p_rec.pty_attribute30 :=
594: ben_pty_shd.g_old_rec.pty_attribute30;
595: End If;
596: --
597: End convert_defs;
598: --

Line 604: p_rec in out nocopy ben_pty_shd.g_rec_type

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

Line 614: ben_pty_shd.lck

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

Line 691: l_rec ben_pty_shd.g_rec_type;

687: ,p_pty_attribute29 in varchar2 default hr_api.g_varchar2
688: ,p_pty_attribute30 in varchar2 default hr_api.g_varchar2
689: ) is
690: --
691: l_rec ben_pty_shd.g_rec_type;
692: l_proc varchar2(72) := g_package||'upd';
693: --
694: Begin
695: hr_utility.set_location('Entering:'||l_proc, 5);

Line 701: ben_pty_shd.convert_args

697: -- Call conversion function to turn arguments into the
698: -- l_rec structure.
699: --
700: l_rec :=
701: ben_pty_shd.convert_args
702: (p_pl_pcp_typ_id
703: ,p_pl_pcp_id
704: ,p_business_group_id
705: ,p_pcp_typ_cd