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_RL1_MAG dependencies on PAY_CA_RL1_MAG

Line 1: PACKAGE BODY pay_ca_rl1_mag AS

1: PACKAGE BODY pay_ca_rl1_mag AS
2: /* $Header: pycarlmg.pkb 120.119.12020000.10 2013/01/23 11:11:50 rgottipa ship $ */
3:
4: -- Name : get_report_parameters
5:

Line 181: hr_utility.set_location('pay_ca_rl1_mag.get_report_parameters', 10);

177: p_business_group_id IN OUT NOCOPY NUMBER
178: ) IS
179: BEGIN
180: --hr_utility.trace_on('Y','RL1MAG');
181: hr_utility.set_location('pay_ca_rl1_mag.get_report_parameters', 10);
182:
183: SELECT ppa.start_date,
184: ppa.effective_date,
185: ppa.business_group_id,

Line 194: hr_utility.set_location('pay_ca_rl1_mag.get_report_parameters', 20);

190: p_report_type
191: FROM pay_payroll_actions ppa
192: WHERE payroll_action_id = p_pactid;
193:
194: hr_utility.set_location('pay_ca_rl1_mag.get_report_parameters', 20);
195:
196: END get_report_parameters;
197:
198: FUNCTION convert_special_char( p_data varchar2)

Line 291: pay_ca_rl1_mag.get_parameter('PRE_ORGANIZATION_ID',

287: ppa.report_qualifier = 'CAEOYRL1' AND
288: ppa.report_category = 'CAEOYRL1' AND
289: ppa.effective_date = p_effective_date AND
290: p_transmitter_org_id =
291: pay_ca_rl1_mag.get_parameter('PRE_ORGANIZATION_ID',
292: ppa.legislative_parameters);
293:
294: l_transmitter_number VARCHAR2(30);
295: l_transmitter_name VARCHAR2(100);

Line 320: l_transmitter_org_id := pay_ca_rl1_mag.get_parameter('TRANSMITTER_PRE',

316: FETCH cur_ppa
317: INTO l_legislative_parameters;
318: CLOSE cur_ppa;
319:
320: l_transmitter_org_id := pay_ca_rl1_mag.get_parameter('TRANSMITTER_PRE',
321: l_legislative_parameters);
322:
323: hr_utility.trace('l_transmitter_org_id = ' || to_char(l_transmitter_org_id));
324: hr_utility.trace('p_bg_id = ' || to_char(p_bg_id));

Line 413: hr_utility.set_location( 'pay_ca_rl1_mag.range_cursor', 10);

409: p_report_type VARCHAR2(30);
410:
411: BEGIN
412: -- hr_utility.trace_on(null,'PDF');
413: hr_utility.set_location( 'pay_ca_rl1_mag.range_cursor', 10);
414:
415: get_report_parameters(
416: p_pactid,
417: p_year_start,

Line 423: hr_utility.set_location( 'pay_ca_rl1_mag.range_cursor', 20);

419: p_report_type,
420: p_business_group_id
421: );
422:
423: hr_utility.set_location( 'pay_ca_rl1_mag.range_cursor', 20);
424:
425:
426: p_sqlstr := 'select distinct to_number(fai1.value)
427: from ff_archive_items fai1,

Line 442: and fai2.value = pay_ca_rl1_mag.get_parameter(''REPORTING_YEAR'',ppa1.legislative_parameters)

438: and ppa.report_type = ''RL1''
439: and ppa.payroll_action_id = paa.payroll_action_id
440: and fdi2.user_name = ''CAEOY_TAXATION_YEAR''
441: and fai2.user_entity_id = fdi2.user_entity_id
442: and fai2.value = pay_ca_rl1_mag.get_parameter(''REPORTING_YEAR'',ppa1.legislative_parameters)
443: and paa.payroll_action_id= fai2.context1
444: and paa.action_status = ''C''
445: and paa.assignment_action_id = fai1.context1
446: and fai1.user_entity_id = fdi1.user_entity_id

Line 449: pay_ca_rl1_mag.get_parameter(''TRANSMITTER_PRE'', ppa1.legislative_parameters )

445: and paa.assignment_action_id = fai1.context1
446: and fai1.user_entity_id = fdi1.user_entity_id
447: and fdi1.user_name = ''CAEOY_PERSON_ID''
448: and decode(hoi.org_information3, ''Y'', hoi.organization_id, hoi.org_information20) =
449: pay_ca_rl1_mag.get_parameter(''TRANSMITTER_PRE'', ppa1.legislative_parameters )
450: and hoi.org_information_context =''Prov Reporting Est''
451: and hoi.organization_id = pay_ca_rl1_mag.get_parameter(''PRE_ORGANIZATION_ID'', ppa.legislative_parameters )
452: order by to_number(fai1.value)' ;
453:

Line 451: and hoi.organization_id = pay_ca_rl1_mag.get_parameter(''PRE_ORGANIZATION_ID'', ppa.legislative_parameters )

447: and fdi1.user_name = ''CAEOY_PERSON_ID''
448: and decode(hoi.org_information3, ''Y'', hoi.organization_id, hoi.org_information20) =
449: pay_ca_rl1_mag.get_parameter(''TRANSMITTER_PRE'', ppa1.legislative_parameters )
450: and hoi.org_information_context =''Prov Reporting Est''
451: and hoi.organization_id = pay_ca_rl1_mag.get_parameter(''PRE_ORGANIZATION_ID'', ppa.legislative_parameters )
452: order by to_number(fai1.value)' ;
453:
454: hr_utility.set_location( 'pay_ca_rl1_mag.range_cursor',40);
455:

Line 454: hr_utility.set_location( 'pay_ca_rl1_mag.range_cursor',40);

450: and hoi.org_information_context =''Prov Reporting Est''
451: and hoi.organization_id = pay_ca_rl1_mag.get_parameter(''PRE_ORGANIZATION_ID'', ppa.legislative_parameters )
452: order by to_number(fai1.value)' ;
453:
454: hr_utility.set_location( 'pay_ca_rl1_mag.range_cursor',40);
455:
456: END range_cursor;
457:
458: -------------------------------------------------------------------------------

Line 547: hr_utility.set_location( 'pay_ca_rl1_mag.create_assignement_act',10);

543:
544: -- hr_utility.trace_on('Y','RL1MAG');
545:
546: l_prev_payact := -1;
547: hr_utility.set_location( 'pay_ca_rl1_mag.create_assignement_act',10);
548:
549: get_report_parameters(
550: p_pactid,
551: l_year_start,

Line 561: hr_utility.set_location( 'pay_ca_rl1_mag.create_assignement_act',20);

557: validate_transmitter_info(p_pactid,
558: l_business_group_id,
559: l_year_end);
560:
561: hr_utility.set_location( 'pay_ca_rl1_mag.create_assignement_act',20);
562:
563: --IF l_report_type = 'PYRL1MAG' THEN
564:
565: OPEN c_all_asg;

Line 574: hr_utility.set_location('pay_ca_rl1_mag.create_assignement_act', 30);

570: l_effective_end_date,
571: l_assignment_action_id,
572: l_payroll_act;
573:
574: hr_utility.set_location('pay_ca_rl1_mag.create_assignement_act', 30);
575:
576: EXIT WHEN c_all_asg%NOTFOUND;
577:
578: /* Added by ssmukher for validating the

Line 605: hr_utility.set_location('pay_ca_rl1_mag.create_assignement_act', 40);

601: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));
602: hr_utility.trace('Person Id : '|| to_char(l_person_id));
603: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
604: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date));
605: hr_utility.set_location('pay_ca_rl1_mag.create_assignement_act', 40);
606:
607: SELECT pay_assignment_actions_s.nextval
608: INTO lockingactid
609: FROM dual;

Line 611: hr_utility.set_location('pay_ca_rl1_mag.create_assignement_act', 50);

607: SELECT pay_assignment_actions_s.nextval
608: INTO lockingactid
609: FROM dual;
610:
611: hr_utility.set_location('pay_ca_rl1_mag.create_assignement_act', 50);
612: hr_nonrun_asact.insact(lockingactid,
613: l_assignment_id,
614: p_pactid,
615: p_chunk,

Line 628: hr_utility.set_location('pay_ca_rl1_mag.create_assignement_act', 60);

624: update pay_assignment_actions aa
625: set aa.serial_number = to_char(l_person_id)
626: where aa.assignment_action_id = lockingactid;
627:
628: hr_utility.set_location('pay_ca_rl1_mag.create_assignement_act', 60);
629: hr_nonrun_asact.insint(lockingactid, l_assignment_action_id);
630: hr_utility.set_location('pay_ca_rl1_mag.create_assignement_act', 70);
631: hr_utility.trace('Interlock Created - ');
632: hr_utility.trace('Locking Action : '|| to_char(lockingactid));

Line 630: hr_utility.set_location('pay_ca_rl1_mag.create_assignement_act', 70);

626: where aa.assignment_action_id = lockingactid;
627:
628: hr_utility.set_location('pay_ca_rl1_mag.create_assignement_act', 60);
629: hr_nonrun_asact.insint(lockingactid, l_assignment_action_id);
630: hr_utility.set_location('pay_ca_rl1_mag.create_assignement_act', 70);
631: hr_utility.trace('Interlock Created - ');
632: hr_utility.trace('Locking Action : '|| to_char(lockingactid));
633: hr_utility.trace('Locked Action : '|| to_char(l_assignment_action_id));
634: END LOOP;

Line 4812: END pay_ca_rl1_mag;

4808: END IF;
4809:
4810: END archive_ca_deinit;
4811: /******************************************** *************************************************************/
4812: END pay_ca_rl1_mag;