DBA Data[Home] [Help]

APPS.PAY_FI_PAYLIST_ARCHIVE dependencies on PAY_ACTION_INFORMATION

Line 294: pay_action_information_api.create_action_information (

290: OPEN csr_time_period_details (g_run_payroll_action_id);
291: FETCH csr_time_period_details INTO lr_time_period_details;
292: CLOSE csr_time_period_details;
293: g_pay_period_end_date := lr_time_period_details.end_date;
294: pay_action_information_api.create_action_information (
295: p_action_information_id=> l_action_info_id,
296: p_action_context_id=> p_payroll_action_id,
297: p_action_context_type=> 'PA',
298: p_object_version_number=> l_ovn,

Line 619: l_action_info_id pay_action_information.action_information_id%TYPE;

615: l_start_date per_time_periods.start_date%TYPE;
616: l_pre_start_date per_time_periods.start_date%TYPE;
617: l_fnd_session NUMBER := 0;
618: l_prev_prepay NUMBER := 0;
619: l_action_info_id pay_action_information.action_information_id%TYPE;
620: l_ovn pay_action_information.object_version_number%TYPE;
621: l_flag NUMBER := 0;
622: -- The place for Variables which fetches the values to be archived
623: l_y_number VARCHAR2 (240);

Line 620: l_ovn pay_action_information.object_version_number%TYPE;

616: l_pre_start_date per_time_periods.start_date%TYPE;
617: l_fnd_session NUMBER := 0;
618: l_prev_prepay NUMBER := 0;
619: l_action_info_id pay_action_information.action_information_id%TYPE;
620: l_ovn pay_action_information.object_version_number%TYPE;
621: l_flag NUMBER := 0;
622: -- The place for Variables which fetches the values to be archived
623: l_y_number VARCHAR2 (240);
624: l_y_number_spare NUMBER;

Line 721: FROM pay_action_information

717:
718: /* BEGIN
719: SELECT 1
720: INTO l_flag
721: FROM pay_action_information
722: WHERE action_information_category = 'EMEA REPORT INFORMATION'
723: AND action_information1 = 'PYFIUMFR'
724: AND action_information2 = 'PER'
725: AND action_context_id = p_assignment_action_id;

Line 730: pay_action_information_api.create_action_information (

726: EXCEPTION
727: WHEN NO_DATA_FOUND
728: THEN*/
729:
730: pay_action_information_api.create_action_information (
731: p_action_information_id=> l_action_info_id,
732: p_action_context_id=> p_assignment_action_id,
733: p_action_context_type=> 'AAP',
734: p_object_version_number=> l_ovn,