APPS.AP_SLA_PROCESSING_PKG dependencies on AP_CHECKS_ALL

Line 12: -- ap_checks_all ap_invoices_all

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

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

539: --bug 10412623, removed code introduced in 9936620
540:
541: TYPE event_tab_type IS TABLE OF l_events_cur%rowtype INDEX BY PLS_INTEGER;
542: TYPE invIDType IS TABLE OF ap_invoice_lines_all.invoice_id%type INDEX BY PLS_INTEGER;
543: TYPE checkIDType IS TABLE OF ap_checks_all.check_id%type INDEX BY PLS_INTEGER;
544:
545: TYPE checkStatusType IS TABLE OF
546: ap_checks_all.status_lookup_code%type INDEX BY PLS_INTEGER;
547:

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

542: TYPE invIDType IS TABLE OF ap_invoice_lines_all.invoice_id%type INDEX BY PLS_INTEGER;
543: TYPE checkIDType IS TABLE OF ap_checks_all.check_id%type INDEX BY PLS_INTEGER;
544:
545: TYPE checkStatusType IS TABLE OF
546: ap_checks_all.status_lookup_code%type INDEX BY PLS_INTEGER;
547:
548: l_Status AP_CHECKS_ALL.status_lookup_code%type;
549: l_matched_flag AP_PAYMENT_HISTORY_ALL.matched_flag%type;
550: l_debug_info VARCHAR2(240);

Line 548: l_Status AP_CHECKS_ALL.status_lookup_code%type;

544:
545: TYPE checkStatusType IS TABLE OF
546: ap_checks_all.status_lookup_code%type INDEX BY PLS_INTEGER;
547:
548: l_Status AP_CHECKS_ALL.status_lookup_code%type;
549: l_matched_flag AP_PAYMENT_HISTORY_ALL.matched_flag%type;
550: l_debug_info VARCHAR2(240);
551: l_procedure_name CONSTANT VARCHAR2(30):='POSTPROCESSING_PROC';
552: l_curr_calling_sequence VARCHAR2(2000);

Line 743: FROM AP_Payment_History_all APH, AP_CHECKS_all AC

739: -----------------------------------------------------------------------
740:
741: SELECT APH.matched_flag, AC.status_lookup_code
742: INTO l_matched_flag, l_status
743: FROM AP_Payment_History_all APH, AP_CHECKS_all AC
744: WHERE AC.check_id = APH.check_id
745: AND APH.accounting_Event_id = l_event_rec.event_id;
746:
747: IF l_status in ('RECONCILED UNACCOUNTED',

Line 1063: UPDATE AP_Checks_All

1059: l_check_id_list.COUNT;
1060: trace(G_LEVEL_STATEMENT, l_procedure_name, l_debug_info);
1061: -----------------------------------------------------------------------
1062: FORALL num in 1 .. l_check_id_list.COUNT
1063: UPDATE AP_Checks_All
1064: SET status_lookup_code = l_check_status_list(num)
1065: -- bug 10101613
1066: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
1067: ,LAST_UPDATE_DATE = SYSDATE