APPS.PAY_CA_EOY_RL2_AMEND_REG dependencies on PAY_CA_EOY_RL2_AMEND_REG

Line 1: PACKAGE BODY pay_ca_eoy_rl2_amend_reg AS

1: PACKAGE BODY pay_ca_eoy_rl2_amend_reg AS
2: /* $Header: pycarl2cr.pkb 120.15.12020000.3 2013/01/15 06:58:16 rgottipa ship $ */
3: /*
4: ******************************************************************
5: * *

Line 20: Name : pay_ca_eoy_rl2_amend_reg

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

Line 79: gv_package VARCHAR2(100) := 'pay_ca_eoy_rl2_amend_reg';

75: get_reprint_rl2_amend_term.
76:
77: *****************************************************************************/
78:
79: gv_package VARCHAR2(100) := 'pay_ca_eoy_rl2_amend_reg';
80: gv_procedure_name VARCHAR2(100);
81:
82: /*****************************************************************************
83: Name : get_payroll_action_info

Line 181: select to_number(pay_ca_eoy_rl2_amend_reg.get_parameter(

177: ,p_print_term out nocopy varchar2
178: )
179: IS
180: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
181: select to_number(pay_ca_eoy_rl2_amend_reg.get_parameter(
182: 'PRE_ORGANIZATION_ID',ppa.legislative_parameters)),
183: to_number(pay_ca_eoy_rl2_amend_reg.get_parameter(
184: 'PER_ID',ppa.legislative_parameters)),
185: to_number(pay_ca_eoy_rl2_amend_reg.get_parameter(

Line 183: to_number(pay_ca_eoy_rl2_amend_reg.get_parameter(

179: IS
180: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
181: select to_number(pay_ca_eoy_rl2_amend_reg.get_parameter(
182: 'PRE_ORGANIZATION_ID',ppa.legislative_parameters)),
183: to_number(pay_ca_eoy_rl2_amend_reg.get_parameter(
184: 'PER_ID',ppa.legislative_parameters)),
185: to_number(pay_ca_eoy_rl2_amend_reg.get_parameter(
186: 'ASG_SET_ID',ppa.legislative_parameters)),
187: pay_ca_eoy_rl2_amend_reg.get_parameter(

Line 185: to_number(pay_ca_eoy_rl2_amend_reg.get_parameter(

181: select to_number(pay_ca_eoy_rl2_amend_reg.get_parameter(
182: 'PRE_ORGANIZATION_ID',ppa.legislative_parameters)),
183: to_number(pay_ca_eoy_rl2_amend_reg.get_parameter(
184: 'PER_ID',ppa.legislative_parameters)),
185: to_number(pay_ca_eoy_rl2_amend_reg.get_parameter(
186: 'ASG_SET_ID',ppa.legislative_parameters)),
187: pay_ca_eoy_rl2_amend_reg.get_parameter(
188: 'MODE',ppa.legislative_parameters),
189: effective_date,

Line 187: pay_ca_eoy_rl2_amend_reg.get_parameter(

183: to_number(pay_ca_eoy_rl2_amend_reg.get_parameter(
184: 'PER_ID',ppa.legislative_parameters)),
185: to_number(pay_ca_eoy_rl2_amend_reg.get_parameter(
186: 'ASG_SET_ID',ppa.legislative_parameters)),
187: pay_ca_eoy_rl2_amend_reg.get_parameter(
188: 'MODE',ppa.legislative_parameters),
189: effective_date,
190: start_date,
191: business_group_id,

Line 195: pay_ca_eoy_rl2_amend_reg.get_parameter(

191: business_group_id,
192: report_type,
193: report_qualifier,
194: report_category,
195: pay_ca_eoy_rl2_amend_reg.get_parameter(
196: 'PRINT_TERM',ppa.legislative_parameters)
197: from pay_payroll_actions ppa
198: where ppa.payroll_action_id = cp_payroll_action_id;
199:

Line 1691: end pay_ca_eoy_rl2_amend_reg;

1687: /* hr_utility.trace_on(null,'RL2AMEND_REG'); */
1688: null;
1689:
1690:
1691: end pay_ca_eoy_rl2_amend_reg;