APPS.AP_IMPORT_UTILITIES_PKG dependencies on AP_INTERFACE_CONTROLS

Line 746: FROM ap_interface_controls

742: -- import_requests_group
743: CURSOR import_requests IS
744: SELECT request_id,
745: group_id
746: FROM ap_interface_controls
747: WHERE source = p_source
748: ORDER BY request_id DESC;
749:
750: CURSOR import_requests_group IS

Line 753: FROM ap_interface_controls

749:
750: CURSOR import_requests_group IS
751: SELECT request_id,
752: group_id
753: FROM ap_interface_controls
754: WHERE source = p_source
755: AND group_id = p_group_id
756: ORDER BY request_id DESC;
757:

Line 788: LOCK TABLE AP_INTERFACE_CONTROLS IN EXCLUSIVE MODE;

784: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then
785: Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,debug_info);
786: END IF;
787:
788: LOCK TABLE AP_INTERFACE_CONTROLS IN EXCLUSIVE MODE;
789:
790: debug_info := '(Check_control_table) Open import_requests cursor';
791:
792: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then

Line 806: -- Step 2, Fetch l_previous_request_id from ap_interface_controls with

802: END IF;
803:
804: LOOP
805: -------------------------------------------------------------------------
806: -- Step 2, Fetch l_previous_request_id from ap_interface_controls with
807: -- the same source and group_id (optional). If group_id is null,
808: -- all requests from the source will be fetched
809: -------------------------------------------------------------------------
810:

Line 892: -- Delete the previous record in ap_interface_controls if the status

888: ELSIF (l_dev_phase = 'COMPLETE') THEN
889:
890: ---------------------------------------------------------------------
891: -- Step 4.2
892: -- Delete the previous record in ap_interface_controls if the status
893: -- is 'COMPLETE'
894: ---------------------------------------------------------------------
895: debug_info := '(Check_control_table 4.2) Delete the previous record '||
896: 'in ap_interface_controls';

Line 896: 'in ap_interface_controls';

892: -- Delete the previous record in ap_interface_controls if the status
893: -- is 'COMPLETE'
894: ---------------------------------------------------------------------
895: debug_info := '(Check_control_table 4.2) Delete the previous record '||
896: 'in ap_interface_controls';
897: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then
898: Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,debug_info);
899: END IF;
900:

Line 903: DELETE FROM AP_INTERFACE_CONTROLS

899: END IF;
900:
901: -- Bug 4145391
902: IF (p_group_id IS NULL) THEN
903: DELETE FROM AP_INTERFACE_CONTROLS
904: WHERE source = p_source
905: AND request_id = l_previous_request_id;
906: ELSE
907: DELETE FROM AP_INTERFACE_CONTROLS

Line 907: DELETE FROM AP_INTERFACE_CONTROLS

903: DELETE FROM AP_INTERFACE_CONTROLS
904: WHERE source = p_source
905: AND request_id = l_previous_request_id;
906: ELSE
907: DELETE FROM AP_INTERFACE_CONTROLS
908: WHERE source = p_source
909: AND group_id = p_group_id
910: AND request_id = l_previous_request_id;
911: END IF;

Line 939: INSERT INTO AP_INTERFACE_CONTROLS(

935: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then
936: Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,debug_info);
937: END IF;
938:
939: INSERT INTO AP_INTERFACE_CONTROLS(
940: source,
941: group_id,
942: request_id)
943: VALUES (p_source,