APPS.AP_IMPORT_UTILITIES_PKG dependencies on AP_INTERFACE_CONTROLS

Line 69: FROM ap_interface_controls

65: -- import_requests_group
66: CURSOR import_requests IS
67: SELECT request_id,
68: group_id
69: FROM ap_interface_controls
70: WHERE source = p_source
71: ORDER BY request_id DESC;
72:
73: CURSOR import_requests_group IS

Line 76: FROM ap_interface_controls

72:
73: CURSOR import_requests_group IS
74: SELECT request_id,
75: group_id
76: FROM ap_interface_controls
77: WHERE source = p_source
78: AND group_id = p_group_id
79: ORDER BY request_id DESC;
80:

Line 111: LOCK TABLE AP_INTERFACE_CONTROLS IN EXCLUSIVE MODE;

107: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then
108: Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,debug_info);
109: END IF;
110:
111: LOCK TABLE AP_INTERFACE_CONTROLS IN EXCLUSIVE MODE;
112:
113: debug_info := '(Check_control_table) Open import_requests cursor';
114:
115: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then

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

125: END IF;
126:
127: LOOP
128: -------------------------------------------------------------------------
129: -- Step 2, Fetch l_previous_request_id from ap_interface_controls with
130: -- the same source and group_id (optional). If group_id is null,
131: -- all requests from the source will be fetched
132: -------------------------------------------------------------------------
133:

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

211: ELSIF (l_dev_phase = 'COMPLETE') THEN
212:
213: ---------------------------------------------------------------------
214: -- Step 4.2
215: -- Delete the previous record in ap_interface_controls if the status
216: -- is 'COMPLETE'
217: ---------------------------------------------------------------------
218: debug_info := '(Check_control_table 4.2) Delete the previous record '||
219: 'in ap_interface_controls';

Line 219: 'in ap_interface_controls';

215: -- Delete the previous record in ap_interface_controls if the status
216: -- is 'COMPLETE'
217: ---------------------------------------------------------------------
218: debug_info := '(Check_control_table 4.2) Delete the previous record '||
219: 'in ap_interface_controls';
220: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then
221: Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,debug_info);
222: END IF;
223:

Line 226: DELETE FROM AP_INTERFACE_CONTROLS

222: END IF;
223:
224: -- Bug 4145391
225: IF (p_group_id IS NULL) THEN
226: DELETE FROM AP_INTERFACE_CONTROLS
227: WHERE source = p_source
228: AND request_id = l_previous_request_id;
229: ELSE
230: DELETE FROM AP_INTERFACE_CONTROLS

Line 230: DELETE FROM AP_INTERFACE_CONTROLS

226: DELETE FROM AP_INTERFACE_CONTROLS
227: WHERE source = p_source
228: AND request_id = l_previous_request_id;
229: ELSE
230: DELETE FROM AP_INTERFACE_CONTROLS
231: WHERE source = p_source
232: AND group_id = p_group_id
233: AND request_id = l_previous_request_id;
234: END IF;

Line 262: INSERT INTO AP_INTERFACE_CONTROLS(

258: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then
259: Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,debug_info);
260: END IF;
261:
262: INSERT INTO AP_INTERFACE_CONTROLS(
263: source,
264: group_id,
265: request_id)
266: VALUES (p_source,