APPS.PAY_CA_T4_AMEND_MAG dependencies on PAY_CA_T4_AMEND_MAG

Line 1: PACKAGE BODY pay_ca_t4_amend_mag AS

1: PACKAGE BODY pay_ca_t4_amend_mag AS
2: /* $Header: pycat4amag.pkb 120.8.12020000.5 2013/01/11 16:28:45 sgotlasw ship $ */
3:
4: PROCEDURE range_cursor (
5: p_pactid IN NUMBER,

Line 18: l_tax_year := pay_ca_t4_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_t4_amend_mag.get_parameter('REPORTING_YEAR',
19: l_legislative_parameters);
20: --
21: SELECT user_entity_id
22: INTO l_tax_year_ue_id

Line 191: hr_utility.set_location( 'pay_ca_t4_amend_mag.action_creation',10);

187: l_lockingactid_check pay_assignment_actions.assignment_action_id%TYPE;
188:
189: BEGIN
190: hr_utility.trace('+=========================================================+');
191: hr_utility.set_location( 'pay_ca_t4_amend_mag.action_creation',10);
192: get_report_parameters(
193: p_pactid,
194: l_legislative_parameters,
195: l_year_end,

Line 199: l_trans_gre := pay_ca_t4_amend_mag.get_parameter('TRANSMITTER_GRE',

195: l_year_end,
196: l_report_type,
197: l_business_group_id);
198:
199: l_trans_gre := pay_ca_t4_amend_mag.get_parameter('TRANSMITTER_GRE',
200: l_legislative_parameters);
201: hr_utility.trace('l_trans_gre ='||l_trans_gre);
202: --
203: l_validate_gre := validate_gre_data(l_trans_gre, to_char(l_year_end,'YYYY'));

Line 219: -- hr_utility.set_location('pay_ca_t4_amend_mag.action_creation', 20);

215: l_assignment_id,
216: l_tax_unit_id,
217: l_effective_end_date,
218: l_assignment_action_id;
219: -- hr_utility.set_location('pay_ca_t4_amend_mag.action_creation', 20);
220: EXIT WHEN c_all_asg%NOTFOUND;
221:
222: hr_utility.trace('+------------------------------------------------+');
223: hr_utility.trace('Fetched Assignment: '|| to_char(l_assignment_id)||

Line 244: -- hr_utility.set_location('pay_ca_t4_amend_mag.action_creation', 80);

240: hr_utility.trace('Amended : '||lv_fed_amend_flag);
241: IF c_get_fed_amend_flag%FOUND THEN
242: IF lv_fed_amend_flag = 'Y' AND lv_flag_count =0 THEN
243: -- Insert into pay_assignment_actions.
244: -- hr_utility.set_location('pay_ca_t4_amend_mag.action_creation', 80);
245: hr_nonrun_asact.insact(lockingactid
246: ,l_assignment_id
247: ,p_pactid
248: ,p_chunk

Line 250: -- hr_utility.set_location('pay_ca_t4_amend_mag.action_creation', 90);

246: ,l_assignment_id
247: ,p_pactid
248: ,p_chunk
249: ,l_tax_unit_id);
250: -- hr_utility.set_location('pay_ca_t4_amend_mag.action_creation', 90);
251: UPDATE pay_assignment_actions aa
252: SET aa.serial_number = to_char(l_person_id)
253: WHERE aa.assignment_action_id = lockingactid;
254:

Line 255: -- hr_utility.set_location('pay_ca_t4_amend_mag.action_creation', 100);

251: UPDATE pay_assignment_actions aa
252: SET aa.serial_number = to_char(l_person_id)
253: WHERE aa.assignment_action_id = lockingactid;
254:
255: -- hr_utility.set_location('pay_ca_t4_amend_mag.action_creation', 100);
256: hr_nonrun_asact.insint(lockingactid ,l_assignment_action_id);
257:
258: hr_utility.trace(to_char(lockingactid)||' locked Amend Archiver ID '||to_char(l_assignment_action_id));
259: lv_flag_count := lv_flag_count + 1;

Line 1946: END pay_ca_t4_amend_mag;

1942:
1943:
1944: END t4_amend_employee_record;
1945:
1946: END pay_ca_t4_amend_mag;