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_CPT_BUS dependencies on PAY_CPT_SHD

Line 64: l_api_updating := pay_cpt_shd.api_updating

60: ,p_argument => 'effective_date'
61: ,p_argument_value => p_effective_date
62: );
63: --
64: l_api_updating := pay_cpt_shd.api_updating
65: (p_emp_province_tax_inf_id => p_emp_province_tax_inf_id,
66: p_effective_date => p_effective_date,
67: p_object_version_number => p_object_version_number);
68: --

Line 73: if p_assignment_id <> pay_cpt_shd.g_old_rec.assignment_id then

69: -- Since assignment_id cannot be updated, the case of
70: -- l_api_updating = TRUE is not considered
71: --
72: if (l_api_updating ) then
73: if p_assignment_id <> pay_cpt_shd.g_old_rec.assignment_id then
74: -- dbms_output.put_line('cannot change assignment_id');
75: hr_utility.set_message(800, 'HR_74027_ASSIGNMENT_ID_CHANGED');
76: hr_utility.raise_error;
77: end if;

Line 162: l_api_updating := pay_cpt_shd.api_updating

158: Begin
159: --
160: hr_utility.set_location('Entering:'||l_proc, 5);
161: --
162: l_api_updating := pay_cpt_shd.api_updating
163: (p_effective_date => p_effective_date,
164: p_emp_province_tax_inf_id => p_emp_province_tax_inf_id,
165: p_object_version_number => p_object_version_number);
166: --

Line 169: <> pay_cpt_shd.g_old_rec.emp_province_tax_inf_id) then

165: p_object_version_number => p_object_version_number);
166: --
167: if (l_api_updating
168: and nvl(p_emp_province_tax_inf_id,hr_api.g_number)
169: <> pay_cpt_shd.g_old_rec.emp_province_tax_inf_id) then
170: --
171: -- raise error as PK has changed
172: --
173: pay_cpt_shd.constraint_error('PAY_CA_EMP_PROVIN_TAX_RULES_PK');

Line 173: pay_cpt_shd.constraint_error('PAY_CA_EMP_PROVIN_TAX_RULES_PK');

169: <> pay_cpt_shd.g_old_rec.emp_province_tax_inf_id) then
170: --
171: -- raise error as PK has changed
172: --
173: pay_cpt_shd.constraint_error('PAY_CA_EMP_PROVIN_TAX_RULES_PK');
174: --
175: elsif not l_api_updating then
176: --
177: -- check if PK is null

Line 183: pay_cpt_shd.constraint_error('PAY_CA_EMP_PROVIN_TAX_RULES_PK');

179: if p_emp_province_tax_inf_id is not null then
180: --
181: -- raise error as PK is not null
182: --
183: pay_cpt_shd.constraint_error('PAY_CA_EMP_PROVIN_TAX_RULES_PK');
184: --
185: end if;
186: --
187: end if;

Line 231: l_api_updating := pay_cpt_shd.api_updating

227: Begin
228: --
229: hr_utility.set_location('Entering:'||l_proc, 5);
230: --
231: l_api_updating := pay_cpt_shd.api_updating
232: (p_emp_province_tax_inf_id => p_emp_province_tax_inf_id,
233: p_effective_date => p_effective_date,
234: p_object_version_number => p_object_version_number);
235: --

Line 238: <> nvl(pay_cpt_shd.g_old_rec.wc_exempt_flag,hr_api.g_varchar2)

234: p_object_version_number => p_object_version_number);
235: --
236: if (l_api_updating
237: and p_wc_exempt_flag
238: <> nvl(pay_cpt_shd.g_old_rec.wc_exempt_flag,hr_api.g_varchar2)
239: or not l_api_updating)
240: and p_wc_exempt_flag is not null then
241: --
242: -- check if value of lookup falls within lookup type.

Line 300: l_api_updating := pay_cpt_shd.api_updating

296: Begin
297: --
298: hr_utility.set_location('Entering:'||l_proc, 5);
299: --
300: l_api_updating := pay_cpt_shd.api_updating
301: (p_emp_province_tax_inf_id => p_emp_province_tax_inf_id,
302: p_effective_date => p_effective_date,
303: p_object_version_number => p_object_version_number);
304: --

Line 307: <> nvl(pay_cpt_shd.g_old_rec.pmed_exempt_flag,hr_api.g_varchar2)

303: p_object_version_number => p_object_version_number);
304: --
305: if (l_api_updating
306: and p_pmed_exempt_flag
307: <> nvl(pay_cpt_shd.g_old_rec.pmed_exempt_flag,hr_api.g_varchar2)
308: or not l_api_updating)
309: and p_pmed_exempt_flag is not null then
310: --
311: -- check if value of lookup falls within lookup type.

Line 369: l_api_updating := pay_cpt_shd.api_updating

365: Begin
366: --
367: hr_utility.set_location('Entering:'||l_proc, 5);
368: --
369: l_api_updating := pay_cpt_shd.api_updating
370: (p_emp_province_tax_inf_id => p_emp_province_tax_inf_id,
371: p_effective_date => p_effective_date,
372: p_object_version_number => p_object_version_number);
373: --

Line 376: <> nvl(pay_cpt_shd.g_old_rec.prov_exempt_flag,hr_api.g_varchar2)

372: p_object_version_number => p_object_version_number);
373: --
374: if (l_api_updating
375: and p_prov_exempt_flag
376: <> nvl(pay_cpt_shd.g_old_rec.prov_exempt_flag,hr_api.g_varchar2)
377: or not l_api_updating)
378: and p_prov_exempt_flag is not null then
379: --
380: -- check if value of lookup falls within lookup type.

Line 440: l_api_updating := pay_cpt_shd.api_updating

436: Begin
437: --
438: hr_utility.set_location('Entering:'||l_proc, 5);
439: --
440: l_api_updating := pay_cpt_shd.api_updating
441: (p_emp_province_tax_inf_id => p_emp_province_tax_inf_id,
442: p_effective_date => p_effective_date,
443: p_object_version_number => p_object_version_number);
444: --

Line 447: <> nvl(pay_cpt_shd.g_old_rec.basic_exemption_flag,hr_api.g_varchar2)

443: p_object_version_number => p_object_version_number);
444: --
445: if (l_api_updating
446: and p_basic_exemption_flag
447: <> nvl(pay_cpt_shd.g_old_rec.basic_exemption_flag,hr_api.g_varchar2)
448: or not l_api_updating)
449: and p_basic_exemption_flag is not null then
450: --
451: -- check if value of lookup falls within lookup type.

Line 525: l_api_updating := pay_cpt_shd.api_updating

521: Begin
522: --
523: hr_utility.set_location('Entering:'||l_proc, 5);
524: --
525: l_api_updating := pay_cpt_shd.api_updating
526: (p_emp_province_tax_inf_id => p_emp_province_tax_inf_id,
527: p_effective_date => p_effective_date,
528: p_object_version_number => p_object_version_number);
529: --

Line 532: <> nvl(pay_cpt_shd.g_old_rec.marriage_status,hr_api.g_varchar2)

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

Line 593: l_api_updating := pay_cpt_shd.api_updating

589: Begin
590: --
591: hr_utility.set_location('Entering:'||l_proc, 5);
592: --
593: l_api_updating := pay_cpt_shd.api_updating
594: (p_emp_province_tax_inf_id => p_emp_province_tax_inf_id,
595: p_effective_date => p_effective_date,
596: p_object_version_number => p_object_version_number);
597: --

Line 600: <> nvl(pay_cpt_shd.g_old_rec.disability_status,hr_api.g_varchar2)

596: p_object_version_number => p_object_version_number);
597: --
598: if (l_api_updating
599: and p_disability_status
600: <> nvl(pay_cpt_shd.g_old_rec.disability_status,hr_api.g_varchar2)
601: or not l_api_updating)
602: and p_disability_status is not null then
603: --
604: -- check if value of lookup falls within lookup type.

Line 661: l_api_updating := pay_cpt_shd.api_updating

657: Begin
658: --
659: hr_utility.set_location('Entering:'||l_proc, 5);
660: --
661: l_api_updating := pay_cpt_shd.api_updating
662: (p_emp_province_tax_inf_id => p_emp_province_tax_inf_id,
663: p_effective_date => p_effective_date,
664: p_object_version_number => p_object_version_number);
665: --

Line 668: <> nvl(pay_cpt_shd.g_old_rec.non_resident_status,hr_api.g_varchar2)

664: p_object_version_number => p_object_version_number);
665: --
666: if (l_api_updating
667: and p_non_resident_status
668: <> nvl(pay_cpt_shd.g_old_rec.non_resident_status,hr_api.g_varchar2)
669: or not l_api_updating)
670: and p_non_resident_status is not null then
671: --
672: -- check if value of lookup falls within lookup type.

Line 729: l_api_updating := pay_cpt_shd.api_updating

725: Begin
726: --
727: hr_utility.set_location('Entering:'||l_proc, 5);
728: --
729: l_api_updating := pay_cpt_shd.api_updating
730: (p_emp_province_tax_inf_id => p_emp_province_tax_inf_id,
731: p_effective_date => p_effective_date,
732: p_object_version_number => p_object_version_number);
733: --

Line 736: <> nvl(pay_cpt_shd.g_old_rec.tax_calc_method,hr_api.g_varchar2)

732: p_object_version_number => p_object_version_number);
733: --
734: if (l_api_updating
735: and p_tax_calc_method
736: <> nvl(pay_cpt_shd.g_old_rec.tax_calc_method,hr_api.g_varchar2)
737: or not l_api_updating)
738: and p_tax_calc_method is not null then
739: --
740: -- check if value of lookup falls within lookup type.

Line 797: l_api_updating := pay_cpt_shd.api_updating

793: Begin
794: --
795: hr_utility.set_location('Entering:'||l_proc, 5);
796: --
797: l_api_updating := pay_cpt_shd.api_updating
798: (p_emp_province_tax_inf_id => p_emp_province_tax_inf_id,
799: p_effective_date => p_effective_date,
800: p_object_version_number => p_object_version_number);
801: --

Line 804: nvl(pay_cpt_shd.g_old_rec.province_code,hr_api.g_varchar2) then

800: p_object_version_number => p_object_version_number);
801: --
802: if (l_api_updating ) then
803: if p_province_code <>
804: nvl(pay_cpt_shd.g_old_rec.province_code,hr_api.g_varchar2) then
805: hr_utility.set_message(800, 'HR_74030_PROVINCE_CODE_CHANGED');
806: hr_utility.raise_error;
807: end if;
808: end if;

Line 812: <> nvl(pay_cpt_shd.g_old_rec.province_code,hr_api.g_varchar2)

808: end if;
809:
810: if (l_api_updating
811: and p_province_code
812: <> nvl(pay_cpt_shd.g_old_rec.province_code,hr_api.g_varchar2)
813: or not l_api_updating)
814: and p_province_code is not null then
815: --
816: -- check if value of lookup falls within lookup type.

Line 873: l_api_updating := pay_cpt_shd.api_updating

869: Begin
870: --
871: hr_utility.set_location('Entering:'||l_proc, 5);
872: --
873: l_api_updating := pay_cpt_shd.api_updating
874: (p_emp_province_tax_inf_id => p_emp_province_tax_inf_id,
875: p_effective_date => p_effective_date,
876: p_object_version_number => p_object_version_number);
877: --

Line 880: <> nvl(pay_cpt_shd.g_old_rec.legislation_code,hr_api.g_varchar2)

876: p_object_version_number => p_object_version_number);
877: --
878: if l_api_updating
879: and p_legislation_code
880: <> nvl(pay_cpt_shd.g_old_rec.legislation_code,hr_api.g_varchar2)
881: or not l_api_updating then
882: ---
883: if p_legislation_code is null then
884: -- raise error as legislation_code is NULL

Line 1114: (p_rec in pay_cpt_shd.g_rec_type,

1110: -- ----------------------------------------------------------------------------
1111: -- |---------------------------< insert_validate >----------------------------|
1112: -- ----------------------------------------------------------------------------
1113: Procedure insert_validate
1114: (p_rec in pay_cpt_shd.g_rec_type,
1115: p_effective_date in date,
1116: p_datetrack_mode in varchar2,
1117: p_validation_start_date in date,
1118: p_validation_end_date in date) is

Line 1211: (p_rec in pay_cpt_shd.g_rec_type,

1207: -- ----------------------------------------------------------------------------
1208: -- |---------------------------< update_validate >----------------------------|
1209: -- ----------------------------------------------------------------------------
1210: Procedure update_validate
1211: (p_rec in pay_cpt_shd.g_rec_type,
1212: p_effective_date in date,
1213: p_datetrack_mode in varchar2,
1214: p_validation_start_date in date,
1215: p_validation_end_date in date) is

Line 1316: (p_rec in pay_cpt_shd.g_rec_type,

1312: -- ----------------------------------------------------------------------------
1313: -- |---------------------------< delete_validate >----------------------------|
1314: -- ----------------------------------------------------------------------------
1315: Procedure delete_validate
1316: (p_rec in pay_cpt_shd.g_rec_type,
1317: p_effective_date in date,
1318: p_datetrack_mode in varchar2,
1319: p_validation_start_date in date,
1320: p_validation_end_date in date) is