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_RL2_MAG dependencies on PAY_CA_RL2_MAG

Line 1: PACKAGE BODY PAY_CA_RL2_MAG AS

1: PACKAGE BODY PAY_CA_RL2_MAG AS
2: /* $Header: pycarl2mg.pkb 120.84.12020000.14 2013/01/17 09:01:32 rgottipa ship $ */
3:
4: -- Name : get_report_parameters
5:

Line 105: hr_utility.set_location('pay_ca_rl2_mag.get_report_parameters', 10);

101: p_legislative_param IN OUT NOCOPY VARCHAR2
102: ) IS
103: BEGIN
104: --hr_utility.trace_on('Y','RL2MAG');
105: hr_utility.set_location('pay_ca_rl2_mag.get_report_parameters', 10);
106:
107: SELECT ppa.start_date,
108: ppa.effective_date,
109: ppa.business_group_id,

Line 120: hr_utility.set_location('pay_ca_rl2_mag.get_report_parameters', 20);

116: p_legislative_param
117: FROM pay_payroll_actions ppa
118: WHERE payroll_action_id = p_pactid;
119:
120: hr_utility.set_location('pay_ca_rl2_mag.get_report_parameters', 20);
121:
122: END get_report_parameters;
123:
124: ---------------------------------------------------------------------------

Line 152: pay_ca_rl2_mag.get_parameter('PRE_ORGANIZATION_ID',

148: ppa.report_qualifier = 'CAEOYRL2' AND
149: ppa.report_category = 'ARCHIVE' AND
150: ppa.effective_date = p_effective_date AND
151: p_transmitter_org_id =
152: pay_ca_rl2_mag.get_parameter('PRE_ORGANIZATION_ID',
153: ppa.legislative_parameters);
154:
155: l_transmitter_number VARCHAR2(30);
156: l_transmitter_name VARCHAR2(100);

Line 181: l_transmitter_org_id := pay_ca_rl2_mag.get_parameter('TRANSMITTER_PRE',

177: FETCH cur_ppa
178: INTO l_legislative_parameters;
179: CLOSE cur_ppa;
180:
181: l_transmitter_org_id := pay_ca_rl2_mag.get_parameter('TRANSMITTER_PRE',
182: l_legislative_parameters);
183:
184: hr_utility.trace('l_transmitter_org_id = ' || to_char(l_transmitter_org_id));
185: hr_utility.trace('p_bg_id = ' || to_char(p_bg_id));

Line 194: l_transmitter_number := pay_ca_rl2_mag.get_transmitter_item( p_bg_id,

190: FETCH cur_arch_pactid
191: INTO l_arch_pactid;
192: CLOSE cur_arch_pactid;
193:
194: l_transmitter_number := pay_ca_rl2_mag.get_transmitter_item( p_bg_id,
195: l_arch_pactid,
196: 'CAEOY_RL2_TRANSMITTER_NUMBER');
197: l_transmitter_name := pay_ca_rl2_mag.get_transmitter_item( p_bg_id,
198: l_arch_pactid,

Line 197: l_transmitter_name := pay_ca_rl2_mag.get_transmitter_item( p_bg_id,

193:
194: l_transmitter_number := pay_ca_rl2_mag.get_transmitter_item( p_bg_id,
195: l_arch_pactid,
196: 'CAEOY_RL2_TRANSMITTER_NUMBER');
197: l_transmitter_name := pay_ca_rl2_mag.get_transmitter_item( p_bg_id,
198: l_arch_pactid,
199: 'CAEOY_RL2_TRANSMITTER_NAME');
200: BEGIN
201:

Line 225: l_type_of_package := pay_ca_rl2_mag.get_transmitter_item(p_bg_id,

221: pay_core_utils.push_token('PRE_NAME',l_transmitter_name);
222: hr_utility.raise_error;
223: END;
224:
225: l_type_of_package := pay_ca_rl2_mag.get_transmitter_item(p_bg_id,
226: l_arch_pactid,
227: 'CAEOY_RL2_TRANSMITTER_PACKAGE_TYPE');
228:
229: hr_utility.trace('l_type_of_package = ' || l_type_of_package);

Line 236: l_source_of_slips := pay_ca_rl2_mag.get_transmitter_item(p_bg_id,

232: pay_core_utils.push_message(800,'PAY_CA_RL1_MISSING_TYPE_OF_PKG','P');
233: hr_utility.raise_error;
234: END IF;
235:
236: l_source_of_slips := pay_ca_rl2_mag.get_transmitter_item(p_bg_id,
237: l_arch_pactid,
238: 'CAEOY_RL2_SOURCE_OF_SLIPS');
239: hr_utility.trace('l_source_of_slips = ' || l_source_of_slips);
240:

Line 246: l_address_line1 := pay_ca_rl2_mag.get_transmitter_item(p_bg_id,

242: pay_core_utils.push_message(800,'PAY_CA_RL1_MISSING_RLSLIP_SRC','P');
243: hr_utility.raise_error;
244: END IF;
245:
246: l_address_line1 := pay_ca_rl2_mag.get_transmitter_item(p_bg_id,
247: l_arch_pactid,
248: 'CAEOY_RL2_TRANSMITTER_ADDRESS_LINE1');
249: hr_utility.trace('l_address_line1 = ' || l_address_line1);
250:

Line 285: hr_utility.set_location( 'pay_ca_rl2_mag.range_cursor', 10);

281: p_legislative_param pay_payroll_actions.legislative_parameters%type;
282:
283: BEGIN
284:
285: hr_utility.set_location( 'pay_ca_rl2_mag.range_cursor', 10);
286:
287: get_report_parameters(
288: p_pactid,
289: p_year_start,

Line 296: hr_utility.set_location( 'pay_ca_rl2_mag.range_cursor', 20);

292: p_business_group_id,
293: p_legislative_param
294: );
295:
296: hr_utility.set_location( 'pay_ca_rl2_mag.range_cursor', 20);
297:
298: p_sqlstr := 'select /*+ leading(ppa_mag,ppa_arch,paa_arch)
299: index(emp.paa_arch,PAY_ASSIGNMENT_ACTIONS_PK)
300: use_hash(emp.ppa_arch,hoi,tran.ppa_arch)

Line 315: and tran.reporting_year = pay_ca_rl2_mag.get_parameter(''REPORTING_YEAR'',ppa_mag.legislative_parameters)

311: and ppa_arch.report_type = ''RL2''
312: and ppa_arch.payroll_action_id = paa_arch.payroll_action_id
313: and tran.reporting_year = to_char(ppa_arch.effective_date,''YYYY'')
314: and tran.business_group_id = ppa_arch.business_group_id
315: and tran.reporting_year = pay_ca_rl2_mag.get_parameter(''REPORTING_YEAR'',ppa_mag.legislative_parameters)
316: and paa_arch.payroll_action_id = tran.payroll_action_id
317: and paa_arch.action_status = ''C''
318: and paa_arch.assignment_action_id = emp.assignment_action_id
319: and paa_arch.payroll_action_id = emp.payroll_action_id

Line 328: hr_utility.set_location( 'pay_ca_rl2_mag.range_cursor',30);

324: and to_char(hoi.organization_id) =
325: pycadar_pkg.get_parameter(''PRE_ORGANIZATION_ID'',ppa_arch.legislative_parameters)
326: order by to_number(emp.person_id)' ;
327:
328: hr_utility.set_location( 'pay_ca_rl2_mag.range_cursor',30);
329:
330: END range_cursor;
331:
332: -------------------------------------------------------------------------------

Line 417: hr_utility.set_location( 'pay_ca_rl2_mag.create_assignment_act',10);

413:
414: -- hr_utility.trace_on(NULL,'RL2MAG');
415: -- Get the report parameters. These define the report being run.
416: l_prev_payact := -1;
417: hr_utility.set_location( 'pay_ca_rl2_mag.create_assignment_act',10);
418:
419: get_report_parameters(
420: p_pactid,
421: l_year_start,

Line 434: hr_utility.set_location( 'pay_ca_rl2_mag.create_assignment_act',20);

430: l_year_end);
431:
432: --Open the appropriate cursor
433:
434: hr_utility.set_location( 'pay_ca_rl2_mag.create_assignment_act',20);
435: hr_utility.trace('Report type '||l_report_type);
436: IF l_report_type = 'RL2_XML_MAG' THEN
437: OPEN c_all_asg(l_legislative_param,
438: l_business_group_id,

Line 448: hr_utility.set_location('pay_ca_rl2_mag.create_assignment_act', 30);

444: l_effective_end_date,
445: l_assignment_action_id,
446: l_payroll_act;
447:
448: hr_utility.set_location('pay_ca_rl2_mag.create_assignment_act', 30);
449:
450: EXIT WHEN c_all_asg%NOTFOUND;
451:
452: --Create the assignment action for the record

Line 460: l_emplyer_name := pay_ca_rl2_mag.get_employer_item(l_business_group_id,

456:
457: hr_utility.trace('The payroll action id '||l_payroll_act);
458:
459: l_prev_payact := l_payroll_act;
460: l_emplyer_name := pay_ca_rl2_mag.get_employer_item(l_business_group_id,
461: l_payroll_act,
462: 'CAEOY_RL2_EMPLOYER_NAME');
463:
464: l_quebec_no := pay_ca_rl2_mag.get_employer_item(l_business_group_id,

Line 464: l_quebec_no := pay_ca_rl2_mag.get_employer_item(l_business_group_id,

460: l_emplyer_name := pay_ca_rl2_mag.get_employer_item(l_business_group_id,
461: l_payroll_act,
462: 'CAEOY_RL2_EMPLOYER_NAME');
463:
464: l_quebec_no := pay_ca_rl2_mag.get_employer_item(l_business_group_id,
465: l_payroll_act,
466: 'CAEOY_RL2_QUEBEC_BN');
467: hr_utility.trace('The Quebec Number is '||l_quebec_no);
468: l_file_no := substr(l_quebec_no,13,4);

Line 484: l_addr_line := pay_ca_rl2_mag.get_employer_item(l_business_group_id,

480:
481: /* Erroring out the RL2 Electronic Interface if any of the
482: mandatory information is missing i.e Address Line 1 */
483:
484: l_addr_line := pay_ca_rl2_mag.get_employer_item(l_business_group_id,
485: l_payroll_act,
486: 'CAEOY_RL2_EMPLOYER_ADDRESS_LINE1');
487: if l_addr_line = ' '
488: then

Line 502: hr_utility.set_location('pay_ca_rl2_mag.create_assignment_act', 40);

498: hr_utility.trace('Person Id : '|| to_char(l_person_id));
499: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
500: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date));
501:
502: hr_utility.set_location('pay_ca_rl2_mag.create_assignment_act', 40);
503:
504: SELECT pay_assignment_actions_s.nextval
505: INTO lockingactid
506: FROM dual;

Line 508: hr_utility.set_location('pay_ca_rl2_mag.create_assignment_act', 50);

504: SELECT pay_assignment_actions_s.nextval
505: INTO lockingactid
506: FROM dual;
507:
508: hr_utility.set_location('pay_ca_rl2_mag.create_assignment_act', 50);
509: hr_nonrun_asact.insact(lockingactid,
510: l_assignment_id,
511: p_pactid,
512: p_chunk,

Line 524: hr_utility.set_location('pay_ca_rl2_mag.create_assignment_act', 60);

520: update pay_assignment_actions aa
521: set aa.serial_number = to_char(l_person_id)
522: where aa.assignment_action_id = lockingactid;
523:
524: hr_utility.set_location('pay_ca_rl2_mag.create_assignment_act', 60);
525:
526: hr_nonrun_asact.insint(lockingactid, l_assignment_action_id);
527:
528: hr_utility.set_location('pay_ca_rl2_mag.create_assignment_act', 70);

Line 528: hr_utility.set_location('pay_ca_rl2_mag.create_assignment_act', 70);

524: hr_utility.set_location('pay_ca_rl2_mag.create_assignment_act', 60);
525:
526: hr_nonrun_asact.insint(lockingactid, l_assignment_action_id);
527:
528: hr_utility.set_location('pay_ca_rl2_mag.create_assignment_act', 70);
529: hr_utility.trace('Interlock Created - ');
530: hr_utility.trace('Locking Action : '|| to_char(lockingactid));
531: hr_utility.trace('Locked Action : '|| to_char(l_assignment_action_id));
532:

Line 1591: := pay_ca_rl2_mag.get_parameter('TAX_YEAR',

1587:
1588: if l_rep_type = 'RL2PAPERPDF' or l_rep_type='PAYCARL2AMPDF' or l_rep_type='PAYCARL2CLPDF'
1589: then
1590: l_taxation_year
1591: := pay_ca_rl2_mag.get_parameter('TAX_YEAR',
1592: l_legislative_parameters);
1593: l_print_instruction := pay_magtape_generic.get_parameter_value('print_instruction');
1594: else
1595: l_taxation_year := pay_magtape_generic.get_parameter_value('REPORTING_YEAR');

Line 4791: l_quebec_bn := pay_ca_rl2_mag.get_employer_item(l_business_grpid,

4787: tab_employer(lNbReleves) := '' || 'Running Total' || '' || EOL;
4788:
4789: hr_utility.trace('The Payroll Action Id : '||l_payroll_actid);
4790: hr_utility.trace('The business group id : '||l_business_grpid);
4791: l_quebec_bn := pay_ca_rl2_mag.get_employer_item(l_business_grpid,
4792: l_payroll_actid,
4793: 'CAEOY_RL2_QUEBEC_BN');
4794: hr_utility.trace('The Quebec Number is '||l_quebec_bn);
4795: tab_employer(lNold) := '' || convert_special_char(substr(l_quebec_bn,1,10)) ||

Line 4803: l_employer_name := pay_ca_rl2_mag.get_employer_item(l_business_grpid,

4799:
4800: tab_employer(lNoDossier) := '' || convert_special_char(substr(l_quebec_bn,13,4)) ||
4801: '' || EOL;
4802: hr_utility.trace('The Employer File Number : '|| substr(l_quebec_bn,13,4));
4803: l_employer_name := pay_ca_rl2_mag.get_employer_item(l_business_grpid,
4804: l_payroll_actid,
4805: 'CAEOY_RL2_EMPLOYER_NAME');
4806:
4807: tab_employer(lNom1) := '' ||

Line 4813: l_address_line := pay_ca_rl2_mag.get_employer_item(l_business_grpid,

4809: hr_utility.trace('tab_employer(lNom) = ' || tab_employer(lNom1));
4810:
4811: -- Address Line 1
4812:
4813: l_address_line := pay_ca_rl2_mag.get_employer_item(l_business_grpid,
4814: l_payroll_actid,
4815: 'CAEOY_RL2_EMPLOYER_ADDRESS_LINE1');
4816:
4817: IF (l_address_line IS NULL AND

Line 4839: l_address_line := pay_ca_rl2_mag.get_employer_item(l_business_grpid,

4835:
4836:
4837: -- Address Line 2
4838:
4839: l_address_line := pay_ca_rl2_mag.get_employer_item(l_business_grpid,
4840: l_payroll_actid,
4841: 'CAEOY_RL2_EMPLOYER_ADDRESS_LINE2');
4842:
4843: IF (l_address_line IS NOT NULL AND

Line 4854: l_address_line := pay_ca_rl2_mag.get_employer_item(l_business_grpid,

4850: hr_utility.trace('tab_employer(lLigne2) = ' || tab_employer(lLigne2));
4851:
4852: -- Ville (City)
4853:
4854: l_address_line := pay_ca_rl2_mag.get_employer_item(l_business_grpid,
4855: l_payroll_actid,
4856: 'CAEOY_RL2_EMPLOYER_CITY');
4857: IF ( l_address_line IS NOT NULL AND
4858: l_address_line <> ' ') THEN

Line 4868: l_address_line := pay_ca_rl2_mag.get_employer_item(l_business_grpid,

4864: hr_utility.trace('tab_employer(lVille) = ' || tab_employer(lVille));
4865:
4866: -- Province
4867:
4868: l_address_line := pay_ca_rl2_mag.get_employer_item(l_business_grpid,
4869: l_payroll_actid,
4870: 'CAEOY_RL2_EMPLOYER_PROVINCE');
4871:
4872: IF ( l_address_line IS NOT NULL AND

Line 4884: l_address_line := pay_ca_rl2_mag.get_employer_item(l_business_grpid,

4880: hr_utility.trace('tab_employer(lProvince) = ' || tab_employer(lProvince));
4881:
4882: -- Postal Code
4883:
4884: l_address_line := pay_ca_rl2_mag.get_employer_item(l_business_grpid,
4885: l_payroll_actid,
4886: 'CAEOY_RL2_EMPLOYER_POSTAL_CODE');
4887:
4888: IF ( l_address_line IS NOT NULL AND

Line 5323: END pay_ca_rl2_mag;

5319: hr_utility.trace('l_seq_number ='|| l_seq_number);
5320: return l_seq_number;
5321: END; */
5322:
5323: END pay_ca_rl2_mag;