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.

[Home] [Help]

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 528: <> nvl(pay_cft_shd.g_old_rec.cpp_qpp_exempt_flag,hr_api.g_varchar2)

524: p_object_version_number => p_object_version_number);
525: --
526: if (l_api_updating
527: and p_cpp_qpp_exempt_flag
528: <> nvl(pay_cft_shd.g_old_rec.cpp_qpp_exempt_flag,hr_api.g_varchar2)
529: or not l_api_updating)
530: and p_cpp_qpp_exempt_flag is not null then
531: --
532: -- check if value of lookup falls within lookup type.

Line 534: if hr_api.not_exists_in_hr_lookups

530: and p_cpp_qpp_exempt_flag is not null then
531: --
532: -- check if value of lookup falls within lookup type.
533: --
534: if hr_api.not_exists_in_hr_lookups
535: (p_lookup_type => 'YES_NO',
536: p_lookup_code => p_cpp_qpp_exempt_flag,
537: p_effective_date => p_effective_date) then
538: --

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

594: p_object_version_number => p_object_version_number);
595: --
596: if (l_api_updating
597: and p_basic_exemption_flag
598: <> nvl(pay_cft_shd.g_old_rec.basic_exemption_flag,hr_api.g_varchar2)
599: or not l_api_updating)
600: and p_basic_exemption_flag is not null then
601: --
602: -- check if value of lookup falls within lookup type.

Line 604: if hr_api.not_exists_in_hr_lookups

600: and p_basic_exemption_flag is not null then
601: --
602: -- check if value of lookup falls within lookup type.
603: --
604: if hr_api.not_exists_in_hr_lookups
605: (p_lookup_type => 'YES_NO',
606: p_lookup_code => p_basic_exemption_flag,
607: p_effective_date => p_effective_date) then
608: --

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

678: p_object_version_number => p_object_version_number);
679: --
680: if (l_api_updating
681: and p_tax_calc_method
682: <> nvl(pay_cft_shd.g_old_rec.tax_calc_method,hr_api.g_varchar2)
683: or not l_api_updating)
684: and p_tax_calc_method is not null then
685: --
686: -- check if value of lookup falls within lookup type.

Line 688: if hr_api.not_exists_in_hr_lookups

684: and p_tax_calc_method is not null then
685: --
686: -- check if value of lookup falls within lookup type.
687: --
688: if hr_api.not_exists_in_hr_lookups
689: (p_lookup_type => 'CA_TAX_CALC_METHOD',
690: p_lookup_code => p_tax_calc_method,
691: p_effective_date => p_effective_date) then
692: --

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

731: --
732: -- {End Of Comments}
733: -- ----------------------------------------------------------------------------
734: Procedure dt_update_validate
735: (p_assignment_id in number default hr_api.g_number,
736: p_datetrack_mode in varchar2,
737: p_validation_start_date in date,
738: p_validation_end_date in date) Is
739: --

Line 749: hr_api.mandatory_arg_error

745: hr_utility.set_location('Entering:'||l_proc, 5);
746: --
747: -- Ensure that the p_datetrack_mode argument is not null
748: --
749: hr_api.mandatory_arg_error
750: (p_api_name => l_proc,
751: p_argument => 'datetrack_mode',
752: p_argument_value => p_datetrack_mode);
753: --

Line 761: hr_api.mandatory_arg_error

757: --
758: --
759: -- Ensure the arguments are not null
760: --
761: hr_api.mandatory_arg_error
762: (p_api_name => l_proc,
763: p_argument => 'validation_start_date',
764: p_argument_value => p_validation_start_date);
765: --

Line 766: hr_api.mandatory_arg_error

762: (p_api_name => l_proc,
763: p_argument => 'validation_start_date',
764: p_argument_value => p_validation_start_date);
765: --
766: hr_api.mandatory_arg_error
767: (p_api_name => l_proc,
768: p_argument => 'validation_end_date',
769: p_argument_value => p_validation_end_date);
770: --

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

767: (p_api_name => l_proc,
768: p_argument => 'validation_end_date',
769: p_argument_value => p_validation_end_date);
770: --
771: If ((nvl(p_assignment_id, hr_api.g_number) <> hr_api.g_number) and
772: NOT (dt_api.check_min_max_dates
773: (p_base_table_name => 'per_all_assignments_f',
774: p_base_key_column => 'assignment_id',
775: p_base_key_value => p_assignment_id,

Line 855: hr_api.mandatory_arg_error

851: hr_utility.set_location('Entering:'||l_proc, 5);
852: --
853: -- Ensure that the p_datetrack_mode argument is not null
854: --
855: hr_api.mandatory_arg_error
856: (p_api_name => l_proc,
857: p_argument => 'datetrack_mode',
858: p_argument_value => p_datetrack_mode);
859: --

Line 869: hr_api.mandatory_arg_error

865: --
866: --
867: -- Ensure the arguments are not null
868: --
869: hr_api.mandatory_arg_error
870: (p_api_name => l_proc,
871: p_argument => 'validation_start_date',
872: p_argument_value => p_validation_start_date);
873: --

Line 874: hr_api.mandatory_arg_error

870: (p_api_name => l_proc,
871: p_argument => 'validation_start_date',
872: p_argument_value => p_validation_start_date);
873: --
874: hr_api.mandatory_arg_error
875: (p_api_name => l_proc,
876: p_argument => 'validation_end_date',
877: p_argument_value => p_validation_end_date);
878: --

Line 879: hr_api.mandatory_arg_error

875: (p_api_name => l_proc,
876: p_argument => 'validation_end_date',
877: p_argument_value => p_validation_end_date);
878: --
879: hr_api.mandatory_arg_error
880: (p_api_name => l_proc,
881: p_argument => 'emp_fed_tax_inf_id',
882: p_argument_value => p_emp_fed_tax_inf_id);
883: --

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

989: p_tax_credit_amount => p_rec.tax_credit_amount,
990: p_effective_date => p_effective_date,
991: p_object_version_number => p_rec.object_version_number);
992: --
993: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
994: --
995: hr_utility.set_location(' Leaving:'||l_proc, 10);
996: End insert_validate;
997: --

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

1068: p_tax_credit_amount => p_rec.tax_credit_amount,
1069: p_effective_date => p_effective_date,
1070: p_object_version_number => p_rec.object_version_number);
1071: --
1072: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1073: --
1074: -- Call the datetrack update integrity operation
1075: --
1076: dt_update_validate

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

1135: hr_utility.set_location('Entering:'|| l_proc, 10);
1136: --
1137: -- Ensure that all the mandatory parameter are not null
1138: --
1139: hr_api.mandatory_arg_error(p_api_name => l_proc,
1140: p_argument => 'emp_fed_tax_inf_id',
1141: p_argument_value => p_emp_fed_tax_inf_id);
1142: --
1143: open csr_leg_code;