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.4 2006/10/17 00:09:08 meshah noship $ */
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 45: gv_package VARCHAR2(100) := 'pay_ca_eoy_t4a_amend_reg';

41: 16-OCT-2006 meshah 115.7 5528944 Addeed Order by clause to the range
42: cursor queries.
43: *****************************************************************************/
44:
45: gv_package VARCHAR2(100) := 'pay_ca_eoy_t4a_amend_reg';
46: gv_procedure_name VARCHAR2(100);
47:
48: /*****************************************************************************
49: Name : get_payroll_action_info

Line 69: select to_number(pay_ca_eoy_t4a_amend_reg.get_parameter(

65: ,p_report_type out nocopy varchar2
66: )
67: IS
68: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
69: select to_number(pay_ca_eoy_t4a_amend_reg.get_parameter(
70: 'GRE_ID',ppa.legislative_parameters)),
71: to_number(pay_ca_eoy_t4a_amend_reg.get_parameter(
72: 'PER_ID',ppa.legislative_parameters)),
73: to_number(pay_ca_eoy_t4a_amend_reg.get_parameter(

Line 71: to_number(pay_ca_eoy_t4a_amend_reg.get_parameter(

67: IS
68: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
69: select to_number(pay_ca_eoy_t4a_amend_reg.get_parameter(
70: 'GRE_ID',ppa.legislative_parameters)),
71: to_number(pay_ca_eoy_t4a_amend_reg.get_parameter(
72: 'PER_ID',ppa.legislative_parameters)),
73: to_number(pay_ca_eoy_t4a_amend_reg.get_parameter(
74: 'ASG_SET_ID',ppa.legislative_parameters)),
75: pay_ca_eoy_t4a_amend_reg.get_parameter(

Line 73: to_number(pay_ca_eoy_t4a_amend_reg.get_parameter(

69: select to_number(pay_ca_eoy_t4a_amend_reg.get_parameter(
70: 'GRE_ID',ppa.legislative_parameters)),
71: to_number(pay_ca_eoy_t4a_amend_reg.get_parameter(
72: 'PER_ID',ppa.legislative_parameters)),
73: to_number(pay_ca_eoy_t4a_amend_reg.get_parameter(
74: 'ASG_SET_ID',ppa.legislative_parameters)),
75: pay_ca_eoy_t4a_amend_reg.get_parameter(
76: 'MODE',ppa.legislative_parameters),
77: effective_date,

Line 75: pay_ca_eoy_t4a_amend_reg.get_parameter(

71: to_number(pay_ca_eoy_t4a_amend_reg.get_parameter(
72: 'PER_ID',ppa.legislative_parameters)),
73: to_number(pay_ca_eoy_t4a_amend_reg.get_parameter(
74: 'ASG_SET_ID',ppa.legislative_parameters)),
75: pay_ca_eoy_t4a_amend_reg.get_parameter(
76: 'MODE',ppa.legislative_parameters),
77: effective_date,
78: start_date,
79: business_group_id,

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

417: and report_qualifier = 'CAEOY'
418: and action_type = 'X'
419: and action_status = 'C'
420: and effective_date = cp_year
421: and pay_ca_eoy_t4a_amend_reg.get_parameter('TRANSFER_GRE',
422: legislative_parameters) = to_char(cp_gre);
423:
424:
425: CURSOR get_warning_dtls_for_ee(cp_person_id in number) is

Line 917: end pay_ca_eoy_t4a_amend_reg;

913: /* hr_utility.trace_on(null,'T4AAMEND_REG'); */
914: null;
915:
916:
917: end pay_ca_eoy_t4a_amend_reg;