APPS.AP_SLA_PROCESSING_PKG dependencies on AP_CHECKS_ALL

Line 11: -- ap_checks_all ap_invoices_all

7: -- \|/ \|/
8: -- | |
9: -- +-----------------------+ +------------------------+
10: -- | |
11: -- ap_checks_all ap_invoices_all
12: -- | |
13: -- | |
14: -- | |
15: -- /|\ /|\

Line 503: TYPE checkIDType IS TABLE OF ap_checks_all.check_id%type INDEX BY PLS_INTEGER;

499: AND XTE.security_id_int_1 = APSP.org_id;
500:
501: TYPE event_tab_type IS TABLE OF l_events_cur%rowtype INDEX BY PLS_INTEGER;
502: TYPE invIDType IS TABLE OF ap_invoice_lines_all.invoice_id%type INDEX BY PLS_INTEGER;
503: TYPE checkIDType IS TABLE OF ap_checks_all.check_id%type INDEX BY PLS_INTEGER;
504:
505: TYPE checkStatusType IS TABLE OF
506: ap_checks_all.status_lookup_code%type INDEX BY PLS_INTEGER;
507:

Line 506: ap_checks_all.status_lookup_code%type INDEX BY PLS_INTEGER;

502: TYPE invIDType IS TABLE OF ap_invoice_lines_all.invoice_id%type INDEX BY PLS_INTEGER;
503: TYPE checkIDType IS TABLE OF ap_checks_all.check_id%type INDEX BY PLS_INTEGER;
504:
505: TYPE checkStatusType IS TABLE OF
506: ap_checks_all.status_lookup_code%type INDEX BY PLS_INTEGER;
507:
508: l_Status AP_CHECKS_ALL.status_lookup_code%type;
509: l_matched_flag AP_PAYMENT_HISTORY_ALL.matched_flag%type;
510: l_debug_info VARCHAR2(240);

Line 508: l_Status AP_CHECKS_ALL.status_lookup_code%type;

504:
505: TYPE checkStatusType IS TABLE OF
506: ap_checks_all.status_lookup_code%type INDEX BY PLS_INTEGER;
507:
508: l_Status AP_CHECKS_ALL.status_lookup_code%type;
509: l_matched_flag AP_PAYMENT_HISTORY_ALL.matched_flag%type;
510: l_debug_info VARCHAR2(240);
511: l_procedure_name CONSTANT VARCHAR2(30):='POSTPROCESSING_PROC';
512: l_curr_calling_sequence VARCHAR2(2000);

Line 695: FROM AP_Payment_History_all APH, AP_CHECKS_all AC

691: -----------------------------------------------------------------------
692:
693: SELECT APH.matched_flag, AC.status_lookup_code
694: INTO l_matched_flag, l_status
695: FROM AP_Payment_History_all APH, AP_CHECKS_all AC
696: WHERE AC.check_id = APH.check_id
697: AND APH.accounting_Event_id = l_event_rec.event_id;
698:
699: IF l_status in ('RECONCILED UNACCOUNTED',

Line 1313: UPDATE AP_Checks_All

1309: l_check_id_list.COUNT;
1310: trace(G_LEVEL_STATEMENT, l_procedure_name, l_debug_info);
1311: -----------------------------------------------------------------------
1312: FORALL num in 1 .. l_check_id_list.COUNT
1313: UPDATE AP_Checks_All
1314: SET status_lookup_code = l_check_status_list(num)
1315: WHERE check_id = l_check_id_list(num)
1316: AND not exists (select 1 from ap_payment_history
1317: where check_id=l_check_id_list(num)