APPS.IGI_EXP_HOLDS dependencies on AP_HOLDS_ALL

Line 125: FROM ap_holds_all ah2

121: AP_HOLDS_S.NEXTVAL,
122: mo_global.get_current_org_id()
123: FROM SYS.DUAL
124: WHERE NOT EXISTS(SELECT 'x'
125: FROM ap_holds_all ah2
126: WHERE ah2.invoice_id = p_invoice_id
127: AND ah2.hold_lookup_code = 'AWAIT EXP APP'
128: AND (NVL(ah2.release_lookup_code, 'NULL') <> 'HOLDS QUICK RELEASED'
129: AND NVL(ah2.release_lookup_code, 'NULL') <> 'EXP HOLD RELEASE'));

Line 181: UPDATE ap_holds_all

177: -- =============== END DEBUG LOG ==================
178:
179: -- Bug No: 2517124 sowsubra changed the statement to select the
180: -- displayed_field column instead of the description column.
181: UPDATE ap_holds_all
182: SET release_lookup_code = l_release_lookup_code,
183: release_reason = (SELECT displayed_field
184: FROM ap_lookup_codes
185: WHERE lookup_code = l_release_lookup_code

Line 195: ' UPDATE ap_holds_all --> ' || SQL%ROWCOUNT);

191: AND hold_lookup_code = p_hold_lookup_code;
192:
193: -- =============== START DEBUG LOG ================
194: Debug_log_string (l_proc_level, 'Release_hold.Msg3',
195: ' UPDATE ap_holds_all --> ' || SQL%ROWCOUNT);
196: Debug_log_string (l_proc_level, 'Set_hold.Msg4',
197: ' ** END RELEASE_HOLD ** ');
198: -- =============== END DEBUG LOG ==================
199:

Line 227: FROM ap_holds_all

223: CURSOR c_hold_status IS
224: SELECT DECODE(release_lookup_code,
225: NULL, 'ALREADY ON HOLD',
226: 'RELEASED BY USER')
227: FROM ap_holds_all
228: WHERE invoice_id = p_invoice_id
229: AND hold_lookup_code = p_hold_lookup_code
230: AND release_lookup_code IS NULL;
231: BEGIN

Line 337: FROM ap_holds_all

333:
334: -- Get the number of unreleased holds for the invoice
335: SELECT COUNT(*)
336: INTO l_invoice_holds
337: FROM ap_holds_all
338: WHERE invoice_id = p_invoice_id
339: AND release_lookup_code IS NULL;
340:
341: -- =============== START DEBUG LOG ================

Line 569: FROM ap_holds_all ah

565:
566: CURSOR c_exp_hold_released(p_invoice_id NUMBER)
567: IS
568: SELECT 'x'
569: FROM ap_holds_all ah
570: WHERE ah.invoice_id = p_invoice_id
571: AND ah.hold_lookup_code = 'AWAIT EXP APP'
572: AND ah.release_lookup_code = 'EXP HOLD RELEASE'
573: AND NOT EXISTS(SELECT 'x'

Line 574: FROM ap_holds_all ah2

570: WHERE ah.invoice_id = p_invoice_id
571: AND ah.hold_lookup_code = 'AWAIT EXP APP'
572: AND ah.release_lookup_code = 'EXP HOLD RELEASE'
573: AND NOT EXISTS(SELECT 'x'
574: FROM ap_holds_all ah2
575: WHERE ah2.invoice_id = p_invoice_id
576: AND ah.hold_lookup_code = 'AWAIT EXP APP'
577: AND ah2.release_lookup_code IS NULL);
578:

Line 899: From AP_HOLDS_ALL

895:
896: CURSOR cur_get_SIA_Hold(p_inv_id ap_invoices_all.invoice_id%type)
897: IS
898: Select hold_lookup_code
899: From AP_HOLDS_ALL
900: Where invoice_id = p_inv_id
901: And hold_lookup_code = 'AWAIT_SEC_APP'
902: And release_lookup_code is not null;
903:

Line 1214: This was to delete the EXP hold from AP_HOLDS_ALL, so allow the invoice to

1210: END IF; -- 'P' to place hold
1211:
1212: /***********************************
1213: The following code snippet below was originally put in to fix bug 3595853.
1214: This was to delete the EXP hold from AP_HOLDS_ALL, so allow the invoice to
1215: be cancelled (by AP - in package AP_CANCEL_PKG Function: ap_cancel_single_invoice).
1216: However now that all EXP HOLDS are RELEASED, rather than deleted
1217: (requirement by AX - bug 3801520).
1218: This fix is no longer required as the above code snippet suffices; invoice amount