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.

APPS.PAY_CA_T4A_CANCEL_MAG dependencies on PAY_CA_T4A_CANCEL_MAG

Line 1: PACKAGE BODY pay_ca_t4a_cancel_mag AS

1: PACKAGE BODY pay_ca_t4a_cancel_mag AS
2: /* $Header: pycat4acmag.pkb 120.4.12020000.3 2012/10/01 07:49:45 rgottipa ship $ */
3:
4: PROCEDURE range_cursor (
5: p_pactid IN NUMBER,

Line 19: to_number(pay_ca_t4a_cancel_mag.get_parameter(''PAY_ACT'', ppa1.legislative_parameters))

15: where ppa.payroll_action_id = paa.payroll_action_id
16: and paa.assignment_id = paaf.assignment_id
17: and ppa1.payroll_action_id = :payroll_action_id
18: and ppa.payroll_action_id =
19: to_number(pay_ca_t4a_cancel_mag.get_parameter(''PAY_ACT'', ppa1.legislative_parameters))
20: and paaf.person_id =
21: nvl(pay_ca_t4a_cancel_mag.get_parameter(''PER_ID'',ppa1.legislative_parameters),paaf.person_id)
22: order by paaf.person_id';
23:

Line 21: nvl(pay_ca_t4a_cancel_mag.get_parameter(''PER_ID'',ppa1.legislative_parameters),paaf.person_id)

17: and ppa1.payroll_action_id = :payroll_action_id
18: and ppa.payroll_action_id =
19: to_number(pay_ca_t4a_cancel_mag.get_parameter(''PAY_ACT'', ppa1.legislative_parameters))
20: and paaf.person_id =
21: nvl(pay_ca_t4a_cancel_mag.get_parameter(''PER_ID'',ppa1.legislative_parameters),paaf.person_id)
22: order by paaf.person_id';
23:
24: END range_cursor;
25: /**************************************************************************/

Line 59: to_number(pay_ca_t4a_cancel_mag.get_parameter('PAY_ACT', ppa1.legislative_parameters))

55: and paa.assignment_id = paaf.assignment_id
56: and ppa1.payroll_action_id = p_pactid
57: and paaf.person_id between p_stperson and p_endperson
58: and ppa.payroll_action_id =
59: to_number(pay_ca_t4a_cancel_mag.get_parameter('PAY_ACT', ppa1.legislative_parameters))
60: and ppa2.report_type in ('T4A','CAEOY_T4A_AMEND_PP')
61: and int.locking_action_id = paa.assignment_action_id
62: and paa1.assignment_action_id = int.locked_action_id
63: and ppa2.payroll_action_id = paa1.payroll_action_id

Line 72: to_number(pay_ca_t4a_cancel_mag.get_parameter('PAY_ACT', ppa1.legislative_parameters))

68: not in (select paa2.assignment_action_id
69: from pay_action_interlocks pai, pay_assignment_actions paa2
70: where paa2.assignment_action_id = pai.locked_action_id
71: and paa2.payroll_action_id =
72: to_number(pay_ca_t4a_cancel_mag.get_parameter('PAY_ACT', ppa1.legislative_parameters))
73: )
74: and paaf.effective_start_date = (select max(paaf2.effective_start_date)
75: from per_all_assignments_f paaf2
76: where paaf2.assignment_id = paa.assignment_id

Line 101: to_number(pay_ca_t4a_cancel_mag.get_parameter('PAY_ACT', ppa1.legislative_parameters))

97: and paa.assignment_id = paaf.assignment_id
98: and ppa1.payroll_action_id = p_pactid
99: and paaf.person_id between p_stperson and p_endperson
100: and ppa.payroll_action_id =
101: to_number(pay_ca_t4a_cancel_mag.get_parameter('PAY_ACT', ppa1.legislative_parameters))
102: and ppa2.report_type in ('T4A','CAEOY_T4A_AMEND_PP')
103: and int.locking_action_id = paa.assignment_action_id
104: and paa1.assignment_action_id = int.locked_action_id
105: and ppa2.payroll_action_id = paa1.payroll_action_id

Line 122: to_number(pay_ca_t4a_cancel_mag.get_parameter('PAY_ACT', ppa1.legislative_parameters))

118: from pay_action_interlocks pai,
119: pay_assignment_actions paa2
120: where paa2.assignment_action_id = pai.locked_action_id
121: and paa2.payroll_action_id =
122: to_number(pay_ca_t4a_cancel_mag.get_parameter('PAY_ACT', ppa1.legislative_parameters))
123: )
124: and paaf.effective_start_date = (select max(paaf2.effective_start_date)
125: from per_all_assignments_f paaf2
126: where paaf2.assignment_id = paa.assignment_id

Line 149: hr_utility.set_location( 'pay_ca_t4a_cancel_mag.action_creation',10);

145: l_payroll_act NUMBER;
146:
147: BEGIN
148: hr_utility.trace('+=========================================================+');
149: hr_utility.set_location( 'pay_ca_t4a_cancel_mag.action_creation',10);
150: get_report_parameters(
151: p_pactid,
152: l_legislative_parameters,
153: l_year_end,

Line 157: l_trans_gre := pay_ca_t4a_cancel_mag.get_parameter('TRANSMITTER_GRE',

153: l_year_end,
154: l_report_type,
155: l_business_group_id);
156:
157: l_trans_gre := pay_ca_t4a_cancel_mag.get_parameter('TRANSMITTER_GRE',
158: l_legislative_parameters);
159: hr_utility.trace('l_trans_gre ='||l_trans_gre);
160: l_validate_gre := validate_gre_data(l_trans_gre, to_char(l_year_end,'YYYY'));
161: IF l_validate_gre = '1' THEN

Line 164: hr_utility.set_location( 'pay_ca_t4a_cancel_mag.action_creation',15);

160: l_validate_gre := validate_gre_data(l_trans_gre, to_char(l_year_end,'YYYY'));
161: IF l_validate_gre = '1' THEN
162: hr_utility.raise_error;
163: END IF;
164: hr_utility.set_location( 'pay_ca_t4a_cancel_mag.action_creation',15);
165: l_asg_set_id := to_number(pay_ca_t4a_cancel_mag.get_parameter('ASG_SET_ID',
166: l_legislative_parameters));
167: hr_utility.trace('l_assignment_set_id ='||l_asg_set_id);
168: --

Line 165: l_asg_set_id := to_number(pay_ca_t4a_cancel_mag.get_parameter('ASG_SET_ID',

161: IF l_validate_gre = '1' THEN
162: hr_utility.raise_error;
163: END IF;
164: hr_utility.set_location( 'pay_ca_t4a_cancel_mag.action_creation',15);
165: l_asg_set_id := to_number(pay_ca_t4a_cancel_mag.get_parameter('ASG_SET_ID',
166: l_legislative_parameters));
167: hr_utility.trace('l_assignment_set_id ='||l_asg_set_id);
168: --
169: IF l_asg_set_id IS NOT NULL THEN

Line 183: hr_utility.set_location('pay_ca_t4a_cancel_mag.action_creation', 20);

179: l_tax_unit_id,
180: l_effective_end_date,
181: l_assignment_action_id,
182: l_payroll_act;
183: hr_utility.set_location('pay_ca_t4a_cancel_mag.action_creation', 20);
184: EXIT WHEN c_all_asg_in_asgset%NOTFOUND;
185: ELSE
186: FETCH c_all_asg INTO l_person_id,
187: l_assignment_id,

Line 192: hr_utility.set_location('pay_ca_t4a_cancel_mag.action_creation', 25);

188: l_tax_unit_id,
189: l_effective_end_date,
190: l_assignment_action_id,
191: l_payroll_act;
192: hr_utility.set_location('pay_ca_t4a_cancel_mag.action_creation', 25);
193: EXIT WHEN c_all_asg%NOTFOUND;
194: END IF;
195:
196: hr_utility.trace('+------------------------------------------------+');

Line 206: hr_utility.set_location('pay_ca_t4a_cancel_mag.action_creation', 30);

202: SELECT pay_assignment_actions_s.nextval
203: INTO lockingactid
204: FROM dual;
205: hr_utility.trace('New T4A Cancel Action = ' ||to_char(lockingactid));
206: hr_utility.set_location('pay_ca_t4a_cancel_mag.action_creation', 30);
207: hr_nonrun_asact.insact(lockingactid
208: ,l_assignment_id
209: ,p_pactid
210: ,p_chunk

Line 212: hr_utility.set_location('pay_ca_t4a_cancel_mag.action_creation', 40);

208: ,l_assignment_id
209: ,p_pactid
210: ,p_chunk
211: ,l_tax_unit_id);
212: hr_utility.set_location('pay_ca_t4a_cancel_mag.action_creation', 40);
213:
214: UPDATE pay_assignment_actions aa
215: SET aa.serial_number = to_char(l_person_id)
216: WHERE aa.assignment_action_id = lockingactid;

Line 218: hr_utility.set_location('pay_ca_t4a_cancel_mag.action_creation', 50);

214: UPDATE pay_assignment_actions aa
215: SET aa.serial_number = to_char(l_person_id)
216: WHERE aa.assignment_action_id = lockingactid;
217:
218: hr_utility.set_location('pay_ca_t4a_cancel_mag.action_creation', 50);
219: hr_nonrun_asact.insint(lockingactid ,l_assignment_action_id);
220: hr_utility.trace(to_char(lockingactid)||' locked Cancel Archiver ID '||to_char(l_assignment_action_id));
221: hr_utility.trace('x------------------------------------------------x');
222: END LOOP; --c_all_asg loop

Line 243: AND hoi.organization_id = pay_ca_t4a_cancel_mag.get_parameter('TRANSFER_GRE',

239: pay_payroll_actions ppa
240: WHERE hoi.organization_id = to_number(c_trans_id)
241: AND hoi.org_information_context='Fed Magnetic Reporting'
242: AND ppa.report_type in ('T4A','CAEOY_T4A_AMEND_PP') -- T4A Archiver Report Type
243: AND hoi.organization_id = pay_ca_t4a_cancel_mag.get_parameter('TRANSFER_GRE',
244: ppa.legislative_parameters)
245: AND ppa.effective_date = to_date('31-12-'||c_year,'DD-MM-YYYY');
246: ----
247:

Line 262: AND hoi.organization_id = pay_ca_t4a_cancel_mag.get_parameter('TRANSFER_GRE',

258: AND hou.organization_id = hoi.organization_id
259: AND ppa.report_type in ('T4A','CAEOY_T4A_AMEND_PP')
260: AND ppa.effective_date = to_date('31-12-'||p_year,'DD-MM-YYYY')
261: AND ppa.business_group_id = p_bg_id
262: AND hoi.organization_id = pay_ca_t4a_cancel_mag.get_parameter('TRANSFER_GRE',
263: ppa.legislative_parameters);
264: ----
265: CURSOR c_gre_name (b_org_id IN VARCHAR2) IS
266: SELECT hou.name

Line 1616: END pay_ca_t4a_cancel_mag;

1612:
1613:
1614: END t4a_cancel_employee_record;
1615:
1616: END pay_ca_t4a_cancel_mag;