APPS.PAY_FI_ARCHIVE_UMFR dependencies on PAY_ACTION_INFORMATION

Line 354: pay_action_information_api.create_action_information (

350: THEN
351: OPEN csr_local_unit_details (g_local_unit_id);
352: FETCH csr_local_unit_details INTO lr_local_unit_details;
353: CLOSE csr_local_unit_details;
354: pay_action_information_api.create_action_information (
355: p_action_information_id=> l_action_info_id,
356: p_action_context_id=> p_payroll_action_id,
357: p_action_context_type=> 'PA',
358: p_object_version_number=> l_ovn,

Line 399: pay_action_information_api.create_action_information (

395: ELSE
396: FOR lr_all_local_unit_details IN
397: csr_all_local_unit_details (g_legal_employer_id)
398: LOOP
399: pay_action_information_api.create_action_information (
400: p_action_information_id=> l_action_info_id,
401: p_action_context_id=> p_payroll_action_id,
402: p_action_context_type=> 'PA',
403: p_object_version_number=> l_ovn,

Line 443: pay_action_information_api.create_action_information (

439: );
440: END LOOP;
441: END IF;
442:
443: pay_action_information_api.create_action_information (
444: p_action_information_id=> l_action_info_id,
445: p_action_context_id=> p_payroll_action_id,
446: p_action_context_type=> 'PA',
447: p_object_version_number=> l_ovn,

Line 485: pay_action_information_api.create_action_information (

481: p_action_information28=> NULL,
482: p_action_information29=> NULL,
483: p_action_information30=> NULL
484: );
485: pay_action_information_api.create_action_information (
486: p_action_information_id=> l_action_info_id,
487: p_action_context_id=> p_payroll_action_id,
488: p_action_context_type=> 'PA',
489: p_object_version_number=> l_ovn,

Line 525: pay_action_information_api.create_action_information (

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

Line 1241: l_action_info_id pay_action_information.action_information_id%TYPE;

1237: l_start_date per_time_periods.start_date%TYPE;
1238: l_pre_start_date per_time_periods.start_date%TYPE;
1239: l_fnd_session NUMBER := 0;
1240: l_prev_prepay NUMBER := 0;
1241: l_action_info_id pay_action_information.action_information_id%TYPE;
1242: l_ovn pay_action_information.object_version_number%TYPE;
1243: l_flag NUMBER := 0;
1244: -- The place for Variables which fetches the values to be archived
1245: l_y_number VARCHAR2 (240);

Line 1242: l_ovn pay_action_information.object_version_number%TYPE;

1238: l_pre_start_date per_time_periods.start_date%TYPE;
1239: l_fnd_session NUMBER := 0;
1240: l_prev_prepay NUMBER := 0;
1241: l_action_info_id pay_action_information.action_information_id%TYPE;
1242: l_ovn pay_action_information.object_version_number%TYPE;
1243: l_flag NUMBER := 0;
1244: -- The place for Variables which fetches the values to be archived
1245: l_y_number VARCHAR2 (240);
1246: l_y_number_spare NUMBER;

Line 1492: FROM pay_action_information

1488:
1489: BEGIN
1490: SELECT 1
1491: INTO l_flag
1492: FROM pay_action_information
1493: WHERE action_information_category = 'EMEA REPORT INFORMATION'
1494: AND action_information1 = 'PYFIUMFR'
1495: AND action_information2 = 'PER'
1496: AND action_context_id = p_assignment_action_id;

Line 1500: pay_action_information_api.create_action_information (

1496: AND action_context_id = p_assignment_action_id;
1497: EXCEPTION
1498: WHEN NO_DATA_FOUND
1499: THEN
1500: pay_action_information_api.create_action_information (
1501: p_action_information_id=> l_action_info_id,
1502: p_action_context_id=> p_assignment_action_id,
1503: p_action_context_type=> 'AAP',
1504: p_object_version_number=> l_ovn,