[Home] [Help]
33: hr_utility.set_location('Entering:'|| l_proc, 10);
34: --
35: -- Check mandatory parameters have been set
36: --
37: hr_api.mandatory_arg_error
38: (p_api_name => l_proc
39: ,p_argument => 'effective date'
40: ,p_argument_value => p_effective_date
41: );
46: -- b) During insert, the type_id is not null.
47: --
48: if (((p_pension_type_id is not null) and
49: nvl(pqp_pty_shd.g_old_rec.contribution_conversion_rule,
50: hr_api.g_varchar2) <> nvl(p_contribution_conversion_rule,
51: hr_api.g_varchar2))
52: or
53: (p_pension_type_id is null)) then
54:
47: --
48: if (((p_pension_type_id is not null) and
49: nvl(pqp_pty_shd.g_old_rec.contribution_conversion_rule,
50: hr_api.g_varchar2) <> nvl(p_contribution_conversion_rule,
51: hr_api.g_varchar2))
52: or
53: (p_pension_type_id is null)) then
54:
55: -- If contribution_conversion_rule is not null then
56: -- Check if the contribution_conversion_rule value exists in hr_lookups
57: -- where the lookup_type is 'PQP_NL_CONVERSION_RULE'
58: --
59: if p_contribution_conversion_rule is not null then
60: if hr_api.not_exists_in_dt_hrstanlookups
61: (p_effective_date => p_effective_date
62: ,p_validation_start_date => p_validation_start_date
63: ,p_validation_end_date => p_validation_end_date
64: ,p_lookup_type => 'PQP_NL_CONVERSION_RULE'
102: hr_utility.set_location('Entering:'|| l_proc, 10);
103: --
104: -- Check mandatory parameters have been set
105: --
106: hr_api.mandatory_arg_error
107: (p_api_name => l_proc
108: ,p_argument => 'effective date'
109: ,p_argument_value => p_effective_date
110: );
115: -- b) During insert, the type_id is not null.
116: --
117: if (((p_pension_type_id is not null) and
118: nvl(pqp_pty_shd.g_old_rec.threshold_conversion_rule,
119: hr_api.g_varchar2) <> nvl(p_threshold_conversion_rule,
120: hr_api.g_varchar2))
121: or
122: (p_pension_type_id is null)) then
123: --
116: --
117: if (((p_pension_type_id is not null) and
118: nvl(pqp_pty_shd.g_old_rec.threshold_conversion_rule,
119: hr_api.g_varchar2) <> nvl(p_threshold_conversion_rule,
120: hr_api.g_varchar2))
121: or
122: (p_pension_type_id is null)) then
123: --
124: -- If threshold_conversion_rule is not null then
125: -- Check if the threshold_conversion_rule value exists in hr_lookups
126: -- where the lookup_type is 'PQP_NL_CONVERSION_RULE'
127: --
128: if p_threshold_conversion_rule is not null then
129: if hr_api.not_exists_in_dt_hrstanlookups
130: (p_effective_date => p_effective_date
131: ,p_validation_start_date => p_validation_start_date
132: ,p_validation_end_date => p_validation_end_date
133: ,p_lookup_type => 'PQP_NL_CONVERSION_RULE'
172: hr_utility.set_location('Entering:'|| l_proc, 10);
173: --
174: -- Check mandatory parameters have been set
175: --
176: hr_api.mandatory_arg_error
177: (p_api_name => l_proc
178: ,p_argument => 'effective date'
179: ,p_argument_value => p_effective_date
180: );
185: -- b) During insert, the type_id is not null.
186: --
187: if (((p_pension_type_id is not null) and
188: nvl(pqp_pty_shd.g_old_rec.pension_category,
189: hr_api.g_varchar2) <> nvl(p_pension_category,
190: hr_api.g_varchar2))
191: or
192: (p_pension_type_id is null)) then
193:
186: --
187: if (((p_pension_type_id is not null) and
188: nvl(pqp_pty_shd.g_old_rec.pension_category,
189: hr_api.g_varchar2) <> nvl(p_pension_category,
190: hr_api.g_varchar2))
191: or
192: (p_pension_type_id is null)) then
193:
194: --
196: -- Check if the pension_category value exists in hr_lookups
197: -- where the lookup_type is 'PQP_PENSION_CATEGORY'
198: --
199: if p_pension_category is not null then
200: if hr_api.not_exists_in_dt_hrstanlookups
201: (p_effective_date => p_effective_date
202: ,p_validation_start_date => p_validation_start_date
203: ,p_validation_end_date => p_validation_end_date
204: ,p_lookup_type => 'PQP_PENSION_CATEGORY'
243: hr_utility.set_location('Entering:'|| l_proc, 10);
244: --
245: -- Check mandatory parameters have been set
246: --
247: hr_api.mandatory_arg_error
248: (p_api_name => l_proc
249: ,p_argument => 'effective date'
250: ,p_argument_value => p_effective_date
251: );
256: -- b) During insert, the type_id is not null.
257: --
258: if (((p_pension_type_id is not null) and
259: nvl(pqp_pty_shd.g_old_rec.pension_provider_type,
260: hr_api.g_varchar2) <> nvl(p_pension_provider_type,
261: hr_api.g_varchar2))
262: or
263: (p_pension_type_id is null)) then
264: --
257: --
258: if (((p_pension_type_id is not null) and
259: nvl(pqp_pty_shd.g_old_rec.pension_provider_type,
260: hr_api.g_varchar2) <> nvl(p_pension_provider_type,
261: hr_api.g_varchar2))
262: or
263: (p_pension_type_id is null)) then
264: --
265: -- If pension_provider_type is not null then
266: -- Check if the pension_provider_type value exists in hr_lookups
267: -- where the lookup_type is 'PQP_NL_PENSION_PROVIDER_TYPE'
268: --
269: if p_pension_provider_type is not null then
270: if hr_api.not_exists_in_dt_hrstanlookups
271: (p_effective_date => p_effective_date
272: ,p_validation_start_date => p_validation_start_date
273: ,p_validation_end_date => p_validation_end_date
274: ,p_lookup_type => 'PQP_NL_PENSION_PROVIDER_TYPE'
311: hr_utility.set_location('Entering:'|| l_proc, 10);
312: --
313: -- Check mandatory parameters have been set
314: --
315: hr_api.mandatory_arg_error
316: (p_api_name => l_proc
317: ,p_argument => 'effective date'
318: ,p_argument_value => p_effective_date
319: );
324: -- b) During insert, the type_id is not null.
325: --
326: if (((p_pension_type_id is not null) and
327: nvl(pqp_pty_shd.g_old_rec.salary_calculation_method,
328: hr_api.g_varchar2) <> nvl(p_salary_calculation_method,
329: hr_api.g_varchar2))
330: or
331: (p_pension_type_id is null)) then
332: --
325: --
326: if (((p_pension_type_id is not null) and
327: nvl(pqp_pty_shd.g_old_rec.salary_calculation_method,
328: hr_api.g_varchar2) <> nvl(p_salary_calculation_method,
329: hr_api.g_varchar2))
330: or
331: (p_pension_type_id is null)) then
332: --
333: -- If salary_calculation_method is not null then
334: -- Check if the salary_calculation_method value exists in hr_lookups
335: -- where the lookup_type is 'PQP_NL_SALARY_CALC_METHOD'
336: --
337: if p_salary_calculation_method is not null then
338: if hr_api.not_exists_in_dt_hrstanlookups
339: (p_effective_date => p_effective_date
340: ,p_validation_start_date => p_validation_start_date
341: ,p_validation_end_date => p_validation_end_date
342: ,p_lookup_type => 'PQP_NL_SALARY_CALC_METHOD'
573: hr_utility.set_location('Entering:'|| l_proc, 10);
574: --
575: -- Check mandatory parameters have been set
576: --
577: hr_api.mandatory_arg_error
578: (p_api_name => l_proc
579: ,p_argument => 'effective date'
580: ,p_argument_value => p_effective_date
581: );
586: -- b) During insert, the type_id is not null.
587: --
588: if (((p_pension_type_id is not null) and
589: nvl(pqp_pty_shd.g_old_rec.special_pension_type_code,
590: hr_api.g_varchar2) <> nvl(p_special_pension_type_code,
591: hr_api.g_varchar2))
592: or
593: (p_pension_type_id is null)) then
594: --
587: --
588: if (((p_pension_type_id is not null) and
589: nvl(pqp_pty_shd.g_old_rec.special_pension_type_code,
590: hr_api.g_varchar2) <> nvl(p_special_pension_type_code,
591: hr_api.g_varchar2))
592: or
593: (p_pension_type_id is null)) then
594: --
595: -- If special_pension_type_code is not null then
596: -- Check if the special_pension_type_code value exists in hr_lookups
597: -- where the lookup_type is 'PQP_SPECIAL_PENSION_TYPE_CODE'
598: --
599: if p_special_pension_type_code is not null then
600: if hr_api.not_exists_in_dt_hrstanlookups
601: (p_effective_date => p_effective_date
602: ,p_validation_start_date => p_validation_start_date
603: ,p_validation_end_date => p_validation_end_date
604: ,p_lookup_type => 'PQP_SPECIAL_PENSION_TYPE_CODE'
642: hr_utility.set_location('Entering:'|| l_proc, 10);
643: --
644: -- Check mandatory parameters have been set
645: --
646: hr_api.mandatory_arg_error
647: (p_api_name => l_proc
648: ,p_argument => 'effective date'
649: ,p_argument_value => p_effective_date
650: );
655: -- b) During insert, the type_id is not null.
656: --
657: if (((p_pension_type_id is not null) and
658: nvl(pqp_pty_shd.g_old_rec.pension_sub_category,
659: hr_api.g_varchar2) <> nvl(p_pension_sub_category,
660: hr_api.g_varchar2))
661: or
662: (p_pension_type_id is null)) then
663: --
656: --
657: if (((p_pension_type_id is not null) and
658: nvl(pqp_pty_shd.g_old_rec.pension_sub_category,
659: hr_api.g_varchar2) <> nvl(p_pension_sub_category,
660: hr_api.g_varchar2))
661: or
662: (p_pension_type_id is null)) then
663: --
664: -- If pension_sub_category is not null then
665: -- Check if the pension_sub_category value exists in hr_lookups
666: -- where the lookup_type is 'PQP_PENSION_SUB_CATEGORY'
667: --
668: if p_pension_sub_category is not null then
669: if hr_api.not_exists_in_dt_hrstanlookups
670: (p_effective_date => p_effective_date
671: ,p_validation_start_date => p_validation_start_date
672: ,p_validation_end_date => p_validation_end_date
673: ,p_lookup_type => 'PQP_PENSION_SUB_CATEGORY'
711: hr_utility.set_location('Entering:'|| l_proc, 10);
712: --
713: -- Check mandatory parameters have been set
714: --
715: hr_api.mandatory_arg_error
716: (p_api_name => l_proc
717: ,p_argument => 'effective date'
718: ,p_argument_value => p_effective_date
719: );
724: -- b) During insert, the type_id is not null.
725: --
726: if (((p_pension_type_id is not null) and
727: nvl(pqp_pty_shd.g_old_rec.pension_basis_calc_method,
728: hr_api.g_varchar2) <> nvl(p_pension_basis_calc_method,
729: hr_api.g_varchar2))
730: or
731: (p_pension_type_id is null)) then
732: --
725: --
726: if (((p_pension_type_id is not null) and
727: nvl(pqp_pty_shd.g_old_rec.pension_basis_calc_method,
728: hr_api.g_varchar2) <> nvl(p_pension_basis_calc_method,
729: hr_api.g_varchar2))
730: or
731: (p_pension_type_id is null)) then
732: --
733: -- If pension_basis_calc_method is not null then
734: -- Check if the pension_basis_calc_method value exists in hr_lookups
735: -- where the lookup_type is 'PQP_PENSION_BASIS_CALC_MTHD'
736: --
737: if p_pension_basis_calc_method is not null then
738: if hr_api.not_exists_in_dt_hrstanlookups
739: (p_effective_date => p_effective_date
740: ,p_validation_start_date => p_validation_start_date
741: ,p_validation_end_date => p_validation_end_date
742: ,p_lookup_type => 'PQP_PENSION_BASIS_CALC_MTHD'
780: hr_utility.set_location('Entering:'|| l_proc, 10);
781: --
782: -- Check mandatory parameters have been set
783: --
784: hr_api.mandatory_arg_error
785: (p_api_name => l_proc
786: ,p_argument => 'effective date'
787: ,p_argument_value => p_effective_date
788: );
793: -- b) During insert, the type_id is not null.
794: --
795: if (((p_pension_type_id is not null) and
796: nvl(pqp_pty_shd.g_old_rec.previous_year_bonus_included,
797: hr_api.g_varchar2) <> nvl(p_previous_year_bonus_included,
798: hr_api.g_varchar2))
799: or
800: (p_pension_type_id is null)) then
801: --
794: --
795: if (((p_pension_type_id is not null) and
796: nvl(pqp_pty_shd.g_old_rec.previous_year_bonus_included,
797: hr_api.g_varchar2) <> nvl(p_previous_year_bonus_included,
798: hr_api.g_varchar2))
799: or
800: (p_pension_type_id is null)) then
801: --
802: -- If previous_year_bonus_included is not null then
803: -- Check if the previous_year_bonus_included value exists in hr_lookups
804: -- where the lookup_type is 'PQP_YES_NO'
805: --
806: if p_previous_year_bonus_included is not null then
807: if hr_api.not_exists_in_dt_hrstanlookups
808: (p_effective_date => p_effective_date
809: ,p_validation_start_date => p_validation_start_date
810: ,p_validation_end_date => p_validation_end_date
811: ,p_lookup_type => 'PQP_YES_NO'
849: hr_utility.set_location('Entering:'|| l_proc, 10);
850: --
851: -- Check mandatory parameters have been set
852: --
853: hr_api.mandatory_arg_error
854: (p_api_name => l_proc
855: ,p_argument => 'effective date'
856: ,p_argument_value => p_effective_date
857: );
862: -- b) During insert, the type_id is not null.
863: --
864: if (((p_pension_type_id is not null) and
865: nvl(pqp_pty_shd.g_old_rec.recurring_bonus_period,
866: hr_api.g_varchar2) <> nvl(p_recurring_bonus_period,
867: hr_api.g_varchar2))
868: or
869: (p_pension_type_id is null)) then
870: --
863: --
864: if (((p_pension_type_id is not null) and
865: nvl(pqp_pty_shd.g_old_rec.recurring_bonus_period,
866: hr_api.g_varchar2) <> nvl(p_recurring_bonus_period,
867: hr_api.g_varchar2))
868: or
869: (p_pension_type_id is null)) then
870: --
871: -- If recurring_bonus_period is not null then
872: -- Check if the recurring_bonus_period value exists in hr_lookups
873: -- where the lookup_type is 'PQP_BONUS_PERIOD'
874: --
875: if p_recurring_bonus_period is not null then
876: if hr_api.not_exists_in_dt_hrstanlookups
877: (p_effective_date => p_effective_date
878: ,p_validation_start_date => p_validation_start_date
879: ,p_validation_end_date => p_validation_end_date
880: ,p_lookup_type => 'PQP_BONUS_PERIOD'
918: hr_utility.set_location('Entering:'|| l_proc, 10);
919: --
920: -- Check mandatory parameters have been set
921: --
922: hr_api.mandatory_arg_error
923: (p_api_name => l_proc
924: ,p_argument => 'effective date'
925: ,p_argument_value => p_effective_date
926: );
931: -- b) During insert, the type_id is not null.
932: --
933: if (((p_pension_type_id is not null) and
934: nvl(pqp_pty_shd.g_old_rec.non_recurring_bonus_period,
935: hr_api.g_varchar2) <> nvl(p_non_recurring_bonus_period,
936: hr_api.g_varchar2))
937: or
938: (p_pension_type_id is null)) then
939: --
932: --
933: if (((p_pension_type_id is not null) and
934: nvl(pqp_pty_shd.g_old_rec.non_recurring_bonus_period,
935: hr_api.g_varchar2) <> nvl(p_non_recurring_bonus_period,
936: hr_api.g_varchar2))
937: or
938: (p_pension_type_id is null)) then
939: --
940: -- If non_recurring_bonus_period is not null then
941: -- Check if the non_recurring_bonus_period value exists in hr_lookups
942: -- where the lookup_type is 'PQP_BONUS_PERIOD'
943: --
944: if p_non_recurring_bonus_period is not null then
945: if hr_api.not_exists_in_dt_hrstanlookups
946: (p_effective_date => p_effective_date
947: ,p_validation_start_date => p_validation_start_date
948: ,p_validation_end_date => p_validation_end_date
949: ,p_lookup_type => 'PQP_BONUS_PERIOD'
1015: hr_utility.set_location('Entering:'|| l_proc, 10);
1016: --
1017: -- Check mandatory parameters have been set
1018: --
1019: hr_api.mandatory_arg_error
1020: (p_api_name => l_proc
1021: ,p_argument => 'effective date'
1022: ,p_argument_value => p_effective_date
1023: );
1028: -- b) During insert, the type_id is not null.
1029: --
1030: if (((p_pension_type_id is not null) and
1031: nvl(pqp_pty_shd.g_old_rec.pension_salary_balance,
1032: hr_api.g_number) <> nvl(p_pension_salary_balance,
1033: hr_api.g_number))
1034: or
1035: (p_pension_type_id is null)) then
1036: --
1029: --
1030: if (((p_pension_type_id is not null) and
1031: nvl(pqp_pty_shd.g_old_rec.pension_salary_balance,
1032: hr_api.g_number) <> nvl(p_pension_salary_balance,
1033: hr_api.g_number))
1034: or
1035: (p_pension_type_id is null)) then
1036: --
1037: -- If pension_salary_balance is not null and the legislation is NL then
1090: hr_utility.set_location('Entering:'|| l_proc, 10);
1091: --
1092: -- Check mandatory parameters have been set
1093: --
1094: hr_api.mandatory_arg_error
1095: (p_api_name => l_proc
1096: ,p_argument => 'effective date'
1097: ,p_argument_value => p_effective_date
1098: );
1103: -- b) During insert, the type_id is not null.
1104: --
1105: if (((p_pension_type_id is not null) and
1106: nvl(pqp_pty_shd.g_old_rec.ee_age_threshold,
1107: hr_api.g_varchar2) <> nvl(p_ee_age_threshold,
1108: hr_api.g_varchar2))
1109: or
1110: (p_pension_type_id is null)) then
1111: --
1104: --
1105: if (((p_pension_type_id is not null) and
1106: nvl(pqp_pty_shd.g_old_rec.ee_age_threshold,
1107: hr_api.g_varchar2) <> nvl(p_ee_age_threshold,
1108: hr_api.g_varchar2))
1109: or
1110: (p_pension_type_id is null)) then
1111: --
1112: -- If ee_age_threshold is not null then
1113: -- Check if the ee_age_threshold value exists in hr_lookups
1114: -- where the lookup_type is 'PQP_YES_NO'
1115: --
1116: if p_ee_age_threshold is not null then
1117: if hr_api.not_exists_in_dt_hrstanlookups
1118: (p_effective_date => p_effective_date
1119: ,p_validation_start_date => p_validation_start_date
1120: ,p_validation_end_date => p_validation_end_date
1121: ,p_lookup_type => 'PQP_YES_NO'
1159: hr_utility.set_location('Entering:'|| l_proc, 10);
1160: --
1161: -- Check mandatory parameters have been set
1162: --
1163: hr_api.mandatory_arg_error
1164: (p_api_name => l_proc
1165: ,p_argument => 'effective date'
1166: ,p_argument_value => p_effective_date
1167: );
1172: -- b) During insert, the type_id is not null.
1173: --
1174: if (((p_pension_type_id is not null) and
1175: nvl(pqp_pty_shd.g_old_rec.er_age_threshold,
1176: hr_api.g_varchar2) <> nvl(p_er_age_threshold,
1177: hr_api.g_varchar2))
1178: or
1179: (p_pension_type_id is null)) then
1180: --
1173: --
1174: if (((p_pension_type_id is not null) and
1175: nvl(pqp_pty_shd.g_old_rec.er_age_threshold,
1176: hr_api.g_varchar2) <> nvl(p_er_age_threshold,
1177: hr_api.g_varchar2))
1178: or
1179: (p_pension_type_id is null)) then
1180: --
1181: -- If er_age_threshold is not null then
1182: -- Check if the er_age_threshold value exists in hr_lookups
1183: -- where the lookup_type is 'PQP_YES_NO'
1184: --
1185: if p_er_age_threshold is not null then
1186: if hr_api.not_exists_in_dt_hrstanlookups
1187: (p_effective_date => p_effective_date
1188: ,p_validation_start_date => p_validation_start_date
1189: ,p_validation_end_date => p_validation_end_date
1190: ,p_lookup_type => 'PQP_YES_NO'
1228: hr_utility.set_location('Entering:'|| l_proc, 10);
1229: --
1230: -- Check mandatory parameters have been set
1231: --
1232: hr_api.mandatory_arg_error
1233: (p_api_name => l_proc
1234: ,p_argument => 'effective date'
1235: ,p_argument_value => p_effective_date
1236: );
1241: -- b) During insert, the type_id is not null.
1242: --
1243: if (((p_pension_type_id is not null) and
1244: nvl(pqp_pty_shd.g_old_rec.ee_age_contribution,
1245: hr_api.g_varchar2) <> nvl(p_ee_age_contribution,
1246: hr_api.g_varchar2))
1247: or
1248: (p_pension_type_id is null)) then
1249: --
1242: --
1243: if (((p_pension_type_id is not null) and
1244: nvl(pqp_pty_shd.g_old_rec.ee_age_contribution,
1245: hr_api.g_varchar2) <> nvl(p_ee_age_contribution,
1246: hr_api.g_varchar2))
1247: or
1248: (p_pension_type_id is null)) then
1249: --
1250: -- If ee_age_contribution is not null then
1251: -- Check if the ee_age_contribution value exists in hr_lookups
1252: -- where the lookup_type is 'PQP_YES_NO'
1253: --
1254: if p_ee_age_contribution is not null then
1255: if hr_api.not_exists_in_dt_hrstanlookups
1256: (p_effective_date => p_effective_date
1257: ,p_validation_start_date => p_validation_start_date
1258: ,p_validation_end_date => p_validation_end_date
1259: ,p_lookup_type => 'PQP_YES_NO'
1297: hr_utility.set_location('Entering:'|| l_proc, 10);
1298: --
1299: -- Check mandatory parameters have been set
1300: --
1301: hr_api.mandatory_arg_error
1302: (p_api_name => l_proc
1303: ,p_argument => 'effective date'
1304: ,p_argument_value => p_effective_date
1305: );
1310: -- b) During insert, the type_id is not null.
1311: --
1312: if (((p_pension_type_id is not null) and
1313: nvl(pqp_pty_shd.g_old_rec.er_age_contribution,
1314: hr_api.g_varchar2) <> nvl(p_er_age_contribution,
1315: hr_api.g_varchar2))
1316: or
1317: (p_pension_type_id is null)) then
1318: --
1311: --
1312: if (((p_pension_type_id is not null) and
1313: nvl(pqp_pty_shd.g_old_rec.er_age_contribution,
1314: hr_api.g_varchar2) <> nvl(p_er_age_contribution,
1315: hr_api.g_varchar2))
1316: or
1317: (p_pension_type_id is null)) then
1318: --
1319: -- If er_age_contribution is not null then
1320: -- Check if the er_age_contribution value exists in hr_lookups
1321: -- where the lookup_type is 'PQP_YES_NO'
1322: --
1323: if p_er_age_contribution is not null then
1324: if hr_api.not_exists_in_dt_hrstanlookups
1325: (p_effective_date => p_effective_date
1326: ,p_validation_start_date => p_validation_start_date
1327: ,p_validation_end_date => p_validation_end_date
1328: ,p_lookup_type => 'PQP_YES_NO'
1366: from fnd_lookup_values
1367: where lookup_type = 'PQP_PENSION_SUB_CATEGORY'
1368: and lookup_code = p_pension_sub_category
1369: and p_effective_date between start_date_active
1370: and nvl(end_date_active,hr_api.g_eot)
1371: and nvl(enabled_flag,'N') = 'Y';
1372:
1373:
1374: l_end_date_active date;
1425: hr_utility.set_location('Entering:'|| l_proc, 10);
1426: --
1427: -- Ensure that all the mandatory parameter are not null
1428: --
1429: hr_api.mandatory_arg_error
1430: (p_api_name => l_proc
1431: ,p_argument => 'pension_type_id'
1432: ,p_argument_value => p_pension_type_id
1433: );
1452: close csr_sec_grp;
1453: --
1454: -- Set the security_group_id in CLIENT_INFO
1455: --
1456: hr_api.set_security_group_id
1457: (p_security_group_id => l_security_group_id
1458: );
1459: --
1460: -- Set the sessions legislation context in HR_SESSION_DATA
1458: );
1459: --
1460: -- Set the sessions legislation context in HR_SESSION_DATA
1461: --
1462: hr_api.set_legislation_context(l_legislation_code);
1463: end if;
1464: --
1465: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1466: --
1494: hr_utility.set_location('Entering:'|| l_proc, 10);
1495: --
1496: -- Ensure that all the mandatory parameter are not null
1497: --
1498: hr_api.mandatory_arg_error
1499: (p_api_name => l_proc
1500: ,p_argument => 'pension_type_id'
1501: ,p_argument_value => p_pension_type_id
1502: );
1500: ,p_argument => 'pension_type_id'
1501: ,p_argument_value => p_pension_type_id
1502: );
1503: --
1504: if ( nvl(pqp_pty_bus.g_pension_type_id, hr_api.g_number)
1505: = p_pension_type_id) then
1506: --
1507: -- The legislation code has already been found with a previous
1508: -- call to this function. Just return the value in the global
1576: begin
1577: hr_utility.set_location('Entering:'||l_proc,10);
1578: --
1579: if ((p_rec.pension_type_id is not null) and (
1580: nvl(pqp_pty_shd.g_old_rec.pty_information_category, hr_api.g_varchar2) <>
1581: nvl(p_rec.pty_information_category, hr_api.g_varchar2) or
1582: nvl(pqp_pty_shd.g_old_rec.pty_information1, hr_api.g_varchar2) <>
1583: nvl(p_rec.pty_information1, hr_api.g_varchar2) or
1584: nvl(pqp_pty_shd.g_old_rec.pty_information2, hr_api.g_varchar2) <>
1577: hr_utility.set_location('Entering:'||l_proc,10);
1578: --
1579: if ((p_rec.pension_type_id is not null) and (
1580: nvl(pqp_pty_shd.g_old_rec.pty_information_category, hr_api.g_varchar2) <>
1581: nvl(p_rec.pty_information_category, hr_api.g_varchar2) or
1582: nvl(pqp_pty_shd.g_old_rec.pty_information1, hr_api.g_varchar2) <>
1583: nvl(p_rec.pty_information1, hr_api.g_varchar2) or
1584: nvl(pqp_pty_shd.g_old_rec.pty_information2, hr_api.g_varchar2) <>
1585: nvl(p_rec.pty_information2, hr_api.g_varchar2) or
1578: --
1579: if ((p_rec.pension_type_id is not null) and (
1580: nvl(pqp_pty_shd.g_old_rec.pty_information_category, hr_api.g_varchar2) <>
1581: nvl(p_rec.pty_information_category, hr_api.g_varchar2) or
1582: nvl(pqp_pty_shd.g_old_rec.pty_information1, hr_api.g_varchar2) <>
1583: nvl(p_rec.pty_information1, hr_api.g_varchar2) or
1584: nvl(pqp_pty_shd.g_old_rec.pty_information2, hr_api.g_varchar2) <>
1585: nvl(p_rec.pty_information2, hr_api.g_varchar2) or
1586: nvl(pqp_pty_shd.g_old_rec.pty_information3, hr_api.g_varchar2) <>
1579: if ((p_rec.pension_type_id is not null) and (
1580: nvl(pqp_pty_shd.g_old_rec.pty_information_category, hr_api.g_varchar2) <>
1581: nvl(p_rec.pty_information_category, hr_api.g_varchar2) or
1582: nvl(pqp_pty_shd.g_old_rec.pty_information1, hr_api.g_varchar2) <>
1583: nvl(p_rec.pty_information1, hr_api.g_varchar2) or
1584: nvl(pqp_pty_shd.g_old_rec.pty_information2, hr_api.g_varchar2) <>
1585: nvl(p_rec.pty_information2, hr_api.g_varchar2) or
1586: nvl(pqp_pty_shd.g_old_rec.pty_information3, hr_api.g_varchar2) <>
1587: nvl(p_rec.pty_information3, hr_api.g_varchar2) or
1580: nvl(pqp_pty_shd.g_old_rec.pty_information_category, hr_api.g_varchar2) <>
1581: nvl(p_rec.pty_information_category, hr_api.g_varchar2) or
1582: nvl(pqp_pty_shd.g_old_rec.pty_information1, hr_api.g_varchar2) <>
1583: nvl(p_rec.pty_information1, hr_api.g_varchar2) or
1584: nvl(pqp_pty_shd.g_old_rec.pty_information2, hr_api.g_varchar2) <>
1585: nvl(p_rec.pty_information2, hr_api.g_varchar2) or
1586: nvl(pqp_pty_shd.g_old_rec.pty_information3, hr_api.g_varchar2) <>
1587: nvl(p_rec.pty_information3, hr_api.g_varchar2) or
1588: nvl(pqp_pty_shd.g_old_rec.pty_information4, hr_api.g_varchar2) <>
1581: nvl(p_rec.pty_information_category, hr_api.g_varchar2) or
1582: nvl(pqp_pty_shd.g_old_rec.pty_information1, hr_api.g_varchar2) <>
1583: nvl(p_rec.pty_information1, hr_api.g_varchar2) or
1584: nvl(pqp_pty_shd.g_old_rec.pty_information2, hr_api.g_varchar2) <>
1585: nvl(p_rec.pty_information2, hr_api.g_varchar2) or
1586: nvl(pqp_pty_shd.g_old_rec.pty_information3, hr_api.g_varchar2) <>
1587: nvl(p_rec.pty_information3, hr_api.g_varchar2) or
1588: nvl(pqp_pty_shd.g_old_rec.pty_information4, hr_api.g_varchar2) <>
1589: nvl(p_rec.pty_information4, hr_api.g_varchar2) or
1582: nvl(pqp_pty_shd.g_old_rec.pty_information1, hr_api.g_varchar2) <>
1583: nvl(p_rec.pty_information1, hr_api.g_varchar2) or
1584: nvl(pqp_pty_shd.g_old_rec.pty_information2, hr_api.g_varchar2) <>
1585: nvl(p_rec.pty_information2, hr_api.g_varchar2) or
1586: nvl(pqp_pty_shd.g_old_rec.pty_information3, hr_api.g_varchar2) <>
1587: nvl(p_rec.pty_information3, hr_api.g_varchar2) or
1588: nvl(pqp_pty_shd.g_old_rec.pty_information4, hr_api.g_varchar2) <>
1589: nvl(p_rec.pty_information4, hr_api.g_varchar2) or
1590: nvl(pqp_pty_shd.g_old_rec.pty_information5, hr_api.g_varchar2) <>
1583: nvl(p_rec.pty_information1, hr_api.g_varchar2) or
1584: nvl(pqp_pty_shd.g_old_rec.pty_information2, hr_api.g_varchar2) <>
1585: nvl(p_rec.pty_information2, hr_api.g_varchar2) or
1586: nvl(pqp_pty_shd.g_old_rec.pty_information3, hr_api.g_varchar2) <>
1587: nvl(p_rec.pty_information3, hr_api.g_varchar2) or
1588: nvl(pqp_pty_shd.g_old_rec.pty_information4, hr_api.g_varchar2) <>
1589: nvl(p_rec.pty_information4, hr_api.g_varchar2) or
1590: nvl(pqp_pty_shd.g_old_rec.pty_information5, hr_api.g_varchar2) <>
1591: nvl(p_rec.pty_information5, hr_api.g_varchar2) or
1584: nvl(pqp_pty_shd.g_old_rec.pty_information2, hr_api.g_varchar2) <>
1585: nvl(p_rec.pty_information2, hr_api.g_varchar2) or
1586: nvl(pqp_pty_shd.g_old_rec.pty_information3, hr_api.g_varchar2) <>
1587: nvl(p_rec.pty_information3, hr_api.g_varchar2) or
1588: nvl(pqp_pty_shd.g_old_rec.pty_information4, hr_api.g_varchar2) <>
1589: nvl(p_rec.pty_information4, hr_api.g_varchar2) or
1590: nvl(pqp_pty_shd.g_old_rec.pty_information5, hr_api.g_varchar2) <>
1591: nvl(p_rec.pty_information5, hr_api.g_varchar2) or
1592: nvl(pqp_pty_shd.g_old_rec.pty_information6, hr_api.g_varchar2) <>
1585: nvl(p_rec.pty_information2, hr_api.g_varchar2) or
1586: nvl(pqp_pty_shd.g_old_rec.pty_information3, hr_api.g_varchar2) <>
1587: nvl(p_rec.pty_information3, hr_api.g_varchar2) or
1588: nvl(pqp_pty_shd.g_old_rec.pty_information4, hr_api.g_varchar2) <>
1589: nvl(p_rec.pty_information4, hr_api.g_varchar2) or
1590: nvl(pqp_pty_shd.g_old_rec.pty_information5, hr_api.g_varchar2) <>
1591: nvl(p_rec.pty_information5, hr_api.g_varchar2) or
1592: nvl(pqp_pty_shd.g_old_rec.pty_information6, hr_api.g_varchar2) <>
1593: nvl(p_rec.pty_information6, hr_api.g_varchar2) or
1586: nvl(pqp_pty_shd.g_old_rec.pty_information3, hr_api.g_varchar2) <>
1587: nvl(p_rec.pty_information3, hr_api.g_varchar2) or
1588: nvl(pqp_pty_shd.g_old_rec.pty_information4, hr_api.g_varchar2) <>
1589: nvl(p_rec.pty_information4, hr_api.g_varchar2) or
1590: nvl(pqp_pty_shd.g_old_rec.pty_information5, hr_api.g_varchar2) <>
1591: nvl(p_rec.pty_information5, hr_api.g_varchar2) or
1592: nvl(pqp_pty_shd.g_old_rec.pty_information6, hr_api.g_varchar2) <>
1593: nvl(p_rec.pty_information6, hr_api.g_varchar2) or
1594: nvl(pqp_pty_shd.g_old_rec.pty_information7, hr_api.g_varchar2) <>
1587: nvl(p_rec.pty_information3, hr_api.g_varchar2) or
1588: nvl(pqp_pty_shd.g_old_rec.pty_information4, hr_api.g_varchar2) <>
1589: nvl(p_rec.pty_information4, hr_api.g_varchar2) or
1590: nvl(pqp_pty_shd.g_old_rec.pty_information5, hr_api.g_varchar2) <>
1591: nvl(p_rec.pty_information5, hr_api.g_varchar2) or
1592: nvl(pqp_pty_shd.g_old_rec.pty_information6, hr_api.g_varchar2) <>
1593: nvl(p_rec.pty_information6, hr_api.g_varchar2) or
1594: nvl(pqp_pty_shd.g_old_rec.pty_information7, hr_api.g_varchar2) <>
1595: nvl(p_rec.pty_information7, hr_api.g_varchar2) or
1588: nvl(pqp_pty_shd.g_old_rec.pty_information4, hr_api.g_varchar2) <>
1589: nvl(p_rec.pty_information4, hr_api.g_varchar2) or
1590: nvl(pqp_pty_shd.g_old_rec.pty_information5, hr_api.g_varchar2) <>
1591: nvl(p_rec.pty_information5, hr_api.g_varchar2) or
1592: nvl(pqp_pty_shd.g_old_rec.pty_information6, hr_api.g_varchar2) <>
1593: nvl(p_rec.pty_information6, hr_api.g_varchar2) or
1594: nvl(pqp_pty_shd.g_old_rec.pty_information7, hr_api.g_varchar2) <>
1595: nvl(p_rec.pty_information7, hr_api.g_varchar2) or
1596: nvl(pqp_pty_shd.g_old_rec.pty_information8, hr_api.g_varchar2) <>
1589: nvl(p_rec.pty_information4, hr_api.g_varchar2) or
1590: nvl(pqp_pty_shd.g_old_rec.pty_information5, hr_api.g_varchar2) <>
1591: nvl(p_rec.pty_information5, hr_api.g_varchar2) or
1592: nvl(pqp_pty_shd.g_old_rec.pty_information6, hr_api.g_varchar2) <>
1593: nvl(p_rec.pty_information6, hr_api.g_varchar2) or
1594: nvl(pqp_pty_shd.g_old_rec.pty_information7, hr_api.g_varchar2) <>
1595: nvl(p_rec.pty_information7, hr_api.g_varchar2) or
1596: nvl(pqp_pty_shd.g_old_rec.pty_information8, hr_api.g_varchar2) <>
1597: nvl(p_rec.pty_information8, hr_api.g_varchar2) or
1590: nvl(pqp_pty_shd.g_old_rec.pty_information5, hr_api.g_varchar2) <>
1591: nvl(p_rec.pty_information5, hr_api.g_varchar2) or
1592: nvl(pqp_pty_shd.g_old_rec.pty_information6, hr_api.g_varchar2) <>
1593: nvl(p_rec.pty_information6, hr_api.g_varchar2) or
1594: nvl(pqp_pty_shd.g_old_rec.pty_information7, hr_api.g_varchar2) <>
1595: nvl(p_rec.pty_information7, hr_api.g_varchar2) or
1596: nvl(pqp_pty_shd.g_old_rec.pty_information8, hr_api.g_varchar2) <>
1597: nvl(p_rec.pty_information8, hr_api.g_varchar2) or
1598: nvl(pqp_pty_shd.g_old_rec.pty_information9, hr_api.g_varchar2) <>
1591: nvl(p_rec.pty_information5, hr_api.g_varchar2) or
1592: nvl(pqp_pty_shd.g_old_rec.pty_information6, hr_api.g_varchar2) <>
1593: nvl(p_rec.pty_information6, hr_api.g_varchar2) or
1594: nvl(pqp_pty_shd.g_old_rec.pty_information7, hr_api.g_varchar2) <>
1595: nvl(p_rec.pty_information7, hr_api.g_varchar2) or
1596: nvl(pqp_pty_shd.g_old_rec.pty_information8, hr_api.g_varchar2) <>
1597: nvl(p_rec.pty_information8, hr_api.g_varchar2) or
1598: nvl(pqp_pty_shd.g_old_rec.pty_information9, hr_api.g_varchar2) <>
1599: nvl(p_rec.pty_information9, hr_api.g_varchar2) or
1592: nvl(pqp_pty_shd.g_old_rec.pty_information6, hr_api.g_varchar2) <>
1593: nvl(p_rec.pty_information6, hr_api.g_varchar2) or
1594: nvl(pqp_pty_shd.g_old_rec.pty_information7, hr_api.g_varchar2) <>
1595: nvl(p_rec.pty_information7, hr_api.g_varchar2) or
1596: nvl(pqp_pty_shd.g_old_rec.pty_information8, hr_api.g_varchar2) <>
1597: nvl(p_rec.pty_information8, hr_api.g_varchar2) or
1598: nvl(pqp_pty_shd.g_old_rec.pty_information9, hr_api.g_varchar2) <>
1599: nvl(p_rec.pty_information9, hr_api.g_varchar2) or
1600: nvl(pqp_pty_shd.g_old_rec.pty_information10, hr_api.g_varchar2) <>
1593: nvl(p_rec.pty_information6, hr_api.g_varchar2) or
1594: nvl(pqp_pty_shd.g_old_rec.pty_information7, hr_api.g_varchar2) <>
1595: nvl(p_rec.pty_information7, hr_api.g_varchar2) or
1596: nvl(pqp_pty_shd.g_old_rec.pty_information8, hr_api.g_varchar2) <>
1597: nvl(p_rec.pty_information8, hr_api.g_varchar2) or
1598: nvl(pqp_pty_shd.g_old_rec.pty_information9, hr_api.g_varchar2) <>
1599: nvl(p_rec.pty_information9, hr_api.g_varchar2) or
1600: nvl(pqp_pty_shd.g_old_rec.pty_information10, hr_api.g_varchar2) <>
1601: nvl(p_rec.pty_information10, hr_api.g_varchar2) or
1594: nvl(pqp_pty_shd.g_old_rec.pty_information7, hr_api.g_varchar2) <>
1595: nvl(p_rec.pty_information7, hr_api.g_varchar2) or
1596: nvl(pqp_pty_shd.g_old_rec.pty_information8, hr_api.g_varchar2) <>
1597: nvl(p_rec.pty_information8, hr_api.g_varchar2) or
1598: nvl(pqp_pty_shd.g_old_rec.pty_information9, hr_api.g_varchar2) <>
1599: nvl(p_rec.pty_information9, hr_api.g_varchar2) or
1600: nvl(pqp_pty_shd.g_old_rec.pty_information10, hr_api.g_varchar2) <>
1601: nvl(p_rec.pty_information10, hr_api.g_varchar2) or
1602: nvl(pqp_pty_shd.g_old_rec.pty_information11, hr_api.g_varchar2) <>
1595: nvl(p_rec.pty_information7, hr_api.g_varchar2) or
1596: nvl(pqp_pty_shd.g_old_rec.pty_information8, hr_api.g_varchar2) <>
1597: nvl(p_rec.pty_information8, hr_api.g_varchar2) or
1598: nvl(pqp_pty_shd.g_old_rec.pty_information9, hr_api.g_varchar2) <>
1599: nvl(p_rec.pty_information9, hr_api.g_varchar2) or
1600: nvl(pqp_pty_shd.g_old_rec.pty_information10, hr_api.g_varchar2) <>
1601: nvl(p_rec.pty_information10, hr_api.g_varchar2) or
1602: nvl(pqp_pty_shd.g_old_rec.pty_information11, hr_api.g_varchar2) <>
1603: nvl(p_rec.pty_information11, hr_api.g_varchar2) or
1596: nvl(pqp_pty_shd.g_old_rec.pty_information8, hr_api.g_varchar2) <>
1597: nvl(p_rec.pty_information8, hr_api.g_varchar2) or
1598: nvl(pqp_pty_shd.g_old_rec.pty_information9, hr_api.g_varchar2) <>
1599: nvl(p_rec.pty_information9, hr_api.g_varchar2) or
1600: nvl(pqp_pty_shd.g_old_rec.pty_information10, hr_api.g_varchar2) <>
1601: nvl(p_rec.pty_information10, hr_api.g_varchar2) or
1602: nvl(pqp_pty_shd.g_old_rec.pty_information11, hr_api.g_varchar2) <>
1603: nvl(p_rec.pty_information11, hr_api.g_varchar2) or
1604: nvl(pqp_pty_shd.g_old_rec.pty_information12, hr_api.g_varchar2) <>
1597: nvl(p_rec.pty_information8, hr_api.g_varchar2) or
1598: nvl(pqp_pty_shd.g_old_rec.pty_information9, hr_api.g_varchar2) <>
1599: nvl(p_rec.pty_information9, hr_api.g_varchar2) or
1600: nvl(pqp_pty_shd.g_old_rec.pty_information10, hr_api.g_varchar2) <>
1601: nvl(p_rec.pty_information10, hr_api.g_varchar2) or
1602: nvl(pqp_pty_shd.g_old_rec.pty_information11, hr_api.g_varchar2) <>
1603: nvl(p_rec.pty_information11, hr_api.g_varchar2) or
1604: nvl(pqp_pty_shd.g_old_rec.pty_information12, hr_api.g_varchar2) <>
1605: nvl(p_rec.pty_information12, hr_api.g_varchar2) or
1598: nvl(pqp_pty_shd.g_old_rec.pty_information9, hr_api.g_varchar2) <>
1599: nvl(p_rec.pty_information9, hr_api.g_varchar2) or
1600: nvl(pqp_pty_shd.g_old_rec.pty_information10, hr_api.g_varchar2) <>
1601: nvl(p_rec.pty_information10, hr_api.g_varchar2) or
1602: nvl(pqp_pty_shd.g_old_rec.pty_information11, hr_api.g_varchar2) <>
1603: nvl(p_rec.pty_information11, hr_api.g_varchar2) or
1604: nvl(pqp_pty_shd.g_old_rec.pty_information12, hr_api.g_varchar2) <>
1605: nvl(p_rec.pty_information12, hr_api.g_varchar2) or
1606: nvl(pqp_pty_shd.g_old_rec.pty_information13, hr_api.g_varchar2) <>
1599: nvl(p_rec.pty_information9, hr_api.g_varchar2) or
1600: nvl(pqp_pty_shd.g_old_rec.pty_information10, hr_api.g_varchar2) <>
1601: nvl(p_rec.pty_information10, hr_api.g_varchar2) or
1602: nvl(pqp_pty_shd.g_old_rec.pty_information11, hr_api.g_varchar2) <>
1603: nvl(p_rec.pty_information11, hr_api.g_varchar2) or
1604: nvl(pqp_pty_shd.g_old_rec.pty_information12, hr_api.g_varchar2) <>
1605: nvl(p_rec.pty_information12, hr_api.g_varchar2) or
1606: nvl(pqp_pty_shd.g_old_rec.pty_information13, hr_api.g_varchar2) <>
1607: nvl(p_rec.pty_information13, hr_api.g_varchar2) or
1600: nvl(pqp_pty_shd.g_old_rec.pty_information10, hr_api.g_varchar2) <>
1601: nvl(p_rec.pty_information10, hr_api.g_varchar2) or
1602: nvl(pqp_pty_shd.g_old_rec.pty_information11, hr_api.g_varchar2) <>
1603: nvl(p_rec.pty_information11, hr_api.g_varchar2) or
1604: nvl(pqp_pty_shd.g_old_rec.pty_information12, hr_api.g_varchar2) <>
1605: nvl(p_rec.pty_information12, hr_api.g_varchar2) or
1606: nvl(pqp_pty_shd.g_old_rec.pty_information13, hr_api.g_varchar2) <>
1607: nvl(p_rec.pty_information13, hr_api.g_varchar2) or
1608: nvl(pqp_pty_shd.g_old_rec.pty_information14, hr_api.g_varchar2) <>
1601: nvl(p_rec.pty_information10, hr_api.g_varchar2) or
1602: nvl(pqp_pty_shd.g_old_rec.pty_information11, hr_api.g_varchar2) <>
1603: nvl(p_rec.pty_information11, hr_api.g_varchar2) or
1604: nvl(pqp_pty_shd.g_old_rec.pty_information12, hr_api.g_varchar2) <>
1605: nvl(p_rec.pty_information12, hr_api.g_varchar2) or
1606: nvl(pqp_pty_shd.g_old_rec.pty_information13, hr_api.g_varchar2) <>
1607: nvl(p_rec.pty_information13, hr_api.g_varchar2) or
1608: nvl(pqp_pty_shd.g_old_rec.pty_information14, hr_api.g_varchar2) <>
1609: nvl(p_rec.pty_information14, hr_api.g_varchar2) or
1602: nvl(pqp_pty_shd.g_old_rec.pty_information11, hr_api.g_varchar2) <>
1603: nvl(p_rec.pty_information11, hr_api.g_varchar2) or
1604: nvl(pqp_pty_shd.g_old_rec.pty_information12, hr_api.g_varchar2) <>
1605: nvl(p_rec.pty_information12, hr_api.g_varchar2) or
1606: nvl(pqp_pty_shd.g_old_rec.pty_information13, hr_api.g_varchar2) <>
1607: nvl(p_rec.pty_information13, hr_api.g_varchar2) or
1608: nvl(pqp_pty_shd.g_old_rec.pty_information14, hr_api.g_varchar2) <>
1609: nvl(p_rec.pty_information14, hr_api.g_varchar2) or
1610: nvl(pqp_pty_shd.g_old_rec.pty_information15, hr_api.g_varchar2) <>
1603: nvl(p_rec.pty_information11, hr_api.g_varchar2) or
1604: nvl(pqp_pty_shd.g_old_rec.pty_information12, hr_api.g_varchar2) <>
1605: nvl(p_rec.pty_information12, hr_api.g_varchar2) or
1606: nvl(pqp_pty_shd.g_old_rec.pty_information13, hr_api.g_varchar2) <>
1607: nvl(p_rec.pty_information13, hr_api.g_varchar2) or
1608: nvl(pqp_pty_shd.g_old_rec.pty_information14, hr_api.g_varchar2) <>
1609: nvl(p_rec.pty_information14, hr_api.g_varchar2) or
1610: nvl(pqp_pty_shd.g_old_rec.pty_information15, hr_api.g_varchar2) <>
1611: nvl(p_rec.pty_information15, hr_api.g_varchar2) or
1604: nvl(pqp_pty_shd.g_old_rec.pty_information12, hr_api.g_varchar2) <>
1605: nvl(p_rec.pty_information12, hr_api.g_varchar2) or
1606: nvl(pqp_pty_shd.g_old_rec.pty_information13, hr_api.g_varchar2) <>
1607: nvl(p_rec.pty_information13, hr_api.g_varchar2) or
1608: nvl(pqp_pty_shd.g_old_rec.pty_information14, hr_api.g_varchar2) <>
1609: nvl(p_rec.pty_information14, hr_api.g_varchar2) or
1610: nvl(pqp_pty_shd.g_old_rec.pty_information15, hr_api.g_varchar2) <>
1611: nvl(p_rec.pty_information15, hr_api.g_varchar2) or
1612: nvl(pqp_pty_shd.g_old_rec.pty_information16, hr_api.g_varchar2) <>
1605: nvl(p_rec.pty_information12, hr_api.g_varchar2) or
1606: nvl(pqp_pty_shd.g_old_rec.pty_information13, hr_api.g_varchar2) <>
1607: nvl(p_rec.pty_information13, hr_api.g_varchar2) or
1608: nvl(pqp_pty_shd.g_old_rec.pty_information14, hr_api.g_varchar2) <>
1609: nvl(p_rec.pty_information14, hr_api.g_varchar2) or
1610: nvl(pqp_pty_shd.g_old_rec.pty_information15, hr_api.g_varchar2) <>
1611: nvl(p_rec.pty_information15, hr_api.g_varchar2) or
1612: nvl(pqp_pty_shd.g_old_rec.pty_information16, hr_api.g_varchar2) <>
1613: nvl(p_rec.pty_information16, hr_api.g_varchar2) or
1606: nvl(pqp_pty_shd.g_old_rec.pty_information13, hr_api.g_varchar2) <>
1607: nvl(p_rec.pty_information13, hr_api.g_varchar2) or
1608: nvl(pqp_pty_shd.g_old_rec.pty_information14, hr_api.g_varchar2) <>
1609: nvl(p_rec.pty_information14, hr_api.g_varchar2) or
1610: nvl(pqp_pty_shd.g_old_rec.pty_information15, hr_api.g_varchar2) <>
1611: nvl(p_rec.pty_information15, hr_api.g_varchar2) or
1612: nvl(pqp_pty_shd.g_old_rec.pty_information16, hr_api.g_varchar2) <>
1613: nvl(p_rec.pty_information16, hr_api.g_varchar2) or
1614: nvl(pqp_pty_shd.g_old_rec.pty_information17, hr_api.g_varchar2) <>
1607: nvl(p_rec.pty_information13, hr_api.g_varchar2) or
1608: nvl(pqp_pty_shd.g_old_rec.pty_information14, hr_api.g_varchar2) <>
1609: nvl(p_rec.pty_information14, hr_api.g_varchar2) or
1610: nvl(pqp_pty_shd.g_old_rec.pty_information15, hr_api.g_varchar2) <>
1611: nvl(p_rec.pty_information15, hr_api.g_varchar2) or
1612: nvl(pqp_pty_shd.g_old_rec.pty_information16, hr_api.g_varchar2) <>
1613: nvl(p_rec.pty_information16, hr_api.g_varchar2) or
1614: nvl(pqp_pty_shd.g_old_rec.pty_information17, hr_api.g_varchar2) <>
1615: nvl(p_rec.pty_information17, hr_api.g_varchar2) or
1608: nvl(pqp_pty_shd.g_old_rec.pty_information14, hr_api.g_varchar2) <>
1609: nvl(p_rec.pty_information14, hr_api.g_varchar2) or
1610: nvl(pqp_pty_shd.g_old_rec.pty_information15, hr_api.g_varchar2) <>
1611: nvl(p_rec.pty_information15, hr_api.g_varchar2) or
1612: nvl(pqp_pty_shd.g_old_rec.pty_information16, hr_api.g_varchar2) <>
1613: nvl(p_rec.pty_information16, hr_api.g_varchar2) or
1614: nvl(pqp_pty_shd.g_old_rec.pty_information17, hr_api.g_varchar2) <>
1615: nvl(p_rec.pty_information17, hr_api.g_varchar2) or
1616: nvl(pqp_pty_shd.g_old_rec.pty_information18, hr_api.g_varchar2) <>
1609: nvl(p_rec.pty_information14, hr_api.g_varchar2) or
1610: nvl(pqp_pty_shd.g_old_rec.pty_information15, hr_api.g_varchar2) <>
1611: nvl(p_rec.pty_information15, hr_api.g_varchar2) or
1612: nvl(pqp_pty_shd.g_old_rec.pty_information16, hr_api.g_varchar2) <>
1613: nvl(p_rec.pty_information16, hr_api.g_varchar2) or
1614: nvl(pqp_pty_shd.g_old_rec.pty_information17, hr_api.g_varchar2) <>
1615: nvl(p_rec.pty_information17, hr_api.g_varchar2) or
1616: nvl(pqp_pty_shd.g_old_rec.pty_information18, hr_api.g_varchar2) <>
1617: nvl(p_rec.pty_information18, hr_api.g_varchar2) or
1610: nvl(pqp_pty_shd.g_old_rec.pty_information15, hr_api.g_varchar2) <>
1611: nvl(p_rec.pty_information15, hr_api.g_varchar2) or
1612: nvl(pqp_pty_shd.g_old_rec.pty_information16, hr_api.g_varchar2) <>
1613: nvl(p_rec.pty_information16, hr_api.g_varchar2) or
1614: nvl(pqp_pty_shd.g_old_rec.pty_information17, hr_api.g_varchar2) <>
1615: nvl(p_rec.pty_information17, hr_api.g_varchar2) or
1616: nvl(pqp_pty_shd.g_old_rec.pty_information18, hr_api.g_varchar2) <>
1617: nvl(p_rec.pty_information18, hr_api.g_varchar2) or
1618: nvl(pqp_pty_shd.g_old_rec.pty_information19, hr_api.g_varchar2) <>
1611: nvl(p_rec.pty_information15, hr_api.g_varchar2) or
1612: nvl(pqp_pty_shd.g_old_rec.pty_information16, hr_api.g_varchar2) <>
1613: nvl(p_rec.pty_information16, hr_api.g_varchar2) or
1614: nvl(pqp_pty_shd.g_old_rec.pty_information17, hr_api.g_varchar2) <>
1615: nvl(p_rec.pty_information17, hr_api.g_varchar2) or
1616: nvl(pqp_pty_shd.g_old_rec.pty_information18, hr_api.g_varchar2) <>
1617: nvl(p_rec.pty_information18, hr_api.g_varchar2) or
1618: nvl(pqp_pty_shd.g_old_rec.pty_information19, hr_api.g_varchar2) <>
1619: nvl(p_rec.pty_information19, hr_api.g_varchar2) or
1612: nvl(pqp_pty_shd.g_old_rec.pty_information16, hr_api.g_varchar2) <>
1613: nvl(p_rec.pty_information16, hr_api.g_varchar2) or
1614: nvl(pqp_pty_shd.g_old_rec.pty_information17, hr_api.g_varchar2) <>
1615: nvl(p_rec.pty_information17, hr_api.g_varchar2) or
1616: nvl(pqp_pty_shd.g_old_rec.pty_information18, hr_api.g_varchar2) <>
1617: nvl(p_rec.pty_information18, hr_api.g_varchar2) or
1618: nvl(pqp_pty_shd.g_old_rec.pty_information19, hr_api.g_varchar2) <>
1619: nvl(p_rec.pty_information19, hr_api.g_varchar2) or
1620: nvl(pqp_pty_shd.g_old_rec.pty_information20, hr_api.g_varchar2) <>
1613: nvl(p_rec.pty_information16, hr_api.g_varchar2) or
1614: nvl(pqp_pty_shd.g_old_rec.pty_information17, hr_api.g_varchar2) <>
1615: nvl(p_rec.pty_information17, hr_api.g_varchar2) or
1616: nvl(pqp_pty_shd.g_old_rec.pty_information18, hr_api.g_varchar2) <>
1617: nvl(p_rec.pty_information18, hr_api.g_varchar2) or
1618: nvl(pqp_pty_shd.g_old_rec.pty_information19, hr_api.g_varchar2) <>
1619: nvl(p_rec.pty_information19, hr_api.g_varchar2) or
1620: nvl(pqp_pty_shd.g_old_rec.pty_information20, hr_api.g_varchar2) <>
1621: nvl(p_rec.pty_information20, hr_api.g_varchar2) ))
1614: nvl(pqp_pty_shd.g_old_rec.pty_information17, hr_api.g_varchar2) <>
1615: nvl(p_rec.pty_information17, hr_api.g_varchar2) or
1616: nvl(pqp_pty_shd.g_old_rec.pty_information18, hr_api.g_varchar2) <>
1617: nvl(p_rec.pty_information18, hr_api.g_varchar2) or
1618: nvl(pqp_pty_shd.g_old_rec.pty_information19, hr_api.g_varchar2) <>
1619: nvl(p_rec.pty_information19, hr_api.g_varchar2) or
1620: nvl(pqp_pty_shd.g_old_rec.pty_information20, hr_api.g_varchar2) <>
1621: nvl(p_rec.pty_information20, hr_api.g_varchar2) ))
1622: or (p_rec.pension_type_id is null) then
1615: nvl(p_rec.pty_information17, hr_api.g_varchar2) or
1616: nvl(pqp_pty_shd.g_old_rec.pty_information18, hr_api.g_varchar2) <>
1617: nvl(p_rec.pty_information18, hr_api.g_varchar2) or
1618: nvl(pqp_pty_shd.g_old_rec.pty_information19, hr_api.g_varchar2) <>
1619: nvl(p_rec.pty_information19, hr_api.g_varchar2) or
1620: nvl(pqp_pty_shd.g_old_rec.pty_information20, hr_api.g_varchar2) <>
1621: nvl(p_rec.pty_information20, hr_api.g_varchar2) ))
1622: or (p_rec.pension_type_id is null) then
1623: --
1616: nvl(pqp_pty_shd.g_old_rec.pty_information18, hr_api.g_varchar2) <>
1617: nvl(p_rec.pty_information18, hr_api.g_varchar2) or
1618: nvl(pqp_pty_shd.g_old_rec.pty_information19, hr_api.g_varchar2) <>
1619: nvl(p_rec.pty_information19, hr_api.g_varchar2) or
1620: nvl(pqp_pty_shd.g_old_rec.pty_information20, hr_api.g_varchar2) <>
1621: nvl(p_rec.pty_information20, hr_api.g_varchar2) ))
1622: or (p_rec.pension_type_id is null) then
1623: --
1624: -- Only execute the validation if absolutely necessary:
1617: nvl(p_rec.pty_information18, hr_api.g_varchar2) or
1618: nvl(pqp_pty_shd.g_old_rec.pty_information19, hr_api.g_varchar2) <>
1619: nvl(p_rec.pty_information19, hr_api.g_varchar2) or
1620: nvl(pqp_pty_shd.g_old_rec.pty_information20, hr_api.g_varchar2) <>
1621: nvl(p_rec.pty_information20, hr_api.g_varchar2) ))
1622: or (p_rec.pension_type_id is null) then
1623: --
1624: -- Only execute the validation if absolutely necessary:
1625: -- a) During update, the structure column value or any
1713: begin
1714: hr_utility.set_location('Entering:'||l_proc,10);
1715: --
1716: if ((p_rec.pension_type_id is not null) and (
1717: nvl(pqp_pty_shd.g_old_rec.pty_attribute_category, hr_api.g_varchar2) <>
1718: nvl(p_rec.pty_attribute_category, hr_api.g_varchar2) or
1719: nvl(pqp_pty_shd.g_old_rec.pty_attribute1, hr_api.g_varchar2) <>
1720: nvl(p_rec.pty_attribute1, hr_api.g_varchar2) or
1721: nvl(pqp_pty_shd.g_old_rec.pty_attribute2, hr_api.g_varchar2) <>
1714: hr_utility.set_location('Entering:'||l_proc,10);
1715: --
1716: if ((p_rec.pension_type_id is not null) and (
1717: nvl(pqp_pty_shd.g_old_rec.pty_attribute_category, hr_api.g_varchar2) <>
1718: nvl(p_rec.pty_attribute_category, hr_api.g_varchar2) or
1719: nvl(pqp_pty_shd.g_old_rec.pty_attribute1, hr_api.g_varchar2) <>
1720: nvl(p_rec.pty_attribute1, hr_api.g_varchar2) or
1721: nvl(pqp_pty_shd.g_old_rec.pty_attribute2, hr_api.g_varchar2) <>
1722: nvl(p_rec.pty_attribute2, hr_api.g_varchar2) or
1715: --
1716: if ((p_rec.pension_type_id is not null) and (
1717: nvl(pqp_pty_shd.g_old_rec.pty_attribute_category, hr_api.g_varchar2) <>
1718: nvl(p_rec.pty_attribute_category, hr_api.g_varchar2) or
1719: nvl(pqp_pty_shd.g_old_rec.pty_attribute1, hr_api.g_varchar2) <>
1720: nvl(p_rec.pty_attribute1, hr_api.g_varchar2) or
1721: nvl(pqp_pty_shd.g_old_rec.pty_attribute2, hr_api.g_varchar2) <>
1722: nvl(p_rec.pty_attribute2, hr_api.g_varchar2) or
1723: nvl(pqp_pty_shd.g_old_rec.pty_attribute3, hr_api.g_varchar2) <>
1716: if ((p_rec.pension_type_id is not null) and (
1717: nvl(pqp_pty_shd.g_old_rec.pty_attribute_category, hr_api.g_varchar2) <>
1718: nvl(p_rec.pty_attribute_category, hr_api.g_varchar2) or
1719: nvl(pqp_pty_shd.g_old_rec.pty_attribute1, hr_api.g_varchar2) <>
1720: nvl(p_rec.pty_attribute1, hr_api.g_varchar2) or
1721: nvl(pqp_pty_shd.g_old_rec.pty_attribute2, hr_api.g_varchar2) <>
1722: nvl(p_rec.pty_attribute2, hr_api.g_varchar2) or
1723: nvl(pqp_pty_shd.g_old_rec.pty_attribute3, hr_api.g_varchar2) <>
1724: nvl(p_rec.pty_attribute3, hr_api.g_varchar2) or
1717: nvl(pqp_pty_shd.g_old_rec.pty_attribute_category, hr_api.g_varchar2) <>
1718: nvl(p_rec.pty_attribute_category, hr_api.g_varchar2) or
1719: nvl(pqp_pty_shd.g_old_rec.pty_attribute1, hr_api.g_varchar2) <>
1720: nvl(p_rec.pty_attribute1, hr_api.g_varchar2) or
1721: nvl(pqp_pty_shd.g_old_rec.pty_attribute2, hr_api.g_varchar2) <>
1722: nvl(p_rec.pty_attribute2, hr_api.g_varchar2) or
1723: nvl(pqp_pty_shd.g_old_rec.pty_attribute3, hr_api.g_varchar2) <>
1724: nvl(p_rec.pty_attribute3, hr_api.g_varchar2) or
1725: nvl(pqp_pty_shd.g_old_rec.pty_attribute4, hr_api.g_varchar2) <>
1718: nvl(p_rec.pty_attribute_category, hr_api.g_varchar2) or
1719: nvl(pqp_pty_shd.g_old_rec.pty_attribute1, hr_api.g_varchar2) <>
1720: nvl(p_rec.pty_attribute1, hr_api.g_varchar2) or
1721: nvl(pqp_pty_shd.g_old_rec.pty_attribute2, hr_api.g_varchar2) <>
1722: nvl(p_rec.pty_attribute2, hr_api.g_varchar2) or
1723: nvl(pqp_pty_shd.g_old_rec.pty_attribute3, hr_api.g_varchar2) <>
1724: nvl(p_rec.pty_attribute3, hr_api.g_varchar2) or
1725: nvl(pqp_pty_shd.g_old_rec.pty_attribute4, hr_api.g_varchar2) <>
1726: nvl(p_rec.pty_attribute4, hr_api.g_varchar2) or
1719: nvl(pqp_pty_shd.g_old_rec.pty_attribute1, hr_api.g_varchar2) <>
1720: nvl(p_rec.pty_attribute1, hr_api.g_varchar2) or
1721: nvl(pqp_pty_shd.g_old_rec.pty_attribute2, hr_api.g_varchar2) <>
1722: nvl(p_rec.pty_attribute2, hr_api.g_varchar2) or
1723: nvl(pqp_pty_shd.g_old_rec.pty_attribute3, hr_api.g_varchar2) <>
1724: nvl(p_rec.pty_attribute3, hr_api.g_varchar2) or
1725: nvl(pqp_pty_shd.g_old_rec.pty_attribute4, hr_api.g_varchar2) <>
1726: nvl(p_rec.pty_attribute4, hr_api.g_varchar2) or
1727: nvl(pqp_pty_shd.g_old_rec.pty_attribute5, hr_api.g_varchar2) <>
1720: nvl(p_rec.pty_attribute1, hr_api.g_varchar2) or
1721: nvl(pqp_pty_shd.g_old_rec.pty_attribute2, hr_api.g_varchar2) <>
1722: nvl(p_rec.pty_attribute2, hr_api.g_varchar2) or
1723: nvl(pqp_pty_shd.g_old_rec.pty_attribute3, hr_api.g_varchar2) <>
1724: nvl(p_rec.pty_attribute3, hr_api.g_varchar2) or
1725: nvl(pqp_pty_shd.g_old_rec.pty_attribute4, hr_api.g_varchar2) <>
1726: nvl(p_rec.pty_attribute4, hr_api.g_varchar2) or
1727: nvl(pqp_pty_shd.g_old_rec.pty_attribute5, hr_api.g_varchar2) <>
1728: nvl(p_rec.pty_attribute5, hr_api.g_varchar2) or
1721: nvl(pqp_pty_shd.g_old_rec.pty_attribute2, hr_api.g_varchar2) <>
1722: nvl(p_rec.pty_attribute2, hr_api.g_varchar2) or
1723: nvl(pqp_pty_shd.g_old_rec.pty_attribute3, hr_api.g_varchar2) <>
1724: nvl(p_rec.pty_attribute3, hr_api.g_varchar2) or
1725: nvl(pqp_pty_shd.g_old_rec.pty_attribute4, hr_api.g_varchar2) <>
1726: nvl(p_rec.pty_attribute4, hr_api.g_varchar2) or
1727: nvl(pqp_pty_shd.g_old_rec.pty_attribute5, hr_api.g_varchar2) <>
1728: nvl(p_rec.pty_attribute5, hr_api.g_varchar2) or
1729: nvl(pqp_pty_shd.g_old_rec.pty_attribute6, hr_api.g_varchar2) <>
1722: nvl(p_rec.pty_attribute2, hr_api.g_varchar2) or
1723: nvl(pqp_pty_shd.g_old_rec.pty_attribute3, hr_api.g_varchar2) <>
1724: nvl(p_rec.pty_attribute3, hr_api.g_varchar2) or
1725: nvl(pqp_pty_shd.g_old_rec.pty_attribute4, hr_api.g_varchar2) <>
1726: nvl(p_rec.pty_attribute4, hr_api.g_varchar2) or
1727: nvl(pqp_pty_shd.g_old_rec.pty_attribute5, hr_api.g_varchar2) <>
1728: nvl(p_rec.pty_attribute5, hr_api.g_varchar2) or
1729: nvl(pqp_pty_shd.g_old_rec.pty_attribute6, hr_api.g_varchar2) <>
1730: nvl(p_rec.pty_attribute6, hr_api.g_varchar2) or
1723: nvl(pqp_pty_shd.g_old_rec.pty_attribute3, hr_api.g_varchar2) <>
1724: nvl(p_rec.pty_attribute3, hr_api.g_varchar2) or
1725: nvl(pqp_pty_shd.g_old_rec.pty_attribute4, hr_api.g_varchar2) <>
1726: nvl(p_rec.pty_attribute4, hr_api.g_varchar2) or
1727: nvl(pqp_pty_shd.g_old_rec.pty_attribute5, hr_api.g_varchar2) <>
1728: nvl(p_rec.pty_attribute5, hr_api.g_varchar2) or
1729: nvl(pqp_pty_shd.g_old_rec.pty_attribute6, hr_api.g_varchar2) <>
1730: nvl(p_rec.pty_attribute6, hr_api.g_varchar2) or
1731: nvl(pqp_pty_shd.g_old_rec.pty_attribute7, hr_api.g_varchar2) <>
1724: nvl(p_rec.pty_attribute3, hr_api.g_varchar2) or
1725: nvl(pqp_pty_shd.g_old_rec.pty_attribute4, hr_api.g_varchar2) <>
1726: nvl(p_rec.pty_attribute4, hr_api.g_varchar2) or
1727: nvl(pqp_pty_shd.g_old_rec.pty_attribute5, hr_api.g_varchar2) <>
1728: nvl(p_rec.pty_attribute5, hr_api.g_varchar2) or
1729: nvl(pqp_pty_shd.g_old_rec.pty_attribute6, hr_api.g_varchar2) <>
1730: nvl(p_rec.pty_attribute6, hr_api.g_varchar2) or
1731: nvl(pqp_pty_shd.g_old_rec.pty_attribute7, hr_api.g_varchar2) <>
1732: nvl(p_rec.pty_attribute7, hr_api.g_varchar2) or
1725: nvl(pqp_pty_shd.g_old_rec.pty_attribute4, hr_api.g_varchar2) <>
1726: nvl(p_rec.pty_attribute4, hr_api.g_varchar2) or
1727: nvl(pqp_pty_shd.g_old_rec.pty_attribute5, hr_api.g_varchar2) <>
1728: nvl(p_rec.pty_attribute5, hr_api.g_varchar2) or
1729: nvl(pqp_pty_shd.g_old_rec.pty_attribute6, hr_api.g_varchar2) <>
1730: nvl(p_rec.pty_attribute6, hr_api.g_varchar2) or
1731: nvl(pqp_pty_shd.g_old_rec.pty_attribute7, hr_api.g_varchar2) <>
1732: nvl(p_rec.pty_attribute7, hr_api.g_varchar2) or
1733: nvl(pqp_pty_shd.g_old_rec.pty_attribute8, hr_api.g_varchar2) <>
1726: nvl(p_rec.pty_attribute4, hr_api.g_varchar2) or
1727: nvl(pqp_pty_shd.g_old_rec.pty_attribute5, hr_api.g_varchar2) <>
1728: nvl(p_rec.pty_attribute5, hr_api.g_varchar2) or
1729: nvl(pqp_pty_shd.g_old_rec.pty_attribute6, hr_api.g_varchar2) <>
1730: nvl(p_rec.pty_attribute6, hr_api.g_varchar2) or
1731: nvl(pqp_pty_shd.g_old_rec.pty_attribute7, hr_api.g_varchar2) <>
1732: nvl(p_rec.pty_attribute7, hr_api.g_varchar2) or
1733: nvl(pqp_pty_shd.g_old_rec.pty_attribute8, hr_api.g_varchar2) <>
1734: nvl(p_rec.pty_attribute8, hr_api.g_varchar2) or
1727: nvl(pqp_pty_shd.g_old_rec.pty_attribute5, hr_api.g_varchar2) <>
1728: nvl(p_rec.pty_attribute5, hr_api.g_varchar2) or
1729: nvl(pqp_pty_shd.g_old_rec.pty_attribute6, hr_api.g_varchar2) <>
1730: nvl(p_rec.pty_attribute6, hr_api.g_varchar2) or
1731: nvl(pqp_pty_shd.g_old_rec.pty_attribute7, hr_api.g_varchar2) <>
1732: nvl(p_rec.pty_attribute7, hr_api.g_varchar2) or
1733: nvl(pqp_pty_shd.g_old_rec.pty_attribute8, hr_api.g_varchar2) <>
1734: nvl(p_rec.pty_attribute8, hr_api.g_varchar2) or
1735: nvl(pqp_pty_shd.g_old_rec.pty_attribute9, hr_api.g_varchar2) <>
1728: nvl(p_rec.pty_attribute5, hr_api.g_varchar2) or
1729: nvl(pqp_pty_shd.g_old_rec.pty_attribute6, hr_api.g_varchar2) <>
1730: nvl(p_rec.pty_attribute6, hr_api.g_varchar2) or
1731: nvl(pqp_pty_shd.g_old_rec.pty_attribute7, hr_api.g_varchar2) <>
1732: nvl(p_rec.pty_attribute7, hr_api.g_varchar2) or
1733: nvl(pqp_pty_shd.g_old_rec.pty_attribute8, hr_api.g_varchar2) <>
1734: nvl(p_rec.pty_attribute8, hr_api.g_varchar2) or
1735: nvl(pqp_pty_shd.g_old_rec.pty_attribute9, hr_api.g_varchar2) <>
1736: nvl(p_rec.pty_attribute9, hr_api.g_varchar2) or
1729: nvl(pqp_pty_shd.g_old_rec.pty_attribute6, hr_api.g_varchar2) <>
1730: nvl(p_rec.pty_attribute6, hr_api.g_varchar2) or
1731: nvl(pqp_pty_shd.g_old_rec.pty_attribute7, hr_api.g_varchar2) <>
1732: nvl(p_rec.pty_attribute7, hr_api.g_varchar2) or
1733: nvl(pqp_pty_shd.g_old_rec.pty_attribute8, hr_api.g_varchar2) <>
1734: nvl(p_rec.pty_attribute8, hr_api.g_varchar2) or
1735: nvl(pqp_pty_shd.g_old_rec.pty_attribute9, hr_api.g_varchar2) <>
1736: nvl(p_rec.pty_attribute9, hr_api.g_varchar2) or
1737: nvl(pqp_pty_shd.g_old_rec.pty_attribute10, hr_api.g_varchar2) <>
1730: nvl(p_rec.pty_attribute6, hr_api.g_varchar2) or
1731: nvl(pqp_pty_shd.g_old_rec.pty_attribute7, hr_api.g_varchar2) <>
1732: nvl(p_rec.pty_attribute7, hr_api.g_varchar2) or
1733: nvl(pqp_pty_shd.g_old_rec.pty_attribute8, hr_api.g_varchar2) <>
1734: nvl(p_rec.pty_attribute8, hr_api.g_varchar2) or
1735: nvl(pqp_pty_shd.g_old_rec.pty_attribute9, hr_api.g_varchar2) <>
1736: nvl(p_rec.pty_attribute9, hr_api.g_varchar2) or
1737: nvl(pqp_pty_shd.g_old_rec.pty_attribute10, hr_api.g_varchar2) <>
1738: nvl(p_rec.pty_attribute10, hr_api.g_varchar2) or
1731: nvl(pqp_pty_shd.g_old_rec.pty_attribute7, hr_api.g_varchar2) <>
1732: nvl(p_rec.pty_attribute7, hr_api.g_varchar2) or
1733: nvl(pqp_pty_shd.g_old_rec.pty_attribute8, hr_api.g_varchar2) <>
1734: nvl(p_rec.pty_attribute8, hr_api.g_varchar2) or
1735: nvl(pqp_pty_shd.g_old_rec.pty_attribute9, hr_api.g_varchar2) <>
1736: nvl(p_rec.pty_attribute9, hr_api.g_varchar2) or
1737: nvl(pqp_pty_shd.g_old_rec.pty_attribute10, hr_api.g_varchar2) <>
1738: nvl(p_rec.pty_attribute10, hr_api.g_varchar2) or
1739: nvl(pqp_pty_shd.g_old_rec.pty_attribute11, hr_api.g_varchar2) <>
1732: nvl(p_rec.pty_attribute7, hr_api.g_varchar2) or
1733: nvl(pqp_pty_shd.g_old_rec.pty_attribute8, hr_api.g_varchar2) <>
1734: nvl(p_rec.pty_attribute8, hr_api.g_varchar2) or
1735: nvl(pqp_pty_shd.g_old_rec.pty_attribute9, hr_api.g_varchar2) <>
1736: nvl(p_rec.pty_attribute9, hr_api.g_varchar2) or
1737: nvl(pqp_pty_shd.g_old_rec.pty_attribute10, hr_api.g_varchar2) <>
1738: nvl(p_rec.pty_attribute10, hr_api.g_varchar2) or
1739: nvl(pqp_pty_shd.g_old_rec.pty_attribute11, hr_api.g_varchar2) <>
1740: nvl(p_rec.pty_attribute11, hr_api.g_varchar2) or
1733: nvl(pqp_pty_shd.g_old_rec.pty_attribute8, hr_api.g_varchar2) <>
1734: nvl(p_rec.pty_attribute8, hr_api.g_varchar2) or
1735: nvl(pqp_pty_shd.g_old_rec.pty_attribute9, hr_api.g_varchar2) <>
1736: nvl(p_rec.pty_attribute9, hr_api.g_varchar2) or
1737: nvl(pqp_pty_shd.g_old_rec.pty_attribute10, hr_api.g_varchar2) <>
1738: nvl(p_rec.pty_attribute10, hr_api.g_varchar2) or
1739: nvl(pqp_pty_shd.g_old_rec.pty_attribute11, hr_api.g_varchar2) <>
1740: nvl(p_rec.pty_attribute11, hr_api.g_varchar2) or
1741: nvl(pqp_pty_shd.g_old_rec.pty_attribute12, hr_api.g_varchar2) <>
1734: nvl(p_rec.pty_attribute8, hr_api.g_varchar2) or
1735: nvl(pqp_pty_shd.g_old_rec.pty_attribute9, hr_api.g_varchar2) <>
1736: nvl(p_rec.pty_attribute9, hr_api.g_varchar2) or
1737: nvl(pqp_pty_shd.g_old_rec.pty_attribute10, hr_api.g_varchar2) <>
1738: nvl(p_rec.pty_attribute10, hr_api.g_varchar2) or
1739: nvl(pqp_pty_shd.g_old_rec.pty_attribute11, hr_api.g_varchar2) <>
1740: nvl(p_rec.pty_attribute11, hr_api.g_varchar2) or
1741: nvl(pqp_pty_shd.g_old_rec.pty_attribute12, hr_api.g_varchar2) <>
1742: nvl(p_rec.pty_attribute12, hr_api.g_varchar2) or
1735: nvl(pqp_pty_shd.g_old_rec.pty_attribute9, hr_api.g_varchar2) <>
1736: nvl(p_rec.pty_attribute9, hr_api.g_varchar2) or
1737: nvl(pqp_pty_shd.g_old_rec.pty_attribute10, hr_api.g_varchar2) <>
1738: nvl(p_rec.pty_attribute10, hr_api.g_varchar2) or
1739: nvl(pqp_pty_shd.g_old_rec.pty_attribute11, hr_api.g_varchar2) <>
1740: nvl(p_rec.pty_attribute11, hr_api.g_varchar2) or
1741: nvl(pqp_pty_shd.g_old_rec.pty_attribute12, hr_api.g_varchar2) <>
1742: nvl(p_rec.pty_attribute12, hr_api.g_varchar2) or
1743: nvl(pqp_pty_shd.g_old_rec.pty_attribute13, hr_api.g_varchar2) <>
1736: nvl(p_rec.pty_attribute9, hr_api.g_varchar2) or
1737: nvl(pqp_pty_shd.g_old_rec.pty_attribute10, hr_api.g_varchar2) <>
1738: nvl(p_rec.pty_attribute10, hr_api.g_varchar2) or
1739: nvl(pqp_pty_shd.g_old_rec.pty_attribute11, hr_api.g_varchar2) <>
1740: nvl(p_rec.pty_attribute11, hr_api.g_varchar2) or
1741: nvl(pqp_pty_shd.g_old_rec.pty_attribute12, hr_api.g_varchar2) <>
1742: nvl(p_rec.pty_attribute12, hr_api.g_varchar2) or
1743: nvl(pqp_pty_shd.g_old_rec.pty_attribute13, hr_api.g_varchar2) <>
1744: nvl(p_rec.pty_attribute13, hr_api.g_varchar2) or
1737: nvl(pqp_pty_shd.g_old_rec.pty_attribute10, hr_api.g_varchar2) <>
1738: nvl(p_rec.pty_attribute10, hr_api.g_varchar2) or
1739: nvl(pqp_pty_shd.g_old_rec.pty_attribute11, hr_api.g_varchar2) <>
1740: nvl(p_rec.pty_attribute11, hr_api.g_varchar2) or
1741: nvl(pqp_pty_shd.g_old_rec.pty_attribute12, hr_api.g_varchar2) <>
1742: nvl(p_rec.pty_attribute12, hr_api.g_varchar2) or
1743: nvl(pqp_pty_shd.g_old_rec.pty_attribute13, hr_api.g_varchar2) <>
1744: nvl(p_rec.pty_attribute13, hr_api.g_varchar2) or
1745: nvl(pqp_pty_shd.g_old_rec.pty_attribute14, hr_api.g_varchar2) <>
1738: nvl(p_rec.pty_attribute10, hr_api.g_varchar2) or
1739: nvl(pqp_pty_shd.g_old_rec.pty_attribute11, hr_api.g_varchar2) <>
1740: nvl(p_rec.pty_attribute11, hr_api.g_varchar2) or
1741: nvl(pqp_pty_shd.g_old_rec.pty_attribute12, hr_api.g_varchar2) <>
1742: nvl(p_rec.pty_attribute12, hr_api.g_varchar2) or
1743: nvl(pqp_pty_shd.g_old_rec.pty_attribute13, hr_api.g_varchar2) <>
1744: nvl(p_rec.pty_attribute13, hr_api.g_varchar2) or
1745: nvl(pqp_pty_shd.g_old_rec.pty_attribute14, hr_api.g_varchar2) <>
1746: nvl(p_rec.pty_attribute14, hr_api.g_varchar2) or
1739: nvl(pqp_pty_shd.g_old_rec.pty_attribute11, hr_api.g_varchar2) <>
1740: nvl(p_rec.pty_attribute11, hr_api.g_varchar2) or
1741: nvl(pqp_pty_shd.g_old_rec.pty_attribute12, hr_api.g_varchar2) <>
1742: nvl(p_rec.pty_attribute12, hr_api.g_varchar2) or
1743: nvl(pqp_pty_shd.g_old_rec.pty_attribute13, hr_api.g_varchar2) <>
1744: nvl(p_rec.pty_attribute13, hr_api.g_varchar2) or
1745: nvl(pqp_pty_shd.g_old_rec.pty_attribute14, hr_api.g_varchar2) <>
1746: nvl(p_rec.pty_attribute14, hr_api.g_varchar2) or
1747: nvl(pqp_pty_shd.g_old_rec.pty_attribute15, hr_api.g_varchar2) <>
1740: nvl(p_rec.pty_attribute11, hr_api.g_varchar2) or
1741: nvl(pqp_pty_shd.g_old_rec.pty_attribute12, hr_api.g_varchar2) <>
1742: nvl(p_rec.pty_attribute12, hr_api.g_varchar2) or
1743: nvl(pqp_pty_shd.g_old_rec.pty_attribute13, hr_api.g_varchar2) <>
1744: nvl(p_rec.pty_attribute13, hr_api.g_varchar2) or
1745: nvl(pqp_pty_shd.g_old_rec.pty_attribute14, hr_api.g_varchar2) <>
1746: nvl(p_rec.pty_attribute14, hr_api.g_varchar2) or
1747: nvl(pqp_pty_shd.g_old_rec.pty_attribute15, hr_api.g_varchar2) <>
1748: nvl(p_rec.pty_attribute15, hr_api.g_varchar2) or
1741: nvl(pqp_pty_shd.g_old_rec.pty_attribute12, hr_api.g_varchar2) <>
1742: nvl(p_rec.pty_attribute12, hr_api.g_varchar2) or
1743: nvl(pqp_pty_shd.g_old_rec.pty_attribute13, hr_api.g_varchar2) <>
1744: nvl(p_rec.pty_attribute13, hr_api.g_varchar2) or
1745: nvl(pqp_pty_shd.g_old_rec.pty_attribute14, hr_api.g_varchar2) <>
1746: nvl(p_rec.pty_attribute14, hr_api.g_varchar2) or
1747: nvl(pqp_pty_shd.g_old_rec.pty_attribute15, hr_api.g_varchar2) <>
1748: nvl(p_rec.pty_attribute15, hr_api.g_varchar2) or
1749: nvl(pqp_pty_shd.g_old_rec.pty_attribute16, hr_api.g_varchar2) <>
1742: nvl(p_rec.pty_attribute12, hr_api.g_varchar2) or
1743: nvl(pqp_pty_shd.g_old_rec.pty_attribute13, hr_api.g_varchar2) <>
1744: nvl(p_rec.pty_attribute13, hr_api.g_varchar2) or
1745: nvl(pqp_pty_shd.g_old_rec.pty_attribute14, hr_api.g_varchar2) <>
1746: nvl(p_rec.pty_attribute14, hr_api.g_varchar2) or
1747: nvl(pqp_pty_shd.g_old_rec.pty_attribute15, hr_api.g_varchar2) <>
1748: nvl(p_rec.pty_attribute15, hr_api.g_varchar2) or
1749: nvl(pqp_pty_shd.g_old_rec.pty_attribute16, hr_api.g_varchar2) <>
1750: nvl(p_rec.pty_attribute16, hr_api.g_varchar2) or
1743: nvl(pqp_pty_shd.g_old_rec.pty_attribute13, hr_api.g_varchar2) <>
1744: nvl(p_rec.pty_attribute13, hr_api.g_varchar2) or
1745: nvl(pqp_pty_shd.g_old_rec.pty_attribute14, hr_api.g_varchar2) <>
1746: nvl(p_rec.pty_attribute14, hr_api.g_varchar2) or
1747: nvl(pqp_pty_shd.g_old_rec.pty_attribute15, hr_api.g_varchar2) <>
1748: nvl(p_rec.pty_attribute15, hr_api.g_varchar2) or
1749: nvl(pqp_pty_shd.g_old_rec.pty_attribute16, hr_api.g_varchar2) <>
1750: nvl(p_rec.pty_attribute16, hr_api.g_varchar2) or
1751: nvl(pqp_pty_shd.g_old_rec.pty_attribute17, hr_api.g_varchar2) <>
1744: nvl(p_rec.pty_attribute13, hr_api.g_varchar2) or
1745: nvl(pqp_pty_shd.g_old_rec.pty_attribute14, hr_api.g_varchar2) <>
1746: nvl(p_rec.pty_attribute14, hr_api.g_varchar2) or
1747: nvl(pqp_pty_shd.g_old_rec.pty_attribute15, hr_api.g_varchar2) <>
1748: nvl(p_rec.pty_attribute15, hr_api.g_varchar2) or
1749: nvl(pqp_pty_shd.g_old_rec.pty_attribute16, hr_api.g_varchar2) <>
1750: nvl(p_rec.pty_attribute16, hr_api.g_varchar2) or
1751: nvl(pqp_pty_shd.g_old_rec.pty_attribute17, hr_api.g_varchar2) <>
1752: nvl(p_rec.pty_attribute17, hr_api.g_varchar2) or
1745: nvl(pqp_pty_shd.g_old_rec.pty_attribute14, hr_api.g_varchar2) <>
1746: nvl(p_rec.pty_attribute14, hr_api.g_varchar2) or
1747: nvl(pqp_pty_shd.g_old_rec.pty_attribute15, hr_api.g_varchar2) <>
1748: nvl(p_rec.pty_attribute15, hr_api.g_varchar2) or
1749: nvl(pqp_pty_shd.g_old_rec.pty_attribute16, hr_api.g_varchar2) <>
1750: nvl(p_rec.pty_attribute16, hr_api.g_varchar2) or
1751: nvl(pqp_pty_shd.g_old_rec.pty_attribute17, hr_api.g_varchar2) <>
1752: nvl(p_rec.pty_attribute17, hr_api.g_varchar2) or
1753: nvl(pqp_pty_shd.g_old_rec.pty_attribute18, hr_api.g_varchar2) <>
1746: nvl(p_rec.pty_attribute14, hr_api.g_varchar2) or
1747: nvl(pqp_pty_shd.g_old_rec.pty_attribute15, hr_api.g_varchar2) <>
1748: nvl(p_rec.pty_attribute15, hr_api.g_varchar2) or
1749: nvl(pqp_pty_shd.g_old_rec.pty_attribute16, hr_api.g_varchar2) <>
1750: nvl(p_rec.pty_attribute16, hr_api.g_varchar2) or
1751: nvl(pqp_pty_shd.g_old_rec.pty_attribute17, hr_api.g_varchar2) <>
1752: nvl(p_rec.pty_attribute17, hr_api.g_varchar2) or
1753: nvl(pqp_pty_shd.g_old_rec.pty_attribute18, hr_api.g_varchar2) <>
1754: nvl(p_rec.pty_attribute18, hr_api.g_varchar2) or
1747: nvl(pqp_pty_shd.g_old_rec.pty_attribute15, hr_api.g_varchar2) <>
1748: nvl(p_rec.pty_attribute15, hr_api.g_varchar2) or
1749: nvl(pqp_pty_shd.g_old_rec.pty_attribute16, hr_api.g_varchar2) <>
1750: nvl(p_rec.pty_attribute16, hr_api.g_varchar2) or
1751: nvl(pqp_pty_shd.g_old_rec.pty_attribute17, hr_api.g_varchar2) <>
1752: nvl(p_rec.pty_attribute17, hr_api.g_varchar2) or
1753: nvl(pqp_pty_shd.g_old_rec.pty_attribute18, hr_api.g_varchar2) <>
1754: nvl(p_rec.pty_attribute18, hr_api.g_varchar2) or
1755: nvl(pqp_pty_shd.g_old_rec.pty_attribute19, hr_api.g_varchar2) <>
1748: nvl(p_rec.pty_attribute15, hr_api.g_varchar2) or
1749: nvl(pqp_pty_shd.g_old_rec.pty_attribute16, hr_api.g_varchar2) <>
1750: nvl(p_rec.pty_attribute16, hr_api.g_varchar2) or
1751: nvl(pqp_pty_shd.g_old_rec.pty_attribute17, hr_api.g_varchar2) <>
1752: nvl(p_rec.pty_attribute17, hr_api.g_varchar2) or
1753: nvl(pqp_pty_shd.g_old_rec.pty_attribute18, hr_api.g_varchar2) <>
1754: nvl(p_rec.pty_attribute18, hr_api.g_varchar2) or
1755: nvl(pqp_pty_shd.g_old_rec.pty_attribute19, hr_api.g_varchar2) <>
1756: nvl(p_rec.pty_attribute19, hr_api.g_varchar2) or
1749: nvl(pqp_pty_shd.g_old_rec.pty_attribute16, hr_api.g_varchar2) <>
1750: nvl(p_rec.pty_attribute16, hr_api.g_varchar2) or
1751: nvl(pqp_pty_shd.g_old_rec.pty_attribute17, hr_api.g_varchar2) <>
1752: nvl(p_rec.pty_attribute17, hr_api.g_varchar2) or
1753: nvl(pqp_pty_shd.g_old_rec.pty_attribute18, hr_api.g_varchar2) <>
1754: nvl(p_rec.pty_attribute18, hr_api.g_varchar2) or
1755: nvl(pqp_pty_shd.g_old_rec.pty_attribute19, hr_api.g_varchar2) <>
1756: nvl(p_rec.pty_attribute19, hr_api.g_varchar2) or
1757: nvl(pqp_pty_shd.g_old_rec.pty_attribute20, hr_api.g_varchar2) <>
1750: nvl(p_rec.pty_attribute16, hr_api.g_varchar2) or
1751: nvl(pqp_pty_shd.g_old_rec.pty_attribute17, hr_api.g_varchar2) <>
1752: nvl(p_rec.pty_attribute17, hr_api.g_varchar2) or
1753: nvl(pqp_pty_shd.g_old_rec.pty_attribute18, hr_api.g_varchar2) <>
1754: nvl(p_rec.pty_attribute18, hr_api.g_varchar2) or
1755: nvl(pqp_pty_shd.g_old_rec.pty_attribute19, hr_api.g_varchar2) <>
1756: nvl(p_rec.pty_attribute19, hr_api.g_varchar2) or
1757: nvl(pqp_pty_shd.g_old_rec.pty_attribute20, hr_api.g_varchar2) <>
1758: nvl(p_rec.pty_attribute20, hr_api.g_varchar2) ))
1751: nvl(pqp_pty_shd.g_old_rec.pty_attribute17, hr_api.g_varchar2) <>
1752: nvl(p_rec.pty_attribute17, hr_api.g_varchar2) or
1753: nvl(pqp_pty_shd.g_old_rec.pty_attribute18, hr_api.g_varchar2) <>
1754: nvl(p_rec.pty_attribute18, hr_api.g_varchar2) or
1755: nvl(pqp_pty_shd.g_old_rec.pty_attribute19, hr_api.g_varchar2) <>
1756: nvl(p_rec.pty_attribute19, hr_api.g_varchar2) or
1757: nvl(pqp_pty_shd.g_old_rec.pty_attribute20, hr_api.g_varchar2) <>
1758: nvl(p_rec.pty_attribute20, hr_api.g_varchar2) ))
1759: or (p_rec.pension_type_id is null) then
1752: nvl(p_rec.pty_attribute17, hr_api.g_varchar2) or
1753: nvl(pqp_pty_shd.g_old_rec.pty_attribute18, hr_api.g_varchar2) <>
1754: nvl(p_rec.pty_attribute18, hr_api.g_varchar2) or
1755: nvl(pqp_pty_shd.g_old_rec.pty_attribute19, hr_api.g_varchar2) <>
1756: nvl(p_rec.pty_attribute19, hr_api.g_varchar2) or
1757: nvl(pqp_pty_shd.g_old_rec.pty_attribute20, hr_api.g_varchar2) <>
1758: nvl(p_rec.pty_attribute20, hr_api.g_varchar2) ))
1759: or (p_rec.pension_type_id is null) then
1760: --
1753: nvl(pqp_pty_shd.g_old_rec.pty_attribute18, hr_api.g_varchar2) <>
1754: nvl(p_rec.pty_attribute18, hr_api.g_varchar2) or
1755: nvl(pqp_pty_shd.g_old_rec.pty_attribute19, hr_api.g_varchar2) <>
1756: nvl(p_rec.pty_attribute19, hr_api.g_varchar2) or
1757: nvl(pqp_pty_shd.g_old_rec.pty_attribute20, hr_api.g_varchar2) <>
1758: nvl(p_rec.pty_attribute20, hr_api.g_varchar2) ))
1759: or (p_rec.pension_type_id is null) then
1760: --
1761: -- Only execute the validation if absolutely necessary:
1754: nvl(p_rec.pty_attribute18, hr_api.g_varchar2) or
1755: nvl(pqp_pty_shd.g_old_rec.pty_attribute19, hr_api.g_varchar2) <>
1756: nvl(p_rec.pty_attribute19, hr_api.g_varchar2) or
1757: nvl(pqp_pty_shd.g_old_rec.pty_attribute20, hr_api.g_varchar2) <>
1758: nvl(p_rec.pty_attribute20, hr_api.g_varchar2) ))
1759: or (p_rec.pension_type_id is null) then
1760: --
1761: -- Only execute the validation if absolutely necessary:
1762: -- a) During update, the structure column value or any
1908: Begin
1909: --
1910: -- Ensure that the p_datetrack_mode argument is not null
1911: --
1912: hr_api.mandatory_arg_error
1913: (p_api_name => l_proc
1914: ,p_argument => 'datetrack_mode'
1915: ,p_argument_value => p_datetrack_mode
1916: );
1918: -- Mode will be valid, as this is checked at the start of the upd.
1919: --
1920: -- Ensure the arguments are not null
1921: --
1922: hr_api.mandatory_arg_error
1923: (p_api_name => l_proc
1924: ,p_argument => 'validation_start_date'
1925: ,p_argument_value => p_validation_start_date
1926: );
1924: ,p_argument => 'validation_start_date'
1925: ,p_argument_value => p_validation_start_date
1926: );
1927: --
1928: hr_api.mandatory_arg_error
1929: (p_api_name => l_proc
1930: ,p_argument => 'validation_end_date'
1931: ,p_argument_value => p_validation_end_date
1932: );
1992: Begin
1993: --
1994: -- Ensure that the p_datetrack_mode argument is not null
1995: --
1996: hr_api.mandatory_arg_error
1997: (p_api_name => l_proc
1998: ,p_argument => 'datetrack_mode'
1999: ,p_argument_value => p_datetrack_mode
2000: );
2001: --
2002: -- Only perform the validation if the datetrack mode is either
2003: -- DELETE or ZAP
2004: --
2005: If (p_datetrack_mode = hr_api.g_delete or
2006: p_datetrack_mode = hr_api.g_zap) then
2007: --
2008: --
2009: -- Ensure the arguments are not null
2002: -- Only perform the validation if the datetrack mode is either
2003: -- DELETE or ZAP
2004: --
2005: If (p_datetrack_mode = hr_api.g_delete or
2006: p_datetrack_mode = hr_api.g_zap) then
2007: --
2008: --
2009: -- Ensure the arguments are not null
2010: --
2007: --
2008: --
2009: -- Ensure the arguments are not null
2010: --
2011: hr_api.mandatory_arg_error
2012: (p_api_name => l_proc
2013: ,p_argument => 'validation_start_date'
2014: ,p_argument_value => p_validation_start_date
2015: );
2013: ,p_argument => 'validation_start_date'
2014: ,p_argument_value => p_validation_start_date
2015: );
2016: --
2017: hr_api.mandatory_arg_error
2018: (p_api_name => l_proc
2019: ,p_argument => 'validation_end_date'
2020: ,p_argument_value => p_validation_end_date
2021: );
2019: ,p_argument => 'validation_end_date'
2020: ,p_argument_value => p_validation_end_date
2021: );
2022: --
2023: hr_api.mandatory_arg_error
2024: (p_api_name => l_proc
2025: ,p_argument => 'pension_type_id'
2026: ,p_argument_value => p_pension_type_id
2027: );
2145: NOT IN ('GENERIC','STARTUP') THEN
2146: --
2147: -- Validate Important Attributes
2148: --
2149: hr_api.validate_bus_grp_id
2150: (p_business_group_id => p_rec.business_group_id
2151: ,p_associated_column1 => pqp_pty_shd.g_tab_nam
2152: || '.BUSINESS_GROUP_ID');
2153: --
2437: NOT IN ('GENERIC','STARTUP') THEN
2438: --
2439: -- Validate Important Attributes
2440: --
2441: hr_api.validate_bus_grp_id
2442: (p_business_group_id => p_rec.business_group_id
2443: ,p_associated_column1 => pqp_pty_shd.g_tab_nam
2444: || '.BUSINESS_GROUP_ID');
2445: --
2790: --
2791: If p_datetrack_mode ='ZAP' Then
2792:
2793: IF p_rec.business_group_id IS NOT NULL THEN
2794: l_legislation_code := hr_api.return_legislation_code (
2795: p_business_group_id => p_rec.business_group_id
2796: );
2797: ELSE
2798: l_legislation_code := p_rec.legislation_code;