APPS.BEN_PCP_BUS dependencies on HR_API

Line 57: and nvl(p_pl_pcp_id,hr_api.g_number)

53: (p_pl_pcp_id => p_pl_pcp_id,
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: --

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 193: if hr_api.not_exists_in_hr_lookups

189: and p_pcp_strt_dt_cd is not null then
190: --
191: -- check if value of lookup falls within lookup type.
192: --
193: if hr_api.not_exists_in_hr_lookups
194: (p_lookup_type => 'BEN_PCP_STRT_DT',
195: p_lookup_code => p_pcp_strt_dt_cd,
196: p_effective_date => p_effective_date) then
197: --

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 270: if hr_api.not_exists_in_hr_lookups

266: and p_pcp_dsgn_cd is not null then
267: --
268: -- check if value of lookup falls within lookup type.
269: --
270: if hr_api.not_exists_in_hr_lookups
271: (p_lookup_type => 'BEN_PCP_DSGN',
272: p_lookup_code => p_pcp_dsgn_cd,
273: p_effective_date => p_effective_date) then
274: --

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 346: if hr_api.not_exists_in_hr_lookups

342: and p_pcp_dpnt_dsgn_cd is not null then
343: --
344: -- check if value of lookup falls within lookup type.
345: --
346: if hr_api.not_exists_in_hr_lookups
347: (p_lookup_type => 'BEN_PCP_DSGN',
348: p_lookup_code => p_pcp_dpnt_dsgn_cd,
349: p_effective_date => p_effective_date) then
350: --

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 417: if hr_api.not_exists_in_hr_lookups

413: and p_pcp_rpstry_flag is not null then
414: --
415: -- check if value of lookup falls within lookup type.
416: --
417: if hr_api.not_exists_in_hr_lookups
418: (p_lookup_type => 'YES_NO',
419: p_lookup_code => p_pcp_rpstry_flag,
420: p_effective_date => p_effective_date) then
421: --

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 488: if hr_api.not_exists_in_hr_lookups

484: and p_pcp_can_keep_flag is not null then
485: --
486: -- check if value of lookup falls within lookup type.
487: --
488: if hr_api.not_exists_in_hr_lookups
489: (p_lookup_type => 'YES_NO',
490: p_lookup_code => p_pcp_can_keep_flag,
491: p_effective_date => p_effective_date) then
492: --

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 559: if hr_api.not_exists_in_hr_lookups

555: and p_pcp_radius_warn_flag is not null then
556: --
557: -- check if value of lookup falls within lookup type.
558: --
559: if hr_api.not_exists_in_hr_lookups
560: (p_lookup_type => 'YES_NO',
561: p_lookup_code => p_pcp_radius_warn_flag,
562: p_effective_date => p_effective_date) then
563: --

Line 825: hr_api.mandatory_arg_error

821: hr_utility.set_location('Entering:'|| l_proc, 10);
822: --
823: -- Ensure that all the mandatory parameter are not null
824: --
825: hr_api.mandatory_arg_error
826: (p_api_name => l_proc
827: ,p_argument => 'pl_pcp_id'
828: ,p_argument_value => p_pl_pcp_id
829: );

Line 848: hr_api.set_security_group_id

844: close csr_sec_grp;
845: --
846: -- Set the security_group_id in CLIENT_INFO
847: --
848: hr_api.set_security_group_id
849: (p_security_group_id => l_security_group_id
850: );
851: --
852: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 885: hr_api.mandatory_arg_error

881: hr_utility.set_location('Entering:'|| l_proc, 10);
882: --
883: -- Ensure that all the mandatory parameter are not null
884: --
885: hr_api.mandatory_arg_error
886: (p_api_name => l_proc
887: ,p_argument => 'pl_pcp_id'
888: ,p_argument_value => p_pl_pcp_id
889: );

Line 891: if ( nvl(ben_pcp_bus.g_pl_pcp_id, hr_api.g_number)

887: ,p_argument => 'pl_pcp_id'
888: ,p_argument_value => p_pl_pcp_id
889: );
890: --
891: if ( nvl(ben_pcp_bus.g_pl_pcp_id, hr_api.g_number)
892: = p_pl_pcp_id) then
893: --
894: -- The legislation code has already been found with a previous
895: -- call to this function. Just return the value in the global

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 968: nvl(p_rec.pcp_attribute_category, hr_api.g_varchar2) or

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) <>
972: nvl(p_rec.pcp_attribute2, hr_api.g_varchar2) or

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 970: nvl(p_rec.pcp_attribute1, hr_api.g_varchar2) or

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) <>
974: nvl(p_rec.pcp_attribute3, hr_api.g_varchar2) or

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 972: nvl(p_rec.pcp_attribute2, hr_api.g_varchar2) or

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) <>
976: nvl(p_rec.pcp_attribute4, hr_api.g_varchar2) or

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 974: nvl(p_rec.pcp_attribute3, hr_api.g_varchar2) or

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) <>
978: nvl(p_rec.pcp_attribute5, hr_api.g_varchar2) or

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 976: nvl(p_rec.pcp_attribute4, hr_api.g_varchar2) or

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) <>
980: nvl(p_rec.pcp_attribute6, hr_api.g_varchar2) or

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 978: nvl(p_rec.pcp_attribute5, hr_api.g_varchar2) or

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) <>
982: nvl(p_rec.pcp_attribute7, hr_api.g_varchar2) or

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 980: nvl(p_rec.pcp_attribute6, hr_api.g_varchar2) or

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) <>
984: nvl(p_rec.pcp_attribute8, hr_api.g_varchar2) or

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 982: nvl(p_rec.pcp_attribute7, hr_api.g_varchar2) or

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) <>
986: nvl(p_rec.pcp_attribute9, hr_api.g_varchar2) or

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 984: nvl(p_rec.pcp_attribute8, hr_api.g_varchar2) or

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) <>
988: nvl(p_rec.pcp_attribute10, hr_api.g_varchar2) or

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 986: nvl(p_rec.pcp_attribute9, hr_api.g_varchar2) or

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) <>
990: nvl(p_rec.pcp_attribute11, hr_api.g_varchar2) or

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 988: nvl(p_rec.pcp_attribute10, hr_api.g_varchar2) or

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) <>
992: nvl(p_rec.pcp_attribute12, hr_api.g_varchar2) or

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 990: nvl(p_rec.pcp_attribute11, hr_api.g_varchar2) or

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) <>
994: nvl(p_rec.pcp_attribute13, hr_api.g_varchar2) or

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 992: nvl(p_rec.pcp_attribute12, hr_api.g_varchar2) or

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) <>
996: nvl(p_rec.pcp_attribute14, hr_api.g_varchar2) or

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 994: nvl(p_rec.pcp_attribute13, hr_api.g_varchar2) or

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) <>
998: nvl(p_rec.pcp_attribute15, hr_api.g_varchar2) or

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 996: nvl(p_rec.pcp_attribute14, hr_api.g_varchar2) or

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) <>
1000: nvl(p_rec.pcp_attribute16, hr_api.g_varchar2) or

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 998: nvl(p_rec.pcp_attribute15, hr_api.g_varchar2) or

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) <>
1002: nvl(p_rec.pcp_attribute17, hr_api.g_varchar2) or

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 1000: nvl(p_rec.pcp_attribute16, hr_api.g_varchar2) or

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) <>
1004: nvl(p_rec.pcp_attribute18, hr_api.g_varchar2) or

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 1002: nvl(p_rec.pcp_attribute17, hr_api.g_varchar2) or

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) <>
1006: nvl(p_rec.pcp_attribute19, hr_api.g_varchar2) or

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 1004: nvl(p_rec.pcp_attribute18, hr_api.g_varchar2) or

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) <>
1008: nvl(p_rec.pcp_attribute20, hr_api.g_varchar2) or

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 1006: nvl(p_rec.pcp_attribute19, hr_api.g_varchar2) or

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) <>
1010: nvl(p_rec.pcp_attribute21, hr_api.g_varchar2) or

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 1008: nvl(p_rec.pcp_attribute20, hr_api.g_varchar2) or

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) <>
1012: nvl(p_rec.pcp_attribute22, hr_api.g_varchar2) or

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 1010: nvl(p_rec.pcp_attribute21, hr_api.g_varchar2) or

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) <>
1014: nvl(p_rec.pcp_attribute23, hr_api.g_varchar2) or

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 1012: nvl(p_rec.pcp_attribute22, hr_api.g_varchar2) or

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) <>
1016: nvl(p_rec.pcp_attribute24, hr_api.g_varchar2) or

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 1014: nvl(p_rec.pcp_attribute23, hr_api.g_varchar2) or

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) <>
1018: nvl(p_rec.pcp_attribute25, hr_api.g_varchar2) or

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 1016: nvl(p_rec.pcp_attribute24, hr_api.g_varchar2) or

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) <>
1020: nvl(p_rec.pcp_attribute26, hr_api.g_varchar2) or

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 1018: nvl(p_rec.pcp_attribute25, hr_api.g_varchar2) or

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) <>
1022: nvl(p_rec.pcp_attribute27, hr_api.g_varchar2) or

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 1020: nvl(p_rec.pcp_attribute26, hr_api.g_varchar2) or

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) <>
1024: nvl(p_rec.pcp_attribute28, hr_api.g_varchar2) or

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 1022: nvl(p_rec.pcp_attribute27, hr_api.g_varchar2) or

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) <>
1026: nvl(p_rec.pcp_attribute29, hr_api.g_varchar2) or

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 1024: nvl(p_rec.pcp_attribute28, hr_api.g_varchar2) or

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) <>
1028: nvl(p_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 1026: nvl(p_rec.pcp_attribute29, hr_api.g_varchar2) or

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
1030: --

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 1028: nvl(p_rec.pcp_attribute30, 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:
1032: -- a) During update, the structure column value or any

Line 1161: hr_api.argument_changed_error

1157: -- not been updated.
1158: --
1159: EXCEPTION
1160: WHEN l_error THEN
1161: hr_api.argument_changed_error
1162: (p_api_name => l_proc
1163: ,p_argument => l_argument);
1164: WHEN OTHERS THEN
1165: RAISE;

Line 1237: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

1233: ,p_pcp_rpstry_flag => p_rec.pcp_rpstry_flag);
1234:
1235:
1236:
1237: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1238: --
1239: -- Call all supporting business operations
1240: --
1241:

Line 1312: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

1308:
1309: chk_pl_pcp_rpstry ( p_pl_id => p_rec.pl_id
1310: ,p_pcp_rpstry_flag => p_rec.pcp_rpstry_flag);
1311:
1312: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1313: --
1314: chk_non_updateable_args
1315: (p_rec => p_rec
1316: );