DBA Data[Home] [Help]

APPS.AP_VOID_PKG dependencies on AP_HOLDS_ALL

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 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