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 937: FROM ap_holds AH

933: WHERE AIP.check_id = P_check_id
934: AND nvl(AIP.reversal_flag, 'N') <> 'Y'
935: AND NOT EXISTS
936: (SELECT 'Invoice already has this hold'
937: FROM ap_holds AH
938: WHERE AH.invoice_id = AIP.invoice_id
939: AND AH.hold_lookup_code = P_Hold_Code
940: AND AH.release_lookup_code IS NULL)
941: AND NOT EXISTS (SELECT 'Invoice is an Interest Invoice'

Line 957: Select AP_HOLDS_S.nextval

953: EXIT WHEN C_Hold_Cur%NOTFOUND;
954:
955: l_hold_tab(l_invoice_id_hold).invoice_id := l_invoice_id_hold;
956: l_hold_tab(l_invoice_id_hold).org_id := l_org_id_hold;
957: Select AP_HOLDS_S.nextval
958: INTO l_hold_tab(l_invoice_id_hold).hold_id
959: From DUAL;
960:
961: END LOOP;

Line 968: INSERT INTO ap_holds_all

964: FOR i in nvl(l_hold_tab.FIRST, 0) .. nvl(l_hold_tab.LAST, 0) LOOP
965:
966: IF (l_hold_tab.exists(i)) THEN
967:
968: INSERT INTO ap_holds_all
969: (invoice_id
970: ,hold_lookup_code
971: ,last_update_date
972: ,last_updated_by

Line 1000: (p_table_name => 'AP_HOLDS',

996:
997: /* bug 5169128 */
998: --Bug 4539462 DBI logging
999: AP_DBI_PKG.Maintain_DBI_Summary
1000: (p_table_name => 'AP_HOLDS',
1001: p_operation => 'I',
1002: p_key_value_list => l_dbi_key_value_list3,
1003: p_calling_sequence => l_curr_calling_sequence);
1004: