[Home] [Help]
445:
446: -- Cursor c1 is to fetch hold lookup code
447: -- for the invoice being passed if any of the PWP or DLV hold exists.
448: Cursor c1(p_invoice_id Number) Is
449: select hold_lookup_code from ap_holds_all
450: where invoice_id= p_invoice_id
451: and hold_lookup_code in ('Pay When Paid','PO Deliverable','Project Hold') --bug 9525493
452: and release_reason IS NULL
453: and hold_lookup_code not in (select decode(FND_PROFILE.value('PA_PAY_WHEN_PAID'),'N','Pay When Paid','Y','#######','Pay When Paid') from dual);
452: and release_reason IS NULL
453: and hold_lookup_code not in (select decode(FND_PROFILE.value('PA_PAY_WHEN_PAID'),'N','Pay When Paid','Y','#######','Pay When Paid') from dual);
454:
455: Cursor c12(p_invoice_id Number, p_hold_type VARCHAR2) Is
456: select hold_lookup_code from ap_holds_all
457: where invoice_id= p_invoice_id
458: and hold_lookup_code in ('Pay When Paid','PO Deliverable','Project Hold') --bug 9525493
459: and release_reason IS NULL
460: and hold_lookup_code = decode(p_hold_type,
467: l_err_msg Varchar2(4000);
468:
469: -- To get the hold reason if any for an Invoice.
470: Cursor C3(P_Invoice_Id Number) Is
471: Select hold_lookup_code, hold_reason, 'PWP/DLV' HoldType From ap_holds_all
472: Where invoice_id= P_Invoice_Id
473: And hold_lookup_code In ('Pay When Paid','PO Deliverable')
474: and RELEASE_REASON is null
475: UNION ALL
472: Where invoice_id= P_Invoice_Id
473: And hold_lookup_code In ('Pay When Paid','PO Deliverable')
474: and RELEASE_REASON is null
475: UNION ALL
476: Select hold_lookup_code, hold_reason, 'OTH' HoldType From ap_holds_all
477: Where invoice_id= P_Invoice_Id
478: And hold_lookup_code Not In ('Pay When Paid','PO Deliverable')
479: and RELEASE_REASON is null;
480:
828:
829: /* Included the hold reasons other than the PWP and DLV */
830: -- To get the hold reason if any for an Invoice.
831: Cursor C3(P_Invoice_Id Number) Is
832: Select hold_lookup_code, hold_reason, 'PWP/DLV' HoldType From ap_holds_all
833: Where invoice_id= P_Invoice_Id
834: And hold_lookup_code In ('Pay When Paid','PO Deliverable')
835: and RELEASE_REASON is null
836: UNION ALL
833: Where invoice_id= P_Invoice_Id
834: And hold_lookup_code In ('Pay When Paid','PO Deliverable')
835: and RELEASE_REASON is null
836: UNION ALL
837: Select hold_lookup_code, hold_reason, 'OTH' HoldType From ap_holds_all
838: Where invoice_id= P_Invoice_Id
839: And hold_lookup_code Not In ('Pay When Paid','PO Deliverable')
840: and RELEASE_REASON is null;
841:
1769: ,X_msg_count OUT NOCOPY NUMBER
1770: ,X_msg_data OUT NOCOPY VARCHAR2) IS
1771: -- To get the hold reason if any for an Invoice.
1772: Cursor C3(P_Invoice_Id Number) Is
1773: Select hold_lookup_code, hold_reason, 'PWP/DLV' HoldType From ap_holds_all
1774: Where invoice_id= P_Invoice_Id
1775: And hold_lookup_code In ('Pay When Paid','PO Deliverable')
1776: and RELEASE_REASON is null
1777: UNION ALL
1774: Where invoice_id= P_Invoice_Id
1775: And hold_lookup_code In ('Pay When Paid','PO Deliverable')
1776: and RELEASE_REASON is null
1777: UNION ALL
1778: Select hold_lookup_code, hold_reason, 'OTH' HoldType From ap_holds_all
1779: Where invoice_id= P_Invoice_Id
1780: And hold_lookup_code Not In ('Pay When Paid','PO Deliverable')
1781: and RELEASE_REASON is null;
1782: