APPS.PAY_CA_EOY_RL2_ARCHIVE dependencies on PAY_ACTION_INFORMATION

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

431:
432:
433: /*
434: Name : archive_data_records
435: Purpose : This procedure will insert values in to pay_action_information
436: table using the plsql table.
437: Arguments :
438: Notes :
439: */

Line 477: pay_action_information_api.create_action_information(

473: hr_utility.trace('act_info6 is'|| p_tab_rec_data(i).act_info6);
474:
475: hr_utility.trace('act_info30 is'|| p_tab_rec_data(i).act_info30);
476:
477: pay_action_information_api.create_action_information(
478: p_action_information_id => l_action_information_id_1,
479: p_object_version_number => l_object_version_number_1,
480: p_action_information_category
481: => p_tab_rec_data(i).action_info_category,

Line 583: from pay_action_information

579:
580: cursor c_get_footnotes(cp_asg_act_id number) is
581: select action_information4,
582: action_information5
583: from pay_action_information
584: where action_context_id = cp_asg_act_id
585: and action_information_category = 'CA FOOTNOTES'
586: and action_context_type = 'AAP'
587: and action_information6 = 'RL2'

Line 622: from pay_action_information

618: nvl(action_information27,'NULL'),
619: nvl(action_information28,'NULL'),
620: nvl(action_information29,'NULL'),
621: nvl(action_information30,'NULL')
622: from pay_action_information
623: where action_context_id = cp_asg_act_id
624: and action_information_category = 'CAEOY RL2 EMPLOYEE INFO'
625: and action_context_type = 'AAP'
626: and jurisdiction_code = 'QC';

Line 1618: /* Inserting rows into pay_action_information table

1614: whether it is for Quebec only or not */
1615:
1616: g_archive_flag := 'Y';
1617:
1618: /* Inserting rows into pay_action_information table
1619: Transmitter PRE Information */
1620:
1621: if ltr_ppa_arch_data.count >0 then
1622: hr_utility.trace('Archiving PRE Data');

Line 1632: /* Inserting rows into pay_action_information table

1628: ,p_effective_date => l_effective_date
1629: ,p_tab_rec_data => pay_ca_eoy_rl2_archive.ltr_ppa_arch_data);
1630: end if;
1631:
1632: /* Inserting rows into pay_action_information table
1633: Employer Information (Could be just a PRE or Transmitter PRE) */
1634:
1635: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_er_data.count >0 then
1636: hr_utility.trace('Archiving Employer Data');

Line 1673: from pay_action_information

1669: l_flag varchar2(1);
1670:
1671: cursor c_chk_payroll_action is
1672: select 'Y'
1673: from pay_action_information
1674: where action_information1 = 'RL2'
1675: and action_context_id = p_payroll_action_id;
1676:
1677: begin

Line 1917: from pay_action_information pac,

1913: transmitter PRE */
1914: cursor c_all_gres(asgactid number) is
1915: select hoi.organization_id ,
1916: hoi.org_information5
1917: from pay_action_information pac,
1918: pay_assignment_actions paa,
1919: hr_organization_information hoi
1920: where paa.assignment_action_id = asgactid
1921: and pac.action_context_id = paa.payroll_action_id

Line 1933: from pay_action_information pac,

1929: transmitter PRE */
1930: cursor c_all_gres_for_footnote(asgactid number) is
1931: select hoi.organization_id ,
1932: hoi.org_information5
1933: from pay_action_information pac,
1934: pay_assignment_actions paa,
1935: hr_organization_information hoi
1936: where paa.assignment_action_id = asgactid
1937: and pac.action_context_id = paa.payroll_action_id

Line 3095: /* Inserting rows into pay_action_information table

3091: := l_postal_code;
3092:
3093: end if;
3094:
3095: /* Inserting rows into pay_action_information table
3096: RL2 Employee Data Archived */
3097:
3098: if pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data.count >0 then
3099: archive_data_records(