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_RL2_CANCEL_PKG dependencies on PAY_CA_EOY_RL2_CANCEL_PKG

Line 1: PACKAGE BODY pay_ca_eoy_rl2_cancel_pkg AS

1: PACKAGE BODY pay_ca_eoy_rl2_cancel_pkg AS
2: /* $Header: pycarl2clcr.pkb 120.2.12020000.2 2012/12/31 13:27:01 rgottipa ship $ */
3: /*
4: ******************************************************************
5: * *

Line 20: Name : pay_ca_eoy_rl2_cancel_pkg

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

Line 64: select to_number(pay_ca_eoy_rl2_cancel_pkg.get_parameter(

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

Line 66: to_number(pay_ca_eoy_rl2_cancel_pkg.get_parameter(

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

Line 68: to_number(pay_ca_eoy_rl2_cancel_pkg.get_parameter(

64: select to_number(pay_ca_eoy_rl2_cancel_pkg.get_parameter(
65: 'PRE_ORGANIZATION_ID',ppa.legislative_parameters)),
66: to_number(pay_ca_eoy_rl2_cancel_pkg.get_parameter(
67: 'PER_ID',ppa.legislative_parameters)),
68: to_number(pay_ca_eoy_rl2_cancel_pkg.get_parameter(
69: 'ASG_SET_ID',ppa.legislative_parameters)),
70: pay_ca_eoy_rl2_cancel_pkg.get_parameter(
71: 'MODE',ppa.legislative_parameters),
72: effective_date,

Line 70: pay_ca_eoy_rl2_cancel_pkg.get_parameter(

66: to_number(pay_ca_eoy_rl2_cancel_pkg.get_parameter(
67: 'PER_ID',ppa.legislative_parameters)),
68: to_number(pay_ca_eoy_rl2_cancel_pkg.get_parameter(
69: 'ASG_SET_ID',ppa.legislative_parameters)),
70: pay_ca_eoy_rl2_cancel_pkg.get_parameter(
71: 'MODE',ppa.legislative_parameters),
72: effective_date,
73: start_date,
74: business_group_id,

Line 75: pay_ca_eoy_rl2_cancel_pkg.get_parameter(

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

Line 149: select to_number(pay_ca_eoy_rl2_cancel_pkg.get_parameter(

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

Line 151: to_number(pay_ca_eoy_rl2_cancel_pkg.get_parameter(

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

Line 153: to_number(pay_ca_eoy_rl2_cancel_pkg.get_parameter(

149: select to_number(pay_ca_eoy_rl2_cancel_pkg.get_parameter(
150: 'PRE_ORGANIZATION_ID',ppa.legislative_parameters)),
151: to_number(pay_ca_eoy_rl2_cancel_pkg.get_parameter(
152: 'PER_ID',ppa.legislative_parameters)),
153: to_number(pay_ca_eoy_rl2_cancel_pkg.get_parameter(
154: 'ASG_SET_ID',ppa.legislative_parameters)),
155: pay_ca_eoy_rl2_cancel_pkg.get_parameter(
156: 'MODE',ppa.legislative_parameters),
157: effective_date,

Line 155: pay_ca_eoy_rl2_cancel_pkg.get_parameter(

151: to_number(pay_ca_eoy_rl2_cancel_pkg.get_parameter(
152: 'PER_ID',ppa.legislative_parameters)),
153: to_number(pay_ca_eoy_rl2_cancel_pkg.get_parameter(
154: 'ASG_SET_ID',ppa.legislative_parameters)),
155: pay_ca_eoy_rl2_cancel_pkg.get_parameter(
156: 'MODE',ppa.legislative_parameters),
157: effective_date,
158: start_date,
159: business_group_id,

Line 160: pay_ca_eoy_rl2_cancel_pkg.get_parameter(

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

Line 165: pay_ca_eoy_rl2_cancel_pkg.get_parameter(

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

Line 563: pay_ca_eoy_rl2_cancel_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 ('RL2PAPERPDF','PAYCARL2AMPDF')
562: and decode(ppa.report_type,'RL2PAPERPDF','LATEST','PAYCARL2AMPDF',
563: pay_ca_eoy_rl2_cancel_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_RL2_NEGATIVE_BALANCE_EXISTS'),'N') = 'N'

Line 671: pay_ca_eoy_rl2_cancel_pkg.get_parameter(

667: and ppa.payroll_action_id = paa.payroll_action_id
668: and ppa.effective_date = cp_effective_date
669: and ppa.report_type in ('RL2PAPERPDF','PAYCARL2AMPDF')
670: and decode(ppa.report_type,'RL2PAPERPDF','LATEST','PAYCARL2AMPDF',
671: pay_ca_eoy_rl2_cancel_pkg.get_parameter(
672: 'MODE',ppa.legislative_parameters)) = 'LATEST'
673: and nvl(pay_ca_archive_utils.get_archive_value(substr(paa.serial_number,3,14),
674: substr(paa.serial_number,1,2),'JURISDICTION_CODE',
675: 'CAEOY_RL2_NEGATIVE_BALANCE_EXISTS'),'N') = 'N'

Line 1380: select pay_ca_eoy_rl2_cancel_pkg.get_parameter('PRE_ID',ppa.legislative_parameters),

1376:
1377: begin
1378:
1379: begin
1380: select pay_ca_eoy_rl2_cancel_pkg.get_parameter('PRE_ID',ppa.legislative_parameters),
1381: pay_ca_eoy_rl2_cancel_pkg.get_parameter('PER_ID',ppa.legislative_parameters),
1382: pay_ca_eoy_rl2_cancel_pkg.get_parameter('ASG_SET_ID',ppa.legislative_parameters),
1383: pay_ca_eoy_rl2_cancel_pkg.get_parameter('P_S1',ppa.legislative_parameters),
1384: pay_ca_eoy_rl2_cancel_pkg.get_parameter('P_S2',ppa.legislative_parameters),

Line 1381: pay_ca_eoy_rl2_cancel_pkg.get_parameter('PER_ID',ppa.legislative_parameters),

1377: begin
1378:
1379: begin
1380: select pay_ca_eoy_rl2_cancel_pkg.get_parameter('PRE_ID',ppa.legislative_parameters),
1381: pay_ca_eoy_rl2_cancel_pkg.get_parameter('PER_ID',ppa.legislative_parameters),
1382: pay_ca_eoy_rl2_cancel_pkg.get_parameter('ASG_SET_ID',ppa.legislative_parameters),
1383: pay_ca_eoy_rl2_cancel_pkg.get_parameter('P_S1',ppa.legislative_parameters),
1384: pay_ca_eoy_rl2_cancel_pkg.get_parameter('P_S2',ppa.legislative_parameters),
1385: pay_ca_eoy_rl2_cancel_pkg.get_parameter('P_S3',ppa.legislative_parameters),

Line 1382: pay_ca_eoy_rl2_cancel_pkg.get_parameter('ASG_SET_ID',ppa.legislative_parameters),

1378:
1379: begin
1380: select pay_ca_eoy_rl2_cancel_pkg.get_parameter('PRE_ID',ppa.legislative_parameters),
1381: pay_ca_eoy_rl2_cancel_pkg.get_parameter('PER_ID',ppa.legislative_parameters),
1382: pay_ca_eoy_rl2_cancel_pkg.get_parameter('ASG_SET_ID',ppa.legislative_parameters),
1383: pay_ca_eoy_rl2_cancel_pkg.get_parameter('P_S1',ppa.legislative_parameters),
1384: pay_ca_eoy_rl2_cancel_pkg.get_parameter('P_S2',ppa.legislative_parameters),
1385: pay_ca_eoy_rl2_cancel_pkg.get_parameter('P_S3',ppa.legislative_parameters),
1386: pay_ca_eoy_rl2_cancel_pkg.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),

Line 1383: pay_ca_eoy_rl2_cancel_pkg.get_parameter('P_S1',ppa.legislative_parameters),

1379: begin
1380: select pay_ca_eoy_rl2_cancel_pkg.get_parameter('PRE_ID',ppa.legislative_parameters),
1381: pay_ca_eoy_rl2_cancel_pkg.get_parameter('PER_ID',ppa.legislative_parameters),
1382: pay_ca_eoy_rl2_cancel_pkg.get_parameter('ASG_SET_ID',ppa.legislative_parameters),
1383: pay_ca_eoy_rl2_cancel_pkg.get_parameter('P_S1',ppa.legislative_parameters),
1384: pay_ca_eoy_rl2_cancel_pkg.get_parameter('P_S2',ppa.legislative_parameters),
1385: pay_ca_eoy_rl2_cancel_pkg.get_parameter('P_S3',ppa.legislative_parameters),
1386: pay_ca_eoy_rl2_cancel_pkg.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),
1387: pay_ca_eoy_rl2_cancel_pkg.get_parameter('MODE',ppa.legislative_parameters),

Line 1384: pay_ca_eoy_rl2_cancel_pkg.get_parameter('P_S2',ppa.legislative_parameters),

1380: select pay_ca_eoy_rl2_cancel_pkg.get_parameter('PRE_ID',ppa.legislative_parameters),
1381: pay_ca_eoy_rl2_cancel_pkg.get_parameter('PER_ID',ppa.legislative_parameters),
1382: pay_ca_eoy_rl2_cancel_pkg.get_parameter('ASG_SET_ID',ppa.legislative_parameters),
1383: pay_ca_eoy_rl2_cancel_pkg.get_parameter('P_S1',ppa.legislative_parameters),
1384: pay_ca_eoy_rl2_cancel_pkg.get_parameter('P_S2',ppa.legislative_parameters),
1385: pay_ca_eoy_rl2_cancel_pkg.get_parameter('P_S3',ppa.legislative_parameters),
1386: pay_ca_eoy_rl2_cancel_pkg.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),
1387: pay_ca_eoy_rl2_cancel_pkg.get_parameter('MODE',ppa.legislative_parameters),
1388: ppa.effective_date,

Line 1385: pay_ca_eoy_rl2_cancel_pkg.get_parameter('P_S3',ppa.legislative_parameters),

1381: pay_ca_eoy_rl2_cancel_pkg.get_parameter('PER_ID',ppa.legislative_parameters),
1382: pay_ca_eoy_rl2_cancel_pkg.get_parameter('ASG_SET_ID',ppa.legislative_parameters),
1383: pay_ca_eoy_rl2_cancel_pkg.get_parameter('P_S1',ppa.legislative_parameters),
1384: pay_ca_eoy_rl2_cancel_pkg.get_parameter('P_S2',ppa.legislative_parameters),
1385: pay_ca_eoy_rl2_cancel_pkg.get_parameter('P_S3',ppa.legislative_parameters),
1386: pay_ca_eoy_rl2_cancel_pkg.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),
1387: pay_ca_eoy_rl2_cancel_pkg.get_parameter('MODE',ppa.legislative_parameters),
1388: ppa.effective_date,
1389: ppa.start_date,

Line 1386: pay_ca_eoy_rl2_cancel_pkg.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),

1382: pay_ca_eoy_rl2_cancel_pkg.get_parameter('ASG_SET_ID',ppa.legislative_parameters),
1383: pay_ca_eoy_rl2_cancel_pkg.get_parameter('P_S1',ppa.legislative_parameters),
1384: pay_ca_eoy_rl2_cancel_pkg.get_parameter('P_S2',ppa.legislative_parameters),
1385: pay_ca_eoy_rl2_cancel_pkg.get_parameter('P_S3',ppa.legislative_parameters),
1386: pay_ca_eoy_rl2_cancel_pkg.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),
1387: pay_ca_eoy_rl2_cancel_pkg.get_parameter('MODE',ppa.legislative_parameters),
1388: ppa.effective_date,
1389: ppa.start_date,
1390: ppa.business_group_id

Line 1387: pay_ca_eoy_rl2_cancel_pkg.get_parameter('MODE',ppa.legislative_parameters),

1383: pay_ca_eoy_rl2_cancel_pkg.get_parameter('P_S1',ppa.legislative_parameters),
1384: pay_ca_eoy_rl2_cancel_pkg.get_parameter('P_S2',ppa.legislative_parameters),
1385: pay_ca_eoy_rl2_cancel_pkg.get_parameter('P_S3',ppa.legislative_parameters),
1386: pay_ca_eoy_rl2_cancel_pkg.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),
1387: pay_ca_eoy_rl2_cancel_pkg.get_parameter('MODE',ppa.legislative_parameters),
1388: ppa.effective_date,
1389: ppa.start_date,
1390: ppa.business_group_id
1391: into l_pre_id,

Line 1505: end pay_ca_eoy_rl2_cancel_pkg;

1501: Begin
1502:
1503: -- hr_utility.trace_on(null,'rl2_cancel_PDF');
1504: null;
1505: end pay_ca_eoy_rl2_cancel_pkg;