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

Line 258: pay_action_information_api.create_action_information

254: If ( csr_rec.classification_name in ('Taxable Earnings','Pre Tax Deductions','Tax Deductions','Post Tax Deductions','Direct Payments','Non Taxable Earnings','Employer Superannuation Contributions')
255: AND csr_rec.payment IS NULL) THEN
256: NULL; -- Bug:3466097,Bug:3606558 - Elements will not be archived in this case to make it similar to SOE
257: ELSE
258: pay_action_information_api.create_action_information
259: ( p_action_information_id => l_action_info_id
260: , p_action_context_id => p_arc_assignment_action_id
261: , p_action_context_type => 'AAP'
262: , p_object_version_number => l_ovn

Line 309: pay_action_information_api.create_action_information

305: begin
306: l_procedure := g_package||'archive_balances';
307: hr_utility.set_location('Entering ' || l_procedure,1);
308:
309: pay_action_information_api.create_action_information
310: (p_action_information_id => l_action_info_id
311: ,p_action_context_id => p_arc_assignment_action_id
312: ,p_action_context_type => 'AAP'
313: ,p_object_version_number => l_ovn

Line 546: l_action_info_id pay_action_information.action_information_id%type;

542: --
543: l_assignment_id per_all_assignments_f.assignment_id%type;
544: --
545: l_balance number; -- Bug: 3991308
546: l_action_info_id pay_action_information.action_information_id%type;
547: l_ovn pay_action_information.object_version_number%type;
548: --
549: -- Cursor to retrieve the Annual Leave accrual plan
550: -- information.

Line 547: l_ovn pay_action_information.object_version_number%type;

543: l_assignment_id per_all_assignments_f.assignment_id%type;
544: --
545: l_balance number; -- Bug: 3991308
546: l_action_info_id pay_action_information.action_information_id%type;
547: l_ovn pay_action_information.object_version_number%type;
548: --
549: -- Cursor to retrieve the Annual Leave accrual plan
550: -- information.
551: --

Line 615: pay_action_information_api.create_action_information

611: hr_utility.set_location('annual leave balance..........= '||to_char(l_balance),30);
612:
613: IF csr_rec.accrual_plan_name IS NOT NULL THEN /* Bug No : 2525895 */
614:
615: pay_action_information_api.create_action_information
616: ( p_action_information_id => l_action_info_id
617: , p_action_context_id => p_arc_assignment_action_id
618: , p_action_context_type => 'AAP'
619: , p_object_version_number => l_ovn

Line 657: into pay_action_information */

653:
654: ------------------------------------------------------------------------------
655: /* Bug 5036580- Modified procedure to fetch and insert values for absence based on split views .
656: l_exists and tab_row declared to ensure duplicate rows fetched from different views are not inserted again
657: into pay_action_information */
658:
659: procedure archive_absences
660: (p_assignment_id in pay_assignment_actions.assignment_id%type
661: ,p_pre_effective_date in pay_payroll_actions.effective_date%type

Line 773: l_action_info_id pay_action_information.action_information_id%type;

769: and action_type IN ('R','Q','V');
770:
771: l_exists varchar2(10) ;
772:
773: l_action_info_id pay_action_information.action_information_id%type;
774: l_ovn pay_action_information.object_version_number%type;
775:
776: l_procedure varchar2(200);
777: l_start_date VARCHAR2(20);

Line 774: l_ovn pay_action_information.object_version_number%type;

770:
771: l_exists varchar2(10) ;
772:
773: l_action_info_id pay_action_information.action_information_id%type;
774: l_ovn pay_action_information.object_version_number%type;
775:
776: l_procedure varchar2(200);
777: l_start_date VARCHAR2(20);
778: l_end_date VARCHAR2(20);

Line 834: pay_action_information_api.create_action_information

830:
831: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date); /*Bug 2438495*/
832: l_end_date := fnd_date.date_to_canonical(csr_rec.end_date);
833:
834: pay_action_information_api.create_action_information
835: (p_action_information_id => l_action_info_id
836: , p_action_context_id => p_arc_assignment_action_id
837: , p_action_context_type => 'AAP'
838: , p_object_version_number => l_ovn

Line 899: pay_action_information_api.create_action_information

895:
896: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date); /*Bug 2438495*/
897: l_end_date := fnd_date.date_to_canonical(csr_rec.end_date);
898:
899: pay_action_information_api.create_action_information
900: (p_action_information_id => l_action_info_id
901: , p_action_context_id => p_arc_assignment_action_id
902: , p_action_context_type => 'AAP'
903: , p_object_version_number => l_ovn

Line 964: pay_action_information_api.create_action_information

960:
961: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date); /*Bug 2438495*/
962: l_end_date := fnd_date.date_to_canonical(csr_rec.end_date);
963:
964: pay_action_information_api.create_action_information
965: (p_action_information_id => l_action_info_id
966: , p_action_context_id => p_arc_assignment_action_id
967: , p_action_context_type => 'AAP'
968: , p_object_version_number => l_ovn

Line 1028: pay_action_information_api.create_action_information

1024:
1025: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date); /*Bug 2438495*/
1026: l_end_date := fnd_date.date_to_canonical(csr_rec.end_date);
1027:
1028: pay_action_information_api.create_action_information
1029: (p_action_information_id => l_action_info_id
1030: , p_action_context_id => p_arc_assignment_action_id
1031: , p_action_context_type => 'AAP'
1032: , p_object_version_number => l_ovn

Line 1091: pay_action_information_api.create_action_information

1087:
1088: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date); /*Bug 2438495*/
1089: l_end_date := fnd_date.date_to_canonical(csr_rec.end_date);
1090:
1091: pay_action_information_api.create_action_information
1092: (p_action_information_id => l_action_info_id
1093: , p_action_context_id => p_arc_assignment_action_id
1094: , p_action_context_type => 'AAP'
1095: , p_object_version_number => l_ovn

Line 1153: pay_action_information_api.create_action_information

1149:
1150: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date); /*Bug 2438495*/
1151: l_end_date := fnd_date.date_to_canonical(csr_rec.end_date);
1152:
1153: pay_action_information_api.create_action_information
1154: (p_action_information_id => l_action_info_id
1155: , p_action_context_id => p_arc_assignment_action_id
1156: , p_action_context_type => 'AAP'
1157: , p_object_version_number => l_ovn

Line 1215: pay_action_information_api.create_action_information

1211:
1212: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date); /*Bug 2438495*/
1213: l_end_date := fnd_date.date_to_canonical(csr_rec.end_date);
1214:
1215: pay_action_information_api.create_action_information
1216: (p_action_information_id => l_action_info_id
1217: , p_action_context_id => p_arc_assignment_action_id
1218: , p_action_context_type => 'AAP'
1219: , p_object_version_number => l_ovn

Line 1344: FROM pay_action_information pai

1340: cp_curr_pymt_eff_date)
1341: /* Bug 6962336 - Add NOT EXISTS Clause */
1342: AND NOT EXISTS
1343: ( SELECT pai.action_information_id
1344: FROM pay_action_information pai
1345: WHERE pai.action_context_id = cp_action_context_id
1346: AND pai.action_information_category = 'EMPLOYEE NET PAY DISTRIBUTION'
1347: AND pai.action_context_type = 'AAP'
1348: AND pai.action_information15 = ppp.pre_payment_id

Line 1406: pay_action_information_api.create_action_information(

1402: if c_net_pay%notfound then
1403: exit;
1404: end if;
1405:
1406: pay_action_information_api.create_action_information(
1407: p_action_information_id => l_action_information_id_1,
1408: p_object_version_number => l_object_version_number_1,
1409: p_action_information_category => 'EMPLOYEE NET PAY DISTRIBUTION',
1410: p_action_context_id => p_action_context_id,

Line 1483: l_action_info_id pay_action_information.action_information_id%type;

1479: ,p_period_end_date in per_time_periods.end_date%type /* Bug No : 2491444 */
1480: ,p_regular_payment_date in per_time_periods.regular_payment_date%type /* Bug# 5681819*/
1481: ) is
1482:
1483: l_action_info_id pay_action_information.action_information_id%type;
1484: l_ovn pay_action_information.object_version_number%type;
1485: l_date_earned pay_payroll_actions.date_earned%type;
1486: l_procedure varchar2(80) ;
1487: l_abn number;

Line 1484: l_ovn pay_action_information.object_version_number%type;

1480: ,p_regular_payment_date in per_time_periods.regular_payment_date%type /* Bug# 5681819*/
1481: ) is
1482:
1483: l_action_info_id pay_action_information.action_information_id%type;
1484: l_ovn pay_action_information.object_version_number%type;
1485: l_date_earned pay_payroll_actions.date_earned%type;
1486: l_procedure varchar2(80) ;
1487: l_abn number;
1488: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;

Line 1738: pay_action_information_api.create_action_information

1734: close csr_abn;
1735:
1736: hr_utility.set_location('Archiving AU EMPLOYEE DETAILS',30);
1737:
1738: pay_action_information_api.create_action_information
1739: ( p_action_information_id => l_action_info_id
1740: , p_action_context_id => p_arc_assignment_action_id
1741: , p_action_context_type => 'AAP'
1742: , p_object_version_number => l_ovn

Line 1786: pay_action_information_api.create_action_information (

1782: hr_utility.trace('Value of l_step is '||l_step);
1783: hr_utility.trace('Value of p_assignment_id is '||p_assignment_id);
1784:
1785:
1786: pay_action_information_api.create_action_information (
1787: p_action_information_id => l_action_info_id
1788: ,p_action_context_id => p_arc_assignment_action_id
1789: ,p_action_context_type => 'AAP'
1790: ,p_object_version_number => l_ovn

Line 1818: ,p_effective_date in pay_action_information.effective_date%TYPE

1814: ----------------------------
1815:
1816: procedure insert_quickpay_pa_info
1817: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
1818: ,p_effective_date in pay_action_information.effective_date%TYPE
1819: ) is
1820:
1821: cursor csr_get_payroll_id
1822: (p_payroll_action_id pay_payroll_actions.payroll_id%TYPE)

Line 1884: p_payroll_action_id pay_action_information.action_context_id%TYPE

1880: from pay_assignment_actions paa
1881: where paa.assignment_action_id = p_aa_id;
1882:
1883: cursor csr_is_employer_addr_archived(
1884: p_payroll_action_id pay_action_information.action_context_id%TYPE
1885: , p_effective_date pay_action_information.effective_date%TYPE)
1886: is
1887: select count(*)
1888: from pay_action_information pai

Line 1885: , p_effective_date pay_action_information.effective_date%TYPE)

1881: where paa.assignment_action_id = p_aa_id;
1882:
1883: cursor csr_is_employer_addr_archived(
1884: p_payroll_action_id pay_action_information.action_context_id%TYPE
1885: , p_effective_date pay_action_information.effective_date%TYPE)
1886: is
1887: select count(*)
1888: from pay_action_information pai
1889: where pai.action_context_type = 'PA'

Line 1888: from pay_action_information pai

1884: p_payroll_action_id pay_action_information.action_context_id%TYPE
1885: , p_effective_date pay_action_information.effective_date%TYPE)
1886: is
1887: select count(*)
1888: from pay_action_information pai
1889: where pai.action_context_type = 'PA'
1890: and pai.action_information_category = 'ADDRESS DETAILS'
1891: and pai.action_information14 = 'Employer Address'
1892: and pai.action_context_id = p_payroll_action_id