APPS.AP_CONC_PROG_PKG dependencies on AP_CHECKRUN_CONC_PROCESSES

Line 10: -- Drives off records in AP_CHECKRUN_CONC_PROCESSES which are loaded up

6: -- concurrent requests submitted for a payment batch are pending,
7: -- currently running or inactive, and sets X_finished_flag to TRUE if no
8: -- payment batch requests could run now and FALSE otherwise.
9: --
10: -- Drives off records in AP_CHECKRUN_CONC_PROCESSES which are loaded up
11: -- as each request is submitted. If all payment batch requests have been
12: -- completed, they are deleted from the table.
13: --
14: PROCEDURE pay_batch_requests_finished(X_batch_name IN VARCHAR2,

Line 34: FROM ap_checkrun_conc_processes

30: -- Declare cursor to check payment batch requests
31: --
32: CURSOR requests_cursor IS
33: SELECT request_id
34: FROM ap_checkrun_conc_processes
35: WHERE checkrun_name = X_batch_name;
36:
37: BEGIN
38: X_curr_calling_sequence := 'AP_CONC_PROG_PKG.PAY_BATCH_REQUESTS_FINISHED<-' ||

Line 83: X_debug_info := 'Delete requests from ap_checkrun_conc_processes';

79: -------------------------------------------------------------------
80: -- Delete payment batch requests from table if all have finished
81: --
82: IF (X_tmp_flag = TRUE) THEN
83: X_debug_info := 'Delete requests from ap_checkrun_conc_processes';
84:
85: DELETE FROM ap_checkrun_conc_processes
86: WHERE checkrun_name = X_batch_name;
87:

Line 85: DELETE FROM ap_checkrun_conc_processes

81: --
82: IF (X_tmp_flag = TRUE) THEN
83: X_debug_info := 'Delete requests from ap_checkrun_conc_processes';
84:
85: DELETE FROM ap_checkrun_conc_processes
86: WHERE checkrun_name = X_batch_name;
87:
88: COMMIT;
89: END IF;