APPS.BEN_PCP_BUS dependencies on BEN_PCP_SHD

Line 52: l_api_updating := ben_pcp_shd.api_updating

48: Begin
49: --
50: hr_utility.set_location('Entering:'||l_proc, 5);
51: --
52: l_api_updating := ben_pcp_shd.api_updating
53: (p_pl_pcp_id => p_pl_pcp_id,
54: p_object_version_number => p_object_version_number);
55: --
56: if (l_api_updating

Line 58: <> ben_pcp_shd.g_old_rec.pl_pcp_id) then

54: p_object_version_number => p_object_version_number);
55: --
56: if (l_api_updating
57: and nvl(p_pl_pcp_id,hr_api.g_number)
58: <> ben_pcp_shd.g_old_rec.pl_pcp_id) then
59: --
60: -- raise error as PK has changed
61: --
62: ben_pcp_shd.constraint_error('BEN_PL_PCP_PK');

Line 62: ben_pcp_shd.constraint_error('BEN_PL_PCP_PK');

58: <> ben_pcp_shd.g_old_rec.pl_pcp_id) then
59: --
60: -- raise error as PK has changed
61: --
62: ben_pcp_shd.constraint_error('BEN_PL_PCP_PK');
63: --
64: elsif not l_api_updating then
65: --
66: -- check if PK is null

Line 72: ben_pcp_shd.constraint_error('BEN_PL_PCP_PK');

68: if p_pl_pcp_id is not null then
69: --
70: -- raise error as PK is not null
71: --
72: ben_pcp_shd.constraint_error('BEN_PL_PCP_PK');
73: --
74: end if;
75: --
76: end if;

Line 177: l_api_updating := ben_pcp_shd.api_updating

173: Begin
174: --
175: hr_utility.set_location('Entering:'||l_proc, 5);
176: --
177: l_api_updating := ben_pcp_shd.api_updating
178: (p_pl_pcp_id => p_pl_pcp_id,
179: p_object_version_number => p_object_version_number);
180: --
181: if p_pcp_strt_dt_cd is null then

Line 187: and p_pcp_strt_dt_cd <> nvl(ben_pcp_shd.g_old_rec.pcp_strt_dt_cd,hr_api.g_varchar2)

183: fnd_message.set_token('FIELD', 'Start Date Code');
184: fnd_message.raise_error;
185: end if;
186: if (l_api_updating
187: and p_pcp_strt_dt_cd <> nvl(ben_pcp_shd.g_old_rec.pcp_strt_dt_cd,hr_api.g_varchar2)
188: or not l_api_updating)
189: and p_pcp_strt_dt_cd is not null then
190: --
191: -- check if value of lookup falls within lookup type.

Line 253: l_api_updating := ben_pcp_shd.api_updating

249: Begin
250: --
251: hr_utility.set_location('Entering:'||l_proc, 5);
252: --
253: l_api_updating := ben_pcp_shd.api_updating
254: (p_pl_pcp_id => p_pl_pcp_id,
255: p_object_version_number => p_object_version_number);
256: --
257: --Ask Sharmista what is the token name for this CD

Line 264: and p_pcp_dsgn_cd <> nvl(ben_pcp_shd.g_old_rec.pcp_dsgn_cd,hr_api.g_varchar2)

260: fnd_message.set_token('FIELD', 'Designation Code');
261: fnd_message.raise_error;
262: end if;
263: if (l_api_updating
264: and p_pcp_dsgn_cd <> nvl(ben_pcp_shd.g_old_rec.pcp_dsgn_cd,hr_api.g_varchar2)
265: or not l_api_updating)
266: and p_pcp_dsgn_cd is not null then
267: --
268: -- check if value of lookup falls within lookup type.

Line 329: l_api_updating := ben_pcp_shd.api_updating

325: Begin
326: --
327: hr_utility.set_location('Entering:'||l_proc, 5);
328: --
329: l_api_updating := ben_pcp_shd.api_updating
330: (p_pl_pcp_id => p_pl_pcp_id,
331: p_object_version_number => p_object_version_number);
332: --
333: --Ask Sharmista what is the token name for this CD

Line 340: and p_pcp_dpnt_dsgn_cd <> nvl(ben_pcp_shd.g_old_rec.pcp_dpnt_dsgn_cd,hr_api.g_varchar2)

336: fnd_message.set_token('FIELD', 'Dependent Designation Code');
337: fnd_message.raise_error;
338: end if;
339: if (l_api_updating
340: and p_pcp_dpnt_dsgn_cd <> nvl(ben_pcp_shd.g_old_rec.pcp_dpnt_dsgn_cd,hr_api.g_varchar2)
341: or not l_api_updating)
342: and p_pcp_dpnt_dsgn_cd is not null then
343: --
344: -- check if value of lookup falls within lookup type.

Line 405: l_api_updating := ben_pcp_shd.api_updating

401: Begin
402: --
403: hr_utility.set_location('Entering:'||l_proc, 5);
404: --
405: l_api_updating := ben_pcp_shd.api_updating
406: (p_pl_pcp_id => p_pl_pcp_id,
407: p_object_version_number => p_object_version_number);
408: --
409: if (l_api_updating

Line 411: <> nvl(ben_pcp_shd.g_old_rec.pcp_rpstry_flag,hr_api.g_varchar2)

407: p_object_version_number => p_object_version_number);
408: --
409: if (l_api_updating
410: and p_pcp_rpstry_flag
411: <> nvl(ben_pcp_shd.g_old_rec.pcp_rpstry_flag,hr_api.g_varchar2)
412: or not l_api_updating)
413: and p_pcp_rpstry_flag is not null then
414: --
415: -- check if value of lookup falls within lookup type.

Line 476: l_api_updating := ben_pcp_shd.api_updating

472: Begin
473: --
474: hr_utility.set_location('Entering:'||l_proc, 5);
475: --
476: l_api_updating := ben_pcp_shd.api_updating
477: (p_pl_pcp_id => p_pl_pcp_id,
478: p_object_version_number => p_object_version_number);
479: --
480: if (l_api_updating

Line 482: <> nvl(ben_pcp_shd.g_old_rec.pcp_can_keep_flag,hr_api.g_varchar2)

478: p_object_version_number => p_object_version_number);
479: --
480: if (l_api_updating
481: and p_pcp_can_keep_flag
482: <> nvl(ben_pcp_shd.g_old_rec.pcp_can_keep_flag,hr_api.g_varchar2)
483: or not l_api_updating)
484: and p_pcp_can_keep_flag is not null then
485: --
486: -- check if value of lookup falls within lookup type.

Line 547: l_api_updating := ben_pcp_shd.api_updating

543: Begin
544: --
545: hr_utility.set_location('Entering:'||l_proc, 5);
546: --
547: l_api_updating := ben_pcp_shd.api_updating
548: (p_pl_pcp_id => p_pl_pcp_id,
549: p_object_version_number => p_object_version_number);
550: --
551: if (l_api_updating

Line 553: <> nvl(ben_pcp_shd.g_old_rec.pcp_radius_warn_flag,hr_api.g_varchar2)

549: p_object_version_number => p_object_version_number);
550: --
551: if (l_api_updating
552: and p_pcp_radius_warn_flag
553: <> nvl(ben_pcp_shd.g_old_rec.pcp_radius_warn_flag,hr_api.g_varchar2)
554: or not l_api_updating)
555: and p_pcp_radius_warn_flag is not null then
556: --
557: -- check if value of lookup falls within lookup type.

Line 958: (p_rec in ben_pcp_shd.g_rec_type

954: -- Internal Row Handler Use Only.
955: --
956: -- ----------------------------------------------------------------------------
957: procedure chk_df
958: (p_rec in ben_pcp_shd.g_rec_type
959: ) is
960: --
961: l_proc varchar2(72) := g_package || 'chk_df';
962: --

Line 967: nvl(ben_pcp_shd.g_old_rec.pcp_attribute_category, hr_api.g_varchar2) <>

963: begin
964: hr_utility.set_location('Entering:'||l_proc,10);
965: --
966: if ((p_rec.pl_pcp_id is not null) and (
967: nvl(ben_pcp_shd.g_old_rec.pcp_attribute_category, hr_api.g_varchar2) <>
968: nvl(p_rec.pcp_attribute_category, hr_api.g_varchar2) or
969: nvl(ben_pcp_shd.g_old_rec.pcp_attribute1, hr_api.g_varchar2) <>
970: nvl(p_rec.pcp_attribute1, hr_api.g_varchar2) or
971: nvl(ben_pcp_shd.g_old_rec.pcp_attribute2, hr_api.g_varchar2) <>

Line 969: nvl(ben_pcp_shd.g_old_rec.pcp_attribute1, hr_api.g_varchar2) <>

965: --
966: if ((p_rec.pl_pcp_id is not null) and (
967: nvl(ben_pcp_shd.g_old_rec.pcp_attribute_category, hr_api.g_varchar2) <>
968: nvl(p_rec.pcp_attribute_category, hr_api.g_varchar2) or
969: nvl(ben_pcp_shd.g_old_rec.pcp_attribute1, hr_api.g_varchar2) <>
970: nvl(p_rec.pcp_attribute1, hr_api.g_varchar2) or
971: nvl(ben_pcp_shd.g_old_rec.pcp_attribute2, hr_api.g_varchar2) <>
972: nvl(p_rec.pcp_attribute2, hr_api.g_varchar2) or
973: nvl(ben_pcp_shd.g_old_rec.pcp_attribute3, hr_api.g_varchar2) <>

Line 971: nvl(ben_pcp_shd.g_old_rec.pcp_attribute2, hr_api.g_varchar2) <>

967: nvl(ben_pcp_shd.g_old_rec.pcp_attribute_category, hr_api.g_varchar2) <>
968: nvl(p_rec.pcp_attribute_category, hr_api.g_varchar2) or
969: nvl(ben_pcp_shd.g_old_rec.pcp_attribute1, hr_api.g_varchar2) <>
970: nvl(p_rec.pcp_attribute1, hr_api.g_varchar2) or
971: nvl(ben_pcp_shd.g_old_rec.pcp_attribute2, hr_api.g_varchar2) <>
972: nvl(p_rec.pcp_attribute2, hr_api.g_varchar2) or
973: nvl(ben_pcp_shd.g_old_rec.pcp_attribute3, hr_api.g_varchar2) <>
974: nvl(p_rec.pcp_attribute3, hr_api.g_varchar2) or
975: nvl(ben_pcp_shd.g_old_rec.pcp_attribute4, hr_api.g_varchar2) <>

Line 973: nvl(ben_pcp_shd.g_old_rec.pcp_attribute3, hr_api.g_varchar2) <>

969: nvl(ben_pcp_shd.g_old_rec.pcp_attribute1, hr_api.g_varchar2) <>
970: nvl(p_rec.pcp_attribute1, hr_api.g_varchar2) or
971: nvl(ben_pcp_shd.g_old_rec.pcp_attribute2, hr_api.g_varchar2) <>
972: nvl(p_rec.pcp_attribute2, hr_api.g_varchar2) or
973: nvl(ben_pcp_shd.g_old_rec.pcp_attribute3, hr_api.g_varchar2) <>
974: nvl(p_rec.pcp_attribute3, hr_api.g_varchar2) or
975: nvl(ben_pcp_shd.g_old_rec.pcp_attribute4, hr_api.g_varchar2) <>
976: nvl(p_rec.pcp_attribute4, hr_api.g_varchar2) or
977: nvl(ben_pcp_shd.g_old_rec.pcp_attribute5, hr_api.g_varchar2) <>

Line 975: nvl(ben_pcp_shd.g_old_rec.pcp_attribute4, hr_api.g_varchar2) <>

971: nvl(ben_pcp_shd.g_old_rec.pcp_attribute2, hr_api.g_varchar2) <>
972: nvl(p_rec.pcp_attribute2, hr_api.g_varchar2) or
973: nvl(ben_pcp_shd.g_old_rec.pcp_attribute3, hr_api.g_varchar2) <>
974: nvl(p_rec.pcp_attribute3, hr_api.g_varchar2) or
975: nvl(ben_pcp_shd.g_old_rec.pcp_attribute4, hr_api.g_varchar2) <>
976: nvl(p_rec.pcp_attribute4, hr_api.g_varchar2) or
977: nvl(ben_pcp_shd.g_old_rec.pcp_attribute5, hr_api.g_varchar2) <>
978: nvl(p_rec.pcp_attribute5, hr_api.g_varchar2) or
979: nvl(ben_pcp_shd.g_old_rec.pcp_attribute6, hr_api.g_varchar2) <>

Line 977: nvl(ben_pcp_shd.g_old_rec.pcp_attribute5, hr_api.g_varchar2) <>

973: nvl(ben_pcp_shd.g_old_rec.pcp_attribute3, hr_api.g_varchar2) <>
974: nvl(p_rec.pcp_attribute3, hr_api.g_varchar2) or
975: nvl(ben_pcp_shd.g_old_rec.pcp_attribute4, hr_api.g_varchar2) <>
976: nvl(p_rec.pcp_attribute4, hr_api.g_varchar2) or
977: nvl(ben_pcp_shd.g_old_rec.pcp_attribute5, hr_api.g_varchar2) <>
978: nvl(p_rec.pcp_attribute5, hr_api.g_varchar2) or
979: nvl(ben_pcp_shd.g_old_rec.pcp_attribute6, hr_api.g_varchar2) <>
980: nvl(p_rec.pcp_attribute6, hr_api.g_varchar2) or
981: nvl(ben_pcp_shd.g_old_rec.pcp_attribute7, hr_api.g_varchar2) <>

Line 979: nvl(ben_pcp_shd.g_old_rec.pcp_attribute6, hr_api.g_varchar2) <>

975: nvl(ben_pcp_shd.g_old_rec.pcp_attribute4, hr_api.g_varchar2) <>
976: nvl(p_rec.pcp_attribute4, hr_api.g_varchar2) or
977: nvl(ben_pcp_shd.g_old_rec.pcp_attribute5, hr_api.g_varchar2) <>
978: nvl(p_rec.pcp_attribute5, hr_api.g_varchar2) or
979: nvl(ben_pcp_shd.g_old_rec.pcp_attribute6, hr_api.g_varchar2) <>
980: nvl(p_rec.pcp_attribute6, hr_api.g_varchar2) or
981: nvl(ben_pcp_shd.g_old_rec.pcp_attribute7, hr_api.g_varchar2) <>
982: nvl(p_rec.pcp_attribute7, hr_api.g_varchar2) or
983: nvl(ben_pcp_shd.g_old_rec.pcp_attribute8, hr_api.g_varchar2) <>

Line 981: nvl(ben_pcp_shd.g_old_rec.pcp_attribute7, hr_api.g_varchar2) <>

977: nvl(ben_pcp_shd.g_old_rec.pcp_attribute5, hr_api.g_varchar2) <>
978: nvl(p_rec.pcp_attribute5, hr_api.g_varchar2) or
979: nvl(ben_pcp_shd.g_old_rec.pcp_attribute6, hr_api.g_varchar2) <>
980: nvl(p_rec.pcp_attribute6, hr_api.g_varchar2) or
981: nvl(ben_pcp_shd.g_old_rec.pcp_attribute7, hr_api.g_varchar2) <>
982: nvl(p_rec.pcp_attribute7, hr_api.g_varchar2) or
983: nvl(ben_pcp_shd.g_old_rec.pcp_attribute8, hr_api.g_varchar2) <>
984: nvl(p_rec.pcp_attribute8, hr_api.g_varchar2) or
985: nvl(ben_pcp_shd.g_old_rec.pcp_attribute9, hr_api.g_varchar2) <>

Line 983: nvl(ben_pcp_shd.g_old_rec.pcp_attribute8, hr_api.g_varchar2) <>

979: nvl(ben_pcp_shd.g_old_rec.pcp_attribute6, hr_api.g_varchar2) <>
980: nvl(p_rec.pcp_attribute6, hr_api.g_varchar2) or
981: nvl(ben_pcp_shd.g_old_rec.pcp_attribute7, hr_api.g_varchar2) <>
982: nvl(p_rec.pcp_attribute7, hr_api.g_varchar2) or
983: nvl(ben_pcp_shd.g_old_rec.pcp_attribute8, hr_api.g_varchar2) <>
984: nvl(p_rec.pcp_attribute8, hr_api.g_varchar2) or
985: nvl(ben_pcp_shd.g_old_rec.pcp_attribute9, hr_api.g_varchar2) <>
986: nvl(p_rec.pcp_attribute9, hr_api.g_varchar2) or
987: nvl(ben_pcp_shd.g_old_rec.pcp_attribute10, hr_api.g_varchar2) <>

Line 985: nvl(ben_pcp_shd.g_old_rec.pcp_attribute9, hr_api.g_varchar2) <>

981: nvl(ben_pcp_shd.g_old_rec.pcp_attribute7, hr_api.g_varchar2) <>
982: nvl(p_rec.pcp_attribute7, hr_api.g_varchar2) or
983: nvl(ben_pcp_shd.g_old_rec.pcp_attribute8, hr_api.g_varchar2) <>
984: nvl(p_rec.pcp_attribute8, hr_api.g_varchar2) or
985: nvl(ben_pcp_shd.g_old_rec.pcp_attribute9, hr_api.g_varchar2) <>
986: nvl(p_rec.pcp_attribute9, hr_api.g_varchar2) or
987: nvl(ben_pcp_shd.g_old_rec.pcp_attribute10, hr_api.g_varchar2) <>
988: nvl(p_rec.pcp_attribute10, hr_api.g_varchar2) or
989: nvl(ben_pcp_shd.g_old_rec.pcp_attribute11, hr_api.g_varchar2) <>

Line 987: nvl(ben_pcp_shd.g_old_rec.pcp_attribute10, hr_api.g_varchar2) <>

983: nvl(ben_pcp_shd.g_old_rec.pcp_attribute8, hr_api.g_varchar2) <>
984: nvl(p_rec.pcp_attribute8, hr_api.g_varchar2) or
985: nvl(ben_pcp_shd.g_old_rec.pcp_attribute9, hr_api.g_varchar2) <>
986: nvl(p_rec.pcp_attribute9, hr_api.g_varchar2) or
987: nvl(ben_pcp_shd.g_old_rec.pcp_attribute10, hr_api.g_varchar2) <>
988: nvl(p_rec.pcp_attribute10, hr_api.g_varchar2) or
989: nvl(ben_pcp_shd.g_old_rec.pcp_attribute11, hr_api.g_varchar2) <>
990: nvl(p_rec.pcp_attribute11, hr_api.g_varchar2) or
991: nvl(ben_pcp_shd.g_old_rec.pcp_attribute12, hr_api.g_varchar2) <>

Line 989: nvl(ben_pcp_shd.g_old_rec.pcp_attribute11, hr_api.g_varchar2) <>

985: nvl(ben_pcp_shd.g_old_rec.pcp_attribute9, hr_api.g_varchar2) <>
986: nvl(p_rec.pcp_attribute9, hr_api.g_varchar2) or
987: nvl(ben_pcp_shd.g_old_rec.pcp_attribute10, hr_api.g_varchar2) <>
988: nvl(p_rec.pcp_attribute10, hr_api.g_varchar2) or
989: nvl(ben_pcp_shd.g_old_rec.pcp_attribute11, hr_api.g_varchar2) <>
990: nvl(p_rec.pcp_attribute11, hr_api.g_varchar2) or
991: nvl(ben_pcp_shd.g_old_rec.pcp_attribute12, hr_api.g_varchar2) <>
992: nvl(p_rec.pcp_attribute12, hr_api.g_varchar2) or
993: nvl(ben_pcp_shd.g_old_rec.pcp_attribute13, hr_api.g_varchar2) <>

Line 991: nvl(ben_pcp_shd.g_old_rec.pcp_attribute12, hr_api.g_varchar2) <>

987: nvl(ben_pcp_shd.g_old_rec.pcp_attribute10, hr_api.g_varchar2) <>
988: nvl(p_rec.pcp_attribute10, hr_api.g_varchar2) or
989: nvl(ben_pcp_shd.g_old_rec.pcp_attribute11, hr_api.g_varchar2) <>
990: nvl(p_rec.pcp_attribute11, hr_api.g_varchar2) or
991: nvl(ben_pcp_shd.g_old_rec.pcp_attribute12, hr_api.g_varchar2) <>
992: nvl(p_rec.pcp_attribute12, hr_api.g_varchar2) or
993: nvl(ben_pcp_shd.g_old_rec.pcp_attribute13, hr_api.g_varchar2) <>
994: nvl(p_rec.pcp_attribute13, hr_api.g_varchar2) or
995: nvl(ben_pcp_shd.g_old_rec.pcp_attribute14, hr_api.g_varchar2) <>

Line 993: nvl(ben_pcp_shd.g_old_rec.pcp_attribute13, hr_api.g_varchar2) <>

989: nvl(ben_pcp_shd.g_old_rec.pcp_attribute11, hr_api.g_varchar2) <>
990: nvl(p_rec.pcp_attribute11, hr_api.g_varchar2) or
991: nvl(ben_pcp_shd.g_old_rec.pcp_attribute12, hr_api.g_varchar2) <>
992: nvl(p_rec.pcp_attribute12, hr_api.g_varchar2) or
993: nvl(ben_pcp_shd.g_old_rec.pcp_attribute13, hr_api.g_varchar2) <>
994: nvl(p_rec.pcp_attribute13, hr_api.g_varchar2) or
995: nvl(ben_pcp_shd.g_old_rec.pcp_attribute14, hr_api.g_varchar2) <>
996: nvl(p_rec.pcp_attribute14, hr_api.g_varchar2) or
997: nvl(ben_pcp_shd.g_old_rec.pcp_attribute15, hr_api.g_varchar2) <>

Line 995: nvl(ben_pcp_shd.g_old_rec.pcp_attribute14, hr_api.g_varchar2) <>

991: nvl(ben_pcp_shd.g_old_rec.pcp_attribute12, hr_api.g_varchar2) <>
992: nvl(p_rec.pcp_attribute12, hr_api.g_varchar2) or
993: nvl(ben_pcp_shd.g_old_rec.pcp_attribute13, hr_api.g_varchar2) <>
994: nvl(p_rec.pcp_attribute13, hr_api.g_varchar2) or
995: nvl(ben_pcp_shd.g_old_rec.pcp_attribute14, hr_api.g_varchar2) <>
996: nvl(p_rec.pcp_attribute14, hr_api.g_varchar2) or
997: nvl(ben_pcp_shd.g_old_rec.pcp_attribute15, hr_api.g_varchar2) <>
998: nvl(p_rec.pcp_attribute15, hr_api.g_varchar2) or
999: nvl(ben_pcp_shd.g_old_rec.pcp_attribute16, hr_api.g_varchar2) <>

Line 997: nvl(ben_pcp_shd.g_old_rec.pcp_attribute15, hr_api.g_varchar2) <>

993: nvl(ben_pcp_shd.g_old_rec.pcp_attribute13, hr_api.g_varchar2) <>
994: nvl(p_rec.pcp_attribute13, hr_api.g_varchar2) or
995: nvl(ben_pcp_shd.g_old_rec.pcp_attribute14, hr_api.g_varchar2) <>
996: nvl(p_rec.pcp_attribute14, hr_api.g_varchar2) or
997: nvl(ben_pcp_shd.g_old_rec.pcp_attribute15, hr_api.g_varchar2) <>
998: nvl(p_rec.pcp_attribute15, hr_api.g_varchar2) or
999: nvl(ben_pcp_shd.g_old_rec.pcp_attribute16, hr_api.g_varchar2) <>
1000: nvl(p_rec.pcp_attribute16, hr_api.g_varchar2) or
1001: nvl(ben_pcp_shd.g_old_rec.pcp_attribute17, hr_api.g_varchar2) <>

Line 999: nvl(ben_pcp_shd.g_old_rec.pcp_attribute16, hr_api.g_varchar2) <>

995: nvl(ben_pcp_shd.g_old_rec.pcp_attribute14, hr_api.g_varchar2) <>
996: nvl(p_rec.pcp_attribute14, hr_api.g_varchar2) or
997: nvl(ben_pcp_shd.g_old_rec.pcp_attribute15, hr_api.g_varchar2) <>
998: nvl(p_rec.pcp_attribute15, hr_api.g_varchar2) or
999: nvl(ben_pcp_shd.g_old_rec.pcp_attribute16, hr_api.g_varchar2) <>
1000: nvl(p_rec.pcp_attribute16, hr_api.g_varchar2) or
1001: nvl(ben_pcp_shd.g_old_rec.pcp_attribute17, hr_api.g_varchar2) <>
1002: nvl(p_rec.pcp_attribute17, hr_api.g_varchar2) or
1003: nvl(ben_pcp_shd.g_old_rec.pcp_attribute18, hr_api.g_varchar2) <>

Line 1001: nvl(ben_pcp_shd.g_old_rec.pcp_attribute17, hr_api.g_varchar2) <>

997: nvl(ben_pcp_shd.g_old_rec.pcp_attribute15, hr_api.g_varchar2) <>
998: nvl(p_rec.pcp_attribute15, hr_api.g_varchar2) or
999: nvl(ben_pcp_shd.g_old_rec.pcp_attribute16, hr_api.g_varchar2) <>
1000: nvl(p_rec.pcp_attribute16, hr_api.g_varchar2) or
1001: nvl(ben_pcp_shd.g_old_rec.pcp_attribute17, hr_api.g_varchar2) <>
1002: nvl(p_rec.pcp_attribute17, hr_api.g_varchar2) or
1003: nvl(ben_pcp_shd.g_old_rec.pcp_attribute18, hr_api.g_varchar2) <>
1004: nvl(p_rec.pcp_attribute18, hr_api.g_varchar2) or
1005: nvl(ben_pcp_shd.g_old_rec.pcp_attribute19, hr_api.g_varchar2) <>

Line 1003: nvl(ben_pcp_shd.g_old_rec.pcp_attribute18, hr_api.g_varchar2) <>

999: nvl(ben_pcp_shd.g_old_rec.pcp_attribute16, hr_api.g_varchar2) <>
1000: nvl(p_rec.pcp_attribute16, hr_api.g_varchar2) or
1001: nvl(ben_pcp_shd.g_old_rec.pcp_attribute17, hr_api.g_varchar2) <>
1002: nvl(p_rec.pcp_attribute17, hr_api.g_varchar2) or
1003: nvl(ben_pcp_shd.g_old_rec.pcp_attribute18, hr_api.g_varchar2) <>
1004: nvl(p_rec.pcp_attribute18, hr_api.g_varchar2) or
1005: nvl(ben_pcp_shd.g_old_rec.pcp_attribute19, hr_api.g_varchar2) <>
1006: nvl(p_rec.pcp_attribute19, hr_api.g_varchar2) or
1007: nvl(ben_pcp_shd.g_old_rec.pcp_attribute20, hr_api.g_varchar2) <>

Line 1005: nvl(ben_pcp_shd.g_old_rec.pcp_attribute19, hr_api.g_varchar2) <>

1001: nvl(ben_pcp_shd.g_old_rec.pcp_attribute17, hr_api.g_varchar2) <>
1002: nvl(p_rec.pcp_attribute17, hr_api.g_varchar2) or
1003: nvl(ben_pcp_shd.g_old_rec.pcp_attribute18, hr_api.g_varchar2) <>
1004: nvl(p_rec.pcp_attribute18, hr_api.g_varchar2) or
1005: nvl(ben_pcp_shd.g_old_rec.pcp_attribute19, hr_api.g_varchar2) <>
1006: nvl(p_rec.pcp_attribute19, hr_api.g_varchar2) or
1007: nvl(ben_pcp_shd.g_old_rec.pcp_attribute20, hr_api.g_varchar2) <>
1008: nvl(p_rec.pcp_attribute20, hr_api.g_varchar2) or
1009: nvl(ben_pcp_shd.g_old_rec.pcp_attribute21, hr_api.g_varchar2) <>

Line 1007: nvl(ben_pcp_shd.g_old_rec.pcp_attribute20, hr_api.g_varchar2) <>

1003: nvl(ben_pcp_shd.g_old_rec.pcp_attribute18, hr_api.g_varchar2) <>
1004: nvl(p_rec.pcp_attribute18, hr_api.g_varchar2) or
1005: nvl(ben_pcp_shd.g_old_rec.pcp_attribute19, hr_api.g_varchar2) <>
1006: nvl(p_rec.pcp_attribute19, hr_api.g_varchar2) or
1007: nvl(ben_pcp_shd.g_old_rec.pcp_attribute20, hr_api.g_varchar2) <>
1008: nvl(p_rec.pcp_attribute20, hr_api.g_varchar2) or
1009: nvl(ben_pcp_shd.g_old_rec.pcp_attribute21, hr_api.g_varchar2) <>
1010: nvl(p_rec.pcp_attribute21, hr_api.g_varchar2) or
1011: nvl(ben_pcp_shd.g_old_rec.pcp_attribute22, hr_api.g_varchar2) <>

Line 1009: nvl(ben_pcp_shd.g_old_rec.pcp_attribute21, hr_api.g_varchar2) <>

1005: nvl(ben_pcp_shd.g_old_rec.pcp_attribute19, hr_api.g_varchar2) <>
1006: nvl(p_rec.pcp_attribute19, hr_api.g_varchar2) or
1007: nvl(ben_pcp_shd.g_old_rec.pcp_attribute20, hr_api.g_varchar2) <>
1008: nvl(p_rec.pcp_attribute20, hr_api.g_varchar2) or
1009: nvl(ben_pcp_shd.g_old_rec.pcp_attribute21, hr_api.g_varchar2) <>
1010: nvl(p_rec.pcp_attribute21, hr_api.g_varchar2) or
1011: nvl(ben_pcp_shd.g_old_rec.pcp_attribute22, hr_api.g_varchar2) <>
1012: nvl(p_rec.pcp_attribute22, hr_api.g_varchar2) or
1013: nvl(ben_pcp_shd.g_old_rec.pcp_attribute23, hr_api.g_varchar2) <>

Line 1011: nvl(ben_pcp_shd.g_old_rec.pcp_attribute22, hr_api.g_varchar2) <>

1007: nvl(ben_pcp_shd.g_old_rec.pcp_attribute20, hr_api.g_varchar2) <>
1008: nvl(p_rec.pcp_attribute20, hr_api.g_varchar2) or
1009: nvl(ben_pcp_shd.g_old_rec.pcp_attribute21, hr_api.g_varchar2) <>
1010: nvl(p_rec.pcp_attribute21, hr_api.g_varchar2) or
1011: nvl(ben_pcp_shd.g_old_rec.pcp_attribute22, hr_api.g_varchar2) <>
1012: nvl(p_rec.pcp_attribute22, hr_api.g_varchar2) or
1013: nvl(ben_pcp_shd.g_old_rec.pcp_attribute23, hr_api.g_varchar2) <>
1014: nvl(p_rec.pcp_attribute23, hr_api.g_varchar2) or
1015: nvl(ben_pcp_shd.g_old_rec.pcp_attribute24, hr_api.g_varchar2) <>

Line 1013: nvl(ben_pcp_shd.g_old_rec.pcp_attribute23, hr_api.g_varchar2) <>

1009: nvl(ben_pcp_shd.g_old_rec.pcp_attribute21, hr_api.g_varchar2) <>
1010: nvl(p_rec.pcp_attribute21, hr_api.g_varchar2) or
1011: nvl(ben_pcp_shd.g_old_rec.pcp_attribute22, hr_api.g_varchar2) <>
1012: nvl(p_rec.pcp_attribute22, hr_api.g_varchar2) or
1013: nvl(ben_pcp_shd.g_old_rec.pcp_attribute23, hr_api.g_varchar2) <>
1014: nvl(p_rec.pcp_attribute23, hr_api.g_varchar2) or
1015: nvl(ben_pcp_shd.g_old_rec.pcp_attribute24, hr_api.g_varchar2) <>
1016: nvl(p_rec.pcp_attribute24, hr_api.g_varchar2) or
1017: nvl(ben_pcp_shd.g_old_rec.pcp_attribute25, hr_api.g_varchar2) <>

Line 1015: nvl(ben_pcp_shd.g_old_rec.pcp_attribute24, hr_api.g_varchar2) <>

1011: nvl(ben_pcp_shd.g_old_rec.pcp_attribute22, hr_api.g_varchar2) <>
1012: nvl(p_rec.pcp_attribute22, hr_api.g_varchar2) or
1013: nvl(ben_pcp_shd.g_old_rec.pcp_attribute23, hr_api.g_varchar2) <>
1014: nvl(p_rec.pcp_attribute23, hr_api.g_varchar2) or
1015: nvl(ben_pcp_shd.g_old_rec.pcp_attribute24, hr_api.g_varchar2) <>
1016: nvl(p_rec.pcp_attribute24, hr_api.g_varchar2) or
1017: nvl(ben_pcp_shd.g_old_rec.pcp_attribute25, hr_api.g_varchar2) <>
1018: nvl(p_rec.pcp_attribute25, hr_api.g_varchar2) or
1019: nvl(ben_pcp_shd.g_old_rec.pcp_attribute26, hr_api.g_varchar2) <>

Line 1017: nvl(ben_pcp_shd.g_old_rec.pcp_attribute25, hr_api.g_varchar2) <>

1013: nvl(ben_pcp_shd.g_old_rec.pcp_attribute23, hr_api.g_varchar2) <>
1014: nvl(p_rec.pcp_attribute23, hr_api.g_varchar2) or
1015: nvl(ben_pcp_shd.g_old_rec.pcp_attribute24, hr_api.g_varchar2) <>
1016: nvl(p_rec.pcp_attribute24, hr_api.g_varchar2) or
1017: nvl(ben_pcp_shd.g_old_rec.pcp_attribute25, hr_api.g_varchar2) <>
1018: nvl(p_rec.pcp_attribute25, hr_api.g_varchar2) or
1019: nvl(ben_pcp_shd.g_old_rec.pcp_attribute26, hr_api.g_varchar2) <>
1020: nvl(p_rec.pcp_attribute26, hr_api.g_varchar2) or
1021: nvl(ben_pcp_shd.g_old_rec.pcp_attribute27, hr_api.g_varchar2) <>

Line 1019: nvl(ben_pcp_shd.g_old_rec.pcp_attribute26, hr_api.g_varchar2) <>

1015: nvl(ben_pcp_shd.g_old_rec.pcp_attribute24, hr_api.g_varchar2) <>
1016: nvl(p_rec.pcp_attribute24, hr_api.g_varchar2) or
1017: nvl(ben_pcp_shd.g_old_rec.pcp_attribute25, hr_api.g_varchar2) <>
1018: nvl(p_rec.pcp_attribute25, hr_api.g_varchar2) or
1019: nvl(ben_pcp_shd.g_old_rec.pcp_attribute26, hr_api.g_varchar2) <>
1020: nvl(p_rec.pcp_attribute26, hr_api.g_varchar2) or
1021: nvl(ben_pcp_shd.g_old_rec.pcp_attribute27, hr_api.g_varchar2) <>
1022: nvl(p_rec.pcp_attribute27, hr_api.g_varchar2) or
1023: nvl(ben_pcp_shd.g_old_rec.pcp_attribute28, hr_api.g_varchar2) <>

Line 1021: nvl(ben_pcp_shd.g_old_rec.pcp_attribute27, hr_api.g_varchar2) <>

1017: nvl(ben_pcp_shd.g_old_rec.pcp_attribute25, hr_api.g_varchar2) <>
1018: nvl(p_rec.pcp_attribute25, hr_api.g_varchar2) or
1019: nvl(ben_pcp_shd.g_old_rec.pcp_attribute26, hr_api.g_varchar2) <>
1020: nvl(p_rec.pcp_attribute26, hr_api.g_varchar2) or
1021: nvl(ben_pcp_shd.g_old_rec.pcp_attribute27, hr_api.g_varchar2) <>
1022: nvl(p_rec.pcp_attribute27, hr_api.g_varchar2) or
1023: nvl(ben_pcp_shd.g_old_rec.pcp_attribute28, hr_api.g_varchar2) <>
1024: nvl(p_rec.pcp_attribute28, hr_api.g_varchar2) or
1025: nvl(ben_pcp_shd.g_old_rec.pcp_attribute29, hr_api.g_varchar2) <>

Line 1023: nvl(ben_pcp_shd.g_old_rec.pcp_attribute28, hr_api.g_varchar2) <>

1019: nvl(ben_pcp_shd.g_old_rec.pcp_attribute26, hr_api.g_varchar2) <>
1020: nvl(p_rec.pcp_attribute26, hr_api.g_varchar2) or
1021: nvl(ben_pcp_shd.g_old_rec.pcp_attribute27, hr_api.g_varchar2) <>
1022: nvl(p_rec.pcp_attribute27, hr_api.g_varchar2) or
1023: nvl(ben_pcp_shd.g_old_rec.pcp_attribute28, hr_api.g_varchar2) <>
1024: nvl(p_rec.pcp_attribute28, hr_api.g_varchar2) or
1025: nvl(ben_pcp_shd.g_old_rec.pcp_attribute29, hr_api.g_varchar2) <>
1026: nvl(p_rec.pcp_attribute29, hr_api.g_varchar2) or
1027: nvl(ben_pcp_shd.g_old_rec.pcp_attribute30, hr_api.g_varchar2) <>

Line 1025: nvl(ben_pcp_shd.g_old_rec.pcp_attribute29, hr_api.g_varchar2) <>

1021: nvl(ben_pcp_shd.g_old_rec.pcp_attribute27, hr_api.g_varchar2) <>
1022: nvl(p_rec.pcp_attribute27, hr_api.g_varchar2) or
1023: nvl(ben_pcp_shd.g_old_rec.pcp_attribute28, hr_api.g_varchar2) <>
1024: nvl(p_rec.pcp_attribute28, hr_api.g_varchar2) or
1025: nvl(ben_pcp_shd.g_old_rec.pcp_attribute29, hr_api.g_varchar2) <>
1026: nvl(p_rec.pcp_attribute29, hr_api.g_varchar2) or
1027: nvl(ben_pcp_shd.g_old_rec.pcp_attribute30, hr_api.g_varchar2) <>
1028: nvl(p_rec.pcp_attribute30, hr_api.g_varchar2) ))
1029: or (p_rec.pl_pcp_id is null) then

Line 1027: nvl(ben_pcp_shd.g_old_rec.pcp_attribute30, hr_api.g_varchar2) <>

1023: nvl(ben_pcp_shd.g_old_rec.pcp_attribute28, hr_api.g_varchar2) <>
1024: nvl(p_rec.pcp_attribute28, hr_api.g_varchar2) or
1025: nvl(ben_pcp_shd.g_old_rec.pcp_attribute29, hr_api.g_varchar2) <>
1026: nvl(p_rec.pcp_attribute29, hr_api.g_varchar2) or
1027: nvl(ben_pcp_shd.g_old_rec.pcp_attribute30, hr_api.g_varchar2) <>
1028: nvl(p_rec.pcp_attribute30, hr_api.g_varchar2) ))
1029: or (p_rec.pl_pcp_id is null) then
1030: --
1031: -- Only execute the validation if absolutely necessary:

Line 1134: (p_rec in ben_pcp_shd.g_rec_type

1130: --
1131: -- {End Of Comments}
1132: -- ----------------------------------------------------------------------------
1133: Procedure chk_non_updateable_args
1134: (p_rec in ben_pcp_shd.g_rec_type
1135: ) IS
1136: --
1137: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
1138: l_error EXCEPTION;

Line 1146: IF NOT ben_pcp_shd.api_updating

1142: --
1143: -- Only proceed with the validation if a row exists for the current
1144: -- record in the HR Schema.
1145: --
1146: IF NOT ben_pcp_shd.api_updating
1147: (p_pl_pcp_id => p_rec.pl_pcp_id
1148: ,p_object_version_number => p_rec.object_version_number
1149: ) THEN
1150: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 1172: (p_rec in ben_pcp_shd.g_rec_type ,

1168: -- ----------------------------------------------------------------------------
1169: -- |---------------------------< insert_validate >----------------------------|
1170: -- ----------------------------------------------------------------------------
1171: Procedure insert_validate
1172: (p_rec in ben_pcp_shd.g_rec_type ,
1173: p_effective_date in date) is
1174: --
1175: l_proc varchar2(72) := g_package||'insert_validate';
1176: --

Line 1251: (p_rec in ben_pcp_shd.g_rec_type

1247: -- ----------------------------------------------------------------------------
1248: -- |---------------------------< update_validate >----------------------------|
1249: -- ----------------------------------------------------------------------------
1250: Procedure update_validate
1251: (p_rec in ben_pcp_shd.g_rec_type
1252: ,p_effective_date in date) is
1253: --
1254: l_proc varchar2(72) := g_package||'update_validate';
1255: --

Line 1328: (p_rec in ben_pcp_shd.g_rec_type

1324: -- ----------------------------------------------------------------------------
1325: -- |---------------------------< delete_validate >----------------------------|
1326: -- ----------------------------------------------------------------------------
1327: Procedure delete_validate
1328: (p_rec in ben_pcp_shd.g_rec_type
1329: ) is
1330: --
1331: l_proc varchar2(72) := g_package||'delete_validate';
1332: --