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_RL1_CANCELLED_PKG dependencies on PAY_CA_EOY_RL1_CANCELLED_PKG

Line 1: PACKAGE BODY pay_ca_eoy_rl1_cancelled_pkg AS

1: PACKAGE BODY pay_ca_eoy_rl1_cancelled_pkg AS
2: /* $Header: pycarl1clcr.pkb 120.3.12020000.2 2012/12/31 12:56:19 rgottipa ship $ */
3: /*
4: ******************************************************************
5: * *

Line 20: Name : pay_ca_eoy_rl1_cancelled_pkg

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

Line 66: select to_number(pay_ca_eoy_rl1_cancelled_pkg.get_parameter(

62: ,p_report_type out nocopy varchar2
63: )
64: IS
65: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
66: select to_number(pay_ca_eoy_rl1_cancelled_pkg.get_parameter(
67: 'PRE_ORGANIZATION_ID',ppa.legislative_parameters)),
68: to_number(pay_ca_eoy_rl1_cancelled_pkg.get_parameter(
69: 'PER_ID',ppa.legislative_parameters)),
70: to_number(pay_ca_eoy_rl1_cancelled_pkg.get_parameter(

Line 68: to_number(pay_ca_eoy_rl1_cancelled_pkg.get_parameter(

64: IS
65: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
66: select to_number(pay_ca_eoy_rl1_cancelled_pkg.get_parameter(
67: 'PRE_ORGANIZATION_ID',ppa.legislative_parameters)),
68: to_number(pay_ca_eoy_rl1_cancelled_pkg.get_parameter(
69: 'PER_ID',ppa.legislative_parameters)),
70: to_number(pay_ca_eoy_rl1_cancelled_pkg.get_parameter(
71: 'ASG_SET_ID',ppa.legislative_parameters)),
72: pay_ca_eoy_rl1_cancelled_pkg.get_parameter(

Line 70: to_number(pay_ca_eoy_rl1_cancelled_pkg.get_parameter(

66: select to_number(pay_ca_eoy_rl1_cancelled_pkg.get_parameter(
67: 'PRE_ORGANIZATION_ID',ppa.legislative_parameters)),
68: to_number(pay_ca_eoy_rl1_cancelled_pkg.get_parameter(
69: 'PER_ID',ppa.legislative_parameters)),
70: to_number(pay_ca_eoy_rl1_cancelled_pkg.get_parameter(
71: 'ASG_SET_ID',ppa.legislative_parameters)),
72: pay_ca_eoy_rl1_cancelled_pkg.get_parameter(
73: 'MODE',ppa.legislative_parameters),
74: effective_date,

Line 72: pay_ca_eoy_rl1_cancelled_pkg.get_parameter(

68: to_number(pay_ca_eoy_rl1_cancelled_pkg.get_parameter(
69: 'PER_ID',ppa.legislative_parameters)),
70: to_number(pay_ca_eoy_rl1_cancelled_pkg.get_parameter(
71: 'ASG_SET_ID',ppa.legislative_parameters)),
72: pay_ca_eoy_rl1_cancelled_pkg.get_parameter(
73: 'MODE',ppa.legislative_parameters),
74: effective_date,
75: start_date,
76: business_group_id,

Line 77: pay_ca_eoy_rl1_cancelled_pkg.get_parameter(

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

Line 151: select to_number(pay_ca_eoy_rl1_cancelled_pkg.get_parameter(

147: ,p_print_term out nocopy varchar2
148: )
149: IS
150: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
151: select to_number(pay_ca_eoy_rl1_cancelled_pkg.get_parameter(
152: 'PRE_ORGANIZATION_ID',ppa.legislative_parameters)),
153: to_number(pay_ca_eoy_rl1_cancelled_pkg.get_parameter(
154: 'PER_ID',ppa.legislative_parameters)),
155: to_number(pay_ca_eoy_rl1_cancelled_pkg.get_parameter(

Line 153: to_number(pay_ca_eoy_rl1_cancelled_pkg.get_parameter(

149: IS
150: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
151: select to_number(pay_ca_eoy_rl1_cancelled_pkg.get_parameter(
152: 'PRE_ORGANIZATION_ID',ppa.legislative_parameters)),
153: to_number(pay_ca_eoy_rl1_cancelled_pkg.get_parameter(
154: 'PER_ID',ppa.legislative_parameters)),
155: to_number(pay_ca_eoy_rl1_cancelled_pkg.get_parameter(
156: 'ASG_SET_ID',ppa.legislative_parameters)),
157: pay_ca_eoy_rl1_cancelled_pkg.get_parameter(

Line 155: to_number(pay_ca_eoy_rl1_cancelled_pkg.get_parameter(

151: select to_number(pay_ca_eoy_rl1_cancelled_pkg.get_parameter(
152: 'PRE_ORGANIZATION_ID',ppa.legislative_parameters)),
153: to_number(pay_ca_eoy_rl1_cancelled_pkg.get_parameter(
154: 'PER_ID',ppa.legislative_parameters)),
155: to_number(pay_ca_eoy_rl1_cancelled_pkg.get_parameter(
156: 'ASG_SET_ID',ppa.legislative_parameters)),
157: pay_ca_eoy_rl1_cancelled_pkg.get_parameter(
158: 'MODE',ppa.legislative_parameters),
159: effective_date,

Line 157: pay_ca_eoy_rl1_cancelled_pkg.get_parameter(

153: to_number(pay_ca_eoy_rl1_cancelled_pkg.get_parameter(
154: 'PER_ID',ppa.legislative_parameters)),
155: to_number(pay_ca_eoy_rl1_cancelled_pkg.get_parameter(
156: 'ASG_SET_ID',ppa.legislative_parameters)),
157: pay_ca_eoy_rl1_cancelled_pkg.get_parameter(
158: 'MODE',ppa.legislative_parameters),
159: effective_date,
160: start_date,
161: business_group_id,

Line 162: pay_ca_eoy_rl1_cancelled_pkg.get_parameter(

158: 'MODE',ppa.legislative_parameters),
159: effective_date,
160: start_date,
161: business_group_id,
162: pay_ca_eoy_rl1_cancelled_pkg.get_parameter(
163: 'PROV_CD',ppa.legislative_parameters),
164: report_type,
165: report_qualifier,
166: report_category,

Line 167: pay_ca_eoy_rl1_cancelled_pkg.get_parameter(

163: 'PROV_CD',ppa.legislative_parameters),
164: report_type,
165: report_qualifier,
166: report_category,
167: pay_ca_eoy_rl1_cancelled_pkg.get_parameter(
168: 'PRINT_TERM',ppa.legislative_parameters)
169: from pay_payroll_actions ppa
170: where ppa.payroll_action_id = cp_payroll_action_id;
171:

Line 563: pay_ca_eoy_rl1_cancelled_pkg.get_parameter(

559: and ppa.payroll_action_id = paa.payroll_action_id
560: and ppa.effective_date = cp_effective_date
561: and ppa.report_type in ('RL1PAPERPDF','PAYCARL1AMPDF')
562: and decode(ppa.report_type,'RL1PAPERPDF','LATEST','PAYCARL1AMPDF',
563: pay_ca_eoy_rl1_cancelled_pkg.get_parameter(
564: 'MODE',ppa.legislative_parameters)) = 'LATEST'
565: and nvl(pay_ca_archive_utils.get_archive_value(substr(paa.serial_number,3,14),
566: substr(paa.serial_number,1,2),'JURISDICTION_CODE',
567: 'CAEOY_RL1_NEGATIVE_BALANCE_EXISTS'),'N') = 'N'

Line 677: pay_ca_eoy_rl1_cancelled_pkg.get_parameter(

673: and ppa.payroll_action_id = paa.payroll_action_id
674: and ppa.effective_date = cp_effective_date
675: and ppa.report_type in ('RL1PAPERPDF','PAYCARL1AMPDF')
676: and decode(ppa.report_type,'RL1PAPERPDF','LATEST','PAYCARL1AMPDF',
677: pay_ca_eoy_rl1_cancelled_pkg.get_parameter(
678: 'MODE',ppa.legislative_parameters)) = 'LATEST'
679: and nvl(pay_ca_archive_utils.get_archive_value(substr(paa.serial_number,3,14),
680: substr(paa.serial_number,1,2),'JURISDICTION_CODE',
681: 'CAEOY_RL1_NEGATIVE_BALANCE_EXISTS'),'N') = 'N'

Line 1394: select pay_ca_eoy_rl1_cancelled_pkg.get_parameter('PRE_ID',ppa.legislative_parameters),

1390:
1391: begin
1392:
1393: begin
1394: select pay_ca_eoy_rl1_cancelled_pkg.get_parameter('PRE_ID',ppa.legislative_parameters),
1395: pay_ca_eoy_rl1_cancelled_pkg.get_parameter('PER_ID',ppa.legislative_parameters),
1396: pay_ca_eoy_rl1_cancelled_pkg.get_parameter('ASG_SET_ID',ppa.legislative_parameters),
1397: pay_ca_eoy_rl1_cancelled_pkg.get_parameter('P_S1',ppa.legislative_parameters),
1398: pay_ca_eoy_rl1_cancelled_pkg.get_parameter('P_S2',ppa.legislative_parameters),

Line 1395: pay_ca_eoy_rl1_cancelled_pkg.get_parameter('PER_ID',ppa.legislative_parameters),

1391: begin
1392:
1393: begin
1394: select pay_ca_eoy_rl1_cancelled_pkg.get_parameter('PRE_ID',ppa.legislative_parameters),
1395: pay_ca_eoy_rl1_cancelled_pkg.get_parameter('PER_ID',ppa.legislative_parameters),
1396: pay_ca_eoy_rl1_cancelled_pkg.get_parameter('ASG_SET_ID',ppa.legislative_parameters),
1397: pay_ca_eoy_rl1_cancelled_pkg.get_parameter('P_S1',ppa.legislative_parameters),
1398: pay_ca_eoy_rl1_cancelled_pkg.get_parameter('P_S2',ppa.legislative_parameters),
1399: pay_ca_eoy_rl1_cancelled_pkg.get_parameter('P_S3',ppa.legislative_parameters),

Line 1396: pay_ca_eoy_rl1_cancelled_pkg.get_parameter('ASG_SET_ID',ppa.legislative_parameters),

1392:
1393: begin
1394: select pay_ca_eoy_rl1_cancelled_pkg.get_parameter('PRE_ID',ppa.legislative_parameters),
1395: pay_ca_eoy_rl1_cancelled_pkg.get_parameter('PER_ID',ppa.legislative_parameters),
1396: pay_ca_eoy_rl1_cancelled_pkg.get_parameter('ASG_SET_ID',ppa.legislative_parameters),
1397: pay_ca_eoy_rl1_cancelled_pkg.get_parameter('P_S1',ppa.legislative_parameters),
1398: pay_ca_eoy_rl1_cancelled_pkg.get_parameter('P_S2',ppa.legislative_parameters),
1399: pay_ca_eoy_rl1_cancelled_pkg.get_parameter('P_S3',ppa.legislative_parameters),
1400: pay_ca_eoy_rl1_cancelled_pkg.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),

Line 1397: pay_ca_eoy_rl1_cancelled_pkg.get_parameter('P_S1',ppa.legislative_parameters),

1393: begin
1394: select pay_ca_eoy_rl1_cancelled_pkg.get_parameter('PRE_ID',ppa.legislative_parameters),
1395: pay_ca_eoy_rl1_cancelled_pkg.get_parameter('PER_ID',ppa.legislative_parameters),
1396: pay_ca_eoy_rl1_cancelled_pkg.get_parameter('ASG_SET_ID',ppa.legislative_parameters),
1397: pay_ca_eoy_rl1_cancelled_pkg.get_parameter('P_S1',ppa.legislative_parameters),
1398: pay_ca_eoy_rl1_cancelled_pkg.get_parameter('P_S2',ppa.legislative_parameters),
1399: pay_ca_eoy_rl1_cancelled_pkg.get_parameter('P_S3',ppa.legislative_parameters),
1400: pay_ca_eoy_rl1_cancelled_pkg.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),
1401: pay_ca_eoy_rl1_cancelled_pkg.get_parameter('MODE',ppa.legislative_parameters),

Line 1398: pay_ca_eoy_rl1_cancelled_pkg.get_parameter('P_S2',ppa.legislative_parameters),

1394: select pay_ca_eoy_rl1_cancelled_pkg.get_parameter('PRE_ID',ppa.legislative_parameters),
1395: pay_ca_eoy_rl1_cancelled_pkg.get_parameter('PER_ID',ppa.legislative_parameters),
1396: pay_ca_eoy_rl1_cancelled_pkg.get_parameter('ASG_SET_ID',ppa.legislative_parameters),
1397: pay_ca_eoy_rl1_cancelled_pkg.get_parameter('P_S1',ppa.legislative_parameters),
1398: pay_ca_eoy_rl1_cancelled_pkg.get_parameter('P_S2',ppa.legislative_parameters),
1399: pay_ca_eoy_rl1_cancelled_pkg.get_parameter('P_S3',ppa.legislative_parameters),
1400: pay_ca_eoy_rl1_cancelled_pkg.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),
1401: pay_ca_eoy_rl1_cancelled_pkg.get_parameter('MODE',ppa.legislative_parameters),
1402: ppa.effective_date,

Line 1399: pay_ca_eoy_rl1_cancelled_pkg.get_parameter('P_S3',ppa.legislative_parameters),

1395: pay_ca_eoy_rl1_cancelled_pkg.get_parameter('PER_ID',ppa.legislative_parameters),
1396: pay_ca_eoy_rl1_cancelled_pkg.get_parameter('ASG_SET_ID',ppa.legislative_parameters),
1397: pay_ca_eoy_rl1_cancelled_pkg.get_parameter('P_S1',ppa.legislative_parameters),
1398: pay_ca_eoy_rl1_cancelled_pkg.get_parameter('P_S2',ppa.legislative_parameters),
1399: pay_ca_eoy_rl1_cancelled_pkg.get_parameter('P_S3',ppa.legislative_parameters),
1400: pay_ca_eoy_rl1_cancelled_pkg.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),
1401: pay_ca_eoy_rl1_cancelled_pkg.get_parameter('MODE',ppa.legislative_parameters),
1402: ppa.effective_date,
1403: ppa.start_date,

Line 1400: pay_ca_eoy_rl1_cancelled_pkg.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),

1396: pay_ca_eoy_rl1_cancelled_pkg.get_parameter('ASG_SET_ID',ppa.legislative_parameters),
1397: pay_ca_eoy_rl1_cancelled_pkg.get_parameter('P_S1',ppa.legislative_parameters),
1398: pay_ca_eoy_rl1_cancelled_pkg.get_parameter('P_S2',ppa.legislative_parameters),
1399: pay_ca_eoy_rl1_cancelled_pkg.get_parameter('P_S3',ppa.legislative_parameters),
1400: pay_ca_eoy_rl1_cancelled_pkg.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),
1401: pay_ca_eoy_rl1_cancelled_pkg.get_parameter('MODE',ppa.legislative_parameters),
1402: ppa.effective_date,
1403: ppa.start_date,
1404: ppa.business_group_id

Line 1401: pay_ca_eoy_rl1_cancelled_pkg.get_parameter('MODE',ppa.legislative_parameters),

1397: pay_ca_eoy_rl1_cancelled_pkg.get_parameter('P_S1',ppa.legislative_parameters),
1398: pay_ca_eoy_rl1_cancelled_pkg.get_parameter('P_S2',ppa.legislative_parameters),
1399: pay_ca_eoy_rl1_cancelled_pkg.get_parameter('P_S3',ppa.legislative_parameters),
1400: pay_ca_eoy_rl1_cancelled_pkg.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),
1401: pay_ca_eoy_rl1_cancelled_pkg.get_parameter('MODE',ppa.legislative_parameters),
1402: ppa.effective_date,
1403: ppa.start_date,
1404: ppa.business_group_id
1405: into l_pre_id,

Line 1519: end pay_ca_eoy_rl1_cancelled_pkg;

1515: Begin
1516:
1517: -- hr_utility.trace_on(null,'RL1_CANCELLED_PDF');
1518: null;
1519: end pay_ca_eoy_rl1_cancelled_pkg;