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_T4_CANCEL_MAG dependencies on PAY_CA_T4_CANCEL_MAG

Line 1: PACKAGE BODY pay_ca_t4_cancel_mag AS

1: PACKAGE BODY pay_ca_t4_cancel_mag AS
2: /* $Header: pycat4cmag.pkb 120.6.12020000.4 2013/01/08 14:46:33 sgotlasw ship $ */
3:
4: PROCEDURE range_cursor (
5: p_pactid IN NUMBER,

Line 22: to_number(pay_ca_t4_cancel_mag.get_parameter(''PAY_ACT'', ppa1.legislative_parameters))

18: where ppa.payroll_action_id = paa.payroll_action_id
19: and paa.assignment_id = paaf.assignment_id
20: and ppa1.payroll_action_id = :payroll_action_id
21: and ppa.payroll_action_id =
22: to_number(pay_ca_t4_cancel_mag.get_parameter(''PAY_ACT'', ppa1.legislative_parameters))
23: and paaf.person_id =
24: nvl(pay_ca_t4_cancel_mag.get_parameter(''PER_ID'',ppa1.legislative_parameters),paaf.person_id)
25: order by paaf.person_id';
26:

Line 24: nvl(pay_ca_t4_cancel_mag.get_parameter(''PER_ID'',ppa1.legislative_parameters),paaf.person_id)

20: and ppa1.payroll_action_id = :payroll_action_id
21: and ppa.payroll_action_id =
22: to_number(pay_ca_t4_cancel_mag.get_parameter(''PAY_ACT'', ppa1.legislative_parameters))
23: and paaf.person_id =
24: nvl(pay_ca_t4_cancel_mag.get_parameter(''PER_ID'',ppa1.legislative_parameters),paaf.person_id)
25: order by paaf.person_id';
26:
27: hr_utility.trace('Leaving Range Cursor');
28:

Line 62: to_number(pay_ca_t4_cancel_mag.get_parameter('PAY_ACT', ppa1.legislative_parameters))

58: and paa.assignment_id = paaf.assignment_id
59: and ppa1.payroll_action_id = p_pactid
60: and paaf.person_id between p_stperson and p_endperson
61: and ppa.payroll_action_id =
62: to_number(pay_ca_t4_cancel_mag.get_parameter('PAY_ACT', ppa1.legislative_parameters))
63: and ppa2.report_type in ('T4','CAEOY_T4_AMEND_PP')
64: and int.locking_action_id = paa.assignment_action_id
65: and paa1.assignment_action_id = int.locked_action_id
66: and ppa2.payroll_action_id = paa1.payroll_action_id

Line 75: to_number(pay_ca_t4_cancel_mag.get_parameter('PAY_ACT', ppa1.legislative_parameters))

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

Line 104: to_number(pay_ca_t4_cancel_mag.get_parameter('PAY_ACT', ppa1.legislative_parameters))

100: and paa.assignment_id = paaf.assignment_id
101: and ppa1.payroll_action_id = p_pactid
102: and paaf.person_id between p_stperson and p_endperson
103: and ppa.payroll_action_id =
104: to_number(pay_ca_t4_cancel_mag.get_parameter('PAY_ACT', ppa1.legislative_parameters))
105: and ppa2.report_type in ('T4','CAEOY_T4_AMEND_PP')
106: and int.locking_action_id = paa.assignment_action_id
107: and paa1.assignment_action_id = int.locked_action_id
108: and ppa2.payroll_action_id = paa1.payroll_action_id

Line 125: to_number(pay_ca_t4_cancel_mag.get_parameter('PAY_ACT', ppa1.legislative_parameters))

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

Line 152: hr_utility.set_location( 'pay_ca_t4_cancel_mag.action_creation',10);

148: l_payroll_act NUMBER;
149:
150: BEGIN
151: hr_utility.trace('+=========================================================+');
152: hr_utility.set_location( 'pay_ca_t4_cancel_mag.action_creation',10);
153: get_report_parameters(
154: p_pactid,
155: l_legislative_parameters,
156: l_year_end,

Line 160: l_trans_gre := pay_ca_t4_cancel_mag.get_parameter('TRANSMITTER_GRE',

156: l_year_end,
157: l_report_type,
158: l_business_group_id);
159:
160: l_trans_gre := pay_ca_t4_cancel_mag.get_parameter('TRANSMITTER_GRE',
161: l_legislative_parameters);
162: hr_utility.trace('l_trans_gre ='||l_trans_gre);
163: l_validate_gre := validate_gre_data(l_trans_gre, to_char(l_year_end,'YYYY'));
164: IF l_validate_gre = '1' THEN

Line 167: hr_utility.set_location( 'pay_ca_t4_cancel_mag.action_creation',15);

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

Line 168: l_asg_set_id := to_number(pay_ca_t4_cancel_mag.get_parameter('ASG_SET_ID',

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

Line 186: hr_utility.set_location('pay_ca_t4_cancel_mag.action_creation', 20);

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

Line 195: hr_utility.set_location('pay_ca_t4_cancel_mag.action_creation', 25);

191: l_tax_unit_id,
192: l_effective_end_date,
193: l_assignment_action_id,
194: l_payroll_act;
195: hr_utility.set_location('pay_ca_t4_cancel_mag.action_creation', 25);
196: EXIT WHEN c_all_asg%NOTFOUND;
197: END IF;
198:
199: hr_utility.trace('+------------------------------------------------+');

Line 209: hr_utility.set_location('pay_ca_t4_cancel_mag.action_creation', 30);

205: SELECT pay_assignment_actions_s.nextval
206: INTO lockingactid
207: FROM dual;
208: hr_utility.trace('New T4 Cancel Action = ' ||to_char(lockingactid));
209: hr_utility.set_location('pay_ca_t4_cancel_mag.action_creation', 30);
210: hr_nonrun_asact.insact(lockingactid
211: ,l_assignment_id
212: ,p_pactid
213: ,p_chunk

Line 215: hr_utility.set_location('pay_ca_t4_cancel_mag.action_creation', 40);

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

Line 221: hr_utility.set_location('pay_ca_t4_cancel_mag.action_creation', 50);

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

Line 246: AND hoi.organization_id = pay_ca_t4_cancel_mag.get_parameter('TRANSFER_GRE',

242: pay_payroll_actions ppa
243: WHERE hoi.organization_id = to_number(c_trans_id)
244: AND hoi.org_information_context='Fed Magnetic Reporting'
245: AND ppa.report_type in ('T4','CAEOY_T4_AMEND_PP') -- T4 Archiver Report Type
246: AND hoi.organization_id = pay_ca_t4_cancel_mag.get_parameter('TRANSFER_GRE',
247: ppa.legislative_parameters)
248: AND ppa.effective_date = to_date('31-12-'||c_year,'DD-MM-YYYY');
249: ----
250:

Line 265: AND hoi.organization_id = pay_ca_t4_cancel_mag.get_parameter('TRANSFER_GRE',

261: AND hou.organization_id = hoi.organization_id
262: AND ppa.report_type in ('T4','CAEOY_T4_AMEND_PP')
263: AND ppa.effective_date = to_date('31-12-'||p_year,'DD-MM-YYYY')
264: AND ppa.business_group_id = p_bg_id
265: AND hoi.organization_id = pay_ca_t4_cancel_mag.get_parameter('TRANSFER_GRE',
266: ppa.legislative_parameters);
267: ----
268: CURSOR c_gre_name (b_org_id IN VARCHAR2) IS
269: SELECT hou.name

Line 1939: END pay_ca_t4_cancel_mag;

1935:
1936:
1937: END t4_cancel_employee_record;
1938:
1939: END pay_ca_t4_cancel_mag;