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_EOY_RL2_ARCHIVE dependencies on PAY_ACTION_INFORMATION

Line 474: Purpose : This procedure will insert values in to pay_action_information

470:
471:
472: /*
473: Name : archive_data_records
474: Purpose : This procedure will insert values in to pay_action_information
475: table using the plsql table.
476: Arguments :
477: Notes :
478: */

Line 516: pay_action_information_api.create_action_information(

512: hr_utility.trace('act_info6 is'|| p_tab_rec_data(i).act_info6);
513:
514: hr_utility.trace('act_info30 is'|| p_tab_rec_data(i).act_info30);
515:
516: pay_action_information_api.create_action_information(
517: p_action_information_id => l_action_information_id_1,
518: p_object_version_number => l_object_version_number_1,
519: p_action_information_category
520: => p_tab_rec_data(i).action_info_category,

Line 624: from pay_action_information

620:
621: cursor c_get_footnotes(cp_asg_act_id number) is
622: select action_information4,
623: action_information5
624: from pay_action_information
625: where action_context_id = cp_asg_act_id
626: and action_information_category = 'CA FOOTNOTES'
627: and action_context_type = 'AAP'
628: and action_information6 = 'RL2'

Line 663: from pay_action_information

659: nvl(action_information27,'NULL'),
660: nvl(action_information28,'NULL'),
661: nvl(action_information29,'NULL'),
662: nvl(action_information30,'NULL')
663: from pay_action_information
664: where action_context_id = cp_asg_act_id
665: and action_information_category = 'CAEOY RL2 EMPLOYEE INFO'
666: and action_context_type = 'AAP'
667: and jurisdiction_code = 'QC';

Line 671: from pay_action_information

667: and jurisdiction_code = 'QC';
668:
669: cursor c_get_employee_data2(cp_asg_act_id number) is -- For Bug 8921055
670: select nvl(action_information1,'NULL')
671: from pay_action_information
672: where action_context_id = cp_asg_act_id
673: and action_information_category = 'CAEOY RL2 EMPLOYEE INFO2'
674: and action_context_type = 'AAP'
675: and jurisdiction_code = 'QC';

Line 1788: /* Inserting rows into pay_action_information table

1784: whether it is for Quebec only or not */
1785:
1786: g_archive_flag := 'Y';
1787:
1788: /* Inserting rows into pay_action_information table
1789: Transmitter PRE Information */
1790:
1791: if ltr_ppa_arch_data.count >0 then
1792: hr_utility.trace('Archiving PRE Data');

Line 1802: /* Inserting rows into pay_action_information table

1798: ,p_effective_date => l_effective_date
1799: ,p_tab_rec_data => pay_ca_eoy_rl2_archive.ltr_ppa_arch_data);
1800: end if;
1801:
1802: /* Inserting rows into pay_action_information table
1803: Employer Information (Could be just a PRE or Transmitter PRE) */
1804:
1805: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data.count >0 then
1806: hr_utility.trace('Archiving Employer Data');

Line 1843: from pay_action_information

1839: l_flag varchar2(1);
1840:
1841: cursor c_chk_payroll_action is
1842: select 'Y'
1843: from pay_action_information
1844: where action_information1 = 'RL2'
1845: and action_context_id = p_payroll_action_id;
1846:
1847: begin

Line 1949: from pay_action_information

1945: cursor c_get_arch_seq_num(cp_aaid number) is
1946: select action_information3,
1947: ACTION_INFORMATION_ID,
1948: OBJECT_VERSION_NUMBER
1949: from pay_action_information
1950: where action_information_category = 'CAEOY RL2 EMPLOYEE INFO2'
1951: and action_context_id = cp_aaid;
1952:
1953: cursor c_get_seq_num_range(cp_run_year varchar2) is

Line 2004: pay_action_information_api.update_action_information(p_action_information_id=>l_act_info_id,

2000:
2001: if (called_from ='XMLPROC') then
2002: hr_utility.trace('In pay_ca_eoy_rl2_archive.gen_rl2_pdf_seq 40');
2003:
2004: pay_action_information_api.update_action_information(p_action_information_id=>l_act_info_id,
2005: p_object_version_number=>l_obj_ver,
2006: p_action_information3=>l_final_seq_num);
2007:
2008: end if;

Line 2133: from pay_action_information pac,

2129: /* Cursor to get the all gre values that are under the archived
2130: transmitter PRE */
2131: cursor c_all_gres(asgactid number) is
2132: select hoi.organization_id
2133: from pay_action_information pac,
2134: pay_assignment_actions paa,
2135: hr_organization_information hoi
2136: where paa.assignment_action_id = asgactid
2137: and pac.action_context_id = paa.payroll_action_id

Line 2623: from pay_action_information pac,

2619: transmitter PRE */
2620: cursor c_all_gres(asgactid number) is
2621: select hoi.organization_id ,
2622: hoi.org_information5
2623: from pay_action_information pac,
2624: pay_assignment_actions paa,
2625: hr_organization_information hoi
2626: where paa.assignment_action_id = asgactid
2627: and pac.action_context_id = paa.payroll_action_id

Line 2639: from pay_action_information pac,

2635: transmitter PRE */
2636: cursor c_all_gres_for_footnote(asgactid number) is
2637: select hoi.organization_id ,
2638: hoi.org_information5
2639: from pay_action_information pac,
2640: pay_assignment_actions paa,
2641: hr_organization_information hoi
2642: where paa.assignment_action_id = asgactid
2643: and pac.action_context_id = paa.payroll_action_id

Line 3908: /* Inserting rows into pay_action_information table

3904: := l_negative_balance_exists;
3905:
3906: end if;
3907:
3908: /* Inserting rows into pay_action_information table
3909: RL2 Employee Data Archived */
3910:
3911: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data.count >0 then
3912: archive_data_records(