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_CA_EOY_T4A_CANCEL_PKG dependencies on PAY_CA_EOY_T4A_CANCEL_PKG

Line 1: PACKAGE BODY pay_ca_eoy_t4a_cancel_pkg AS

1: PACKAGE BODY pay_ca_eoy_t4a_cancel_pkg AS
2: /* $Header: pycat4aclcr.pkb 120.4.12020000.2 2012/12/31 11:59:28 rgottipa ship $ */
3: /*
4: ******************************************************************
5: * *

Line 20: Name : pay_ca_eoy_t4a_cancel_pkg

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

Line 50: gv_package VARCHAR2(100) := 'pay_ca_eoy_t4a_cancel_pkg';

46: terminate employees and Self Service
47: 'paper' option.
48: *****************************************************************************/
49:
50: gv_package VARCHAR2(100) := 'pay_ca_eoy_t4a_cancel_pkg';
51: gv_procedure_name VARCHAR2(100);
52:
53: /*****************************************************************************
54: Name : get_payroll_action_info

Line 74: select to_number(pay_ca_eoy_t4a_cancel_pkg.get_parameter(

70: ,p_report_type out nocopy varchar2
71: )
72: IS
73: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
74: select to_number(pay_ca_eoy_t4a_cancel_pkg.get_parameter(
75: 'GRE_ID',ppa.legislative_parameters)),
76: to_number(pay_ca_eoy_t4a_cancel_pkg.get_parameter(
77: 'PER_ID',ppa.legislative_parameters)),
78: to_number(pay_ca_eoy_t4a_cancel_pkg.get_parameter(

Line 76: to_number(pay_ca_eoy_t4a_cancel_pkg.get_parameter(

72: IS
73: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
74: select to_number(pay_ca_eoy_t4a_cancel_pkg.get_parameter(
75: 'GRE_ID',ppa.legislative_parameters)),
76: to_number(pay_ca_eoy_t4a_cancel_pkg.get_parameter(
77: 'PER_ID',ppa.legislative_parameters)),
78: to_number(pay_ca_eoy_t4a_cancel_pkg.get_parameter(
79: 'ASG_SET_ID',ppa.legislative_parameters)),
80: pay_ca_eoy_t4a_cancel_pkg.get_parameter(

Line 78: to_number(pay_ca_eoy_t4a_cancel_pkg.get_parameter(

74: select to_number(pay_ca_eoy_t4a_cancel_pkg.get_parameter(
75: 'GRE_ID',ppa.legislative_parameters)),
76: to_number(pay_ca_eoy_t4a_cancel_pkg.get_parameter(
77: 'PER_ID',ppa.legislative_parameters)),
78: to_number(pay_ca_eoy_t4a_cancel_pkg.get_parameter(
79: 'ASG_SET_ID',ppa.legislative_parameters)),
80: pay_ca_eoy_t4a_cancel_pkg.get_parameter(
81: 'MODE',ppa.legislative_parameters),
82: effective_date,

Line 80: pay_ca_eoy_t4a_cancel_pkg.get_parameter(

76: to_number(pay_ca_eoy_t4a_cancel_pkg.get_parameter(
77: 'PER_ID',ppa.legislative_parameters)),
78: to_number(pay_ca_eoy_t4a_cancel_pkg.get_parameter(
79: 'ASG_SET_ID',ppa.legislative_parameters)),
80: pay_ca_eoy_t4a_cancel_pkg.get_parameter(
81: 'MODE',ppa.legislative_parameters),
82: effective_date,
83: start_date,
84: business_group_id,

Line 163: select to_number(pay_ca_eoy_t4a_cancel_pkg.get_parameter(

159: ,p_print_term out nocopy varchar2
160: )
161: IS
162: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
163: select to_number(pay_ca_eoy_t4a_cancel_pkg.get_parameter(
164: 'GRE_ID',ppa.legislative_parameters)),
165: to_number(pay_ca_eoy_t4a_cancel_pkg.get_parameter(
166: 'PER_ID',ppa.legislative_parameters)),
167: to_number(pay_ca_eoy_t4a_cancel_pkg.get_parameter(

Line 165: to_number(pay_ca_eoy_t4a_cancel_pkg.get_parameter(

161: IS
162: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
163: select to_number(pay_ca_eoy_t4a_cancel_pkg.get_parameter(
164: 'GRE_ID',ppa.legislative_parameters)),
165: to_number(pay_ca_eoy_t4a_cancel_pkg.get_parameter(
166: 'PER_ID',ppa.legislative_parameters)),
167: to_number(pay_ca_eoy_t4a_cancel_pkg.get_parameter(
168: 'ASG_SET_ID',ppa.legislative_parameters)),
169: pay_ca_eoy_t4a_cancel_pkg.get_parameter(

Line 167: to_number(pay_ca_eoy_t4a_cancel_pkg.get_parameter(

163: select to_number(pay_ca_eoy_t4a_cancel_pkg.get_parameter(
164: 'GRE_ID',ppa.legislative_parameters)),
165: to_number(pay_ca_eoy_t4a_cancel_pkg.get_parameter(
166: 'PER_ID',ppa.legislative_parameters)),
167: to_number(pay_ca_eoy_t4a_cancel_pkg.get_parameter(
168: 'ASG_SET_ID',ppa.legislative_parameters)),
169: pay_ca_eoy_t4a_cancel_pkg.get_parameter(
170: 'MODE',ppa.legislative_parameters),
171: effective_date,

Line 169: pay_ca_eoy_t4a_cancel_pkg.get_parameter(

165: to_number(pay_ca_eoy_t4a_cancel_pkg.get_parameter(
166: 'PER_ID',ppa.legislative_parameters)),
167: to_number(pay_ca_eoy_t4a_cancel_pkg.get_parameter(
168: 'ASG_SET_ID',ppa.legislative_parameters)),
169: pay_ca_eoy_t4a_cancel_pkg.get_parameter(
170: 'MODE',ppa.legislative_parameters),
171: effective_date,
172: start_date,
173: business_group_id,

Line 177: pay_ca_eoy_t4a_cancel_pkg.get_parameter(

173: business_group_id,
174: report_type,
175: report_qualifier,
176: report_category,
177: pay_ca_eoy_t4a_cancel_pkg.get_parameter(
178: 'PRINT_TERM',ppa.legislative_parameters)
179: from pay_payroll_actions ppa
180: where ppa.payroll_action_id = cp_payroll_action_id;
181:

Line 569: pay_ca_eoy_t4a_cancel_pkg.get_parameter(

565: and ppa.payroll_action_id = paa.payroll_action_id
566: and ppa.effective_date = cp_effective_date
567: and ppa.report_type in ('PAYCAT4APDF','PAYCAT4AAMPDF')
568: and decode(ppa.report_type,'PAYCAT4APDF','LATEST','PAYCAT4AAMPDF',
569: pay_ca_eoy_t4a_cancel_pkg.get_parameter(
570: 'MODE',ppa.legislative_parameters)) = 'LATEST'
571: and paf.effective_end_date = (select max(paf.effective_end_date)
572: from per_assignments_f paf
573: where paf.assignment_id = paa.assignment_id

Line 597: pay_ca_eoy_t4a_cancel_pkg.get_parameter('MODE',ppa2.legislative_parameters)) = 'LATEST'

593: and paa2.assignment_id = paa.assignment_id
594: and substr(paa2.serial_number,1,14)||lpad(paa2.assignment_action_id,14,0)
595: > substr(paa.serial_number,1,14)||lpad(paa.assignment_action_id,14,0)
596: and decode(ppa2.report_type,'PAYCAT4APDF','LATEST','PAYCAT4AAMPDF',
597: pay_ca_eoy_t4a_cancel_pkg.get_parameter('MODE',ppa2.legislative_parameters)) = 'LATEST'
598: )
599: group by paa.assignment_action_id,ppa.report_type,paa.assignment_id,paa.tax_unit_id,paa.serial_number,paf.effective_end_date
600: order by paa.assignment_action_id desc;
601:

Line 650: pay_ca_eoy_t4a_cancel_pkg.get_parameter('MODE',ppa2.legislative_parameters)) = 'LATEST'

646: and paa2.assignment_id = paa.assignment_id
647: and substr(paa2.serial_number,1,14)||lpad(paa2.assignment_action_id,14,0)
648: > substr(paa.serial_number,1,14)||lpad(paa.assignment_action_id,14,0)
649: and decode(ppa2.report_type,'PAYCAT4APDF','LATEST','PAYCAT4AAMPDF',
650: pay_ca_eoy_t4a_cancel_pkg.get_parameter('MODE',ppa2.legislative_parameters)) = 'LATEST'
651: )
652: group by paa.assignment_action_id,ppa.report_type,paa.assignment_id,paa.tax_unit_id,paa.serial_number,paf.effective_end_date
653: order by paa.assignment_action_id desc;
654:

Line 678: pay_ca_eoy_t4a_cancel_pkg.get_parameter(

674: and ppa.payroll_action_id = paa.payroll_action_id
675: and ppa.effective_date = cp_effective_date
676: and ppa.report_type in ('PAYCAT4APDF','PAYCAT4AAMPDF')
677: and decode(ppa.report_type,'PAYCAT4APDF','LATEST','PAYCAT4AAMPDF',
678: pay_ca_eoy_t4a_cancel_pkg.get_parameter(
679: 'MODE',ppa.legislative_parameters)) = 'LATEST'
680: and paf.effective_end_date = (select max(paf.effective_end_date)
681: from per_assignments_f paf
682: where paf.assignment_id = paa.assignment_id

Line 706: pay_ca_eoy_t4a_cancel_pkg.get_parameter('MODE',ppa2.legislative_parameters)) = 'LATEST'

702: and paa2.assignment_id = paa.assignment_id
703: and substr(paa2.serial_number,1,14)||lpad(paa2.assignment_action_id,14,0)
704: > substr(paa.serial_number,1,14)||lpad(paa.assignment_action_id,14,0)
705: and decode(ppa2.report_type,'PAYCAT4APDF','LATEST','PAYCAT4AAMPDF',
706: pay_ca_eoy_t4a_cancel_pkg.get_parameter('MODE',ppa2.legislative_parameters)) = 'LATEST'
707: )
708: and pds.actual_termination_date is not null
709: and pds.period_of_service_id = paf.period_of_service_id
710: group by paa.assignment_action_id,ppa.report_type,paa.assignment_id,paa.tax_unit_id,paa.serial_number,paf.effective_end_date

Line 762: pay_ca_eoy_t4a_cancel_pkg.get_parameter('MODE',ppa2.legislative_parameters)) = 'LATEST'

758: and paa2.assignment_id = paa.assignment_id
759: and substr(paa2.serial_number,1,14)||lpad(paa2.assignment_action_id,14,0)
760: > substr(paa.serial_number,1,14)||lpad(paa.assignment_action_id,14,0)
761: and decode(ppa2.report_type,'PAYCAT4APDF','LATEST','PAYCAT4AAMPDF',
762: pay_ca_eoy_t4a_cancel_pkg.get_parameter('MODE',ppa2.legislative_parameters)) = 'LATEST'
763: )
764: and pds.actual_termination_date is not null
765: and pds.period_of_service_id = paf.period_of_service_id
766: group by paa.assignment_action_id,ppa.report_type,paa.assignment_id,paa.tax_unit_id,paa.serial_number,paf.effective_end_date

Line 1443: select pay_ca_eoy_t4a_cancel_pkg.get_parameter('GRE_ID',ppa.legislative_parameters),

1439:
1440: begin
1441:
1442: begin
1443: select pay_ca_eoy_t4a_cancel_pkg.get_parameter('GRE_ID',ppa.legislative_parameters),
1444: pay_ca_eoy_t4a_cancel_pkg.get_parameter('PER_ID',ppa.legislative_parameters),
1445: pay_ca_eoy_t4a_cancel_pkg.get_parameter('ASG_SET_ID',ppa.legislative_parameters),
1446: pay_ca_eoy_t4a_cancel_pkg.get_parameter('P_S1',ppa.legislative_parameters),
1447: pay_ca_eoy_t4a_cancel_pkg.get_parameter('P_S2',ppa.legislative_parameters),

Line 1444: pay_ca_eoy_t4a_cancel_pkg.get_parameter('PER_ID',ppa.legislative_parameters),

1440: begin
1441:
1442: begin
1443: select pay_ca_eoy_t4a_cancel_pkg.get_parameter('GRE_ID',ppa.legislative_parameters),
1444: pay_ca_eoy_t4a_cancel_pkg.get_parameter('PER_ID',ppa.legislative_parameters),
1445: pay_ca_eoy_t4a_cancel_pkg.get_parameter('ASG_SET_ID',ppa.legislative_parameters),
1446: pay_ca_eoy_t4a_cancel_pkg.get_parameter('P_S1',ppa.legislative_parameters),
1447: pay_ca_eoy_t4a_cancel_pkg.get_parameter('P_S2',ppa.legislative_parameters),
1448: pay_ca_eoy_t4a_cancel_pkg.get_parameter('P_S3',ppa.legislative_parameters),

Line 1445: pay_ca_eoy_t4a_cancel_pkg.get_parameter('ASG_SET_ID',ppa.legislative_parameters),

1441:
1442: begin
1443: select pay_ca_eoy_t4a_cancel_pkg.get_parameter('GRE_ID',ppa.legislative_parameters),
1444: pay_ca_eoy_t4a_cancel_pkg.get_parameter('PER_ID',ppa.legislative_parameters),
1445: pay_ca_eoy_t4a_cancel_pkg.get_parameter('ASG_SET_ID',ppa.legislative_parameters),
1446: pay_ca_eoy_t4a_cancel_pkg.get_parameter('P_S1',ppa.legislative_parameters),
1447: pay_ca_eoy_t4a_cancel_pkg.get_parameter('P_S2',ppa.legislative_parameters),
1448: pay_ca_eoy_t4a_cancel_pkg.get_parameter('P_S3',ppa.legislative_parameters),
1449: pay_ca_eoy_t4a_cancel_pkg.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),

Line 1446: pay_ca_eoy_t4a_cancel_pkg.get_parameter('P_S1',ppa.legislative_parameters),

1442: begin
1443: select pay_ca_eoy_t4a_cancel_pkg.get_parameter('GRE_ID',ppa.legislative_parameters),
1444: pay_ca_eoy_t4a_cancel_pkg.get_parameter('PER_ID',ppa.legislative_parameters),
1445: pay_ca_eoy_t4a_cancel_pkg.get_parameter('ASG_SET_ID',ppa.legislative_parameters),
1446: pay_ca_eoy_t4a_cancel_pkg.get_parameter('P_S1',ppa.legislative_parameters),
1447: pay_ca_eoy_t4a_cancel_pkg.get_parameter('P_S2',ppa.legislative_parameters),
1448: pay_ca_eoy_t4a_cancel_pkg.get_parameter('P_S3',ppa.legislative_parameters),
1449: pay_ca_eoy_t4a_cancel_pkg.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),
1450: pay_ca_eoy_t4a_cancel_pkg.get_parameter('MODE',ppa.legislative_parameters),

Line 1447: pay_ca_eoy_t4a_cancel_pkg.get_parameter('P_S2',ppa.legislative_parameters),

1443: select pay_ca_eoy_t4a_cancel_pkg.get_parameter('GRE_ID',ppa.legislative_parameters),
1444: pay_ca_eoy_t4a_cancel_pkg.get_parameter('PER_ID',ppa.legislative_parameters),
1445: pay_ca_eoy_t4a_cancel_pkg.get_parameter('ASG_SET_ID',ppa.legislative_parameters),
1446: pay_ca_eoy_t4a_cancel_pkg.get_parameter('P_S1',ppa.legislative_parameters),
1447: pay_ca_eoy_t4a_cancel_pkg.get_parameter('P_S2',ppa.legislative_parameters),
1448: pay_ca_eoy_t4a_cancel_pkg.get_parameter('P_S3',ppa.legislative_parameters),
1449: pay_ca_eoy_t4a_cancel_pkg.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),
1450: pay_ca_eoy_t4a_cancel_pkg.get_parameter('MODE',ppa.legislative_parameters),
1451: ppa.effective_date,

Line 1448: pay_ca_eoy_t4a_cancel_pkg.get_parameter('P_S3',ppa.legislative_parameters),

1444: pay_ca_eoy_t4a_cancel_pkg.get_parameter('PER_ID',ppa.legislative_parameters),
1445: pay_ca_eoy_t4a_cancel_pkg.get_parameter('ASG_SET_ID',ppa.legislative_parameters),
1446: pay_ca_eoy_t4a_cancel_pkg.get_parameter('P_S1',ppa.legislative_parameters),
1447: pay_ca_eoy_t4a_cancel_pkg.get_parameter('P_S2',ppa.legislative_parameters),
1448: pay_ca_eoy_t4a_cancel_pkg.get_parameter('P_S3',ppa.legislative_parameters),
1449: pay_ca_eoy_t4a_cancel_pkg.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),
1450: pay_ca_eoy_t4a_cancel_pkg.get_parameter('MODE',ppa.legislative_parameters),
1451: ppa.effective_date,
1452: ppa.start_date,

Line 1449: pay_ca_eoy_t4a_cancel_pkg.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),

1445: pay_ca_eoy_t4a_cancel_pkg.get_parameter('ASG_SET_ID',ppa.legislative_parameters),
1446: pay_ca_eoy_t4a_cancel_pkg.get_parameter('P_S1',ppa.legislative_parameters),
1447: pay_ca_eoy_t4a_cancel_pkg.get_parameter('P_S2',ppa.legislative_parameters),
1448: pay_ca_eoy_t4a_cancel_pkg.get_parameter('P_S3',ppa.legislative_parameters),
1449: pay_ca_eoy_t4a_cancel_pkg.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),
1450: pay_ca_eoy_t4a_cancel_pkg.get_parameter('MODE',ppa.legislative_parameters),
1451: ppa.effective_date,
1452: ppa.start_date,
1453: ppa.business_group_id

Line 1450: pay_ca_eoy_t4a_cancel_pkg.get_parameter('MODE',ppa.legislative_parameters),

1446: pay_ca_eoy_t4a_cancel_pkg.get_parameter('P_S1',ppa.legislative_parameters),
1447: pay_ca_eoy_t4a_cancel_pkg.get_parameter('P_S2',ppa.legislative_parameters),
1448: pay_ca_eoy_t4a_cancel_pkg.get_parameter('P_S3',ppa.legislative_parameters),
1449: pay_ca_eoy_t4a_cancel_pkg.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),
1450: pay_ca_eoy_t4a_cancel_pkg.get_parameter('MODE',ppa.legislative_parameters),
1451: ppa.effective_date,
1452: ppa.start_date,
1453: ppa.business_group_id
1454: into l_gre_id,

Line 1569: end pay_ca_eoy_t4a_cancel_pkg;

1565:
1566: /* hr_utility.trace_on(null,'T4A_CANCEL_PDF'); */
1567: null;
1568:
1569: end pay_ca_eoy_t4a_cancel_pkg;