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;
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:
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(
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