APPS.AP_INVOICES_POST_PROCESS_PKG dependencies on AP_HOLDS

Line 83: ap_holds_pkg.insert_single_hold(

79: --
80: if (X_event = 'INSERT' or
81: (X_update_base = 'Y' or
82: X_vendor_changed_flag = 'Y')) then
83: ap_holds_pkg.insert_single_hold(
84: X_invoice_id,
85: 'AMOUNT',
86: 'INVOICE HOLD REASON',
87: '',

Line 93: ap_holds_pkg.release_single_hold(

89: current_calling_sequence);
90: end if;
91: else
92: -- Release the invoice amount hold if one exists
93: ap_holds_pkg.release_single_hold(
94: X_invoice_id,
95: 'AMOUNT',
96: 'AMOUNT LOWERED',
97: 5,

Line 112: ap_holds_pkg.insert_single_hold(

108: --
109: if (X_event = 'INSERT' or
110: X_vendor_changed_flag = 'Y') then
111:
112: ap_holds_pkg.insert_single_hold(
113: X_invoice_id,
114: 'VENDOR',
115: 'INVOICE HOLD REASON',
116: '',

Line 124: ap_holds_pkg.release_single_hold(

120: end if;
121:
122: else
123: -- Release the vendor hold if one exists
124: ap_holds_pkg.release_single_hold(
125: X_invoice_id,
126: 'VENDOR',
127: 'VENDOR UPDATED',
128: 5,

Line 154: -- Inserts child records into AP_HOLDS, AP_PAYMENT_SCHEDULES,

150:
151:
152: -----------------------------------------------------------------------
153: -- Procedure insert_children
154: -- Inserts child records into AP_HOLDS, AP_PAYMENT_SCHEDULES,
155: -- and AP_INVOICE_DISTRIBUTIONS
156: -- PRECONDITION: Called from PRE-UPDATE, POST-INSERT of INV_SUM_FOLDER
157: -----------------------------------------------------------------------
158: procedure insert_children (

Line 281: ap_holds_pkg.insert_single_hold(

277:
278: -- Insert the batch-level hold if one exists
279: if (l_batch_hold_lookup_code is not null) then
280:
281: ap_holds_pkg.insert_single_hold(
282: X_invoice_id,
283: l_batch_hold_lookup_code,
284: '',
285: l_batch_hold_reason,

Line 297: from ap_holds

293: debug_info := 'Select counts and sum of amounts from lines and holds';
294:
295: select count(*)
296: into X_Hold_count
297: from ap_holds
298: where invoice_id = X_invoice_id
299: and release_lookup_code is null;
300:
301: --bug 5334577

Line 617: debug_info := 'Select count from AP_HOLDS';

613: close invoice_cursor;
614:
615: -- Get the new Distribution and hold counts
616:
617: debug_info := 'Select count from AP_HOLDS';
618:
619: select count(*)
620: into X_Hold_count
621: from ap_holds

Line 621: from ap_holds

617: debug_info := 'Select count from AP_HOLDS';
618:
619: select count(*)
620: into X_Hold_count
621: from ap_holds
622: where invoice_id = X_invoice_id
623: and release_lookup_code is null;
624:
625: debug_info := 'Recalculate Payment Schedules: '||X_recalc_pay_sched;