DBA Data[Home] [Help]

APPS.PAY_PAP_BUS dependencies on HR_API

Line 135: hr_api.mandatory_arg_error(p_api_name => l_proc,

131: BEGIN
132:
133: hr_utility.set_location('Entering: '||l_proc, 10);
134:
135: hr_api.mandatory_arg_error(p_api_name => l_proc,
136: p_argument => 'p_accrual_plan_name',
137: p_argument_value => p_accrual_plan_name);
138:
139: --

Line 208: AND NVL(pay_pap_shd.g_old_rec.accrual_category, hr_api.g_varchar2)

204: (p_accrual_plan_id => p_accrual_plan_id
205: ,p_object_version_number => p_object_version_number);
206:
207: IF (l_api_updating
208: AND NVL(pay_pap_shd.g_old_rec.accrual_category, hr_api.g_varchar2)
209: = NVL(p_accrual_category, hr_api.g_varchar2)) THEN
210: RETURN;
211: END IF;
212:

Line 209: = NVL(p_accrual_category, hr_api.g_varchar2)) THEN

205: ,p_object_version_number => p_object_version_number);
206:
207: IF (l_api_updating
208: AND NVL(pay_pap_shd.g_old_rec.accrual_category, hr_api.g_varchar2)
209: = NVL(p_accrual_category, hr_api.g_varchar2)) THEN
210: RETURN;
211: END IF;
212:
213: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 213: hr_api.mandatory_arg_error(p_api_name => l_proc,

209: = NVL(p_accrual_category, hr_api.g_varchar2)) THEN
210: RETURN;
211: END IF;
212:
213: hr_api.mandatory_arg_error(p_api_name => l_proc,
214: p_argument => 'p_accrual_category',
215: p_argument_value => p_accrual_category);
216:
217: --

Line 220: IF hr_api.not_exists_in_leg_lookups

216:
217: --
218: -- Bug 1744331: use leg_lookups.
219: --
220: IF hr_api.not_exists_in_leg_lookups
221: (p_effective_date => p_effective_date
222: ,p_lookup_type => 'US_PTO_ACCRUAL'
223: ,p_lookup_code => p_accrual_category) THEN
224:

Line 273: AND NVL(pay_pap_shd.g_old_rec.accrual_start, hr_api.g_varchar2)

269: (p_accrual_plan_id => p_accrual_plan_id
270: ,p_object_version_number => p_object_version_number);
271:
272: IF (l_api_updating
273: AND NVL(pay_pap_shd.g_old_rec.accrual_start, hr_api.g_varchar2)
274: = NVL(p_accrual_start, hr_api.g_varchar2)) THEN
275: RETURN;
276: END IF;
277:

Line 274: = NVL(p_accrual_start, hr_api.g_varchar2)) THEN

270: ,p_object_version_number => p_object_version_number);
271:
272: IF (l_api_updating
273: AND NVL(pay_pap_shd.g_old_rec.accrual_start, hr_api.g_varchar2)
274: = NVL(p_accrual_start, hr_api.g_varchar2)) THEN
275: RETURN;
276: END IF;
277:
278: IF p_accrual_start IS NOT NULL THEN

Line 282: IF hr_api.not_exists_in_hr_lookups

278: IF p_accrual_start IS NOT NULL THEN
279:
280: hr_utility.set_location(l_proc, 20);
281:
282: IF hr_api.not_exists_in_hr_lookups
283: (p_effective_date => p_effective_date
284: ,p_lookup_type => 'US_ACCRUAL_START_TYPE'
285: ,p_lookup_code => p_accrual_start) THEN
286:

Line 326: hr_api.mandatory_arg_error(p_api_name => l_proc,

322: BEGIN
323:
324: hr_utility.set_location('Entering: '||l_proc, 10);
325:
326: hr_api.mandatory_arg_error(p_api_name => l_proc,
327: p_argument => 'p_accrual_units_of_measure',
328: p_argument_value => p_accrual_units_of_measure);
329:
330: IF hr_api.not_exists_in_hr_lookups

Line 330: IF hr_api.not_exists_in_hr_lookups

326: hr_api.mandatory_arg_error(p_api_name => l_proc,
327: p_argument => 'p_accrual_units_of_measure',
328: p_argument_value => p_accrual_units_of_measure);
329:
330: IF hr_api.not_exists_in_hr_lookups
331: (p_effective_date => p_effective_date
332: ,p_lookup_type => 'HOURS_OR_DAYS'
333: ,p_lookup_code => p_accrual_units_of_measure) THEN
334:

Line 386: AND NVL(pay_pap_shd.g_old_rec.accrual_formula_id, hr_api.g_number)

382: (p_accrual_plan_id => p_accrual_plan_id
383: ,p_object_version_number => p_object_version_number);
384:
385: IF (l_api_updating
386: AND NVL(pay_pap_shd.g_old_rec.accrual_formula_id, hr_api.g_number)
387: = NVL(p_accrual_formula_id, hr_api.g_number)) THEN
388: RETURN;
389: END IF;
390:

Line 387: = NVL(p_accrual_formula_id, hr_api.g_number)) THEN

383: ,p_object_version_number => p_object_version_number);
384:
385: IF (l_api_updating
386: AND NVL(pay_pap_shd.g_old_rec.accrual_formula_id, hr_api.g_number)
387: = NVL(p_accrual_formula_id, hr_api.g_number)) THEN
388: RETURN;
389: END IF;
390:
391: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 391: hr_api.mandatory_arg_error(p_api_name => l_proc,

387: = NVL(p_accrual_formula_id, hr_api.g_number)) THEN
388: RETURN;
389: END IF;
390:
391: hr_api.mandatory_arg_error(p_api_name => l_proc,
392: p_argument => 'p_accrual_formula_id',
393: p_argument_value => p_accrual_formula_id);
394:
395: hr_utility.set_location(l_proc, 20);

Line 460: AND NVL(pay_pap_shd.g_old_rec.accrual_formula_id, hr_api.g_number)

456: (p_accrual_plan_id => p_accrual_plan_id
457: ,p_object_version_number => p_object_version_number);
458:
459: IF (l_api_updating
460: AND NVL(pay_pap_shd.g_old_rec.accrual_formula_id, hr_api.g_number)
461: = NVL(p_accrual_formula_id, hr_api.g_number)
462: AND NVL(pay_pap_shd.g_old_rec.co_formula_id, hr_api.g_number)
463: = NVL(p_co_formula_id, hr_api.g_number)) THEN
464: RETURN;

Line 461: = NVL(p_accrual_formula_id, hr_api.g_number)

457: ,p_object_version_number => p_object_version_number);
458:
459: IF (l_api_updating
460: AND NVL(pay_pap_shd.g_old_rec.accrual_formula_id, hr_api.g_number)
461: = NVL(p_accrual_formula_id, hr_api.g_number)
462: AND NVL(pay_pap_shd.g_old_rec.co_formula_id, hr_api.g_number)
463: = NVL(p_co_formula_id, hr_api.g_number)) THEN
464: RETURN;
465: END IF;

Line 462: AND NVL(pay_pap_shd.g_old_rec.co_formula_id, hr_api.g_number)

458:
459: IF (l_api_updating
460: AND NVL(pay_pap_shd.g_old_rec.accrual_formula_id, hr_api.g_number)
461: = NVL(p_accrual_formula_id, hr_api.g_number)
462: AND NVL(pay_pap_shd.g_old_rec.co_formula_id, hr_api.g_number)
463: = NVL(p_co_formula_id, hr_api.g_number)) THEN
464: RETURN;
465: END IF;
466:

Line 463: = NVL(p_co_formula_id, hr_api.g_number)) THEN

459: IF (l_api_updating
460: AND NVL(pay_pap_shd.g_old_rec.accrual_formula_id, hr_api.g_number)
461: = NVL(p_accrual_formula_id, hr_api.g_number)
462: AND NVL(pay_pap_shd.g_old_rec.co_formula_id, hr_api.g_number)
463: = NVL(p_co_formula_id, hr_api.g_number)) THEN
464: RETURN;
465: END IF;
466:
467: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 467: hr_api.mandatory_arg_error(p_api_name => l_proc,

463: = NVL(p_co_formula_id, hr_api.g_number)) THEN
464: RETURN;
465: END IF;
466:
467: hr_api.mandatory_arg_error(p_api_name => l_proc,
468: p_argument => 'p_co_formula_id',
469: p_argument_value => p_co_formula_id);
470:
471: hr_utility.set_location(l_proc, 20);

Line 649: AND NVL(pay_pap_shd.g_old_rec.pto_input_value_id, hr_api.g_number)

645: (p_accrual_plan_id => p_accrual_plan_id
646: ,p_object_version_number => p_object_version_number);
647:
648: IF (l_api_updating
649: AND NVL(pay_pap_shd.g_old_rec.pto_input_value_id, hr_api.g_number)
650: = NVL(p_pto_input_value_id, hr_api.g_number)
651: AND NVL(pay_pap_shd.g_old_rec.accrual_units_of_measure, hr_api.g_varchar2)
652: = NVL(p_accrual_units_of_measure, hr_api.g_varchar2)) THEN
653: RETURN;

Line 650: = NVL(p_pto_input_value_id, hr_api.g_number)

646: ,p_object_version_number => p_object_version_number);
647:
648: IF (l_api_updating
649: AND NVL(pay_pap_shd.g_old_rec.pto_input_value_id, hr_api.g_number)
650: = NVL(p_pto_input_value_id, hr_api.g_number)
651: AND NVL(pay_pap_shd.g_old_rec.accrual_units_of_measure, hr_api.g_varchar2)
652: = NVL(p_accrual_units_of_measure, hr_api.g_varchar2)) THEN
653: RETURN;
654: END IF;

Line 651: AND NVL(pay_pap_shd.g_old_rec.accrual_units_of_measure, hr_api.g_varchar2)

647:
648: IF (l_api_updating
649: AND NVL(pay_pap_shd.g_old_rec.pto_input_value_id, hr_api.g_number)
650: = NVL(p_pto_input_value_id, hr_api.g_number)
651: AND NVL(pay_pap_shd.g_old_rec.accrual_units_of_measure, hr_api.g_varchar2)
652: = NVL(p_accrual_units_of_measure, hr_api.g_varchar2)) THEN
653: RETURN;
654: END IF;
655:

Line 652: = NVL(p_accrual_units_of_measure, hr_api.g_varchar2)) THEN

648: IF (l_api_updating
649: AND NVL(pay_pap_shd.g_old_rec.pto_input_value_id, hr_api.g_number)
650: = NVL(p_pto_input_value_id, hr_api.g_number)
651: AND NVL(pay_pap_shd.g_old_rec.accrual_units_of_measure, hr_api.g_varchar2)
652: = NVL(p_accrual_units_of_measure, hr_api.g_varchar2)) THEN
653: RETURN;
654: END IF;
655:
656: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 656: hr_api.mandatory_arg_error(p_api_name => l_proc,

652: = NVL(p_accrual_units_of_measure, hr_api.g_varchar2)) THEN
653: RETURN;
654: END IF;
655:
656: hr_api.mandatory_arg_error(p_api_name => l_proc,
657: p_argument => 'p_pto_input_value_id',
658: p_argument_value => p_pto_input_value_id);
659:
660: hr_utility.set_location(l_proc, 20);

Line 785: AND NVL(pay_pap_shd.g_old_rec.accrual_formula_id, hr_api.g_number)

781: (p_accrual_plan_id => p_accrual_plan_id
782: ,p_object_version_number => p_object_version_number);
783:
784: IF (l_api_updating
785: AND NVL(pay_pap_shd.g_old_rec.accrual_formula_id, hr_api.g_number)
786: = NVL(p_accrual_formula_id, hr_api.g_number)
787: AND NVL(pay_pap_shd.g_old_rec.defined_balance_id, hr_api.g_number)
788: = NVL(p_defined_balance_id, hr_api.g_number)) THEN
789: RETURN;

Line 786: = NVL(p_accrual_formula_id, hr_api.g_number)

782: ,p_object_version_number => p_object_version_number);
783:
784: IF (l_api_updating
785: AND NVL(pay_pap_shd.g_old_rec.accrual_formula_id, hr_api.g_number)
786: = NVL(p_accrual_formula_id, hr_api.g_number)
787: AND NVL(pay_pap_shd.g_old_rec.defined_balance_id, hr_api.g_number)
788: = NVL(p_defined_balance_id, hr_api.g_number)) THEN
789: RETURN;
790: END IF;

Line 787: AND NVL(pay_pap_shd.g_old_rec.defined_balance_id, hr_api.g_number)

783:
784: IF (l_api_updating
785: AND NVL(pay_pap_shd.g_old_rec.accrual_formula_id, hr_api.g_number)
786: = NVL(p_accrual_formula_id, hr_api.g_number)
787: AND NVL(pay_pap_shd.g_old_rec.defined_balance_id, hr_api.g_number)
788: = NVL(p_defined_balance_id, hr_api.g_number)) THEN
789: RETURN;
790: END IF;
791:

Line 788: = NVL(p_defined_balance_id, hr_api.g_number)) THEN

784: IF (l_api_updating
785: AND NVL(pay_pap_shd.g_old_rec.accrual_formula_id, hr_api.g_number)
786: = NVL(p_accrual_formula_id, hr_api.g_number)
787: AND NVL(pay_pap_shd.g_old_rec.defined_balance_id, hr_api.g_number)
788: = NVL(p_defined_balance_id, hr_api.g_number)) THEN
789: RETURN;
790: END IF;
791:
792: hr_utility.set_location(l_proc, 20);

Line 799: AND NVL(pay_pap_shd.g_old_rec.defined_balance_id, hr_api.g_number)

795:
796: hr_utility.set_location(l_proc, 30);
797:
798: IF l_api_updating
799: AND NVL(pay_pap_shd.g_old_rec.defined_balance_id, hr_api.g_number)
800: <> hr_api.g_number THEN
801:
802: --
803: -- The balance dimension has previously been set and is trying

Line 800: <> hr_api.g_number THEN

796: hr_utility.set_location(l_proc, 30);
797:
798: IF l_api_updating
799: AND NVL(pay_pap_shd.g_old_rec.defined_balance_id, hr_api.g_number)
800: <> hr_api.g_number THEN
801:
802: --
803: -- The balance dimension has previously been set and is trying
804: -- to be updated. This is not allowed so error.

Line 920: OR (NVL(l_balance_type, hr_api.g_varchar2) <> 'DE' AND

916: IF (l_balance_type = 'DE' AND
917: l_dimension_name NOT IN ('_ASG_PTO_DE_YTD'
918: ,'_ASG_PTO_DE_SM_YTD'
919: ,'_ASG_PTO_DE_HD_YTD'))
920: OR (NVL(l_balance_type, hr_api.g_varchar2) <> 'DE' AND
921: l_dimension_name IN ('_ASG_PTO_DE_YTD'
922: ,'_ASG_PTO_DE_SM_YTD'
923: ,'_ASG_PTO_DE_HD_YTD')) THEN
924:

Line 991: AND NVL(pay_pap_shd.g_old_rec.ineligible_period_type, hr_api.g_varchar2)

987: (p_accrual_plan_id => p_accrual_plan_id
988: ,p_object_version_number => p_object_version_number);
989:
990: IF (l_api_updating
991: AND NVL(pay_pap_shd.g_old_rec.ineligible_period_type, hr_api.g_varchar2)
992: = NVL(p_ineligible_period_type, hr_api.g_varchar2)) THEN
993: RETURN;
994: END IF;
995:

Line 992: = NVL(p_ineligible_period_type, hr_api.g_varchar2)) THEN

988: ,p_object_version_number => p_object_version_number);
989:
990: IF (l_api_updating
991: AND NVL(pay_pap_shd.g_old_rec.ineligible_period_type, hr_api.g_varchar2)
992: = NVL(p_ineligible_period_type, hr_api.g_varchar2)) THEN
993: RETURN;
994: END IF;
995:
996: IF p_ineligible_period_type IS NOT NULL THEN

Line 1000: IF hr_api.not_exists_in_hr_lookups

996: IF p_ineligible_period_type IS NOT NULL THEN
997:
998: hr_utility.set_location(l_proc, 20);
999:
1000: IF hr_api.not_exists_in_hr_lookups
1001: (p_effective_date => p_effective_date
1002: ,p_lookup_type => 'PROC_PERIOD_TYPE'
1003: ,p_lookup_code => p_ineligible_period_type) THEN
1004:

Line 1059: AND NVL(pay_pap_shd.g_old_rec.ineligibility_formula_id, hr_api.g_number)

1055: (p_accrual_plan_id => p_accrual_plan_id
1056: ,p_object_version_number => p_object_version_number);
1057:
1058: IF (l_api_updating
1059: AND NVL(pay_pap_shd.g_old_rec.ineligibility_formula_id, hr_api.g_number)
1060: = NVL(p_ineligibility_formula_id, hr_api.g_number)) THEN
1061: RETURN;
1062: END IF;
1063:

Line 1060: = NVL(p_ineligibility_formula_id, hr_api.g_number)) THEN

1056: ,p_object_version_number => p_object_version_number);
1057:
1058: IF (l_api_updating
1059: AND NVL(pay_pap_shd.g_old_rec.ineligibility_formula_id, hr_api.g_number)
1060: = NVL(p_ineligibility_formula_id, hr_api.g_number)) THEN
1061: RETURN;
1062: END IF;
1063:
1064: hr_utility.set_location(l_proc, 20);

Line 1132: nvl(pay_pap_shd.g_old_rec.information_category, hr_api.g_varchar2) <>

1128: begin
1129: hr_utility.set_location('Entering:'||l_proc,10);
1130: --
1131: if ((p_rec.accrual_plan_id is not null) and (
1132: nvl(pay_pap_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
1133: nvl(p_rec.information_category, hr_api.g_varchar2) or
1134: nvl(pay_pap_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1135: nvl(p_rec.information1, hr_api.g_varchar2) or
1136: nvl(pay_pap_shd.g_old_rec.information2, hr_api.g_varchar2) <>

Line 1133: nvl(p_rec.information_category, hr_api.g_varchar2) or

1129: hr_utility.set_location('Entering:'||l_proc,10);
1130: --
1131: if ((p_rec.accrual_plan_id is not null) and (
1132: nvl(pay_pap_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
1133: nvl(p_rec.information_category, hr_api.g_varchar2) or
1134: nvl(pay_pap_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1135: nvl(p_rec.information1, hr_api.g_varchar2) or
1136: nvl(pay_pap_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1137: nvl(p_rec.information2, hr_api.g_varchar2) or

Line 1134: nvl(pay_pap_shd.g_old_rec.information1, hr_api.g_varchar2) <>

1130: --
1131: if ((p_rec.accrual_plan_id is not null) and (
1132: nvl(pay_pap_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
1133: nvl(p_rec.information_category, hr_api.g_varchar2) or
1134: nvl(pay_pap_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1135: nvl(p_rec.information1, hr_api.g_varchar2) or
1136: nvl(pay_pap_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1137: nvl(p_rec.information2, hr_api.g_varchar2) or
1138: nvl(pay_pap_shd.g_old_rec.information3, hr_api.g_varchar2) <>

Line 1135: nvl(p_rec.information1, hr_api.g_varchar2) or

1131: if ((p_rec.accrual_plan_id is not null) and (
1132: nvl(pay_pap_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
1133: nvl(p_rec.information_category, hr_api.g_varchar2) or
1134: nvl(pay_pap_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1135: nvl(p_rec.information1, hr_api.g_varchar2) or
1136: nvl(pay_pap_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1137: nvl(p_rec.information2, hr_api.g_varchar2) or
1138: nvl(pay_pap_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1139: nvl(p_rec.information3, hr_api.g_varchar2) or

Line 1136: nvl(pay_pap_shd.g_old_rec.information2, hr_api.g_varchar2) <>

1132: nvl(pay_pap_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
1133: nvl(p_rec.information_category, hr_api.g_varchar2) or
1134: nvl(pay_pap_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1135: nvl(p_rec.information1, hr_api.g_varchar2) or
1136: nvl(pay_pap_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1137: nvl(p_rec.information2, hr_api.g_varchar2) or
1138: nvl(pay_pap_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1139: nvl(p_rec.information3, hr_api.g_varchar2) or
1140: nvl(pay_pap_shd.g_old_rec.information4, hr_api.g_varchar2) <>

Line 1137: nvl(p_rec.information2, hr_api.g_varchar2) or

1133: nvl(p_rec.information_category, hr_api.g_varchar2) or
1134: nvl(pay_pap_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1135: nvl(p_rec.information1, hr_api.g_varchar2) or
1136: nvl(pay_pap_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1137: nvl(p_rec.information2, hr_api.g_varchar2) or
1138: nvl(pay_pap_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1139: nvl(p_rec.information3, hr_api.g_varchar2) or
1140: nvl(pay_pap_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1141: nvl(p_rec.information4, hr_api.g_varchar2) or

Line 1138: nvl(pay_pap_shd.g_old_rec.information3, hr_api.g_varchar2) <>

1134: nvl(pay_pap_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1135: nvl(p_rec.information1, hr_api.g_varchar2) or
1136: nvl(pay_pap_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1137: nvl(p_rec.information2, hr_api.g_varchar2) or
1138: nvl(pay_pap_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1139: nvl(p_rec.information3, hr_api.g_varchar2) or
1140: nvl(pay_pap_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1141: nvl(p_rec.information4, hr_api.g_varchar2) or
1142: nvl(pay_pap_shd.g_old_rec.information5, hr_api.g_varchar2) <>

Line 1139: nvl(p_rec.information3, hr_api.g_varchar2) or

1135: nvl(p_rec.information1, hr_api.g_varchar2) or
1136: nvl(pay_pap_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1137: nvl(p_rec.information2, hr_api.g_varchar2) or
1138: nvl(pay_pap_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1139: nvl(p_rec.information3, hr_api.g_varchar2) or
1140: nvl(pay_pap_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1141: nvl(p_rec.information4, hr_api.g_varchar2) or
1142: nvl(pay_pap_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1143: nvl(p_rec.information5, hr_api.g_varchar2) or

Line 1140: nvl(pay_pap_shd.g_old_rec.information4, hr_api.g_varchar2) <>

1136: nvl(pay_pap_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1137: nvl(p_rec.information2, hr_api.g_varchar2) or
1138: nvl(pay_pap_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1139: nvl(p_rec.information3, hr_api.g_varchar2) or
1140: nvl(pay_pap_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1141: nvl(p_rec.information4, hr_api.g_varchar2) or
1142: nvl(pay_pap_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1143: nvl(p_rec.information5, hr_api.g_varchar2) or
1144: nvl(pay_pap_shd.g_old_rec.information6, hr_api.g_varchar2) <>

Line 1141: nvl(p_rec.information4, hr_api.g_varchar2) or

1137: nvl(p_rec.information2, hr_api.g_varchar2) or
1138: nvl(pay_pap_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1139: nvl(p_rec.information3, hr_api.g_varchar2) or
1140: nvl(pay_pap_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1141: nvl(p_rec.information4, hr_api.g_varchar2) or
1142: nvl(pay_pap_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1143: nvl(p_rec.information5, hr_api.g_varchar2) or
1144: nvl(pay_pap_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1145: nvl(p_rec.information6, hr_api.g_varchar2) or

Line 1142: nvl(pay_pap_shd.g_old_rec.information5, hr_api.g_varchar2) <>

1138: nvl(pay_pap_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1139: nvl(p_rec.information3, hr_api.g_varchar2) or
1140: nvl(pay_pap_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1141: nvl(p_rec.information4, hr_api.g_varchar2) or
1142: nvl(pay_pap_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1143: nvl(p_rec.information5, hr_api.g_varchar2) or
1144: nvl(pay_pap_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1145: nvl(p_rec.information6, hr_api.g_varchar2) or
1146: nvl(pay_pap_shd.g_old_rec.information7, hr_api.g_varchar2) <>

Line 1143: nvl(p_rec.information5, hr_api.g_varchar2) or

1139: nvl(p_rec.information3, hr_api.g_varchar2) or
1140: nvl(pay_pap_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1141: nvl(p_rec.information4, hr_api.g_varchar2) or
1142: nvl(pay_pap_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1143: nvl(p_rec.information5, hr_api.g_varchar2) or
1144: nvl(pay_pap_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1145: nvl(p_rec.information6, hr_api.g_varchar2) or
1146: nvl(pay_pap_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1147: nvl(p_rec.information7, hr_api.g_varchar2) or

Line 1144: nvl(pay_pap_shd.g_old_rec.information6, hr_api.g_varchar2) <>

1140: nvl(pay_pap_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1141: nvl(p_rec.information4, hr_api.g_varchar2) or
1142: nvl(pay_pap_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1143: nvl(p_rec.information5, hr_api.g_varchar2) or
1144: nvl(pay_pap_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1145: nvl(p_rec.information6, hr_api.g_varchar2) or
1146: nvl(pay_pap_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1147: nvl(p_rec.information7, hr_api.g_varchar2) or
1148: nvl(pay_pap_shd.g_old_rec.information8, hr_api.g_varchar2) <>

Line 1145: nvl(p_rec.information6, hr_api.g_varchar2) or

1141: nvl(p_rec.information4, hr_api.g_varchar2) or
1142: nvl(pay_pap_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1143: nvl(p_rec.information5, hr_api.g_varchar2) or
1144: nvl(pay_pap_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1145: nvl(p_rec.information6, hr_api.g_varchar2) or
1146: nvl(pay_pap_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1147: nvl(p_rec.information7, hr_api.g_varchar2) or
1148: nvl(pay_pap_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1149: nvl(p_rec.information8, hr_api.g_varchar2) or

Line 1146: nvl(pay_pap_shd.g_old_rec.information7, hr_api.g_varchar2) <>

1142: nvl(pay_pap_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1143: nvl(p_rec.information5, hr_api.g_varchar2) or
1144: nvl(pay_pap_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1145: nvl(p_rec.information6, hr_api.g_varchar2) or
1146: nvl(pay_pap_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1147: nvl(p_rec.information7, hr_api.g_varchar2) or
1148: nvl(pay_pap_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1149: nvl(p_rec.information8, hr_api.g_varchar2) or
1150: nvl(pay_pap_shd.g_old_rec.information9, hr_api.g_varchar2) <>

Line 1147: nvl(p_rec.information7, hr_api.g_varchar2) or

1143: nvl(p_rec.information5, hr_api.g_varchar2) or
1144: nvl(pay_pap_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1145: nvl(p_rec.information6, hr_api.g_varchar2) or
1146: nvl(pay_pap_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1147: nvl(p_rec.information7, hr_api.g_varchar2) or
1148: nvl(pay_pap_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1149: nvl(p_rec.information8, hr_api.g_varchar2) or
1150: nvl(pay_pap_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1151: nvl(p_rec.information9, hr_api.g_varchar2) or

Line 1148: nvl(pay_pap_shd.g_old_rec.information8, hr_api.g_varchar2) <>

1144: nvl(pay_pap_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1145: nvl(p_rec.information6, hr_api.g_varchar2) or
1146: nvl(pay_pap_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1147: nvl(p_rec.information7, hr_api.g_varchar2) or
1148: nvl(pay_pap_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1149: nvl(p_rec.information8, hr_api.g_varchar2) or
1150: nvl(pay_pap_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1151: nvl(p_rec.information9, hr_api.g_varchar2) or
1152: nvl(pay_pap_shd.g_old_rec.information10, hr_api.g_varchar2) <>

Line 1149: nvl(p_rec.information8, hr_api.g_varchar2) or

1145: nvl(p_rec.information6, hr_api.g_varchar2) or
1146: nvl(pay_pap_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1147: nvl(p_rec.information7, hr_api.g_varchar2) or
1148: nvl(pay_pap_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1149: nvl(p_rec.information8, hr_api.g_varchar2) or
1150: nvl(pay_pap_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1151: nvl(p_rec.information9, hr_api.g_varchar2) or
1152: nvl(pay_pap_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1153: nvl(p_rec.information10, hr_api.g_varchar2) or

Line 1150: nvl(pay_pap_shd.g_old_rec.information9, hr_api.g_varchar2) <>

1146: nvl(pay_pap_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1147: nvl(p_rec.information7, hr_api.g_varchar2) or
1148: nvl(pay_pap_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1149: nvl(p_rec.information8, hr_api.g_varchar2) or
1150: nvl(pay_pap_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1151: nvl(p_rec.information9, hr_api.g_varchar2) or
1152: nvl(pay_pap_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1153: nvl(p_rec.information10, hr_api.g_varchar2) or
1154: nvl(pay_pap_shd.g_old_rec.information11, hr_api.g_varchar2) <>

Line 1151: nvl(p_rec.information9, hr_api.g_varchar2) or

1147: nvl(p_rec.information7, hr_api.g_varchar2) or
1148: nvl(pay_pap_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1149: nvl(p_rec.information8, hr_api.g_varchar2) or
1150: nvl(pay_pap_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1151: nvl(p_rec.information9, hr_api.g_varchar2) or
1152: nvl(pay_pap_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1153: nvl(p_rec.information10, hr_api.g_varchar2) or
1154: nvl(pay_pap_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1155: nvl(p_rec.information11, hr_api.g_varchar2) or

Line 1152: nvl(pay_pap_shd.g_old_rec.information10, hr_api.g_varchar2) <>

1148: nvl(pay_pap_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1149: nvl(p_rec.information8, hr_api.g_varchar2) or
1150: nvl(pay_pap_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1151: nvl(p_rec.information9, hr_api.g_varchar2) or
1152: nvl(pay_pap_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1153: nvl(p_rec.information10, hr_api.g_varchar2) or
1154: nvl(pay_pap_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1155: nvl(p_rec.information11, hr_api.g_varchar2) or
1156: nvl(pay_pap_shd.g_old_rec.information12, hr_api.g_varchar2) <>

Line 1153: nvl(p_rec.information10, hr_api.g_varchar2) or

1149: nvl(p_rec.information8, hr_api.g_varchar2) or
1150: nvl(pay_pap_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1151: nvl(p_rec.information9, hr_api.g_varchar2) or
1152: nvl(pay_pap_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1153: nvl(p_rec.information10, hr_api.g_varchar2) or
1154: nvl(pay_pap_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1155: nvl(p_rec.information11, hr_api.g_varchar2) or
1156: nvl(pay_pap_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1157: nvl(p_rec.information12, hr_api.g_varchar2) or

Line 1154: nvl(pay_pap_shd.g_old_rec.information11, hr_api.g_varchar2) <>

1150: nvl(pay_pap_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1151: nvl(p_rec.information9, hr_api.g_varchar2) or
1152: nvl(pay_pap_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1153: nvl(p_rec.information10, hr_api.g_varchar2) or
1154: nvl(pay_pap_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1155: nvl(p_rec.information11, hr_api.g_varchar2) or
1156: nvl(pay_pap_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1157: nvl(p_rec.information12, hr_api.g_varchar2) or
1158: nvl(pay_pap_shd.g_old_rec.information13, hr_api.g_varchar2) <>

Line 1155: nvl(p_rec.information11, hr_api.g_varchar2) or

1151: nvl(p_rec.information9, hr_api.g_varchar2) or
1152: nvl(pay_pap_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1153: nvl(p_rec.information10, hr_api.g_varchar2) or
1154: nvl(pay_pap_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1155: nvl(p_rec.information11, hr_api.g_varchar2) or
1156: nvl(pay_pap_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1157: nvl(p_rec.information12, hr_api.g_varchar2) or
1158: nvl(pay_pap_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1159: nvl(p_rec.information13, hr_api.g_varchar2) or

Line 1156: nvl(pay_pap_shd.g_old_rec.information12, hr_api.g_varchar2) <>

1152: nvl(pay_pap_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1153: nvl(p_rec.information10, hr_api.g_varchar2) or
1154: nvl(pay_pap_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1155: nvl(p_rec.information11, hr_api.g_varchar2) or
1156: nvl(pay_pap_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1157: nvl(p_rec.information12, hr_api.g_varchar2) or
1158: nvl(pay_pap_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1159: nvl(p_rec.information13, hr_api.g_varchar2) or
1160: nvl(pay_pap_shd.g_old_rec.information14, hr_api.g_varchar2) <>

Line 1157: nvl(p_rec.information12, hr_api.g_varchar2) or

1153: nvl(p_rec.information10, hr_api.g_varchar2) or
1154: nvl(pay_pap_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1155: nvl(p_rec.information11, hr_api.g_varchar2) or
1156: nvl(pay_pap_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1157: nvl(p_rec.information12, hr_api.g_varchar2) or
1158: nvl(pay_pap_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1159: nvl(p_rec.information13, hr_api.g_varchar2) or
1160: nvl(pay_pap_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1161: nvl(p_rec.information14, hr_api.g_varchar2) or

Line 1158: nvl(pay_pap_shd.g_old_rec.information13, hr_api.g_varchar2) <>

1154: nvl(pay_pap_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1155: nvl(p_rec.information11, hr_api.g_varchar2) or
1156: nvl(pay_pap_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1157: nvl(p_rec.information12, hr_api.g_varchar2) or
1158: nvl(pay_pap_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1159: nvl(p_rec.information13, hr_api.g_varchar2) or
1160: nvl(pay_pap_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1161: nvl(p_rec.information14, hr_api.g_varchar2) or
1162: nvl(pay_pap_shd.g_old_rec.information15, hr_api.g_varchar2) <>

Line 1159: nvl(p_rec.information13, hr_api.g_varchar2) or

1155: nvl(p_rec.information11, hr_api.g_varchar2) or
1156: nvl(pay_pap_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1157: nvl(p_rec.information12, hr_api.g_varchar2) or
1158: nvl(pay_pap_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1159: nvl(p_rec.information13, hr_api.g_varchar2) or
1160: nvl(pay_pap_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1161: nvl(p_rec.information14, hr_api.g_varchar2) or
1162: nvl(pay_pap_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1163: nvl(p_rec.information15, hr_api.g_varchar2) or

Line 1160: nvl(pay_pap_shd.g_old_rec.information14, hr_api.g_varchar2) <>

1156: nvl(pay_pap_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1157: nvl(p_rec.information12, hr_api.g_varchar2) or
1158: nvl(pay_pap_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1159: nvl(p_rec.information13, hr_api.g_varchar2) or
1160: nvl(pay_pap_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1161: nvl(p_rec.information14, hr_api.g_varchar2) or
1162: nvl(pay_pap_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1163: nvl(p_rec.information15, hr_api.g_varchar2) or
1164: nvl(pay_pap_shd.g_old_rec.information16, hr_api.g_varchar2) <>

Line 1161: nvl(p_rec.information14, hr_api.g_varchar2) or

1157: nvl(p_rec.information12, hr_api.g_varchar2) or
1158: nvl(pay_pap_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1159: nvl(p_rec.information13, hr_api.g_varchar2) or
1160: nvl(pay_pap_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1161: nvl(p_rec.information14, hr_api.g_varchar2) or
1162: nvl(pay_pap_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1163: nvl(p_rec.information15, hr_api.g_varchar2) or
1164: nvl(pay_pap_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1165: nvl(p_rec.information16, hr_api.g_varchar2) or

Line 1162: nvl(pay_pap_shd.g_old_rec.information15, hr_api.g_varchar2) <>

1158: nvl(pay_pap_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1159: nvl(p_rec.information13, hr_api.g_varchar2) or
1160: nvl(pay_pap_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1161: nvl(p_rec.information14, hr_api.g_varchar2) or
1162: nvl(pay_pap_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1163: nvl(p_rec.information15, hr_api.g_varchar2) or
1164: nvl(pay_pap_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1165: nvl(p_rec.information16, hr_api.g_varchar2) or
1166: nvl(pay_pap_shd.g_old_rec.information17, hr_api.g_varchar2) <>

Line 1163: nvl(p_rec.information15, hr_api.g_varchar2) or

1159: nvl(p_rec.information13, hr_api.g_varchar2) or
1160: nvl(pay_pap_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1161: nvl(p_rec.information14, hr_api.g_varchar2) or
1162: nvl(pay_pap_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1163: nvl(p_rec.information15, hr_api.g_varchar2) or
1164: nvl(pay_pap_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1165: nvl(p_rec.information16, hr_api.g_varchar2) or
1166: nvl(pay_pap_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1167: nvl(p_rec.information17, hr_api.g_varchar2) or

Line 1164: nvl(pay_pap_shd.g_old_rec.information16, hr_api.g_varchar2) <>

1160: nvl(pay_pap_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1161: nvl(p_rec.information14, hr_api.g_varchar2) or
1162: nvl(pay_pap_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1163: nvl(p_rec.information15, hr_api.g_varchar2) or
1164: nvl(pay_pap_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1165: nvl(p_rec.information16, hr_api.g_varchar2) or
1166: nvl(pay_pap_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1167: nvl(p_rec.information17, hr_api.g_varchar2) or
1168: nvl(pay_pap_shd.g_old_rec.information18, hr_api.g_varchar2) <>

Line 1165: nvl(p_rec.information16, hr_api.g_varchar2) or

1161: nvl(p_rec.information14, hr_api.g_varchar2) or
1162: nvl(pay_pap_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1163: nvl(p_rec.information15, hr_api.g_varchar2) or
1164: nvl(pay_pap_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1165: nvl(p_rec.information16, hr_api.g_varchar2) or
1166: nvl(pay_pap_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1167: nvl(p_rec.information17, hr_api.g_varchar2) or
1168: nvl(pay_pap_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1169: nvl(p_rec.information18, hr_api.g_varchar2) or

Line 1166: nvl(pay_pap_shd.g_old_rec.information17, hr_api.g_varchar2) <>

1162: nvl(pay_pap_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1163: nvl(p_rec.information15, hr_api.g_varchar2) or
1164: nvl(pay_pap_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1165: nvl(p_rec.information16, hr_api.g_varchar2) or
1166: nvl(pay_pap_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1167: nvl(p_rec.information17, hr_api.g_varchar2) or
1168: nvl(pay_pap_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1169: nvl(p_rec.information18, hr_api.g_varchar2) or
1170: nvl(pay_pap_shd.g_old_rec.information19, hr_api.g_varchar2) <>

Line 1167: nvl(p_rec.information17, hr_api.g_varchar2) or

1163: nvl(p_rec.information15, hr_api.g_varchar2) or
1164: nvl(pay_pap_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1165: nvl(p_rec.information16, hr_api.g_varchar2) or
1166: nvl(pay_pap_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1167: nvl(p_rec.information17, hr_api.g_varchar2) or
1168: nvl(pay_pap_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1169: nvl(p_rec.information18, hr_api.g_varchar2) or
1170: nvl(pay_pap_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1171: nvl(p_rec.information19, hr_api.g_varchar2) or

Line 1168: nvl(pay_pap_shd.g_old_rec.information18, hr_api.g_varchar2) <>

1164: nvl(pay_pap_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1165: nvl(p_rec.information16, hr_api.g_varchar2) or
1166: nvl(pay_pap_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1167: nvl(p_rec.information17, hr_api.g_varchar2) or
1168: nvl(pay_pap_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1169: nvl(p_rec.information18, hr_api.g_varchar2) or
1170: nvl(pay_pap_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1171: nvl(p_rec.information19, hr_api.g_varchar2) or
1172: nvl(pay_pap_shd.g_old_rec.information20, hr_api.g_varchar2) <>

Line 1169: nvl(p_rec.information18, hr_api.g_varchar2) or

1165: nvl(p_rec.information16, hr_api.g_varchar2) or
1166: nvl(pay_pap_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1167: nvl(p_rec.information17, hr_api.g_varchar2) or
1168: nvl(pay_pap_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1169: nvl(p_rec.information18, hr_api.g_varchar2) or
1170: nvl(pay_pap_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1171: nvl(p_rec.information19, hr_api.g_varchar2) or
1172: nvl(pay_pap_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1173: nvl(p_rec.information20, hr_api.g_varchar2) or

Line 1170: nvl(pay_pap_shd.g_old_rec.information19, hr_api.g_varchar2) <>

1166: nvl(pay_pap_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1167: nvl(p_rec.information17, hr_api.g_varchar2) or
1168: nvl(pay_pap_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1169: nvl(p_rec.information18, hr_api.g_varchar2) or
1170: nvl(pay_pap_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1171: nvl(p_rec.information19, hr_api.g_varchar2) or
1172: nvl(pay_pap_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1173: nvl(p_rec.information20, hr_api.g_varchar2) or
1174: nvl(pay_pap_shd.g_old_rec.information21, hr_api.g_varchar2) <>

Line 1171: nvl(p_rec.information19, hr_api.g_varchar2) or

1167: nvl(p_rec.information17, hr_api.g_varchar2) or
1168: nvl(pay_pap_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1169: nvl(p_rec.information18, hr_api.g_varchar2) or
1170: nvl(pay_pap_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1171: nvl(p_rec.information19, hr_api.g_varchar2) or
1172: nvl(pay_pap_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1173: nvl(p_rec.information20, hr_api.g_varchar2) or
1174: nvl(pay_pap_shd.g_old_rec.information21, hr_api.g_varchar2) <>
1175: nvl(p_rec.information21, hr_api.g_varchar2) or

Line 1172: nvl(pay_pap_shd.g_old_rec.information20, hr_api.g_varchar2) <>

1168: nvl(pay_pap_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1169: nvl(p_rec.information18, hr_api.g_varchar2) or
1170: nvl(pay_pap_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1171: nvl(p_rec.information19, hr_api.g_varchar2) or
1172: nvl(pay_pap_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1173: nvl(p_rec.information20, hr_api.g_varchar2) or
1174: nvl(pay_pap_shd.g_old_rec.information21, hr_api.g_varchar2) <>
1175: nvl(p_rec.information21, hr_api.g_varchar2) or
1176: nvl(pay_pap_shd.g_old_rec.information22, hr_api.g_varchar2) <>

Line 1173: nvl(p_rec.information20, hr_api.g_varchar2) or

1169: nvl(p_rec.information18, hr_api.g_varchar2) or
1170: nvl(pay_pap_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1171: nvl(p_rec.information19, hr_api.g_varchar2) or
1172: nvl(pay_pap_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1173: nvl(p_rec.information20, hr_api.g_varchar2) or
1174: nvl(pay_pap_shd.g_old_rec.information21, hr_api.g_varchar2) <>
1175: nvl(p_rec.information21, hr_api.g_varchar2) or
1176: nvl(pay_pap_shd.g_old_rec.information22, hr_api.g_varchar2) <>
1177: nvl(p_rec.information22, hr_api.g_varchar2) or

Line 1174: nvl(pay_pap_shd.g_old_rec.information21, hr_api.g_varchar2) <>

1170: nvl(pay_pap_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1171: nvl(p_rec.information19, hr_api.g_varchar2) or
1172: nvl(pay_pap_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1173: nvl(p_rec.information20, hr_api.g_varchar2) or
1174: nvl(pay_pap_shd.g_old_rec.information21, hr_api.g_varchar2) <>
1175: nvl(p_rec.information21, hr_api.g_varchar2) or
1176: nvl(pay_pap_shd.g_old_rec.information22, hr_api.g_varchar2) <>
1177: nvl(p_rec.information22, hr_api.g_varchar2) or
1178: nvl(pay_pap_shd.g_old_rec.information23, hr_api.g_varchar2) <>

Line 1175: nvl(p_rec.information21, hr_api.g_varchar2) or

1171: nvl(p_rec.information19, hr_api.g_varchar2) or
1172: nvl(pay_pap_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1173: nvl(p_rec.information20, hr_api.g_varchar2) or
1174: nvl(pay_pap_shd.g_old_rec.information21, hr_api.g_varchar2) <>
1175: nvl(p_rec.information21, hr_api.g_varchar2) or
1176: nvl(pay_pap_shd.g_old_rec.information22, hr_api.g_varchar2) <>
1177: nvl(p_rec.information22, hr_api.g_varchar2) or
1178: nvl(pay_pap_shd.g_old_rec.information23, hr_api.g_varchar2) <>
1179: nvl(p_rec.information23, hr_api.g_varchar2) or

Line 1176: nvl(pay_pap_shd.g_old_rec.information22, hr_api.g_varchar2) <>

1172: nvl(pay_pap_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1173: nvl(p_rec.information20, hr_api.g_varchar2) or
1174: nvl(pay_pap_shd.g_old_rec.information21, hr_api.g_varchar2) <>
1175: nvl(p_rec.information21, hr_api.g_varchar2) or
1176: nvl(pay_pap_shd.g_old_rec.information22, hr_api.g_varchar2) <>
1177: nvl(p_rec.information22, hr_api.g_varchar2) or
1178: nvl(pay_pap_shd.g_old_rec.information23, hr_api.g_varchar2) <>
1179: nvl(p_rec.information23, hr_api.g_varchar2) or
1180: nvl(pay_pap_shd.g_old_rec.information24, hr_api.g_varchar2) <>

Line 1177: nvl(p_rec.information22, hr_api.g_varchar2) or

1173: nvl(p_rec.information20, hr_api.g_varchar2) or
1174: nvl(pay_pap_shd.g_old_rec.information21, hr_api.g_varchar2) <>
1175: nvl(p_rec.information21, hr_api.g_varchar2) or
1176: nvl(pay_pap_shd.g_old_rec.information22, hr_api.g_varchar2) <>
1177: nvl(p_rec.information22, hr_api.g_varchar2) or
1178: nvl(pay_pap_shd.g_old_rec.information23, hr_api.g_varchar2) <>
1179: nvl(p_rec.information23, hr_api.g_varchar2) or
1180: nvl(pay_pap_shd.g_old_rec.information24, hr_api.g_varchar2) <>
1181: nvl(p_rec.information24, hr_api.g_varchar2) or

Line 1178: nvl(pay_pap_shd.g_old_rec.information23, hr_api.g_varchar2) <>

1174: nvl(pay_pap_shd.g_old_rec.information21, hr_api.g_varchar2) <>
1175: nvl(p_rec.information21, hr_api.g_varchar2) or
1176: nvl(pay_pap_shd.g_old_rec.information22, hr_api.g_varchar2) <>
1177: nvl(p_rec.information22, hr_api.g_varchar2) or
1178: nvl(pay_pap_shd.g_old_rec.information23, hr_api.g_varchar2) <>
1179: nvl(p_rec.information23, hr_api.g_varchar2) or
1180: nvl(pay_pap_shd.g_old_rec.information24, hr_api.g_varchar2) <>
1181: nvl(p_rec.information24, hr_api.g_varchar2) or
1182: nvl(pay_pap_shd.g_old_rec.information25, hr_api.g_varchar2) <>

Line 1179: nvl(p_rec.information23, hr_api.g_varchar2) or

1175: nvl(p_rec.information21, hr_api.g_varchar2) or
1176: nvl(pay_pap_shd.g_old_rec.information22, hr_api.g_varchar2) <>
1177: nvl(p_rec.information22, hr_api.g_varchar2) or
1178: nvl(pay_pap_shd.g_old_rec.information23, hr_api.g_varchar2) <>
1179: nvl(p_rec.information23, hr_api.g_varchar2) or
1180: nvl(pay_pap_shd.g_old_rec.information24, hr_api.g_varchar2) <>
1181: nvl(p_rec.information24, hr_api.g_varchar2) or
1182: nvl(pay_pap_shd.g_old_rec.information25, hr_api.g_varchar2) <>
1183: nvl(p_rec.information25, hr_api.g_varchar2) or

Line 1180: nvl(pay_pap_shd.g_old_rec.information24, hr_api.g_varchar2) <>

1176: nvl(pay_pap_shd.g_old_rec.information22, hr_api.g_varchar2) <>
1177: nvl(p_rec.information22, hr_api.g_varchar2) or
1178: nvl(pay_pap_shd.g_old_rec.information23, hr_api.g_varchar2) <>
1179: nvl(p_rec.information23, hr_api.g_varchar2) or
1180: nvl(pay_pap_shd.g_old_rec.information24, hr_api.g_varchar2) <>
1181: nvl(p_rec.information24, hr_api.g_varchar2) or
1182: nvl(pay_pap_shd.g_old_rec.information25, hr_api.g_varchar2) <>
1183: nvl(p_rec.information25, hr_api.g_varchar2) or
1184: nvl(pay_pap_shd.g_old_rec.information26, hr_api.g_varchar2) <>

Line 1181: nvl(p_rec.information24, hr_api.g_varchar2) or

1177: nvl(p_rec.information22, hr_api.g_varchar2) or
1178: nvl(pay_pap_shd.g_old_rec.information23, hr_api.g_varchar2) <>
1179: nvl(p_rec.information23, hr_api.g_varchar2) or
1180: nvl(pay_pap_shd.g_old_rec.information24, hr_api.g_varchar2) <>
1181: nvl(p_rec.information24, hr_api.g_varchar2) or
1182: nvl(pay_pap_shd.g_old_rec.information25, hr_api.g_varchar2) <>
1183: nvl(p_rec.information25, hr_api.g_varchar2) or
1184: nvl(pay_pap_shd.g_old_rec.information26, hr_api.g_varchar2) <>
1185: nvl(p_rec.information26, hr_api.g_varchar2) or

Line 1182: nvl(pay_pap_shd.g_old_rec.information25, hr_api.g_varchar2) <>

1178: nvl(pay_pap_shd.g_old_rec.information23, hr_api.g_varchar2) <>
1179: nvl(p_rec.information23, hr_api.g_varchar2) or
1180: nvl(pay_pap_shd.g_old_rec.information24, hr_api.g_varchar2) <>
1181: nvl(p_rec.information24, hr_api.g_varchar2) or
1182: nvl(pay_pap_shd.g_old_rec.information25, hr_api.g_varchar2) <>
1183: nvl(p_rec.information25, hr_api.g_varchar2) or
1184: nvl(pay_pap_shd.g_old_rec.information26, hr_api.g_varchar2) <>
1185: nvl(p_rec.information26, hr_api.g_varchar2) or
1186: nvl(pay_pap_shd.g_old_rec.information27, hr_api.g_varchar2) <>

Line 1183: nvl(p_rec.information25, hr_api.g_varchar2) or

1179: nvl(p_rec.information23, hr_api.g_varchar2) or
1180: nvl(pay_pap_shd.g_old_rec.information24, hr_api.g_varchar2) <>
1181: nvl(p_rec.information24, hr_api.g_varchar2) or
1182: nvl(pay_pap_shd.g_old_rec.information25, hr_api.g_varchar2) <>
1183: nvl(p_rec.information25, hr_api.g_varchar2) or
1184: nvl(pay_pap_shd.g_old_rec.information26, hr_api.g_varchar2) <>
1185: nvl(p_rec.information26, hr_api.g_varchar2) or
1186: nvl(pay_pap_shd.g_old_rec.information27, hr_api.g_varchar2) <>
1187: nvl(p_rec.information27, hr_api.g_varchar2) or

Line 1184: nvl(pay_pap_shd.g_old_rec.information26, hr_api.g_varchar2) <>

1180: nvl(pay_pap_shd.g_old_rec.information24, hr_api.g_varchar2) <>
1181: nvl(p_rec.information24, hr_api.g_varchar2) or
1182: nvl(pay_pap_shd.g_old_rec.information25, hr_api.g_varchar2) <>
1183: nvl(p_rec.information25, hr_api.g_varchar2) or
1184: nvl(pay_pap_shd.g_old_rec.information26, hr_api.g_varchar2) <>
1185: nvl(p_rec.information26, hr_api.g_varchar2) or
1186: nvl(pay_pap_shd.g_old_rec.information27, hr_api.g_varchar2) <>
1187: nvl(p_rec.information27, hr_api.g_varchar2) or
1188: nvl(pay_pap_shd.g_old_rec.information28, hr_api.g_varchar2) <>

Line 1185: nvl(p_rec.information26, hr_api.g_varchar2) or

1181: nvl(p_rec.information24, hr_api.g_varchar2) or
1182: nvl(pay_pap_shd.g_old_rec.information25, hr_api.g_varchar2) <>
1183: nvl(p_rec.information25, hr_api.g_varchar2) or
1184: nvl(pay_pap_shd.g_old_rec.information26, hr_api.g_varchar2) <>
1185: nvl(p_rec.information26, hr_api.g_varchar2) or
1186: nvl(pay_pap_shd.g_old_rec.information27, hr_api.g_varchar2) <>
1187: nvl(p_rec.information27, hr_api.g_varchar2) or
1188: nvl(pay_pap_shd.g_old_rec.information28, hr_api.g_varchar2) <>
1189: nvl(p_rec.information28, hr_api.g_varchar2) or

Line 1186: nvl(pay_pap_shd.g_old_rec.information27, hr_api.g_varchar2) <>

1182: nvl(pay_pap_shd.g_old_rec.information25, hr_api.g_varchar2) <>
1183: nvl(p_rec.information25, hr_api.g_varchar2) or
1184: nvl(pay_pap_shd.g_old_rec.information26, hr_api.g_varchar2) <>
1185: nvl(p_rec.information26, hr_api.g_varchar2) or
1186: nvl(pay_pap_shd.g_old_rec.information27, hr_api.g_varchar2) <>
1187: nvl(p_rec.information27, hr_api.g_varchar2) or
1188: nvl(pay_pap_shd.g_old_rec.information28, hr_api.g_varchar2) <>
1189: nvl(p_rec.information28, hr_api.g_varchar2) or
1190: nvl(pay_pap_shd.g_old_rec.information29, hr_api.g_varchar2) <>

Line 1187: nvl(p_rec.information27, hr_api.g_varchar2) or

1183: nvl(p_rec.information25, hr_api.g_varchar2) or
1184: nvl(pay_pap_shd.g_old_rec.information26, hr_api.g_varchar2) <>
1185: nvl(p_rec.information26, hr_api.g_varchar2) or
1186: nvl(pay_pap_shd.g_old_rec.information27, hr_api.g_varchar2) <>
1187: nvl(p_rec.information27, hr_api.g_varchar2) or
1188: nvl(pay_pap_shd.g_old_rec.information28, hr_api.g_varchar2) <>
1189: nvl(p_rec.information28, hr_api.g_varchar2) or
1190: nvl(pay_pap_shd.g_old_rec.information29, hr_api.g_varchar2) <>
1191: nvl(p_rec.information29, hr_api.g_varchar2) or

Line 1188: nvl(pay_pap_shd.g_old_rec.information28, hr_api.g_varchar2) <>

1184: nvl(pay_pap_shd.g_old_rec.information26, hr_api.g_varchar2) <>
1185: nvl(p_rec.information26, hr_api.g_varchar2) or
1186: nvl(pay_pap_shd.g_old_rec.information27, hr_api.g_varchar2) <>
1187: nvl(p_rec.information27, hr_api.g_varchar2) or
1188: nvl(pay_pap_shd.g_old_rec.information28, hr_api.g_varchar2) <>
1189: nvl(p_rec.information28, hr_api.g_varchar2) or
1190: nvl(pay_pap_shd.g_old_rec.information29, hr_api.g_varchar2) <>
1191: nvl(p_rec.information29, hr_api.g_varchar2) or
1192: nvl(pay_pap_shd.g_old_rec.information30, hr_api.g_varchar2) <>

Line 1189: nvl(p_rec.information28, hr_api.g_varchar2) or

1185: nvl(p_rec.information26, hr_api.g_varchar2) or
1186: nvl(pay_pap_shd.g_old_rec.information27, hr_api.g_varchar2) <>
1187: nvl(p_rec.information27, hr_api.g_varchar2) or
1188: nvl(pay_pap_shd.g_old_rec.information28, hr_api.g_varchar2) <>
1189: nvl(p_rec.information28, hr_api.g_varchar2) or
1190: nvl(pay_pap_shd.g_old_rec.information29, hr_api.g_varchar2) <>
1191: nvl(p_rec.information29, hr_api.g_varchar2) or
1192: nvl(pay_pap_shd.g_old_rec.information30, hr_api.g_varchar2) <>
1193: nvl(p_rec.information30, hr_api.g_varchar2) ))

Line 1190: nvl(pay_pap_shd.g_old_rec.information29, hr_api.g_varchar2) <>

1186: nvl(pay_pap_shd.g_old_rec.information27, hr_api.g_varchar2) <>
1187: nvl(p_rec.information27, hr_api.g_varchar2) or
1188: nvl(pay_pap_shd.g_old_rec.information28, hr_api.g_varchar2) <>
1189: nvl(p_rec.information28, hr_api.g_varchar2) or
1190: nvl(pay_pap_shd.g_old_rec.information29, hr_api.g_varchar2) <>
1191: nvl(p_rec.information29, hr_api.g_varchar2) or
1192: nvl(pay_pap_shd.g_old_rec.information30, hr_api.g_varchar2) <>
1193: nvl(p_rec.information30, hr_api.g_varchar2) ))
1194: or (p_rec.accrual_plan_id is null) then

Line 1191: nvl(p_rec.information29, hr_api.g_varchar2) or

1187: nvl(p_rec.information27, hr_api.g_varchar2) or
1188: nvl(pay_pap_shd.g_old_rec.information28, hr_api.g_varchar2) <>
1189: nvl(p_rec.information28, hr_api.g_varchar2) or
1190: nvl(pay_pap_shd.g_old_rec.information29, hr_api.g_varchar2) <>
1191: nvl(p_rec.information29, hr_api.g_varchar2) or
1192: nvl(pay_pap_shd.g_old_rec.information30, hr_api.g_varchar2) <>
1193: nvl(p_rec.information30, hr_api.g_varchar2) ))
1194: or (p_rec.accrual_plan_id is null) then
1195: --

Line 1192: nvl(pay_pap_shd.g_old_rec.information30, hr_api.g_varchar2) <>

1188: nvl(pay_pap_shd.g_old_rec.information28, hr_api.g_varchar2) <>
1189: nvl(p_rec.information28, hr_api.g_varchar2) or
1190: nvl(pay_pap_shd.g_old_rec.information29, hr_api.g_varchar2) <>
1191: nvl(p_rec.information29, hr_api.g_varchar2) or
1192: nvl(pay_pap_shd.g_old_rec.information30, hr_api.g_varchar2) <>
1193: nvl(p_rec.information30, hr_api.g_varchar2) ))
1194: or (p_rec.accrual_plan_id is null) then
1195: --
1196: -- Only execute the validation if absolutely necessary:

Line 1193: nvl(p_rec.information30, hr_api.g_varchar2) ))

1189: nvl(p_rec.information28, hr_api.g_varchar2) or
1190: nvl(pay_pap_shd.g_old_rec.information29, hr_api.g_varchar2) <>
1191: nvl(p_rec.information29, hr_api.g_varchar2) or
1192: nvl(pay_pap_shd.g_old_rec.information30, hr_api.g_varchar2) <>
1193: nvl(p_rec.information30, hr_api.g_varchar2) ))
1194: or (p_rec.accrual_plan_id is null) then
1195: --
1196: -- Only execute the validation if absolutely necessary:
1197: -- a) During update, the structure column value or any

Line 1320: and (nvl(p_information_category,hr_api.g_varchar2)

1316: p_object_version_number => p_object_version_number);
1317: --
1318:
1319: if (l_api_updating
1320: and (nvl(p_information_category,hr_api.g_varchar2)
1321: <> nvl(pay_pap_shd.g_old_rec.information_category, hr_api.g_varchar2)
1322: )
1323: OR
1324: (nvl(p_accrual_category, hr_api.g_varchar2)

Line 1321: <> nvl(pay_pap_shd.g_old_rec.information_category, hr_api.g_varchar2)

1317: --
1318:
1319: if (l_api_updating
1320: and (nvl(p_information_category,hr_api.g_varchar2)
1321: <> nvl(pay_pap_shd.g_old_rec.information_category, hr_api.g_varchar2)
1322: )
1323: OR
1324: (nvl(p_accrual_category, hr_api.g_varchar2)
1325: <> nvl(pay_pap_shd.g_old_rec.accrual_category, hr_api.g_varchar2)

Line 1324: (nvl(p_accrual_category, hr_api.g_varchar2)

1320: and (nvl(p_information_category,hr_api.g_varchar2)
1321: <> nvl(pay_pap_shd.g_old_rec.information_category, hr_api.g_varchar2)
1322: )
1323: OR
1324: (nvl(p_accrual_category, hr_api.g_varchar2)
1325: <> nvl(pay_pap_shd.g_old_rec.accrual_category, hr_api.g_varchar2)
1326: ))
1327: OR not l_api_updating
1328: --

Line 1325: <> nvl(pay_pap_shd.g_old_rec.accrual_category, hr_api.g_varchar2)

1321: <> nvl(pay_pap_shd.g_old_rec.information_category, hr_api.g_varchar2)
1322: )
1323: OR
1324: (nvl(p_accrual_category, hr_api.g_varchar2)
1325: <> nvl(pay_pap_shd.g_old_rec.accrual_category, hr_api.g_varchar2)
1326: ))
1327: OR not l_api_updating
1328: --
1329: -- it is an update with values changing, or it is an insert

Line 1350: if (l_api_updating and nvl(p_accrual_category, hr_api.g_varchar2)

1346: fnd_message.set_name('PER','HR_289740_PAP_BAD_INFO_CONTEXT');
1347: fnd_message.raise_error;
1348: end if;
1349: -- error if accrual category is changing and ddf is already used.
1350: if (l_api_updating and nvl(p_accrual_category, hr_api.g_varchar2)
1351: <> nvl(pay_pap_shd.g_old_rec.accrual_category, hr_api.g_varchar2)
1352: and pay_pap_shd.g_old_rec.information_category is not null )
1353: then
1354: fnd_message.set_name('PER','HR_289741_PAP_CHANGE_CATEGORY');

Line 1351: <> nvl(pay_pap_shd.g_old_rec.accrual_category, hr_api.g_varchar2)

1347: fnd_message.raise_error;
1348: end if;
1349: -- error if accrual category is changing and ddf is already used.
1350: if (l_api_updating and nvl(p_accrual_category, hr_api.g_varchar2)
1351: <> nvl(pay_pap_shd.g_old_rec.accrual_category, hr_api.g_varchar2)
1352: and pay_pap_shd.g_old_rec.information_category is not null )
1353: then
1354: fnd_message.set_name('PER','HR_289741_PAP_CHANGE_CATEGORY');
1355: fnd_message.raise_error;

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

1373: BEGIN
1374:
1375: hr_utility.set_location('Entering:'||l_proc, 10);
1376:
1377: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1378:
1379: --
1380: -- Call all supporting business operations
1381: --

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

1526: BEGIN
1527:
1528: hr_utility.set_location('Entering:'||l_proc, 10);
1529:
1530: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1531:
1532: --
1533: -- Call all supporting business operations
1534: --

Line 1695: hr_api.mandatory_arg_error(p_api_name => l_proc,

1691: hr_utility.set_location('Entering:'|| l_proc, 10);
1692: --
1693: -- Ensure that all the mandatory parameter are not null
1694: --
1695: hr_api.mandatory_arg_error(p_api_name => l_proc,
1696: p_argument => 'accrual_plan_id',
1697: p_argument_value => p_accrual_plan_id);
1698: --
1699: open csr_leg_code;

Line 1750: hr_api.mandatory_arg_error(p_api_name => l_proc,

1746: hr_utility.set_location('Entering:'|| l_proc, 10);
1747: --
1748: -- Ensure that all the mandatory parameter are not null
1749: --
1750: hr_api.mandatory_arg_error(p_api_name => l_proc,
1751: p_argument => 'accrual_plan_id',
1752: p_argument_value => p_accrual_plan_id);
1753: --
1754: open csr_sec_grp;

Line 1768: hr_api.set_security_group_id

1764: close csr_sec_grp;
1765: --
1766: -- Set the security_group_id in CLIENT_INFO
1767: --
1768: hr_api.set_security_group_id
1769: (p_security_group_id => l_security_group_id
1770: );
1771: --
1772: hr_utility.set_location(' Leaving:'|| l_proc, 20);