APPS.PAY_FI_ARCHIVE_LTFA dependencies on PAY_ACTION_INFORMATION

Line 346: FROM pay_action_information

342: IF g_archive = 'Y' THEN
343:
344: SELECT count(*)
345: INTO l_count
346: FROM pay_action_information
347: WHERE action_information_category = 'EMEA REPORT DETAILS'
348: AND action_information1 = 'PYFILTFA'
349: AND action_context_id = p_payroll_action_id;
350:

Line 483: pay_action_information_api.create_action_information (

479: END IF ;
480:
481: /*
482: --fnd_file.put_line(fnd_file.log,'Range Code 10');
483: pay_action_information_api.create_action_information (
484: p_action_information_id => l_action_info_id
485: ,p_action_context_id => p_payroll_action_id
486: ,p_action_context_type => 'PA'
487: ,p_object_version_number => l_ovn

Line 524: pay_action_information_api.create_action_information (

520: ,p_action_information29 => null
521: ,p_action_information30 => null );
522:
523: */
524: pay_action_information_api.create_action_information (
525: p_action_information_id => l_action_info_id
526: ,p_action_context_id => p_payroll_action_id
527: ,p_action_context_type => 'PA'
528: ,p_object_version_number => l_ovn

Line 1011: FROM pay_action_information

1007:
1008: BEGIN
1009: SELECT 1
1010: INTO l_flag
1011: FROM pay_action_information
1012: WHERE action_information_category = 'EMEA REPORT INFORMATION'
1013: AND action_information1 = 'PYFILTFA'
1014: AND action_information2 = 'PER'
1015: AND action_context_id = p_assignment_action_id;

Line 1021: pay_action_information_api.create_action_information (

1017: WHEN NO_DATA_FOUND
1018: THEN
1019:
1020: --fnd_file.put_line(fnd_file.log,'Archive Code 7');
1021: pay_action_information_api.create_action_information (
1022: p_action_information_id=> l_action_info_id,
1023: p_action_context_id=> p_assignment_action_id,
1024: p_action_context_type=> 'AAP',
1025: p_object_version_number=> l_ovn,

Line 1087: CURSOR csr_person_pay_action_info(p_payroll_action_id pay_action_information.action_information1%TYPE)

1083: PROCEDURE DEINITIALIZATION_CODE
1084: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
1085:
1086: /*
1087: CURSOR csr_person_pay_action_info(p_payroll_action_id pay_action_information.action_information1%TYPE)
1088: IS
1089: SELECT COUNT(*) emp_count , sum (FND_NUMBER.CANONICAL_TO_NUMBER(action_information7) + FND_NUMBER.CANONICAL_TO_NUMBER(action_information8) + FND_NUMBER.CANONICAL_TO_NUMBER(action_information9)) emp_sal
1090: ,sum (FND_NUMBER.CANONICAL_TO_NUMBER(action_information11)) pension , sum (FND_NUMBER.CANONICAL_TO_NUMBER(action_information12)) emp_pension
1091: FROM pay_action_information

Line 1091: FROM pay_action_information

1087: CURSOR csr_person_pay_action_info(p_payroll_action_id pay_action_information.action_information1%TYPE)
1088: IS
1089: SELECT COUNT(*) emp_count , sum (FND_NUMBER.CANONICAL_TO_NUMBER(action_information7) + FND_NUMBER.CANONICAL_TO_NUMBER(action_information8) + FND_NUMBER.CANONICAL_TO_NUMBER(action_information9)) emp_sal
1090: ,sum (FND_NUMBER.CANONICAL_TO_NUMBER(action_information11)) pension , sum (FND_NUMBER.CANONICAL_TO_NUMBER(action_information12)) emp_pension
1091: FROM pay_action_information
1092: WHERE action_information_category = 'EMEA REPORT INFORMATION'
1093: AND action_information1 = 'PYFILTFA'
1094: AND action_information2 = 'PER'
1095: AND action_information10 = p_payroll_action_id ;

Line 1161: pay_action_information_api.create_action_information (

1157: l_total_ins_fee := l_pension + l_emp_pension;
1158:
1159: l_total := l_total_ins_fee + (nvl(g_penalty_amt,0)*100) ;
1160:
1161: pay_action_information_api.create_action_information (
1162: p_action_information_id=> l_action_info_id,
1163: p_action_context_id=> p_payroll_action_id,
1164: p_action_context_type=> 'PA',
1165: p_object_version_number=> l_ovn,