eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_PPD_BUS dependencies on HR_API

Line 47: hr_api.mandatory_arg_error

43: hr_utility.set_location('Entering:'|| l_proc, 10);
44: --
45: -- Ensure that all the mandatory parameter are not null
46: --
47: hr_api.mandatory_arg_error
48: (p_api_name => l_proc
49: ,p_argument => 'paye_details_id'
50: ,p_argument_value => p_paye_details_id
51: );

Line 74: hr_api.set_security_group_id

70: close csr_sec_grp;
71: --
72: -- Set the security_group_id in CLIENT_INFO
73: --
74: hr_api.set_security_group_id
75: (p_security_group_id => l_security_group_id
76: );
77: --
78: -- Set the sessions legislation context in HR_SESSION_DATA

Line 80: hr_api.set_legislation_context(l_legislation_code);

76: );
77: --
78: -- Set the sessions legislation context in HR_SESSION_DATA
79: --
80: hr_api.set_legislation_context(l_legislation_code);
81: end if;
82: --
83: hr_utility.set_location(' Leaving:'|| l_proc, 20);
84: --

Line 116: hr_api.mandatory_arg_error

112: hr_utility.set_location('Entering:'|| l_proc, 10);
113: --
114: -- Ensure that all the mandatory parameter are not null
115: --
116: hr_api.mandatory_arg_error
117: (p_api_name => l_proc
118: ,p_argument => 'paye_details_id'
119: ,p_argument_value => p_paye_details_id
120: );

Line 122: if ( nvl(pay_ppd_bus.g_paye_details_id, hr_api.g_number)

118: ,p_argument => 'paye_details_id'
119: ,p_argument_value => p_paye_details_id
120: );
121: --
122: if ( nvl(pay_ppd_bus.g_paye_details_id, hr_api.g_number)
123: = p_paye_details_id) then
124: --
125: -- The legislation code has already been found with a previous
126: -- call to this function. Just return the value in the global

Line 220: if nvl(p_rec.business_group_id, hr_api.g_number) <>

216: fnd_message.set_token('STEP ', '5');
217: fnd_message.raise_error;
218: END IF;
219: --
220: if nvl(p_rec.business_group_id, hr_api.g_number) <>
221: nvl(pay_ppd_shd.g_old_rec.business_group_id
222: ,hr_api.g_number
223: ) then
224: hr_api.argument_changed_error

Line 222: ,hr_api.g_number

218: END IF;
219: --
220: if nvl(p_rec.business_group_id, hr_api.g_number) <>
221: nvl(pay_ppd_shd.g_old_rec.business_group_id
222: ,hr_api.g_number
223: ) then
224: hr_api.argument_changed_error
225: (p_api_name => l_proc
226: ,p_argument => 'BUSINESS_GROUP_ID'

Line 224: hr_api.argument_changed_error

220: if nvl(p_rec.business_group_id, hr_api.g_number) <>
221: nvl(pay_ppd_shd.g_old_rec.business_group_id
222: ,hr_api.g_number
223: ) then
224: hr_api.argument_changed_error
225: (p_api_name => l_proc
226: ,p_argument => 'BUSINESS_GROUP_ID'
227: ,p_base_table => pay_ppd_shd.g_tab_nam
228: );

Line 231: if nvl(p_rec.contract_category, hr_api.g_varchar2) <>

227: ,p_base_table => pay_ppd_shd.g_tab_nam
228: );
229: end if;
230:
231: if nvl(p_rec.contract_category, hr_api.g_varchar2) <>
232: nvl(pay_ppd_shd.g_old_rec.contract_category
233: ,hr_api.g_varchar2
234: ) then
235: hr_api.argument_changed_error

Line 233: ,hr_api.g_varchar2

229: end if;
230:
231: if nvl(p_rec.contract_category, hr_api.g_varchar2) <>
232: nvl(pay_ppd_shd.g_old_rec.contract_category
233: ,hr_api.g_varchar2
234: ) then
235: hr_api.argument_changed_error
236: (p_api_name => l_proc
237: ,p_argument => 'CONTRACT_CATEGORY'

Line 235: hr_api.argument_changed_error

231: if nvl(p_rec.contract_category, hr_api.g_varchar2) <>
232: nvl(pay_ppd_shd.g_old_rec.contract_category
233: ,hr_api.g_varchar2
234: ) then
235: hr_api.argument_changed_error
236: (p_api_name => l_proc
237: ,p_argument => 'CONTRACT_CATEGORY'
238: ,p_base_table => pay_ppd_shd.g_tab_nam
239: );

Line 242: if nvl(p_rec.per_or_asg_id, hr_api.g_number) <>

238: ,p_base_table => pay_ppd_shd.g_tab_nam
239: );
240: end if;
241:
242: if nvl(p_rec.per_or_asg_id, hr_api.g_number) <>
243: nvl(pay_ppd_shd.g_old_rec.per_or_asg_id
244: ,hr_api.g_number
245: ) then
246: hr_api.argument_changed_error

Line 244: ,hr_api.g_number

240: end if;
241:
242: if nvl(p_rec.per_or_asg_id, hr_api.g_number) <>
243: nvl(pay_ppd_shd.g_old_rec.per_or_asg_id
244: ,hr_api.g_number
245: ) then
246: hr_api.argument_changed_error
247: (p_api_name => l_proc
248: ,p_argument => 'PER_OR_ASG_ID'

Line 246: hr_api.argument_changed_error

242: if nvl(p_rec.per_or_asg_id, hr_api.g_number) <>
243: nvl(pay_ppd_shd.g_old_rec.per_or_asg_id
244: ,hr_api.g_number
245: ) then
246: hr_api.argument_changed_error
247: (p_api_name => l_proc
248: ,p_argument => 'PER_OR_ASG_ID'
249: ,p_base_table => pay_ppd_shd.g_tab_nam
250: );

Line 254: if nvl(p_rec.income_reduction, hr_api.g_varchar2) <>

250: );
251: end if;
252: -- Check to Income Reduction for CIVIL contract its non updateable
253: If p_rec.contract_category in ('CIVIL','LUMP','F_LUMP') then
254: if nvl(p_rec.income_reduction, hr_api.g_varchar2) <>
255: nvl(pay_ppd_shd.g_old_rec.income_reduction
256: ,hr_api.g_varchar2
257: ) then
258: hr_api.argument_changed_error

Line 256: ,hr_api.g_varchar2

252: -- Check to Income Reduction for CIVIL contract its non updateable
253: If p_rec.contract_category in ('CIVIL','LUMP','F_LUMP') then
254: if nvl(p_rec.income_reduction, hr_api.g_varchar2) <>
255: nvl(pay_ppd_shd.g_old_rec.income_reduction
256: ,hr_api.g_varchar2
257: ) then
258: hr_api.argument_changed_error
259: (p_api_name => l_proc
260: ,p_argument => 'INCOME_REDUCTION'

Line 258: hr_api.argument_changed_error

254: if nvl(p_rec.income_reduction, hr_api.g_varchar2) <>
255: nvl(pay_ppd_shd.g_old_rec.income_reduction
256: ,hr_api.g_varchar2
257: ) then
258: hr_api.argument_changed_error
259: (p_api_name => l_proc
260: ,p_argument => 'INCOME_REDUCTION'
261: ,p_base_table => pay_ppd_shd.g_tab_nam
262: );

Line 277: if nvl(p_rec.rate_of_tax, hr_api.g_varchar2) <>

273: fetch csr_contract_type into l_contract_type;
274: close csr_contract_type;
275:
276: if l_contract_type in ('L01','L02','L03','L04','L09','L10','L11') then
277: if nvl(p_rec.rate_of_tax, hr_api.g_varchar2) <>
278: nvl(pay_ppd_shd.g_old_rec.rate_of_tax
279: ,hr_api.g_varchar2
280: ) then
281: hr_api.argument_changed_error

Line 279: ,hr_api.g_varchar2

275:
276: if l_contract_type in ('L01','L02','L03','L04','L09','L10','L11') then
277: if nvl(p_rec.rate_of_tax, hr_api.g_varchar2) <>
278: nvl(pay_ppd_shd.g_old_rec.rate_of_tax
279: ,hr_api.g_varchar2
280: ) then
281: hr_api.argument_changed_error
282: (p_api_name => l_proc
283: ,p_argument => 'RATE_OF_TAX'

Line 281: hr_api.argument_changed_error

277: if nvl(p_rec.rate_of_tax, hr_api.g_varchar2) <>
278: nvl(pay_ppd_shd.g_old_rec.rate_of_tax
279: ,hr_api.g_varchar2
280: ) then
281: hr_api.argument_changed_error
282: (p_api_name => l_proc
283: ,p_argument => 'RATE_OF_TAX'
284: ,p_base_table => pay_ppd_shd.g_tab_nam
285: );

Line 333: hr_api.mandatory_arg_error

329: Begin
330: --
331: -- Ensure that the p_datetrack_mode argument is not null
332: --
333: hr_api.mandatory_arg_error
334: (p_api_name => l_proc
335: ,p_argument => 'datetrack_mode'
336: ,p_argument_value => p_datetrack_mode
337: );

Line 343: hr_api.mandatory_arg_error

339: -- Mode will be valid, as this is checked at the start of the upd.
340: --
341: -- Ensure the arguments are not null
342: --
343: hr_api.mandatory_arg_error
344: (p_api_name => l_proc
345: ,p_argument => 'validation_start_date'
346: ,p_argument_value => p_validation_start_date
347: );

Line 349: hr_api.mandatory_arg_error

345: ,p_argument => 'validation_start_date'
346: ,p_argument_value => p_validation_start_date
347: );
348: --
349: hr_api.mandatory_arg_error
350: (p_api_name => l_proc
351: ,p_argument => 'validation_end_date'
352: ,p_argument_value => p_validation_end_date
353: );

Line 417: hr_api.mandatory_arg_error

413: Begin
414: --
415: -- Ensure that the p_datetrack_mode argument is not null
416: --
417: hr_api.mandatory_arg_error
418: (p_api_name => l_proc
419: ,p_argument => 'datetrack_mode'
420: ,p_argument_value => p_datetrack_mode
421: );

Line 426: If (p_datetrack_mode = hr_api.g_delete or

422: --
423: -- Only perform the validation if the datetrack mode is either
424: -- DELETE or ZAP
425: --
426: If (p_datetrack_mode = hr_api.g_delete or
427: p_datetrack_mode = hr_api.g_zap) then
428: --
429: --
430: -- Ensure the arguments are not null

Line 427: p_datetrack_mode = hr_api.g_zap) then

423: -- Only perform the validation if the datetrack mode is either
424: -- DELETE or ZAP
425: --
426: If (p_datetrack_mode = hr_api.g_delete or
427: p_datetrack_mode = hr_api.g_zap) then
428: --
429: --
430: -- Ensure the arguments are not null
431: --

Line 432: hr_api.mandatory_arg_error

428: --
429: --
430: -- Ensure the arguments are not null
431: --
432: hr_api.mandatory_arg_error
433: (p_api_name => l_proc
434: ,p_argument => 'validation_start_date'
435: ,p_argument_value => p_validation_start_date
436: );

Line 438: hr_api.mandatory_arg_error

434: ,p_argument => 'validation_start_date'
435: ,p_argument_value => p_validation_start_date
436: );
437: --
438: hr_api.mandatory_arg_error
439: (p_api_name => l_proc
440: ,p_argument => 'validation_end_date'
441: ,p_argument_value => p_validation_end_date
442: );

Line 444: hr_api.mandatory_arg_error

440: ,p_argument => 'validation_end_date'
441: ,p_argument_value => p_validation_end_date
442: );
443: --
444: hr_api.mandatory_arg_error
445: (p_api_name => l_proc
446: ,p_argument => 'paye_details_id'
447: ,p_argument_value => p_paye_details_id
448: );

Line 485: hr_api.validate_bus_grp_id

481: hr_utility.set_location('Entering:'||l_proc, 5);
482: --
483: -- Call all supporting business operations
484: --
485: hr_api.validate_bus_grp_id
486: (p_business_group_id => p_rec.business_group_id
487: ,p_associated_column1 => pay_ppd_shd.g_tab_nam
488: || '.BUSINESS_GROUP_ID');
489: --

Line 581: hr_api.validate_bus_grp_id

577: hr_utility.set_location('Entering:'||l_proc, 5);
578: --
579: -- Call all supporting business operations
580: --
581: hr_api.validate_bus_grp_id
582: (p_business_group_id => p_rec.business_group_id
583: ,p_associated_column1 => pay_ppd_shd.g_tab_nam
584: || '.BUSINESS_GROUP_ID');
585: --

Line 697: hr_api.mandatory_arg_error

693:
694: --
695: -- Check mandatory parameters have been set
696: --
697: hr_api.mandatory_arg_error
698: (p_api_name => l_proc
699: ,p_argument => 'effective date'
700: ,p_argument_value => p_effective_date
701: );

Line 703: hr_api.mandatory_arg_error

699: ,p_argument => 'effective date'
700: ,p_argument_value => p_effective_date
701: );
702:
703: hr_api.mandatory_arg_error
704: (p_api_name => l_proc
705: ,p_argument => hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_CATEGORY')
706: ,p_argument_value => p_contract_category
707: );

Line 714: if hr_api.not_exists_in_dt_hr_lookups

710: -- Check if the Contract Category value exists in hr_lookups
711: -- where the lookup_type is 'PL_CONTRACT_CATEGORY'
712: --
713: if p_contract_category is not null then
714: if hr_api.not_exists_in_dt_hr_lookups
715: (p_effective_date => p_effective_date
716: ,p_validation_start_date => p_validation_start_date
717: ,p_validation_end_date => p_validation_end_date
718: ,p_lookup_type => 'PL_CONTRACT_CATEGORY'

Line 811: hr_api.mandatory_arg_error

807:
808: --
809: -- Check mandatory parameters have been set
810: --
811: hr_api.mandatory_arg_error
812: (p_api_name => l_proc
813: ,p_argument => 'effective date'
814: ,p_argument_value => p_effective_date
815: );

Line 817: hr_api.mandatory_arg_error

813: ,p_argument => 'effective date'
814: ,p_argument_value => p_effective_date
815: );
816:
817: hr_api.mandatory_arg_error
818: (p_api_name => l_proc
819: ,p_argument => hr_general.decode_lookup('PL_FORM_LABELS','PER_ASG_ID')
820: ,p_argument_value => p_per_or_asg_id
821: );

Line 904: hr_api.mandatory_arg_error

900:
901: --
902: -- Check mandatory parameters have been set
903: --
904: hr_api.mandatory_arg_error
905: (p_api_name => l_proc
906: ,p_argument => 'effective date'
907: ,p_argument_value => p_effective_date
908: );

Line 910: hr_api.mandatory_arg_error

906: ,p_argument => 'effective date'
907: ,p_argument_value => p_effective_date
908: );
909:
910: hr_api.mandatory_arg_error
911: (p_api_name => l_proc
912: ,p_argument => hr_general.decode_lookup('PL_FORM_LABELS','BUSINESS_GROUP')
913: ,p_argument_value => p_business_group_id
914: );

Line 916: hr_api.validate_bus_grp_id

912: ,p_argument => hr_general.decode_lookup('PL_FORM_LABELS','BUSINESS_GROUP')
913: ,p_argument_value => p_business_group_id
914: );
915:
916: hr_api.validate_bus_grp_id
917: (p_business_group_id => p_business_group_id
918: ,p_associated_column1 => pay_ppd_shd.g_tab_nam||'.BUSINESS_GROUP_ID');
919:
920: hr_multi_message.end_validation_set;

Line 985: hr_api.mandatory_arg_error

981: -- b) CONTRACT_CATEGORY are valid.
982:
983: -- Check mandatory parameters have been set
984: --
985: hr_api.mandatory_arg_error
986: (p_api_name => l_proc
987: ,p_argument => 'effective date'
988: ,p_argument_value => p_effective_date
989: );

Line 992: hr_api.mandatory_arg_error

988: ,p_argument_value => p_effective_date
989: );
990:
991: if p_contract_category in ('NORMAL','TERM_NORMAL','CIVIL','F_LUMP') then
992: hr_api.mandatory_arg_error
993: (p_api_name => l_proc
994: ,p_argument => hr_general.decode_lookup('PL_FORM_LABELS','RATE_OF_TAX')
995: ,p_argument_value => p_rate_of_tax
996: );

Line 1011: hr_api.g_varchar2)

1007: ,p_effective_date => p_effective_date
1008: ,p_object_version_number => p_object_version_number);
1009:
1010: if ((l_api_updating and nvl(pay_ppd_shd.g_old_rec.rate_of_tax,
1011: hr_api.g_varchar2)
1012: <> nvl(p_rate_of_tax,hr_api.g_varchar2)) or
1013: (NOT l_api_updating)) then
1014:
1015: --

Line 1012: <> nvl(p_rate_of_tax,hr_api.g_varchar2)) or

1008: ,p_object_version_number => p_object_version_number);
1009:
1010: if ((l_api_updating and nvl(pay_ppd_shd.g_old_rec.rate_of_tax,
1011: hr_api.g_varchar2)
1012: <> nvl(p_rate_of_tax,hr_api.g_varchar2)) or
1013: (NOT l_api_updating)) then
1014:
1015: --
1016: -- If Rate of tax is not null then

Line 1022: if hr_api.not_exists_in_dt_hr_lookups

1018: -- where the lookup_type is 'PL_CIVIL_RATE_OF_TAX' or 'PL_NORMAL_RATE_OF_TAX' based on the contract category
1019: --
1020: if p_rate_of_tax is not null then
1021: if p_contract_category in ('NORMAL','TERM_NORMAL') then
1022: if hr_api.not_exists_in_dt_hr_lookups
1023: (p_effective_date => p_effective_date
1024: ,p_validation_start_date => p_validation_start_date
1025: ,p_validation_end_date => p_validation_end_date
1026: ,p_lookup_type => 'PL_NORMAL_RATE_OF_TAX'

Line 1035: if hr_api.not_exists_in_dt_hr_lookups

1031: -- This message will be 'Ensure that you enter a valid tax rate for this employee.'
1032: hr_utility.raise_error;
1033: end if;
1034: elsif p_contract_category = 'CIVIL' then
1035: if hr_api.not_exists_in_dt_hr_lookups
1036: (p_effective_date => p_effective_date
1037: ,p_validation_start_date => p_validation_start_date
1038: ,p_validation_end_date => p_validation_end_date
1039: ,p_lookup_type => 'PL_CIVIL_RATE_OF_TAX'

Line 1106: hr_api.mandatory_arg_error

1102:
1103: --
1104: -- Check mandatory parameters have been set
1105: --
1106: hr_api.mandatory_arg_error
1107: (p_api_name => l_proc
1108: ,p_argument => 'effective date'
1109: ,p_argument_value => p_effective_date
1110: );

Line 1112: hr_api.mandatory_arg_error

1108: ,p_argument => 'effective date'
1109: ,p_argument_value => p_effective_date
1110: );
1111:
1112: hr_api.mandatory_arg_error
1113: (p_api_name => l_proc
1114: ,p_argument => hr_general.decode_lookup('PL_FORM_LABELS','TAX_REDUCTION')
1115: ,p_argument_value => p_tax_reduction
1116: );

Line 1130: hr_api.g_varchar2)

1126: ,p_effective_date => p_effective_date
1127: ,p_object_version_number => p_object_version_number);
1128:
1129: if ((l_api_updating and nvl(pay_ppd_shd.g_old_rec.tax_reduction,
1130: hr_api.g_varchar2)
1131: <> nvl(p_tax_reduction,hr_api.g_varchar2)) or
1132: (NOT l_api_updating)) then
1133:
1134: --

Line 1131: <> nvl(p_tax_reduction,hr_api.g_varchar2)) or

1127: ,p_object_version_number => p_object_version_number);
1128:
1129: if ((l_api_updating and nvl(pay_ppd_shd.g_old_rec.tax_reduction,
1130: hr_api.g_varchar2)
1131: <> nvl(p_tax_reduction,hr_api.g_varchar2)) or
1132: (NOT l_api_updating)) then
1133:
1134: --
1135: -- If Tax Reduction is not null then

Line 1140: if hr_api.not_exists_in_dt_hr_lookups

1136: -- Check if the Tax Reduction value exists in hr_lookups
1137: -- where the lookup_type is 'PL_TAX_REDUCTION'
1138: --
1139: if p_tax_reduction is not null then
1140: if hr_api.not_exists_in_dt_hr_lookups
1141: (p_effective_date => p_effective_date
1142: ,p_validation_start_date => p_validation_start_date
1143: ,p_validation_end_date => p_validation_end_date
1144: ,p_lookup_type => 'PL_TAX_REDUCTION'

Line 1191: hr_api.mandatory_arg_error

1187:
1188: --
1189: -- Check mandatory parameters have been set
1190: --
1191: hr_api.mandatory_arg_error
1192: (p_api_name => l_proc
1193: ,p_argument => 'effective date'
1194: ,p_argument_value => p_effective_date
1195: );

Line 1197: hr_api.mandatory_arg_error

1193: ,p_argument => 'effective date'
1194: ,p_argument_value => p_effective_date
1195: );
1196:
1197: hr_api.mandatory_arg_error
1198: (p_api_name => l_proc
1199: ,p_argument => hr_general.decode_lookup('PL_FORM_LABELS','TAX_CALC_WITH_SPOUSE_CHILD')
1200: ,p_argument_value => p_tax_calc_with_spouse_child
1201: );

Line 1215: hr_api.g_varchar2)

1211: ,p_effective_date => p_effective_date
1212: ,p_object_version_number => p_object_version_number);
1213:
1214: if ((l_api_updating and nvl(pay_ppd_shd.g_old_rec.tax_calc_with_spouse_child,
1215: hr_api.g_varchar2)
1216: <> nvl(p_tax_calc_with_spouse_child,hr_api.g_varchar2)) or
1217: (NOT l_api_updating)) then
1218:
1219: --

Line 1216: <> nvl(p_tax_calc_with_spouse_child,hr_api.g_varchar2)) or

1212: ,p_object_version_number => p_object_version_number);
1213:
1214: if ((l_api_updating and nvl(pay_ppd_shd.g_old_rec.tax_calc_with_spouse_child,
1215: hr_api.g_varchar2)
1216: <> nvl(p_tax_calc_with_spouse_child,hr_api.g_varchar2)) or
1217: (NOT l_api_updating)) then
1218:
1219: --
1220: -- If Tax Reduction is not null then

Line 1225: if hr_api.not_exists_in_dt_hr_lookups

1221: -- Check if the Tax Calculation with Spouse or Child value exists in hr_lookups
1222: -- where the lookup_type is 'YES_NO'
1223: --
1224: if p_tax_calc_with_spouse_child is not null then
1225: if hr_api.not_exists_in_dt_hr_lookups
1226: (p_effective_date => p_effective_date
1227: ,p_validation_start_date => p_validation_start_date
1228: ,p_validation_end_date => p_validation_end_date
1229: ,p_lookup_type => 'YES_NO'

Line 1276: hr_api.mandatory_arg_error

1272:
1273: --
1274: -- Check mandatory parameters have been set
1275: --
1276: hr_api.mandatory_arg_error
1277: (p_api_name => l_proc
1278: ,p_argument => 'effective date'
1279: ,p_argument_value => p_effective_date
1280: );

Line 1282: hr_api.mandatory_arg_error

1278: ,p_argument => 'effective date'
1279: ,p_argument_value => p_effective_date
1280: );
1281:
1282: hr_api.mandatory_arg_error
1283: (p_api_name => l_proc
1284: ,p_argument => hr_general.decode_lookup('PL_FORM_LABELS','INCOME_REDUCTION')
1285: ,p_argument_value => p_income_reduction
1286: );

Line 1300: hr_api.g_varchar2)

1296: ,p_effective_date => p_effective_date
1297: ,p_object_version_number => p_object_version_number);
1298:
1299: if ((l_api_updating and nvl(pay_ppd_shd.g_old_rec.income_reduction,
1300: hr_api.g_varchar2)
1301: <> nvl(p_income_reduction,hr_api.g_varchar2)) or
1302: (NOT l_api_updating)) then
1303:
1304: --

Line 1301: <> nvl(p_income_reduction,hr_api.g_varchar2)) or

1297: ,p_object_version_number => p_object_version_number);
1298:
1299: if ((l_api_updating and nvl(pay_ppd_shd.g_old_rec.income_reduction,
1300: hr_api.g_varchar2)
1301: <> nvl(p_income_reduction,hr_api.g_varchar2)) or
1302: (NOT l_api_updating)) then
1303:
1304: --
1305: -- If Income Reduction is not null then

Line 1310: if hr_api.not_exists_in_dt_hr_lookups

1306: -- Check if the Income Reduction value exists in hr_lookups
1307: -- where the lookup_type is 'PL_INCOME_REDUCTION'
1308: --
1309: if p_income_reduction is not null then
1310: if hr_api.not_exists_in_dt_hr_lookups
1311: (p_effective_date => p_effective_date
1312: ,p_validation_start_date => p_validation_start_date
1313: ,p_validation_end_date => p_validation_end_date
1314: ,p_lookup_type => 'PL_INCOME_REDUCTION'