[Home] [Help]
1536: SELECT 'Y'
1537: INTO l_unpostable_holds_exist
1538: FROM dual
1539: WHERE EXISTS (SELECT 1
1540: FROM ap_holds H, ap_hold_codes C
1541: WHERE H.invoice_id = l_invoice_id
1542: AND H.hold_lookup_code = C.hold_lookup_code
1543: AND ((H.release_lookup_code IS NULL)
1544: AND ((C.postable_flag = 'N') OR (C.postable_flag = 'X'))));
4513: WHERE AID1.invoice_id = AI.invoice_id
4514: AND AID1.awt_group_id IS NOT NULL)
4515: AND NOT EXISTS (SELECT 'Unreleased System holds exist'
4516: FROM ap_holds AH,
4517: ap_hold_codes AHC
4518: WHERE AH.invoice_id = AI.invoice_id
4519: AND AH.release_lookup_code IS NULL
4520: AND AH.hold_lookup_code <> 'AWT ERROR'
4521: AND AH.hold_lookup_code = AHC.hold_lookup_code
4587: FROM ap_invoices_all AI
4588: WHERE AI.invoice_id = p_invoice_id
4589: AND NOT EXISTS (SELECT 'Unreleased System holds exist'
4590: FROM ap_holds AH,
4591: ap_hold_codes AHC
4592: WHERE AH.invoice_id = AI.invoice_id
4593: AND AH.release_lookup_code IS NULL
4594: AND AH.hold_lookup_code <> 'AWT ERROR'
4595: AND AH.hold_lookup_code = AHC.hold_lookup_code
4783: WHERE match_status_flag = 'T'
4784: AND D.invoice_id = p_invoice_id
4785: AND ((NOT EXISTS
4786: (SELECT invoice_id
4787: FROM ap_holds H, ap_hold_codes C
4788: WHERE H.invoice_id = D.invoice_id
4789: AND H.hold_lookup_code = C.hold_lookup_code
4790: AND ((H.release_lookup_code IS NULL) AND
4791: ((C.postable_flag = 'N') OR
4803: WHERE match_status_flag = 'T'
4804: AND D.invoice_id = p_invoice_id
4805: AND ((NOT EXISTS
4806: (SELECT invoice_id
4807: FROM ap_holds H, ap_hold_codes C
4808: WHERE H.invoice_id = D.invoice_id
4809: AND H.hold_lookup_code = C.hold_lookup_code
4810: AND ((H.release_lookup_code IS NULL) AND
4811: ((C.postable_flag = 'N') OR
5328: SELECT user_releaseable_flag,
5329: initiate_workflow_flag
5330: INTO l_user_releaseable_flag,
5331: l_initiate_workflow_flag
5332: FROM ap_hold_codes
5333: WHERE hold_lookup_code = p_hold_lookup_code;
5334:
5335: --
5336: -- If the hold is a user releaseable hold then we will start the
7068: p_report_holds_count OUT NOCOPY NUMBER) RETURN BOOLEAN
7069:
7070: IS
7071:
7072: TYPE hold_codeTab IS TABLE OF ap_hold_codes.hold_lookup_code%Type;
7073: TYPE invoiceIDTab IS TABLE OF ap_invoices.invoice_id%Type INDEX BY BINARY_INTEGER;
7074: TYPE invoiceNUMTab IS TABLE OF ap_invoices.invoice_num%Type INDEX BY BINARY_INTEGER;
7075: TYPE procinvoiceIDTab IS TABLE OF ap_invoices.invoice_id%Type;
7076: TYPE hold_org_idTab IS TABLE OF ap_invoices.org_id%Type;