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_CA_EOY_T4_CANCEL_PKG dependencies on PAY_CA_EOY_T4_CANCEL_PKG

Line 1: PACKAGE BODY pay_ca_eoy_t4_cancel_pkg AS

1: PACKAGE BODY pay_ca_eoy_t4_cancel_pkg AS
2: /* $Header: pycat4clcr.pkb 120.3.12020000.2 2012/12/31 11:14:20 rgottipa ship $ */
3: /*
4: ******************************************************************
5: * *

Line 20: Name : pay_ca_eoy_t4_cancel_pkg

16: * 500 Oracle Parkway, Redwood City, CA, 94065. *
17: * *
18: ******************************************************************
19:
20: Name : pay_ca_eoy_t4_cancel_pkg
21:
22: Description : This Package is used by T4 Cancel PDF Report.
23:
24: Change List

Line 43: gv_package VARCHAR2(100) := 'pay_ca_eoy_t4_cancel_pkg';

39: terminate employees and online
40: 'paper' option.
41: *****************************************************************************/
42:
43: gv_package VARCHAR2(100) := 'pay_ca_eoy_t4_cancel_pkg';
44: gv_procedure_name VARCHAR2(100);
45:
46: /*****************************************************************************
47: Name : get_payroll_action_info

Line 68: select to_number(pay_ca_eoy_t4_cancel_pkg.get_parameter(

64: ,p_report_type out nocopy varchar2
65: )
66: IS
67: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
68: select to_number(pay_ca_eoy_t4_cancel_pkg.get_parameter(
69: 'GRE_ID',ppa.legislative_parameters)),
70: to_number(pay_ca_eoy_t4_cancel_pkg.get_parameter(
71: 'PER_ID',ppa.legislative_parameters)),
72: to_number(pay_ca_eoy_t4_cancel_pkg.get_parameter(

Line 70: to_number(pay_ca_eoy_t4_cancel_pkg.get_parameter(

66: IS
67: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
68: select to_number(pay_ca_eoy_t4_cancel_pkg.get_parameter(
69: 'GRE_ID',ppa.legislative_parameters)),
70: to_number(pay_ca_eoy_t4_cancel_pkg.get_parameter(
71: 'PER_ID',ppa.legislative_parameters)),
72: to_number(pay_ca_eoy_t4_cancel_pkg.get_parameter(
73: 'ASG_SET_ID',ppa.legislative_parameters)),
74: pay_ca_eoy_t4_cancel_pkg.get_parameter(

Line 72: to_number(pay_ca_eoy_t4_cancel_pkg.get_parameter(

68: select to_number(pay_ca_eoy_t4_cancel_pkg.get_parameter(
69: 'GRE_ID',ppa.legislative_parameters)),
70: to_number(pay_ca_eoy_t4_cancel_pkg.get_parameter(
71: 'PER_ID',ppa.legislative_parameters)),
72: to_number(pay_ca_eoy_t4_cancel_pkg.get_parameter(
73: 'ASG_SET_ID',ppa.legislative_parameters)),
74: pay_ca_eoy_t4_cancel_pkg.get_parameter(
75: 'MODE',ppa.legislative_parameters),
76: effective_date,

Line 74: pay_ca_eoy_t4_cancel_pkg.get_parameter(

70: to_number(pay_ca_eoy_t4_cancel_pkg.get_parameter(
71: 'PER_ID',ppa.legislative_parameters)),
72: to_number(pay_ca_eoy_t4_cancel_pkg.get_parameter(
73: 'ASG_SET_ID',ppa.legislative_parameters)),
74: pay_ca_eoy_t4_cancel_pkg.get_parameter(
75: 'MODE',ppa.legislative_parameters),
76: effective_date,
77: start_date,
78: business_group_id,

Line 79: pay_ca_eoy_t4_cancel_pkg.get_parameter(

75: 'MODE',ppa.legislative_parameters),
76: effective_date,
77: start_date,
78: business_group_id,
79: pay_ca_eoy_t4_cancel_pkg.get_parameter(
80: 'PROV_CD',ppa.legislative_parameters),
81: report_type
82: from pay_payroll_actions ppa
83: where ppa.payroll_action_id = cp_payroll_action_id;

Line 154: select to_number(pay_ca_eoy_t4_cancel_pkg.get_parameter(

150: ,p_print_term out nocopy varchar2
151: )
152: IS
153: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
154: select to_number(pay_ca_eoy_t4_cancel_pkg.get_parameter(
155: 'GRE_ID',ppa.legislative_parameters)),
156: to_number(pay_ca_eoy_t4_cancel_pkg.get_parameter(
157: 'PER_ID',ppa.legislative_parameters)),
158: to_number(pay_ca_eoy_t4_cancel_pkg.get_parameter(

Line 156: to_number(pay_ca_eoy_t4_cancel_pkg.get_parameter(

152: IS
153: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
154: select to_number(pay_ca_eoy_t4_cancel_pkg.get_parameter(
155: 'GRE_ID',ppa.legislative_parameters)),
156: to_number(pay_ca_eoy_t4_cancel_pkg.get_parameter(
157: 'PER_ID',ppa.legislative_parameters)),
158: to_number(pay_ca_eoy_t4_cancel_pkg.get_parameter(
159: 'ASG_SET_ID',ppa.legislative_parameters)),
160: pay_ca_eoy_t4_cancel_pkg.get_parameter(

Line 158: to_number(pay_ca_eoy_t4_cancel_pkg.get_parameter(

154: select to_number(pay_ca_eoy_t4_cancel_pkg.get_parameter(
155: 'GRE_ID',ppa.legislative_parameters)),
156: to_number(pay_ca_eoy_t4_cancel_pkg.get_parameter(
157: 'PER_ID',ppa.legislative_parameters)),
158: to_number(pay_ca_eoy_t4_cancel_pkg.get_parameter(
159: 'ASG_SET_ID',ppa.legislative_parameters)),
160: pay_ca_eoy_t4_cancel_pkg.get_parameter(
161: 'MODE',ppa.legislative_parameters),
162: effective_date,

Line 160: pay_ca_eoy_t4_cancel_pkg.get_parameter(

156: to_number(pay_ca_eoy_t4_cancel_pkg.get_parameter(
157: 'PER_ID',ppa.legislative_parameters)),
158: to_number(pay_ca_eoy_t4_cancel_pkg.get_parameter(
159: 'ASG_SET_ID',ppa.legislative_parameters)),
160: pay_ca_eoy_t4_cancel_pkg.get_parameter(
161: 'MODE',ppa.legislative_parameters),
162: effective_date,
163: start_date,
164: business_group_id,

Line 165: pay_ca_eoy_t4_cancel_pkg.get_parameter(

161: 'MODE',ppa.legislative_parameters),
162: effective_date,
163: start_date,
164: business_group_id,
165: pay_ca_eoy_t4_cancel_pkg.get_parameter(
166: 'PROV_CD',ppa.legislative_parameters),
167: report_type,
168: report_qualifier,
169: report_category,

Line 170: pay_ca_eoy_t4_cancel_pkg.get_parameter(

166: 'PROV_CD',ppa.legislative_parameters),
167: report_type,
168: report_qualifier,
169: report_category,
170: pay_ca_eoy_t4_cancel_pkg.get_parameter(
171: 'PRINT_TERM',ppa.legislative_parameters)
172: from pay_payroll_actions ppa
173: where ppa.payroll_action_id = cp_payroll_action_id;
174:

Line 607: pay_ca_eoy_t4_cancel_pkg.get_parameter(

603: and ppa.payroll_action_id = paa.payroll_action_id
604: and ppa.effective_date = cp_effective_date
605: and ppa.report_type in ('T4_XML','PAYCAT4AMPDF')
606: and decode(ppa.report_type,'T4_XML','LATEST','PAYCAT4AMPDF',
607: pay_ca_eoy_t4_cancel_pkg.get_parameter(
608: 'MODE',ppa.legislative_parameters)) = 'LATEST'
609: and paf.effective_end_date = (select max(paf.effective_end_date)
610: from per_assignments_f paf
611: where paf.assignment_id = paa.assignment_id

Line 718: pay_ca_eoy_t4_cancel_pkg.get_parameter(

714: and ppa.payroll_action_id = paa.payroll_action_id
715: and ppa.effective_date = cp_effective_date
716: and ppa.report_type in ('T4_XML','PAYCAT4AMPDF')
717: and decode(ppa.report_type,'T4_XML','LATEST','PAYCAT4AMPDF',
718: pay_ca_eoy_t4_cancel_pkg.get_parameter(
719: 'MODE',ppa.legislative_parameters)) = 'LATEST'
720: and paf.effective_end_date = (select max(paf.effective_end_date)
721: from per_assignments_f paf
722: where paf.assignment_id = paa.assignment_id

Line 1419: select pay_ca_eoy_t4_cancel_pkg.get_parameter('GRE_ID',ppa.legislative_parameters),

1415:
1416: begin
1417:
1418: begin
1419: select pay_ca_eoy_t4_cancel_pkg.get_parameter('GRE_ID',ppa.legislative_parameters),
1420: pay_ca_eoy_t4_cancel_pkg.get_parameter('PER_ID',ppa.legislative_parameters),
1421: pay_ca_eoy_t4_cancel_pkg.get_parameter('ASG_SET_ID',ppa.legislative_parameters),
1422: pay_ca_eoy_t4_cancel_pkg.get_parameter('P_S1',ppa.legislative_parameters),
1423: pay_ca_eoy_t4_cancel_pkg.get_parameter('P_S2',ppa.legislative_parameters),

Line 1420: pay_ca_eoy_t4_cancel_pkg.get_parameter('PER_ID',ppa.legislative_parameters),

1416: begin
1417:
1418: begin
1419: select pay_ca_eoy_t4_cancel_pkg.get_parameter('GRE_ID',ppa.legislative_parameters),
1420: pay_ca_eoy_t4_cancel_pkg.get_parameter('PER_ID',ppa.legislative_parameters),
1421: pay_ca_eoy_t4_cancel_pkg.get_parameter('ASG_SET_ID',ppa.legislative_parameters),
1422: pay_ca_eoy_t4_cancel_pkg.get_parameter('P_S1',ppa.legislative_parameters),
1423: pay_ca_eoy_t4_cancel_pkg.get_parameter('P_S2',ppa.legislative_parameters),
1424: pay_ca_eoy_t4_cancel_pkg.get_parameter('P_S3',ppa.legislative_parameters),

Line 1421: pay_ca_eoy_t4_cancel_pkg.get_parameter('ASG_SET_ID',ppa.legislative_parameters),

1417:
1418: begin
1419: select pay_ca_eoy_t4_cancel_pkg.get_parameter('GRE_ID',ppa.legislative_parameters),
1420: pay_ca_eoy_t4_cancel_pkg.get_parameter('PER_ID',ppa.legislative_parameters),
1421: pay_ca_eoy_t4_cancel_pkg.get_parameter('ASG_SET_ID',ppa.legislative_parameters),
1422: pay_ca_eoy_t4_cancel_pkg.get_parameter('P_S1',ppa.legislative_parameters),
1423: pay_ca_eoy_t4_cancel_pkg.get_parameter('P_S2',ppa.legislative_parameters),
1424: pay_ca_eoy_t4_cancel_pkg.get_parameter('P_S3',ppa.legislative_parameters),
1425: pay_ca_eoy_t4_cancel_pkg.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),

Line 1422: pay_ca_eoy_t4_cancel_pkg.get_parameter('P_S1',ppa.legislative_parameters),

1418: begin
1419: select pay_ca_eoy_t4_cancel_pkg.get_parameter('GRE_ID',ppa.legislative_parameters),
1420: pay_ca_eoy_t4_cancel_pkg.get_parameter('PER_ID',ppa.legislative_parameters),
1421: pay_ca_eoy_t4_cancel_pkg.get_parameter('ASG_SET_ID',ppa.legislative_parameters),
1422: pay_ca_eoy_t4_cancel_pkg.get_parameter('P_S1',ppa.legislative_parameters),
1423: pay_ca_eoy_t4_cancel_pkg.get_parameter('P_S2',ppa.legislative_parameters),
1424: pay_ca_eoy_t4_cancel_pkg.get_parameter('P_S3',ppa.legislative_parameters),
1425: pay_ca_eoy_t4_cancel_pkg.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),
1426: pay_ca_eoy_t4_cancel_pkg.get_parameter('MODE',ppa.legislative_parameters),

Line 1423: pay_ca_eoy_t4_cancel_pkg.get_parameter('P_S2',ppa.legislative_parameters),

1419: select pay_ca_eoy_t4_cancel_pkg.get_parameter('GRE_ID',ppa.legislative_parameters),
1420: pay_ca_eoy_t4_cancel_pkg.get_parameter('PER_ID',ppa.legislative_parameters),
1421: pay_ca_eoy_t4_cancel_pkg.get_parameter('ASG_SET_ID',ppa.legislative_parameters),
1422: pay_ca_eoy_t4_cancel_pkg.get_parameter('P_S1',ppa.legislative_parameters),
1423: pay_ca_eoy_t4_cancel_pkg.get_parameter('P_S2',ppa.legislative_parameters),
1424: pay_ca_eoy_t4_cancel_pkg.get_parameter('P_S3',ppa.legislative_parameters),
1425: pay_ca_eoy_t4_cancel_pkg.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),
1426: pay_ca_eoy_t4_cancel_pkg.get_parameter('MODE',ppa.legislative_parameters),
1427: ppa.effective_date,

Line 1424: pay_ca_eoy_t4_cancel_pkg.get_parameter('P_S3',ppa.legislative_parameters),

1420: pay_ca_eoy_t4_cancel_pkg.get_parameter('PER_ID',ppa.legislative_parameters),
1421: pay_ca_eoy_t4_cancel_pkg.get_parameter('ASG_SET_ID',ppa.legislative_parameters),
1422: pay_ca_eoy_t4_cancel_pkg.get_parameter('P_S1',ppa.legislative_parameters),
1423: pay_ca_eoy_t4_cancel_pkg.get_parameter('P_S2',ppa.legislative_parameters),
1424: pay_ca_eoy_t4_cancel_pkg.get_parameter('P_S3',ppa.legislative_parameters),
1425: pay_ca_eoy_t4_cancel_pkg.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),
1426: pay_ca_eoy_t4_cancel_pkg.get_parameter('MODE',ppa.legislative_parameters),
1427: ppa.effective_date,
1428: ppa.start_date,

Line 1425: pay_ca_eoy_t4_cancel_pkg.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),

1421: pay_ca_eoy_t4_cancel_pkg.get_parameter('ASG_SET_ID',ppa.legislative_parameters),
1422: pay_ca_eoy_t4_cancel_pkg.get_parameter('P_S1',ppa.legislative_parameters),
1423: pay_ca_eoy_t4_cancel_pkg.get_parameter('P_S2',ppa.legislative_parameters),
1424: pay_ca_eoy_t4_cancel_pkg.get_parameter('P_S3',ppa.legislative_parameters),
1425: pay_ca_eoy_t4_cancel_pkg.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),
1426: pay_ca_eoy_t4_cancel_pkg.get_parameter('MODE',ppa.legislative_parameters),
1427: ppa.effective_date,
1428: ppa.start_date,
1429: ppa.business_group_id

Line 1426: pay_ca_eoy_t4_cancel_pkg.get_parameter('MODE',ppa.legislative_parameters),

1422: pay_ca_eoy_t4_cancel_pkg.get_parameter('P_S1',ppa.legislative_parameters),
1423: pay_ca_eoy_t4_cancel_pkg.get_parameter('P_S2',ppa.legislative_parameters),
1424: pay_ca_eoy_t4_cancel_pkg.get_parameter('P_S3',ppa.legislative_parameters),
1425: pay_ca_eoy_t4_cancel_pkg.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),
1426: pay_ca_eoy_t4_cancel_pkg.get_parameter('MODE',ppa.legislative_parameters),
1427: ppa.effective_date,
1428: ppa.start_date,
1429: ppa.business_group_id
1430: into l_gre_id,

Line 1545: end pay_ca_eoy_t4_cancel_pkg;

1541:
1542: /* hr_utility.trace_on(null,'T4_CANCEL_PDF'); */
1543: null;
1544:
1545: end pay_ca_eoy_t4_cancel_pkg;