DBA Data[Home] [Help]

APPS.PAY_ZA_PAYSLIP_ARCHIVE dependencies on PAY_ACTION_INFORMATION

Line 278: pay_action_information_api.create_action_information

274:
275: -- Archive the balance definition in 'EMEA BALANCE DEFINITION' if archive is Y
276: if p_archive = 'Y' then
277:
278: pay_action_information_api.create_action_information
279: (
280: p_action_information_id => l_action_info_id,
281: p_action_context_id => p_pactid, -- Payroll Action of the Archiver
282: p_action_context_type => 'PA',

Line 344: pay_action_information_api.create_action_information

340: if p_archive = 'Y' then
341:
342: hr_utility.set_location('Arch EMEA ELEMENT DEFINITION', 99);
343:
344: pay_action_information_api.create_action_information
345: (
346: p_action_information_id => l_action_info_id,
347: p_action_context_id => p_pactid, -- Payroll Action of the Archiver
348: p_action_context_type => 'PA',

Line 486: pay_action_information_api.create_action_information

482: hr_utility.set_location('Arch EMEA ELEMENT DEFINITION', 99);
483:
484: -- Archive the element definition in 'EMEA ELEMENT DEFINITION'
485: -- Note: These are the Elements from the above Classifications and not the ones on the Org Flex
486: pay_action_information_api.create_action_information
487: (
488: p_action_information_id => l_action_info_id,
489: p_action_context_id => p_pactid,
490: p_action_context_type => 'PA',

Line 975: pay_action_information_api.create_action_information(

971: l_telephone_number_1;
972:
973: close csr_legal_entity_details;
974:
975: pay_action_information_api.create_action_information(
976: p_action_information_id => l_action_information_id,
977: p_action_context_id => p_payroll_action_id, -- Payroll Action of the Archiver
978: p_action_context_type => 'PA',
979: p_object_version_number => l_ovn,

Line 1015: from pay_action_information

1011: ,p_assignment_id number) is
1012: select action_information_id,
1013: effective_date,
1014: object_version_number
1015: from pay_action_information
1016: where action_context_id = p_action_context_id
1017: and action_context_type = 'AAP'
1018: and assignment_id = p_assignment_id
1019: and action_information_category = 'EMPLOYEE DETAILS';

Line 1027: from pay_action_information

1023: select action_information_id,
1024: action_information10, --region2 i.e. Postal same as residential address indicator
1025: effective_date,
1026: object_version_number
1027: from pay_action_information
1028: where action_context_id = p_action_context_id
1029: and action_context_type = 'AAP'
1030: and assignment_id = p_assignment_id
1031: and action_information_category = 'ADDRESS DETAILS'

Line 1106: pay_action_information_api.update_action_information(

1102: -- telephone number should be archived in action_information25
1103: -- but for ZA, address_line4 is stored in hl.telephone_number_1
1104: -- so action_information25 is set to null until this is resolved
1105:
1106: pay_action_information_api.update_action_information(
1107: p_action_information_id => l_action_information_id,
1108: p_object_version_number => l_ovn,
1109: p_action_information18 => l_legal_entity_name,
1110: p_action_information25 => NULL

Line 1113: update pay_action_information

1109: p_action_information18 => l_legal_entity_name,
1110: p_action_information25 => NULL
1111: );
1112:
1113: update pay_action_information
1114: set tax_unit_id = l_legal_entity_id
1115: where action_information_id = l_action_information_id;
1116:
1117: end loop;

Line 1128: pay_action_information_api.update_action_information(

1124: open csr_res_address;
1125: fetch csr_res_address into rec_res_address;
1126: close csr_res_address;
1127:
1128: pay_action_information_api.update_action_information(
1129: p_action_information_id => rec_employee_address.action_information_id,
1130: p_object_version_number => rec_employee_address.object_version_number,
1131: p_action_information5 => rec_res_address.ee_unit_num,
1132: p_action_information6 => rec_res_address.ee_complex,

Line 1142: pay_action_information_api.update_action_information(

1138: );
1139:
1140: elsif rec_employee_address.action_information10='N' then
1141: --Set the Postal as same as residential to null so it is not displayed in payslip
1142: pay_action_information_api.update_action_information(
1143: p_action_information_id => rec_employee_address.action_information_id,
1144: p_object_version_number => rec_employee_address.object_version_number,
1145: p_action_information10 => NULL
1146: );

Line 1503: pay_action_information_api.create_action_information

1499:
1500: hr_utility.set_location('Archiving ZA EMPLOYEE DETAILS', 50);
1501:
1502: -- Archive the ZA specific employee details
1503: pay_action_information_api.create_action_information
1504: (
1505: p_action_information_id => l_action_info_id,
1506: p_action_context_id => p_assactid,
1507: p_action_context_type => 'AAP',

Line 1578: pay_action_information_api.create_action_information

1574: if l_balance_value <> 0 then
1575:
1576: hr_utility.set_location('Archiving EMEA BALANCES', 20);
1577:
1578: pay_action_information_api.create_action_information
1579: (
1580: p_action_information_id => l_action_info_id,
1581: p_action_context_id => p_action_context_id,
1582: p_action_context_type => 'AAP',

Line 1776: pay_action_information_api.create_action_information

1772: else
1773:
1774: hr_utility.set_location('Result_Value = ' || rec_element_value.result_value, 21);
1775:
1776: pay_action_information_api.create_action_information
1777: (
1778: p_action_information_id => l_action_info_id,
1779: p_action_context_id => p_action_context_id,
1780: p_action_context_type => 'AAP',

Line 1829: pay_action_information_api.create_action_information

1825:
1826: hr_utility.set_location('Result_Value = ' || rec_paye_er_contr.result_value, 22);
1827:
1828:
1829: pay_action_information_api.create_action_information
1830: (
1831: p_action_information_id => l_action_info_id,
1832: p_action_context_id => p_action_context_id,
1833: p_action_context_type => 'AAP',

Line 1940: from pay_action_information pai

1936: and pact.action_status = 'C'
1937: and not exists
1938: (
1939: select null
1940: from pay_action_information pai
1941: where pai.action_context_id = pact.payroll_action_id -- Payroll Action of Prepayments
1942: and pai.action_context_type = 'PA'
1943: and pai.action_information_category = 'EMEA PAYROLL INFO'
1944: );

Line 1970: from pay_action_information pai

1966: and pact.action_status = 'C'
1967: and not exists
1968: (
1969: select null
1970: from pay_action_information pai
1971: where pai.action_context_id = pact.payroll_action_id -- FIX can't user payroll action id of Run
1972: and pai.action_context_type = 'PA' -- should be PA of archiver
1973: and pai.action_information_category = 'EMPLOYEE OTHER INFORMATION'
1974: );

Line 2176: pay_action_information_api.create_action_information

2172: hr_utility.set_location('Archiving EMEA PAYROLL INFO', 30);
2173: --
2174: -- Archive the Payroll Info in 'EMEA PAYROLL INFO'
2175: -- Note: Actually information on Org DF Tax Details References
2176: pay_action_information_api.create_action_information
2177: ( p_action_information_id => l_action_info_id
2178: ,p_action_context_id => pactid
2179: ,p_action_context_type => 'PA'
2180: ,p_object_version_number => l_ovn

Line 2205: pay_action_information_api.create_action_information

2201: l_canonical_end_date
2202: )
2203: loop
2204: --Archive the Payroll message in 'EMPLOYEE OTHER INFORMATION'
2205: pay_action_information_api.create_action_information
2206: (
2207: p_action_information_id => l_action_info_id,
2208: p_action_context_id => pactid, -- Payroll Action ID of archiver
2209: p_action_context_type => 'PA',

Line 2868: from pay_action_information pai

2864: and pact.action_status = 'C'
2865: and not exists
2866: (
2867: select null
2868: from pay_action_information pai
2869: where pai.action_context_id = pact.payroll_action_id -- Payroll Action of Prepayments
2870: and pai.action_context_type = 'PA'
2871: and pai.action_information_category = 'EMEA PAYROLL INFO'
2872: );