APPS.PAY_CA_EOY_T4A_AMEND_REG dependencies on PAY_CA_EOY_T4A_AMEND_REG

Line 1: PACKAGE BODY pay_ca_eoy_t4a_amend_reg AS

1: PACKAGE BODY pay_ca_eoy_t4a_amend_reg AS
2: /* $Header: pycat4acr.pkb 120.15.12020000.2 2012/12/31 11:53:27 rgottipa ship $ */
3: /*
4: ******************************************************************
5: * *

Line 20: Name : pay_ca_eoy_t4a_amend_reg

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

Line 61: pay_ca_eoy_t4a_amend_reg.action_creation

57: 25-NOV-2010 nkjaladi 115.13 10332249 Corrected GSCC Error.
58: 25-NOV-2010 nkjaladi 115.14 10332249 Corrected typo.
59: 30-NOV-2010 nkjaladi 115.15 10352779 Modified cursors get_reprint_t4a_amendpdf_dtls
60: and get_latest_t4a_amendpdf_dtls in pkg proc
61: pay_ca_eoy_t4a_amend_reg.action_creation
62: 08-DEC-2010 emunisek 115.16 10381064 Modified cursors get_latest_t4a_amendpdf_dtls,
63: get_reprint_t4a_amendpdf_dtls to introduce the Date
64: Check on pay_payroll_actions table used in exists
65: clauses

Line 76: gv_package VARCHAR2(100) := 'pay_ca_eoy_t4a_amend_reg';

72: terminate employees and online
73: 'paper' option.
74: *****************************************************************************/
75:
76: gv_package VARCHAR2(100) := 'pay_ca_eoy_t4a_amend_reg';
77: gv_procedure_name VARCHAR2(100);
78:
79: /*****************************************************************************
80: Name : get_payroll_action_info

Line 100: select to_number(pay_ca_eoy_t4a_amend_reg.get_parameter(

96: ,p_report_type out nocopy varchar2
97: )
98: IS
99: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
100: select to_number(pay_ca_eoy_t4a_amend_reg.get_parameter(
101: 'GRE_ID',ppa.legislative_parameters)),
102: to_number(pay_ca_eoy_t4a_amend_reg.get_parameter(
103: 'PER_ID',ppa.legislative_parameters)),
104: to_number(pay_ca_eoy_t4a_amend_reg.get_parameter(

Line 102: to_number(pay_ca_eoy_t4a_amend_reg.get_parameter(

98: IS
99: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
100: select to_number(pay_ca_eoy_t4a_amend_reg.get_parameter(
101: 'GRE_ID',ppa.legislative_parameters)),
102: to_number(pay_ca_eoy_t4a_amend_reg.get_parameter(
103: 'PER_ID',ppa.legislative_parameters)),
104: to_number(pay_ca_eoy_t4a_amend_reg.get_parameter(
105: 'ASG_SET_ID',ppa.legislative_parameters)),
106: pay_ca_eoy_t4a_amend_reg.get_parameter(

Line 104: to_number(pay_ca_eoy_t4a_amend_reg.get_parameter(

100: select to_number(pay_ca_eoy_t4a_amend_reg.get_parameter(
101: 'GRE_ID',ppa.legislative_parameters)),
102: to_number(pay_ca_eoy_t4a_amend_reg.get_parameter(
103: 'PER_ID',ppa.legislative_parameters)),
104: to_number(pay_ca_eoy_t4a_amend_reg.get_parameter(
105: 'ASG_SET_ID',ppa.legislative_parameters)),
106: pay_ca_eoy_t4a_amend_reg.get_parameter(
107: 'MODE',ppa.legislative_parameters),
108: effective_date,

Line 106: pay_ca_eoy_t4a_amend_reg.get_parameter(

102: to_number(pay_ca_eoy_t4a_amend_reg.get_parameter(
103: 'PER_ID',ppa.legislative_parameters)),
104: to_number(pay_ca_eoy_t4a_amend_reg.get_parameter(
105: 'ASG_SET_ID',ppa.legislative_parameters)),
106: pay_ca_eoy_t4a_amend_reg.get_parameter(
107: 'MODE',ppa.legislative_parameters),
108: effective_date,
109: start_date,
110: business_group_id,

Line 188: select to_number(pay_ca_eoy_t4a_amend_reg.get_parameter(

184: ,p_print_term out nocopy varchar2
185: )
186: IS
187: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
188: select to_number(pay_ca_eoy_t4a_amend_reg.get_parameter(
189: 'GRE_ID',ppa.legislative_parameters)),
190: to_number(pay_ca_eoy_t4a_amend_reg.get_parameter(
191: 'PER_ID',ppa.legislative_parameters)),
192: to_number(pay_ca_eoy_t4a_amend_reg.get_parameter(

Line 190: to_number(pay_ca_eoy_t4a_amend_reg.get_parameter(

186: IS
187: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
188: select to_number(pay_ca_eoy_t4a_amend_reg.get_parameter(
189: 'GRE_ID',ppa.legislative_parameters)),
190: to_number(pay_ca_eoy_t4a_amend_reg.get_parameter(
191: 'PER_ID',ppa.legislative_parameters)),
192: to_number(pay_ca_eoy_t4a_amend_reg.get_parameter(
193: 'ASG_SET_ID',ppa.legislative_parameters)),
194: pay_ca_eoy_t4a_amend_reg.get_parameter(

Line 192: to_number(pay_ca_eoy_t4a_amend_reg.get_parameter(

188: select to_number(pay_ca_eoy_t4a_amend_reg.get_parameter(
189: 'GRE_ID',ppa.legislative_parameters)),
190: to_number(pay_ca_eoy_t4a_amend_reg.get_parameter(
191: 'PER_ID',ppa.legislative_parameters)),
192: to_number(pay_ca_eoy_t4a_amend_reg.get_parameter(
193: 'ASG_SET_ID',ppa.legislative_parameters)),
194: pay_ca_eoy_t4a_amend_reg.get_parameter(
195: 'MODE',ppa.legislative_parameters),
196: effective_date,

Line 194: pay_ca_eoy_t4a_amend_reg.get_parameter(

190: to_number(pay_ca_eoy_t4a_amend_reg.get_parameter(
191: 'PER_ID',ppa.legislative_parameters)),
192: to_number(pay_ca_eoy_t4a_amend_reg.get_parameter(
193: 'ASG_SET_ID',ppa.legislative_parameters)),
194: pay_ca_eoy_t4a_amend_reg.get_parameter(
195: 'MODE',ppa.legislative_parameters),
196: effective_date,
197: start_date,
198: business_group_id,

Line 202: pay_ca_eoy_t4a_amend_reg.get_parameter(

198: business_group_id,
199: report_type,
200: report_qualifier,
201: report_category,
202: pay_ca_eoy_t4a_amend_reg.get_parameter(
203: 'PRINT_TERM',ppa.legislative_parameters)
204: from pay_payroll_actions ppa
205: where ppa.payroll_action_id = cp_payroll_action_id;
206:

Line 818: and pay_ca_eoy_t4a_amend_reg.get_parameter('TRANSFER_GRE',

814: and report_qualifier = 'CAEOY'
815: and action_type = 'X'
816: and action_status = 'C'
817: and effective_date = cp_year
818: and pay_ca_eoy_t4a_amend_reg.get_parameter('TRANSFER_GRE',
819: legislative_parameters) = to_char(cp_gre);
820:
821:
822: CURSOR get_warning_dtls_for_ee(cp_person_id in number) is

Line 1729: end pay_ca_eoy_t4a_amend_reg;

1725: /* hr_utility.trace_on(null,'T4AAMEND_REG'); */
1726: null;
1727:
1728:
1729: end pay_ca_eoy_t4a_amend_reg;