APPS.PAY_FI_ARCHIVE_TEL dependencies on PAY_ACTION_INFORMATION

Line 416: pay_action_information_api.create_action_information (

412: INTO lr_Local_Unit_Details;
413: CLOSE csr_Local_Unit_Details;
414: -- *********************************************************************
415:
416: pay_action_information_api.create_action_information (
417: p_action_information_id=> l_action_info_id,
418: p_action_context_id=> p_payroll_action_id,
419: p_action_context_type=> 'PA',
420: p_object_version_number=> l_ovn,

Line 470: pay_action_information_api.create_action_information (

466: ELSE
467: FOR lr_all_local_unit_details IN
468: csr_all_local_unit_details (g_legal_employer_id)
469: LOOP
470: pay_action_information_api.create_action_information (
471: p_action_information_id=> l_action_info_id,
472: p_action_context_id=> p_payroll_action_id,
473: p_action_context_type=> 'PA',
474: p_object_version_number=> l_ovn,

Line 516: pay_action_information_api.create_action_information (

512: END IF; -- END OF G_LOCAL_UNIT_ID NULL CHECK
513: */
514: -- *****************************************************************************
515: -- Insert the report Parameters
516: pay_action_information_api.create_action_information (
517: p_action_information_id=> l_action_info_id,
518: p_action_context_id=> p_payroll_action_id,
519: p_action_context_type=> 'PA',
520: p_object_version_number=> l_ovn,

Line 570: pay_action_information_api.create_action_information (

566:
567: -- *****************************************************************************
568: -- Information regarding the Legal Employer
569: /*
570: pay_action_information_api.create_action_information (
571: p_action_information_id=> l_action_info_id,
572: p_action_context_id=> p_payroll_action_id,
573: p_action_context_type=> 'PA',
574: p_object_version_number=> l_ovn,

Line 1032: l_action_info_id pay_action_information.action_information_id%TYPE;

1028: l_pre_start_date per_time_periods.start_date%TYPE;
1029: l_fnd_session NUMBER := 0;
1030: l_prev_prepay NUMBER := 0;
1031:
1032: l_action_info_id pay_action_information.action_information_id%TYPE;
1033: l_ovn pay_action_information.object_version_number%TYPE;
1034: l_flag number:=0;
1035:
1036: -- The place for Variables which fetches the values to be archived

Line 1033: l_ovn pay_action_information.object_version_number%TYPE;

1029: l_fnd_session NUMBER := 0;
1030: l_prev_prepay NUMBER := 0;
1031:
1032: l_action_info_id pay_action_information.action_information_id%TYPE;
1033: l_ovn pay_action_information.object_version_number%TYPE;
1034: l_flag number:=0;
1035:
1036: -- The place for Variables which fetches the values to be archived
1037: l_Insurance_pol_number VARCHAR2(240); --Pension Insurance Number

Line 1841: FROM pay_action_information

1837: -- End of Pickingup the Data
1838:
1839: BEGIN
1840: SELECT 1 INTO l_flag
1841: FROM pay_action_information
1842: WHERE action_information_category = 'EMEA REPORT DETAILS'
1843: AND action_information1 = 'PYFITELA'
1844: AND action_context_id = p_assignment_action_id;
1845:

Line 1851: pay_action_information_api.create_action_information (

1847: WHEN NO_DATA_FOUND
1848: THEN
1849: fnd_file.put_line(fnd_file.log,'Not found In Archive record ' );
1850: fnd_file.put_line(fnd_file.log,'g_payroll_action_id ' || g_payroll_action_id);
1851: pay_action_information_api.create_action_information (
1852: p_action_information_id => l_action_info_id
1853: ,p_action_context_id => p_assignment_action_id
1854: ,p_action_context_type => 'AAP'
1855: ,p_object_version_number => l_ovn

Line 2040: pay_action_information_api.create_action_information (

2036: fnd_file.put_line(fnd_file.log,'(2) END_DATE==> '|| l_third_end_date);
2037:
2038:
2039:
2040: pay_action_information_api.create_action_information (
2041: p_action_information_id => l_action_info_id
2042: ,p_action_context_id => p_assignment_action_id
2043: ,p_action_context_type => 'AAP'
2044: ,p_object_version_number => l_ovn

Line 2086: pay_action_information_api.create_action_information (

2082:
2083: FOR l_PERSON_ALL_EIT IN
2084: CSR_PERSON_ALL_EIT (l_person_id)
2085: LOOP
2086: pay_action_information_api.create_action_information (
2087: p_action_information_id => l_action_info_id,
2088: p_action_context_id => p_assignment_action_id,
2089: p_action_context_type => 'AAP',
2090: p_object_version_number => l_ovn,