APPS.PAY_CA_T4A_AMEND_MAG dependencies on PAY_CA_T4A_AMEND_MAG

Line 1: PACKAGE BODY pay_ca_t4a_amend_mag AS

1: PACKAGE BODY pay_ca_t4a_amend_mag AS
2: /* $Header: pycat4aamag.pkb 120.11.12020000.3 2012/10/01 07:47:06 rgottipa ship $ */
3:
4: PROCEDURE range_cursor (
5: p_pactid IN NUMBER,

Line 18: l_tax_year := pay_ca_t4a_amend_mag.get_parameter('REPORTING_YEAR',

14: SELECT legislative_parameters
15: INTO l_legislative_parameters
16: FROM pay_payroll_actions
17: WHERE payroll_action_id = p_pactid;
18: l_tax_year := pay_ca_t4a_amend_mag.get_parameter('REPORTING_YEAR',
19: l_legislative_parameters);
20:
21: SELECT user_entity_id
22: INTO l_tax_year_ue_id

Line 202: hr_utility.set_location( 'pay_ca_t4a_amend_mag.action_creation',10);

198: l_lockingactid_check pay_assignment_actions.assignment_action_id%TYPE;
199:
200: BEGIN
201: hr_utility.trace('+=========================================================+');
202: hr_utility.set_location( 'pay_ca_t4a_amend_mag.action_creation',10);
203: get_report_parameters(
204: p_pactid,
205: l_legislative_parameters,
206: l_year_end,

Line 210: l_trans_gre := pay_ca_t4a_amend_mag.get_parameter('TRANSMITTER_GRE',

206: l_year_end,
207: l_report_type,
208: l_business_group_id);
209:
210: l_trans_gre := pay_ca_t4a_amend_mag.get_parameter('TRANSMITTER_GRE',
211: l_legislative_parameters);
212: hr_utility.trace('l_trans_gre ='||l_trans_gre);
213: --
214: l_validate_gre := validate_gre_data(l_trans_gre, to_char(l_year_end,'YYYY'));

Line 230: hr_utility.set_location('pay_ca_t4a_amend_mag.action_creation', 20);

226: l_assignment_id,
227: l_tax_unit_id,
228: l_effective_end_date,
229: l_assignment_action_id;
230: hr_utility.set_location('pay_ca_t4a_amend_mag.action_creation', 20);
231: EXIT WHEN c_all_asg%NOTFOUND;
232:
233: hr_utility.trace('+------------------------------------------------+');
234: hr_utility.trace('Fetched Assignment ID : '|| to_char(l_assignment_id));

Line 255: -- hr_utility.set_location('pay_ca_t4a_amend_mag.action_creation', 80);

251: hr_utility.trace('Amended : '||lv_fed_amend_flag);
252: IF c_get_fed_amend_flag%FOUND THEN
253: IF lv_fed_amend_flag = 'Y' AND lv_flag_count =0 THEN
254: -- Insert into pay_assignment_actions.
255: -- hr_utility.set_location('pay_ca_t4a_amend_mag.action_creation', 80);
256: hr_nonrun_asact.insact(lockingactid
257: ,l_assignment_id
258: ,p_pactid
259: ,p_chunk

Line 261: -- hr_utility.set_location('pay_ca_t4a_amend_mag.action_creation', 90);

257: ,l_assignment_id
258: ,p_pactid
259: ,p_chunk
260: ,l_tax_unit_id);
261: -- hr_utility.set_location('pay_ca_t4a_amend_mag.action_creation', 90);
262: UPDATE pay_assignment_actions aa
263: SET aa.serial_number = to_char(l_person_id)
264: WHERE aa.assignment_action_id = lockingactid;
265:

Line 266: -- hr_utility.set_location('pay_ca_t4a_amend_mag.action_creation', 100);

262: UPDATE pay_assignment_actions aa
263: SET aa.serial_number = to_char(l_person_id)
264: WHERE aa.assignment_action_id = lockingactid;
265:
266: -- hr_utility.set_location('pay_ca_t4a_amend_mag.action_creation', 100);
267: hr_nonrun_asact.insint(lockingactid ,l_assignment_action_id);
268:
269: hr_utility.trace(to_char(lockingactid)||' locked Amend Archiver ID '||to_char(l_assignment_action_id));
270: lv_flag_count := lv_flag_count + 1;

Line 1683: END pay_ca_t4a_amend_mag;

1679:
1680:
1681: END t4a_amend_employee_record;
1682:
1683: END pay_ca_t4a_amend_mag;