APPS.PAY_US_W2C_ARCH dependencies on PAY_US_W2C_ARCH

Line 1: PACKAGE BODY pay_us_w2c_arch AS

1: PACKAGE BODY pay_us_w2c_arch AS
2: /* $Header: pyusw2cp.pkb 120.1.12010000.2 2008/08/06 08:40:18 ubhat ship $ */
3: /*
4: ******************************************************************
5: * *

Line 20: Name : pay_us_w2c_arch

16: * 500 Oracle Parkway, Redwood City, CA, 94065. *
17: * *
18: ******************************************************************
19:
20: Name : pay_us_w2c_arch
21:
22: Description : This procedure is used by W-2C Pre-Process
23: to archive data for W-2C Corrections Reporting.
24:

Line 57: gv_package VARCHAR2(100) := 'pay_us_w2c_arch';

53: for secondary assignment in
54: procedure w2c_action_creation
55: *****************************************************************************/
56:
57: gv_package VARCHAR2(100) := 'pay_us_w2c_arch';
58: gv_procedure_name VARCHAR2(100);
59:
60:
61:

Line 81: and pay_us_w2c_arch.get_parameter('TRANSFER_GRE',ppa.legislative_parameters)

77: select ppa.payroll_action_id
78: from pay_payroll_actions ppa
79: where ppa.report_type = 'YREND'
80: and ppa.effective_date = cp_w2c_eff_date
81: and pay_us_w2c_arch.get_parameter('TRANSFER_GRE',ppa.legislative_parameters)
82: = cp_w2c_tax_unit_id;
83:
84: ln_eoy_pactid number :=0;
85:

Line 136: select to_number(pay_us_w2c_arch.get_parameter(

132: ,p_asg_set out nocopy number
133: )
134: IS
135: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
136: select to_number(pay_us_w2c_arch.get_parameter(
137: 'TRANSFER_GRE',ppa.legislative_parameters)),
138: to_number(pay_us_w2c_arch.get_parameter(
139: 'PER_ID',ppa.legislative_parameters)),
140: to_number(pay_us_w2c_arch.get_parameter(

Line 138: to_number(pay_us_w2c_arch.get_parameter(

134: IS
135: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
136: select to_number(pay_us_w2c_arch.get_parameter(
137: 'TRANSFER_GRE',ppa.legislative_parameters)),
138: to_number(pay_us_w2c_arch.get_parameter(
139: 'PER_ID',ppa.legislative_parameters)),
140: to_number(pay_us_w2c_arch.get_parameter(
141: 'SSN',ppa.legislative_parameters)),
142: to_number(pay_us_w2c_arch.get_parameter(

Line 140: to_number(pay_us_w2c_arch.get_parameter(

136: select to_number(pay_us_w2c_arch.get_parameter(
137: 'TRANSFER_GRE',ppa.legislative_parameters)),
138: to_number(pay_us_w2c_arch.get_parameter(
139: 'PER_ID',ppa.legislative_parameters)),
140: to_number(pay_us_w2c_arch.get_parameter(
141: 'SSN',ppa.legislative_parameters)),
142: to_number(pay_us_w2c_arch.get_parameter(
143: 'ASG_SET',ppa.legislative_parameters)),
144: to_char(effective_date,'YYYY') ,

Line 142: to_number(pay_us_w2c_arch.get_parameter(

138: to_number(pay_us_w2c_arch.get_parameter(
139: 'PER_ID',ppa.legislative_parameters)),
140: to_number(pay_us_w2c_arch.get_parameter(
141: 'SSN',ppa.legislative_parameters)),
142: to_number(pay_us_w2c_arch.get_parameter(
143: 'ASG_SET',ppa.legislative_parameters)),
144: to_char(effective_date,'YYYY') ,
145: effective_date,
146: start_date,

Line 632: end pay_us_w2c_arch;

628: --Begin
629: --hr_utility.trace_on(null,'W2C');
630:
631:
632: end pay_us_w2c_arch;