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_T4_AMEND_REG dependencies on PAY_CA_EOY_T4_AMEND_REG

Line 1: PACKAGE BODY pay_ca_eoy_t4_amend_reg AS

1: PACKAGE BODY pay_ca_eoy_t4_amend_reg AS
2: /* $Header: pycat4cr.pkb 120.12.12020000.5 2013/02/04 06:53:20 rgottipa ship $ */
3: /*
4: ******************************************************************
5: * *

Line 20: Name : pay_ca_eoy_t4_amend_reg

16: * 500 Oracle Parkway, Redwood City, CA, 94065. *
17: * *
18: ******************************************************************
19:
20: Name : pay_ca_eoy_t4_amend_reg
21:
22: Description : This Package is used by T4 Amendment Register
23: and T4 Amendment Paper Reports.
24:

Line 97: gv_package VARCHAR2(100) := 'pay_ca_eoy_t4_amend_reg';

93: 04-Feb-2013 rgottipa 115.23 16208287 Wrongly checking lv_report_type, hence
94: removed that check.
95: *****************************************************************************/
96:
97: gv_package VARCHAR2(100) := 'pay_ca_eoy_t4_amend_reg';
98: gv_procedure_name VARCHAR2(100);
99:
100: /*****************************************************************************
101: Name : get_payroll_action_info

Line 122: select to_number(pay_ca_eoy_t4_amend_reg.get_parameter(

118: ,p_report_type out nocopy varchar2
119: )
120: IS
121: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
122: select to_number(pay_ca_eoy_t4_amend_reg.get_parameter(
123: 'GRE_ID',ppa.legislative_parameters)),
124: to_number(pay_ca_eoy_t4_amend_reg.get_parameter(
125: 'PER_ID',ppa.legislative_parameters)),
126: to_number(pay_ca_eoy_t4_amend_reg.get_parameter(

Line 124: to_number(pay_ca_eoy_t4_amend_reg.get_parameter(

120: IS
121: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
122: select to_number(pay_ca_eoy_t4_amend_reg.get_parameter(
123: 'GRE_ID',ppa.legislative_parameters)),
124: to_number(pay_ca_eoy_t4_amend_reg.get_parameter(
125: 'PER_ID',ppa.legislative_parameters)),
126: to_number(pay_ca_eoy_t4_amend_reg.get_parameter(
127: 'ASG_SET_ID',ppa.legislative_parameters)),
128: pay_ca_eoy_t4_amend_reg.get_parameter(

Line 126: to_number(pay_ca_eoy_t4_amend_reg.get_parameter(

122: select to_number(pay_ca_eoy_t4_amend_reg.get_parameter(
123: 'GRE_ID',ppa.legislative_parameters)),
124: to_number(pay_ca_eoy_t4_amend_reg.get_parameter(
125: 'PER_ID',ppa.legislative_parameters)),
126: to_number(pay_ca_eoy_t4_amend_reg.get_parameter(
127: 'ASG_SET_ID',ppa.legislative_parameters)),
128: pay_ca_eoy_t4_amend_reg.get_parameter(
129: 'MODE',ppa.legislative_parameters),
130: effective_date,

Line 128: pay_ca_eoy_t4_amend_reg.get_parameter(

124: to_number(pay_ca_eoy_t4_amend_reg.get_parameter(
125: 'PER_ID',ppa.legislative_parameters)),
126: to_number(pay_ca_eoy_t4_amend_reg.get_parameter(
127: 'ASG_SET_ID',ppa.legislative_parameters)),
128: pay_ca_eoy_t4_amend_reg.get_parameter(
129: 'MODE',ppa.legislative_parameters),
130: effective_date,
131: start_date,
132: business_group_id,

Line 133: pay_ca_eoy_t4_amend_reg.get_parameter(

129: 'MODE',ppa.legislative_parameters),
130: effective_date,
131: start_date,
132: business_group_id,
133: pay_ca_eoy_t4_amend_reg.get_parameter(
134: 'PROV_CD',ppa.legislative_parameters),
135: report_type
136: from pay_payroll_actions ppa
137: where ppa.payroll_action_id = cp_payroll_action_id;

Line 207: select to_number(pay_ca_eoy_t4_amend_reg.get_parameter(

203: ,p_print_term out nocopy varchar2
204: )
205: IS
206: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
207: select to_number(pay_ca_eoy_t4_amend_reg.get_parameter(
208: 'GRE_ID',ppa.legislative_parameters)),
209: to_number(pay_ca_eoy_t4_amend_reg.get_parameter(
210: 'PER_ID',ppa.legislative_parameters)),
211: to_number(pay_ca_eoy_t4_amend_reg.get_parameter(

Line 209: to_number(pay_ca_eoy_t4_amend_reg.get_parameter(

205: IS
206: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
207: select to_number(pay_ca_eoy_t4_amend_reg.get_parameter(
208: 'GRE_ID',ppa.legislative_parameters)),
209: to_number(pay_ca_eoy_t4_amend_reg.get_parameter(
210: 'PER_ID',ppa.legislative_parameters)),
211: to_number(pay_ca_eoy_t4_amend_reg.get_parameter(
212: 'ASG_SET_ID',ppa.legislative_parameters)),
213: pay_ca_eoy_t4_amend_reg.get_parameter(

Line 211: to_number(pay_ca_eoy_t4_amend_reg.get_parameter(

207: select to_number(pay_ca_eoy_t4_amend_reg.get_parameter(
208: 'GRE_ID',ppa.legislative_parameters)),
209: to_number(pay_ca_eoy_t4_amend_reg.get_parameter(
210: 'PER_ID',ppa.legislative_parameters)),
211: to_number(pay_ca_eoy_t4_amend_reg.get_parameter(
212: 'ASG_SET_ID',ppa.legislative_parameters)),
213: pay_ca_eoy_t4_amend_reg.get_parameter(
214: 'MODE',ppa.legislative_parameters),
215: effective_date,

Line 213: pay_ca_eoy_t4_amend_reg.get_parameter(

209: to_number(pay_ca_eoy_t4_amend_reg.get_parameter(
210: 'PER_ID',ppa.legislative_parameters)),
211: to_number(pay_ca_eoy_t4_amend_reg.get_parameter(
212: 'ASG_SET_ID',ppa.legislative_parameters)),
213: pay_ca_eoy_t4_amend_reg.get_parameter(
214: 'MODE',ppa.legislative_parameters),
215: effective_date,
216: start_date,
217: business_group_id,

Line 218: pay_ca_eoy_t4_amend_reg.get_parameter(

214: 'MODE',ppa.legislative_parameters),
215: effective_date,
216: start_date,
217: business_group_id,
218: pay_ca_eoy_t4_amend_reg.get_parameter(
219: 'PROV_CD',ppa.legislative_parameters),
220: report_type,
221: report_qualifier,
222: report_category,

Line 223: pay_ca_eoy_t4_amend_reg.get_parameter(

219: 'PROV_CD',ppa.legislative_parameters),
220: report_type,
221: report_qualifier,
222: report_category,
223: pay_ca_eoy_t4_amend_reg.get_parameter(
224: 'PRINT_TERM',ppa.legislative_parameters)
225: from pay_payroll_actions ppa
226: where ppa.payroll_action_id = cp_payroll_action_id;
227:

Line 860: and pay_ca_eoy_t4_amend_reg.get_parameter('TRANSFER_GRE',

856: and report_qualifier = 'CAEOY'
857: and action_type = 'X'
858: and action_status = 'C'
859: and effective_date = cp_year
860: and pay_ca_eoy_t4_amend_reg.get_parameter('TRANSFER_GRE',
861: legislative_parameters)
862: = to_char(cp_gre);
863:
864:

Line 1771: select pay_ca_eoy_t4_amend_reg.get_parameter('GRE_ID',ppa.legislative_parameters),

1767:
1768: begin
1769:
1770: begin
1771: select pay_ca_eoy_t4_amend_reg.get_parameter('GRE_ID',ppa.legislative_parameters),
1772: pay_ca_eoy_t4_amend_reg.get_parameter('PER_ID',ppa.legislative_parameters),
1773: pay_ca_eoy_t4_amend_reg.get_parameter('ASG_SET_ID',ppa.legislative_parameters),
1774: pay_ca_eoy_t4_amend_reg.get_parameter('P_S1',ppa.legislative_parameters),
1775: pay_ca_eoy_t4_amend_reg.get_parameter('P_S2',ppa.legislative_parameters),

Line 1772: pay_ca_eoy_t4_amend_reg.get_parameter('PER_ID',ppa.legislative_parameters),

1768: begin
1769:
1770: begin
1771: select pay_ca_eoy_t4_amend_reg.get_parameter('GRE_ID',ppa.legislative_parameters),
1772: pay_ca_eoy_t4_amend_reg.get_parameter('PER_ID',ppa.legislative_parameters),
1773: pay_ca_eoy_t4_amend_reg.get_parameter('ASG_SET_ID',ppa.legislative_parameters),
1774: pay_ca_eoy_t4_amend_reg.get_parameter('P_S1',ppa.legislative_parameters),
1775: pay_ca_eoy_t4_amend_reg.get_parameter('P_S2',ppa.legislative_parameters),
1776: pay_ca_eoy_t4_amend_reg.get_parameter('P_S3',ppa.legislative_parameters),

Line 1773: pay_ca_eoy_t4_amend_reg.get_parameter('ASG_SET_ID',ppa.legislative_parameters),

1769:
1770: begin
1771: select pay_ca_eoy_t4_amend_reg.get_parameter('GRE_ID',ppa.legislative_parameters),
1772: pay_ca_eoy_t4_amend_reg.get_parameter('PER_ID',ppa.legislative_parameters),
1773: pay_ca_eoy_t4_amend_reg.get_parameter('ASG_SET_ID',ppa.legislative_parameters),
1774: pay_ca_eoy_t4_amend_reg.get_parameter('P_S1',ppa.legislative_parameters),
1775: pay_ca_eoy_t4_amend_reg.get_parameter('P_S2',ppa.legislative_parameters),
1776: pay_ca_eoy_t4_amend_reg.get_parameter('P_S3',ppa.legislative_parameters),
1777: pay_ca_eoy_t4_amend_reg.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),

Line 1774: pay_ca_eoy_t4_amend_reg.get_parameter('P_S1',ppa.legislative_parameters),

1770: begin
1771: select pay_ca_eoy_t4_amend_reg.get_parameter('GRE_ID',ppa.legislative_parameters),
1772: pay_ca_eoy_t4_amend_reg.get_parameter('PER_ID',ppa.legislative_parameters),
1773: pay_ca_eoy_t4_amend_reg.get_parameter('ASG_SET_ID',ppa.legislative_parameters),
1774: pay_ca_eoy_t4_amend_reg.get_parameter('P_S1',ppa.legislative_parameters),
1775: pay_ca_eoy_t4_amend_reg.get_parameter('P_S2',ppa.legislative_parameters),
1776: pay_ca_eoy_t4_amend_reg.get_parameter('P_S3',ppa.legislative_parameters),
1777: pay_ca_eoy_t4_amend_reg.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),
1778: pay_ca_eoy_t4_amend_reg.get_parameter('MODE',ppa.legislative_parameters),

Line 1775: pay_ca_eoy_t4_amend_reg.get_parameter('P_S2',ppa.legislative_parameters),

1771: select pay_ca_eoy_t4_amend_reg.get_parameter('GRE_ID',ppa.legislative_parameters),
1772: pay_ca_eoy_t4_amend_reg.get_parameter('PER_ID',ppa.legislative_parameters),
1773: pay_ca_eoy_t4_amend_reg.get_parameter('ASG_SET_ID',ppa.legislative_parameters),
1774: pay_ca_eoy_t4_amend_reg.get_parameter('P_S1',ppa.legislative_parameters),
1775: pay_ca_eoy_t4_amend_reg.get_parameter('P_S2',ppa.legislative_parameters),
1776: pay_ca_eoy_t4_amend_reg.get_parameter('P_S3',ppa.legislative_parameters),
1777: pay_ca_eoy_t4_amend_reg.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),
1778: pay_ca_eoy_t4_amend_reg.get_parameter('MODE',ppa.legislative_parameters),
1779: ppa.effective_date,

Line 1776: pay_ca_eoy_t4_amend_reg.get_parameter('P_S3',ppa.legislative_parameters),

1772: pay_ca_eoy_t4_amend_reg.get_parameter('PER_ID',ppa.legislative_parameters),
1773: pay_ca_eoy_t4_amend_reg.get_parameter('ASG_SET_ID',ppa.legislative_parameters),
1774: pay_ca_eoy_t4_amend_reg.get_parameter('P_S1',ppa.legislative_parameters),
1775: pay_ca_eoy_t4_amend_reg.get_parameter('P_S2',ppa.legislative_parameters),
1776: pay_ca_eoy_t4_amend_reg.get_parameter('P_S3',ppa.legislative_parameters),
1777: pay_ca_eoy_t4_amend_reg.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),
1778: pay_ca_eoy_t4_amend_reg.get_parameter('MODE',ppa.legislative_parameters),
1779: ppa.effective_date,
1780: ppa.start_date,

Line 1777: pay_ca_eoy_t4_amend_reg.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),

1773: pay_ca_eoy_t4_amend_reg.get_parameter('ASG_SET_ID',ppa.legislative_parameters),
1774: pay_ca_eoy_t4_amend_reg.get_parameter('P_S1',ppa.legislative_parameters),
1775: pay_ca_eoy_t4_amend_reg.get_parameter('P_S2',ppa.legislative_parameters),
1776: pay_ca_eoy_t4_amend_reg.get_parameter('P_S3',ppa.legislative_parameters),
1777: pay_ca_eoy_t4_amend_reg.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),
1778: pay_ca_eoy_t4_amend_reg.get_parameter('MODE',ppa.legislative_parameters),
1779: ppa.effective_date,
1780: ppa.start_date,
1781: ppa.business_group_id

Line 1778: pay_ca_eoy_t4_amend_reg.get_parameter('MODE',ppa.legislative_parameters),

1774: pay_ca_eoy_t4_amend_reg.get_parameter('P_S1',ppa.legislative_parameters),
1775: pay_ca_eoy_t4_amend_reg.get_parameter('P_S2',ppa.legislative_parameters),
1776: pay_ca_eoy_t4_amend_reg.get_parameter('P_S3',ppa.legislative_parameters),
1777: pay_ca_eoy_t4_amend_reg.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),
1778: pay_ca_eoy_t4_amend_reg.get_parameter('MODE',ppa.legislative_parameters),
1779: ppa.effective_date,
1780: ppa.start_date,
1781: ppa.business_group_id
1782: into l_gre_id,

Line 1897: end pay_ca_eoy_t4_amend_reg;

1893: /* hr_utility.trace_on(null,'T4AMEND_REG'); */
1894: null;
1895:
1896:
1897: end pay_ca_eoy_t4_amend_reg;