APPS.AP_VOID_PKG dependencies on AP_HOLDS

Line 24: (invoice_id AP_HOLDS_ALL.invoice_id%TYPE,

20: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'AP.PLSQL.AP_VOID_PKG.';
21:
22: /* bug 5169128 */
23: TYPE r_hold_info IS RECORD
24: (invoice_id AP_HOLDS_ALL.invoice_id%TYPE,
25: org_id AP_HOLDS_ALL.org_id%TYPE,
26: hold_id AP_HOLDS_ALL.hold_id%TYPE);
27:
28: TYPE hold_tab_type IS TABLE OF r_hold_info INDEX BY BINARY_INTEGER;

Line 25: org_id AP_HOLDS_ALL.org_id%TYPE,

21:
22: /* bug 5169128 */
23: TYPE r_hold_info IS RECORD
24: (invoice_id AP_HOLDS_ALL.invoice_id%TYPE,
25: org_id AP_HOLDS_ALL.org_id%TYPE,
26: hold_id AP_HOLDS_ALL.hold_id%TYPE);
27:
28: TYPE hold_tab_type IS TABLE OF r_hold_info INDEX BY BINARY_INTEGER;
29:

Line 26: hold_id AP_HOLDS_ALL.hold_id%TYPE);

22: /* bug 5169128 */
23: TYPE r_hold_info IS RECORD
24: (invoice_id AP_HOLDS_ALL.invoice_id%TYPE,
25: org_id AP_HOLDS_ALL.org_id%TYPE,
26: hold_id AP_HOLDS_ALL.hold_id%TYPE);
27:
28: TYPE hold_tab_type IS TABLE OF r_hold_info INDEX BY BINARY_INTEGER;
29:
30: PROCEDURE Ap_Reverse_Check(

Line 196: FROM ap_holds AH

192: WHERE AIP.check_id = P_check_id
193: AND nvl(AIP.reversal_flag, 'N') <> 'Y'
194: AND NOT EXISTS
195: (SELECT 'Invoice already has this hold'
196: FROM ap_holds AH
197: WHERE AH.invoice_id = AIP.invoice_id
198: AND AH.hold_lookup_code = P_Hold_Code
199: AND AH.release_lookup_code IS NULL)
200: AND NOT EXISTS (SELECT 'Invoice is an Interest Invoice' -- 3240962

Line 783: FROM ap_holds AH

779: WHERE AIP.check_id = P_check_id
780: AND nvl(AIP.reversal_flag, 'N') <> 'Y'
781: AND NOT EXISTS
782: (SELECT 'Invoice already has this hold'
783: FROM ap_holds AH
784: WHERE AH.invoice_id = AIP.invoice_id
785: AND AH.hold_lookup_code = P_Hold_Code
786: AND AH.release_lookup_code IS NULL)
787: AND NOT EXISTS (SELECT 'Invoice is an Interest Invoice'

Line 803: Select AP_HOLDS_S.nextval

799: EXIT WHEN C_Hold_Cur%NOTFOUND;
800:
801: l_hold_tab(l_invoice_id_hold).invoice_id := l_invoice_id_hold;
802: l_hold_tab(l_invoice_id_hold).org_id := l_org_id_hold;
803: Select AP_HOLDS_S.nextval
804: INTO l_hold_tab(l_invoice_id_hold).hold_id
805: From DUAL;
806:
807: END LOOP;

Line 814: INSERT INTO ap_holds_all

810: FOR i in nvl(l_hold_tab.FIRST, 0) .. nvl(l_hold_tab.LAST, 0) LOOP
811:
812: IF (l_hold_tab.exists(i)) THEN
813:
814: INSERT INTO ap_holds_all
815: (invoice_id
816: ,hold_lookup_code
817: ,last_update_date
818: ,last_updated_by

Line 846: (p_table_name => 'AP_HOLDS',

842:
843: /* bug 5169128 */
844: --Bug 4539462 DBI logging
845: AP_DBI_PKG.Maintain_DBI_Summary
846: (p_table_name => 'AP_HOLDS',
847: p_operation => 'I',
848: p_key_value_list => l_dbi_key_value_list3,
849: p_calling_sequence => l_curr_calling_sequence);
850: