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