eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PAY_CA_EOY_T4_AMEND_REG dependencies on PAY_CA_EOY_T4_AMEND_REG

Line 1: PACKAGE BODY pay_ca_eoy_t4_amend_reg AS

1: PACKAGE BODY pay_ca_eoy_t4_amend_reg AS
2: /* $Header: pycat4cr.pkb 120.4 2006/10/17 00:08:37 meshah noship $ */
3: /*
4: ******************************************************************
5: * *

Line 20: Name : pay_ca_eoy_t4_amend_reg

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

Line 61: gv_package VARCHAR2(100) := 'pay_ca_eoy_t4_amend_reg';

57: 16-OCT-2006 meshah 115.11 5528944 Added order by to the range cursor
58: queries.
59: *****************************************************************************/
60:
61: gv_package VARCHAR2(100) := 'pay_ca_eoy_t4_amend_reg';
62: gv_procedure_name VARCHAR2(100);
63:
64: /*****************************************************************************
65: Name : get_payroll_action_info

Line 86: select to_number(pay_ca_eoy_t4_amend_reg.get_parameter(

82: ,p_report_type out nocopy varchar2
83: )
84: IS
85: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
86: select to_number(pay_ca_eoy_t4_amend_reg.get_parameter(
87: 'GRE_ID',ppa.legislative_parameters)),
88: to_number(pay_ca_eoy_t4_amend_reg.get_parameter(
89: 'PER_ID',ppa.legislative_parameters)),
90: to_number(pay_ca_eoy_t4_amend_reg.get_parameter(

Line 88: to_number(pay_ca_eoy_t4_amend_reg.get_parameter(

84: IS
85: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
86: select to_number(pay_ca_eoy_t4_amend_reg.get_parameter(
87: 'GRE_ID',ppa.legislative_parameters)),
88: to_number(pay_ca_eoy_t4_amend_reg.get_parameter(
89: 'PER_ID',ppa.legislative_parameters)),
90: to_number(pay_ca_eoy_t4_amend_reg.get_parameter(
91: 'ASG_SET_ID',ppa.legislative_parameters)),
92: pay_ca_eoy_t4_amend_reg.get_parameter(

Line 90: to_number(pay_ca_eoy_t4_amend_reg.get_parameter(

86: select to_number(pay_ca_eoy_t4_amend_reg.get_parameter(
87: 'GRE_ID',ppa.legislative_parameters)),
88: to_number(pay_ca_eoy_t4_amend_reg.get_parameter(
89: 'PER_ID',ppa.legislative_parameters)),
90: to_number(pay_ca_eoy_t4_amend_reg.get_parameter(
91: 'ASG_SET_ID',ppa.legislative_parameters)),
92: pay_ca_eoy_t4_amend_reg.get_parameter(
93: 'MODE',ppa.legislative_parameters),
94: effective_date,

Line 92: pay_ca_eoy_t4_amend_reg.get_parameter(

88: to_number(pay_ca_eoy_t4_amend_reg.get_parameter(
89: 'PER_ID',ppa.legislative_parameters)),
90: to_number(pay_ca_eoy_t4_amend_reg.get_parameter(
91: 'ASG_SET_ID',ppa.legislative_parameters)),
92: pay_ca_eoy_t4_amend_reg.get_parameter(
93: 'MODE',ppa.legislative_parameters),
94: effective_date,
95: start_date,
96: business_group_id,

Line 97: pay_ca_eoy_t4_amend_reg.get_parameter(

93: 'MODE',ppa.legislative_parameters),
94: effective_date,
95: start_date,
96: business_group_id,
97: pay_ca_eoy_t4_amend_reg.get_parameter(
98: 'PROV_CD',ppa.legislative_parameters),
99: report_type
100: from pay_payroll_actions ppa
101: where ppa.payroll_action_id = cp_payroll_action_id;

Line 458: and pay_ca_eoy_t4_amend_reg.get_parameter('TRANSFER_GRE',

454: and report_qualifier = 'CAEOY'
455: and action_type = 'X'
456: and action_status = 'C'
457: and effective_date = cp_year
458: and pay_ca_eoy_t4_amend_reg.get_parameter('TRANSFER_GRE',
459: legislative_parameters)
460: = to_char(cp_gre);
461:
462:

Line 888: select pay_ca_eoy_t4_amend_reg.get_parameter('GRE_ID',ppa.legislative_parameters),

884:
885: begin
886:
887: begin
888: select pay_ca_eoy_t4_amend_reg.get_parameter('GRE_ID',ppa.legislative_parameters),
889: pay_ca_eoy_t4_amend_reg.get_parameter('PER_ID',ppa.legislative_parameters),
890: pay_ca_eoy_t4_amend_reg.get_parameter('ASG_SET_ID',ppa.legislative_parameters),
891: pay_ca_eoy_t4_amend_reg.get_parameter('P_S1',ppa.legislative_parameters),
892: pay_ca_eoy_t4_amend_reg.get_parameter('P_S2',ppa.legislative_parameters),

Line 889: pay_ca_eoy_t4_amend_reg.get_parameter('PER_ID',ppa.legislative_parameters),

885: begin
886:
887: begin
888: select pay_ca_eoy_t4_amend_reg.get_parameter('GRE_ID',ppa.legislative_parameters),
889: pay_ca_eoy_t4_amend_reg.get_parameter('PER_ID',ppa.legislative_parameters),
890: pay_ca_eoy_t4_amend_reg.get_parameter('ASG_SET_ID',ppa.legislative_parameters),
891: pay_ca_eoy_t4_amend_reg.get_parameter('P_S1',ppa.legislative_parameters),
892: pay_ca_eoy_t4_amend_reg.get_parameter('P_S2',ppa.legislative_parameters),
893: pay_ca_eoy_t4_amend_reg.get_parameter('P_S3',ppa.legislative_parameters),

Line 890: pay_ca_eoy_t4_amend_reg.get_parameter('ASG_SET_ID',ppa.legislative_parameters),

886:
887: begin
888: select pay_ca_eoy_t4_amend_reg.get_parameter('GRE_ID',ppa.legislative_parameters),
889: pay_ca_eoy_t4_amend_reg.get_parameter('PER_ID',ppa.legislative_parameters),
890: pay_ca_eoy_t4_amend_reg.get_parameter('ASG_SET_ID',ppa.legislative_parameters),
891: pay_ca_eoy_t4_amend_reg.get_parameter('P_S1',ppa.legislative_parameters),
892: pay_ca_eoy_t4_amend_reg.get_parameter('P_S2',ppa.legislative_parameters),
893: pay_ca_eoy_t4_amend_reg.get_parameter('P_S3',ppa.legislative_parameters),
894: pay_ca_eoy_t4_amend_reg.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),

Line 891: pay_ca_eoy_t4_amend_reg.get_parameter('P_S1',ppa.legislative_parameters),

887: begin
888: select pay_ca_eoy_t4_amend_reg.get_parameter('GRE_ID',ppa.legislative_parameters),
889: pay_ca_eoy_t4_amend_reg.get_parameter('PER_ID',ppa.legislative_parameters),
890: pay_ca_eoy_t4_amend_reg.get_parameter('ASG_SET_ID',ppa.legislative_parameters),
891: pay_ca_eoy_t4_amend_reg.get_parameter('P_S1',ppa.legislative_parameters),
892: pay_ca_eoy_t4_amend_reg.get_parameter('P_S2',ppa.legislative_parameters),
893: pay_ca_eoy_t4_amend_reg.get_parameter('P_S3',ppa.legislative_parameters),
894: pay_ca_eoy_t4_amend_reg.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),
895: pay_ca_eoy_t4_amend_reg.get_parameter('MODE',ppa.legislative_parameters),

Line 892: pay_ca_eoy_t4_amend_reg.get_parameter('P_S2',ppa.legislative_parameters),

888: select pay_ca_eoy_t4_amend_reg.get_parameter('GRE_ID',ppa.legislative_parameters),
889: pay_ca_eoy_t4_amend_reg.get_parameter('PER_ID',ppa.legislative_parameters),
890: pay_ca_eoy_t4_amend_reg.get_parameter('ASG_SET_ID',ppa.legislative_parameters),
891: pay_ca_eoy_t4_amend_reg.get_parameter('P_S1',ppa.legislative_parameters),
892: pay_ca_eoy_t4_amend_reg.get_parameter('P_S2',ppa.legislative_parameters),
893: pay_ca_eoy_t4_amend_reg.get_parameter('P_S3',ppa.legislative_parameters),
894: pay_ca_eoy_t4_amend_reg.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),
895: pay_ca_eoy_t4_amend_reg.get_parameter('MODE',ppa.legislative_parameters),
896: ppa.effective_date,

Line 893: pay_ca_eoy_t4_amend_reg.get_parameter('P_S3',ppa.legislative_parameters),

889: pay_ca_eoy_t4_amend_reg.get_parameter('PER_ID',ppa.legislative_parameters),
890: pay_ca_eoy_t4_amend_reg.get_parameter('ASG_SET_ID',ppa.legislative_parameters),
891: pay_ca_eoy_t4_amend_reg.get_parameter('P_S1',ppa.legislative_parameters),
892: pay_ca_eoy_t4_amend_reg.get_parameter('P_S2',ppa.legislative_parameters),
893: pay_ca_eoy_t4_amend_reg.get_parameter('P_S3',ppa.legislative_parameters),
894: pay_ca_eoy_t4_amend_reg.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),
895: pay_ca_eoy_t4_amend_reg.get_parameter('MODE',ppa.legislative_parameters),
896: ppa.effective_date,
897: ppa.start_date,

Line 894: pay_ca_eoy_t4_amend_reg.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),

890: pay_ca_eoy_t4_amend_reg.get_parameter('ASG_SET_ID',ppa.legislative_parameters),
891: pay_ca_eoy_t4_amend_reg.get_parameter('P_S1',ppa.legislative_parameters),
892: pay_ca_eoy_t4_amend_reg.get_parameter('P_S2',ppa.legislative_parameters),
893: pay_ca_eoy_t4_amend_reg.get_parameter('P_S3',ppa.legislative_parameters),
894: pay_ca_eoy_t4_amend_reg.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),
895: pay_ca_eoy_t4_amend_reg.get_parameter('MODE',ppa.legislative_parameters),
896: ppa.effective_date,
897: ppa.start_date,
898: ppa.business_group_id

Line 895: pay_ca_eoy_t4_amend_reg.get_parameter('MODE',ppa.legislative_parameters),

891: pay_ca_eoy_t4_amend_reg.get_parameter('P_S1',ppa.legislative_parameters),
892: pay_ca_eoy_t4_amend_reg.get_parameter('P_S2',ppa.legislative_parameters),
893: pay_ca_eoy_t4_amend_reg.get_parameter('P_S3',ppa.legislative_parameters),
894: pay_ca_eoy_t4_amend_reg.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),
895: pay_ca_eoy_t4_amend_reg.get_parameter('MODE',ppa.legislative_parameters),
896: ppa.effective_date,
897: ppa.start_date,
898: ppa.business_group_id
899: into l_gre_id,

Line 1014: end pay_ca_eoy_t4_amend_reg;

1010: /* hr_utility.trace_on(null,'T4AMEND_REG'); */
1011: null;
1012:
1013:
1014: end pay_ca_eoy_t4_amend_reg;