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.3.12020000.2 2013/03/15 11:49:04 skchalla 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 60: gv_package VARCHAR2(100) := 'pay_us_w2c_arch';

56: 15-MAR-2013 skchalla 115.21 16480506 Modified the w2c_action_creation to check whether
57: W2-C PDF is run or not along with the W-2c Paper
58: *****************************************************************************/
59:
60: gv_package VARCHAR2(100) := 'pay_us_w2c_arch';
61: gv_procedure_name VARCHAR2(100);
62:
63:
64:

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

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

Line 139: select to_number(pay_us_w2c_arch.get_parameter(

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

Line 141: to_number(pay_us_w2c_arch.get_parameter(

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

Line 143: to_number(pay_us_w2c_arch.get_parameter(

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

Line 145: to_number(pay_us_w2c_arch.get_parameter(

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

Line 635: end pay_us_w2c_arch;

631: --Begin
632: --hr_utility.trace_on(null,'W2C');
633:
634:
635: end pay_us_w2c_arch;