[Home] [Help]
719: SELECT
720: count(*),
721: payment_id
722: FROM
723: IBY_DOCS_PAYABLE_ALL
724: WHERE
725: document_status = DOC_STATUS_PAY_CREATED
726: GROUP BY
727: payment_id
901: );
902:
903: /* documents related to setup payments can be bulk inserted */
904: FORALL i in p_setupDocsTab.FIRST..p_setupDocsTab.LAST
905: INSERT INTO IBY_DOCS_PAYABLE_ALL VALUES p_setupDocsTab(i);
906:
907: END IF;
908:
909: /*
1070: );
1071:
1072: /*
1073: * For overflow payments, the documents are already
1074: * available in the IBY_DOCS_PAYABLE_ALL table. The
1075: * formatting payment id on these documents needs
1076: * to be updated to account for the overflow payments
1077: * (1 overflow payment = 1 printed void check).
1078: */
1078: */
1079: FOR i in p_overflowDocsTab.FIRST..p_overflowDocsTab.LAST LOOP
1080:
1081: UPDATE
1082: IBY_DOCS_PAYABLE_ALL
1083: SET
1084: formatting_payment_id =
1085: p_overflowDocsTab(i).format_payment_id
1086: WHERE
1525: * Add the details about the setup docs and
1526: * overflow docs for this payment into the
1527: * special docs table. This special docs table
1528: * will be used for inserting dummy payments
1529: * into the IBY_DOCS_PAYABLE_ALL and
1530: * IBY_PAYMENTS_ALL tables to account for setup
1531: * and overflow checks.
1532: */
1533: l_paper_special_docs_rec.payment_id :=
1574: *
1575: * Use this information to create appropriate number
1576: * of dummy payments (to insert into IBY_PAYMENTS_ALL table)
1577: * and corresponding documents (to insert into
1578: * IBY_DOCS_PAYABLE_ALL table).
1579: */
1580: performSpecialPaperDocHandling(
1581: l_paper_special_docs_tab,
1582: x_dummyPaperPmtsTab,
2765: x_setupDocsTab IN OUT NOCOPY docsTabType,
2766: x_overflowDocsTab IN OUT NOCOPY overflowDocsTabType
2767: )
2768: IS
2769: l_doc_rec iby_docs_payable_all%ROWTYPE;
2770: l_pmt_rec IBY_PAYMENTS_ALL%ROWTYPE;
2771:
2772: l_payment_id IBY_PAYMENTS_ALL.payment_id%TYPE;
2773:
2787: l_begin_doc_index NUMBER := 0;
2788: l_end_doc_index NUMBER := 0;
2789:
2790: /* payments cursor */
2791: CURSOR c_document_data(p_payment_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE)
2792: IS
2793: SELECT
2794: document_payable_id,
2795: payment_id,
2798: formatting_payment_id,
2799: org_id,
2800: org_type
2801: FROM
2802: IBY_DOCS_PAYABLE_ALL
2803: WHERE
2804: payment_id = p_payment_id
2805: ORDER BY
2806: document_payable_id ASC