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_CFT_BUS dependencies on HR_API

Line 54: and nvl(p_emp_fed_tax_inf_id,hr_api.g_number)

50: p_emp_fed_tax_inf_id => p_emp_fed_tax_inf_id,
51: p_object_version_number => p_object_version_number);
52: --
53: if (l_api_updating
54: and nvl(p_emp_fed_tax_inf_id,hr_api.g_number)
55: <> pay_cft_shd.g_old_rec.emp_fed_tax_inf_id) then
56: --
57: -- raise error as PK has changed
58: --

Line 124: <> nvl(pay_cft_shd.g_old_rec.legislation_code,hr_api.g_varchar2)

120: p_object_version_number => p_object_version_number);
121: --
122: if l_api_updating
123: and p_legislation_code
124: <> nvl(pay_cft_shd.g_old_rec.legislation_code,hr_api.g_varchar2)
125: or not l_api_updating then
126: ---
127: if p_legislation_code is null then
128: -- raise error as legislation_code is NULL

Line 201: hr_api.mandatory_arg_error

197: hr_utility.raise_error;
198: end if;
199: --
200: --dbms_output.put_line('in assignment_id 3');
201: hr_api.mandatory_arg_error
202: (p_api_name => l_proc
203: ,p_argument => 'effective_date'
204: ,p_argument_value => p_effective_date
205: );

Line 322: <> nvl(pay_cft_shd.g_old_rec.employment_province,hr_api.g_varchar2)

318: p_object_version_number => p_object_version_number);
319: --
320: if (l_api_updating
321: and p_employment_province
322: <> nvl(pay_cft_shd.g_old_rec.employment_province,hr_api.g_varchar2)
323: or not l_api_updating)
324: and p_employment_province is not null then
325: --
326: -- check if value of lookup falls within lookup type.

Line 328: if hr_api.not_exists_in_hr_lookups

324: and p_employment_province is not null then
325: --
326: -- check if value of lookup falls within lookup type.
327: --
328: if hr_api.not_exists_in_hr_lookups
329: (p_lookup_type => 'CA_PROVINCE',
330: p_lookup_code => p_employment_province,
331: p_effective_date => p_effective_date) then
332: --

Line 390: <> nvl(pay_cft_shd.g_old_rec.ei_exempt_flag,hr_api.g_varchar2)

386: p_object_version_number => p_object_version_number);
387: --
388: if (l_api_updating
389: and p_ei_exempt_flag
390: <> nvl(pay_cft_shd.g_old_rec.ei_exempt_flag,hr_api.g_varchar2)
391: or not l_api_updating)
392: and p_ei_exempt_flag is not null then
393: --
394: -- check if value of lookup falls within lookup type.

Line 396: if hr_api.not_exists_in_hr_lookups

392: and p_ei_exempt_flag is not null then
393: --
394: -- check if value of lookup falls within lookup type.
395: --
396: if hr_api.not_exists_in_hr_lookups
397: (p_lookup_type => 'YES_NO',
398: p_lookup_code => p_ei_exempt_flag,
399: p_effective_date => p_effective_date) then
400: --

Line 459: <> nvl(pay_cft_shd.g_old_rec.fed_exempt_flag,hr_api.g_varchar2)

455: p_object_version_number => p_object_version_number);
456: --
457: if (l_api_updating
458: and p_fed_exempt_flag
459: <> nvl(pay_cft_shd.g_old_rec.fed_exempt_flag,hr_api.g_varchar2)
460: or not l_api_updating)
461: and p_fed_exempt_flag is not null then
462: --
463: -- check if value of lookup falls within lookup type.

Line 465: if hr_api.not_exists_in_hr_lookups

461: and p_fed_exempt_flag is not null then
462: --
463: -- check if value of lookup falls within lookup type.
464: --
465: if hr_api.not_exists_in_hr_lookups
466: (p_lookup_type => 'YES_NO',
467: p_lookup_code => p_fed_exempt_flag,
468: p_effective_date => p_effective_date) then
469: --

Line 533: <> nvl(pay_cft_shd.g_old_rec.cpp_qpp_exempt_flag,hr_api.g_varchar2)

529: p_object_version_number => p_object_version_number);
530: --
531: if (l_api_updating
532: and p_cpp_qpp_exempt_flag
533: <> nvl(pay_cft_shd.g_old_rec.cpp_qpp_exempt_flag,hr_api.g_varchar2)
534: or not l_api_updating)
535: and p_cpp_qpp_exempt_flag is not null then
536: --
537: -- check if value of lookup falls within lookup type.

Line 539: if hr_api.not_exists_in_hr_lookups

535: and p_cpp_qpp_exempt_flag is not null then
536: --
537: -- check if value of lookup falls within lookup type.
538: --
539: if hr_api.not_exists_in_hr_lookups
540: (p_lookup_type => 'YES_NO',
541: p_lookup_code => p_cpp_qpp_exempt_flag,
542: p_effective_date => p_effective_date) then
543: --

Line 615: <> nvl(pay_cft_shd.g_old_rec.basic_exemption_flag,hr_api.g_varchar2)

611: p_object_version_number => p_object_version_number);
612: --
613: if (l_api_updating
614: and p_basic_exemption_flag
615: <> nvl(pay_cft_shd.g_old_rec.basic_exemption_flag,hr_api.g_varchar2)
616: or not l_api_updating)
617: and p_basic_exemption_flag is not null then
618: --
619: -- check if value of lookup falls within lookup type.

Line 621: if hr_api.not_exists_in_hr_lookups

617: and p_basic_exemption_flag is not null then
618: --
619: -- check if value of lookup falls within lookup type.
620: --
621: if hr_api.not_exists_in_hr_lookups
622: (p_lookup_type => 'YES_NO',
623: p_lookup_code => p_basic_exemption_flag,
624: p_effective_date => p_effective_date) then
625: --

Line 699: <> nvl(pay_cft_shd.g_old_rec.tax_calc_method,hr_api.g_varchar2)

695: p_object_version_number => p_object_version_number);
696: --
697: if (l_api_updating
698: and p_tax_calc_method
699: <> nvl(pay_cft_shd.g_old_rec.tax_calc_method,hr_api.g_varchar2)
700: or not l_api_updating)
701: and p_tax_calc_method is not null then
702: --
703: -- check if value of lookup falls within lookup type.

Line 705: if hr_api.not_exists_in_hr_lookups

701: and p_tax_calc_method is not null then
702: --
703: -- check if value of lookup falls within lookup type.
704: --
705: if hr_api.not_exists_in_hr_lookups
706: (p_lookup_type => 'CA_TAX_CALC_METHOD',
707: p_lookup_code => p_tax_calc_method,
708: p_effective_date => p_effective_date) then
709: --

Line 778: hr_api.g_date)

774: p_effective_date => p_effective_date,
775: p_object_version_number => p_object_version_number);
776: --
777: if ((l_api_updating and nvl(pay_cft_shd.g_old_rec.cpp_election_date,
778: hr_api.g_date)
779: <> nvl(p_cpp_election_date,hr_api.g_date))
780: or (not l_api_updating))
781: then
782: hr_utility.set_location(l_proc, 2);

Line 779: <> nvl(p_cpp_election_date,hr_api.g_date))

775: p_object_version_number => p_object_version_number);
776: --
777: if ((l_api_updating and nvl(pay_cft_shd.g_old_rec.cpp_election_date,
778: hr_api.g_date)
779: <> nvl(p_cpp_election_date,hr_api.g_date))
780: or (not l_api_updating))
781: then
782: hr_utility.set_location(l_proc, 2);
783:

Line 873: hr_api.g_date)

869: p_object_version_number => p_object_version_number);
870: --
871: --
872: if ((l_api_updating and nvl(pay_cft_shd.g_old_rec.cpp_revocation_date,
873: hr_api.g_date)
874: <> nvl(p_cpp_revocation_date,hr_api.g_date))
875: or (not l_api_updating)) then
876:
877: hr_utility.set_location(l_proc, 2);

Line 874: <> nvl(p_cpp_revocation_date,hr_api.g_date))

870: --
871: --
872: if ((l_api_updating and nvl(pay_cft_shd.g_old_rec.cpp_revocation_date,
873: hr_api.g_date)
874: <> nvl(p_cpp_revocation_date,hr_api.g_date))
875: or (not l_api_updating)) then
876:
877: hr_utility.set_location(l_proc, 2);
878:

Line 942: (p_assignment_id in number default hr_api.g_number,

938: --
939: -- {End Of Comments}
940: -- ----------------------------------------------------------------------------
941: Procedure dt_update_validate
942: (p_assignment_id in number default hr_api.g_number,
943: p_datetrack_mode in varchar2,
944: p_validation_start_date in date,
945: p_validation_end_date in date) Is
946: --

Line 956: hr_api.mandatory_arg_error

952: hr_utility.set_location('Entering:'||l_proc, 5);
953: --
954: -- Ensure that the p_datetrack_mode argument is not null
955: --
956: hr_api.mandatory_arg_error
957: (p_api_name => l_proc,
958: p_argument => 'datetrack_mode',
959: p_argument_value => p_datetrack_mode);
960: --

Line 968: hr_api.mandatory_arg_error

964: --
965: --
966: -- Ensure the arguments are not null
967: --
968: hr_api.mandatory_arg_error
969: (p_api_name => l_proc,
970: p_argument => 'validation_start_date',
971: p_argument_value => p_validation_start_date);
972: --

Line 973: hr_api.mandatory_arg_error

969: (p_api_name => l_proc,
970: p_argument => 'validation_start_date',
971: p_argument_value => p_validation_start_date);
972: --
973: hr_api.mandatory_arg_error
974: (p_api_name => l_proc,
975: p_argument => 'validation_end_date',
976: p_argument_value => p_validation_end_date);
977: --

Line 978: If ((nvl(p_assignment_id, hr_api.g_number) <> hr_api.g_number) and

974: (p_api_name => l_proc,
975: p_argument => 'validation_end_date',
976: p_argument_value => p_validation_end_date);
977: --
978: If ((nvl(p_assignment_id, hr_api.g_number) <> hr_api.g_number) and
979: NOT (dt_api.check_min_max_dates
980: (p_base_table_name => 'per_all_assignments_f',
981: p_base_key_column => 'assignment_id',
982: p_base_key_value => p_assignment_id,

Line 1062: hr_api.mandatory_arg_error

1058: hr_utility.set_location('Entering:'||l_proc, 5);
1059: --
1060: -- Ensure that the p_datetrack_mode argument is not null
1061: --
1062: hr_api.mandatory_arg_error
1063: (p_api_name => l_proc,
1064: p_argument => 'datetrack_mode',
1065: p_argument_value => p_datetrack_mode);
1066: --

Line 1076: hr_api.mandatory_arg_error

1072: --
1073: --
1074: -- Ensure the arguments are not null
1075: --
1076: hr_api.mandatory_arg_error
1077: (p_api_name => l_proc,
1078: p_argument => 'validation_start_date',
1079: p_argument_value => p_validation_start_date);
1080: --

Line 1081: hr_api.mandatory_arg_error

1077: (p_api_name => l_proc,
1078: p_argument => 'validation_start_date',
1079: p_argument_value => p_validation_start_date);
1080: --
1081: hr_api.mandatory_arg_error
1082: (p_api_name => l_proc,
1083: p_argument => 'validation_end_date',
1084: p_argument_value => p_validation_end_date);
1085: --

Line 1086: hr_api.mandatory_arg_error

1082: (p_api_name => l_proc,
1083: p_argument => 'validation_end_date',
1084: p_argument_value => p_validation_end_date);
1085: --
1086: hr_api.mandatory_arg_error
1087: (p_api_name => l_proc,
1088: p_argument => 'emp_fed_tax_inf_id',
1089: p_argument_value => p_emp_fed_tax_inf_id);
1090: --

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

1198: p_tax_credit_amount => p_rec.tax_credit_amount,
1199: p_effective_date => p_effective_date,
1200: p_object_version_number => p_rec.object_version_number);
1201: --
1202: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1203: --
1204: hr_utility.set_location(' Leaving:'||l_proc, 10);
1205: End insert_validate;
1206: --

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

1299: p_effective_date => p_effective_date,
1300: p_cpp_revocation_warning=> l_cpp_revocation_warning,
1301: p_object_version_number => p_rec.object_version_number);
1302: --
1303: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1304: --
1305: -- Call the datetrack update integrity operation
1306: --
1307: dt_update_validate

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

1366: hr_utility.set_location('Entering:'|| l_proc, 10);
1367: --
1368: -- Ensure that all the mandatory parameter are not null
1369: --
1370: hr_api.mandatory_arg_error(p_api_name => l_proc,
1371: p_argument => 'emp_fed_tax_inf_id',
1372: p_argument_value => p_emp_fed_tax_inf_id);
1373: --
1374: open csr_leg_code;