eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_CHECKNUMBER_PUB dependencies on IBY_DOCS_PAYABLE_ALL

Line 571: * a query on iby_docs_payable_all - AtT Build pmts perf issue

567:
568: /* populate the document count associated with each payment */
569: /* removed the call to populateDocumentCount, alternatively in
570: * processPaperPayments() API, the count of document is got through
571: * a query on iby_docs_payable_all - AtT Build pmts perf issue
572: */
573: -- populateDocumentCount(l_pmtsInInstrTab);
574:
575: /*

Line 775: IBY_DOCS_PAYABLE_ALL DOCS, IBY_PAYMENTS_ALL PMTS

771: SELECT
772: count(*),
773: DOCS.payment_id
774: FROM
775: IBY_DOCS_PAYABLE_ALL DOCS, IBY_PAYMENTS_ALL PMTS
776: WHERE
777: PMTS.PAYMENT_INSTRUCTION_ID = pmt_instruction_id
778: AND PMTS.PAYMENT_ID = DOCS.PAYMENT_ID
779: AND DOCS.document_status = DOC_STATUS_PAY_CREATED

Line 978: INSERT INTO IBY_DOCS_PAYABLE_ALL VALUES p_setupDocsTab(i);

974:
975: END IF;
976: /* documents related to setup payments can be bulk inserted */
977: FORALL i in p_setupDocsTab.FIRST..p_setupDocsTab.LAST
978: INSERT INTO IBY_DOCS_PAYABLE_ALL VALUES p_setupDocsTab(i);
979:
980: END IF;
981:
982: /*

Line 1153: * available in the IBY_DOCS_PAYABLE_ALL table. The

1149:
1150: END IF;
1151: /*
1152: * For overflow payments, the documents are already
1153: * available in the IBY_DOCS_PAYABLE_ALL table. The
1154: * formatting payment id on these documents needs
1155: * to be updated to account for the overflow payments
1156: * (1 overflow payment = 1 printed void check).
1157: */

Line 1161: IBY_DOCS_PAYABLE_ALL

1157: */
1158: FOR i in p_overflowDocsTab.FIRST..p_overflowDocsTab.LAST LOOP
1159:
1160: UPDATE
1161: IBY_DOCS_PAYABLE_ALL
1162: SET
1163: formatting_payment_id =
1164: p_overflowDocsTab(i).format_payment_id
1165: WHERE

Line 1580: * IBY_DOCS_PAYABLE_ALL table to get the count of the

1576: || ' ..'
1577: );
1578: END IF;
1579: /* Removing the call to getDocumentCount, rather accessing
1580: * IBY_DOCS_PAYABLE_ALL table to get the count of the
1581: * documents
1582: */
1583: /* l_docs_count := getDocumentCountForPayment(
1584: x_pmtsInPmtInstrTab(j).payment_id,

Line 1594: IBY_DOCS_PAYABLE_ALL

1590: COUNT(*)
1591: INTO
1592: x_pmtsInPmtInstrTab(j).document_count
1593: FROM
1594: IBY_DOCS_PAYABLE_ALL
1595: WHERE
1596: payment_id = x_pmtsInPmtInstrTab(j).payment_id
1597: AND
1598: document_status = DOC_STATUS_PAY_CREATED;

Line 1663: * into the IBY_DOCS_PAYABLE_ALL and

1659: * Add the details about the setup docs and
1660: * overflow docs for this payment into the
1661: * special docs table. This special docs table
1662: * will be used for inserting dummy payments
1663: * into the IBY_DOCS_PAYABLE_ALL and
1664: * IBY_PAYMENTS_ALL tables to account for setup
1665: * and overflow checks.
1666: */
1667: l_paper_special_docs_rec.payment_id :=

Line 1754: * IBY_DOCS_PAYABLE_ALL table).

1750: *
1751: * Use this information to create appropriate number
1752: * of dummy payments (to insert into IBY_PAYMENTS_ALL table)
1753: * and corresponding documents (to insert into
1754: * IBY_DOCS_PAYABLE_ALL table).
1755: */
1756: performSpecialPaperDocHandling(
1757: l_paper_special_docs_tab,
1758: x_dummyPaperPmtsTab,

Line 1925: * IBY_DOCS_PAYABLE_ALL table to get the count of the

1921: || ' ..'
1922: );
1923: END IF;
1924: /* Removing the call to getDocumentCount, rather accessing
1925: * IBY_DOCS_PAYABLE_ALL table to get the count of the
1926: * documents
1927: */
1928: /* l_docs_count := getDocumentCountForPayment(
1929: x_pmtsInPmtInstrTab(j).payment_id,

Line 1939: IBY_DOCS_PAYABLE_ALL

1935: COUNT(*)
1936: INTO
1937: x_pmtsInPmtInstrTab(j).document_count
1938: FROM
1939: IBY_DOCS_PAYABLE_ALL
1940: WHERE
1941: payment_id = x_pmtsInPmtInstrTab(j).payment_id
1942: AND
1943: document_status = DOC_STATUS_PAY_CREATED;

Line 2006: * into the IBY_DOCS_PAYABLE_ALL and

2002: * Add the details about the setup docs and
2003: * overflow docs for this payment into the
2004: * special docs table. This special docs table
2005: * will be used for inserting dummy payments
2006: * into the IBY_DOCS_PAYABLE_ALL and
2007: * IBY_PAYMENTS_ALL tables to account for setup
2008: * and overflow checks.
2009: */
2010: l_paper_special_docs_rec.payment_id :=

Line 2055: * IBY_DOCS_PAYABLE_ALL table).

2051: *
2052: * Use this information to create appropriate number
2053: * of dummy payments (to insert into IBY_PAYMENTS_ALL table)
2054: * and corresponding documents (to insert into
2055: * IBY_DOCS_PAYABLE_ALL table).
2056: */
2057: /*Special Paper Doc Handling is not required for Electronic type of payments*/
2058: /*performSpecialPaperDocHandling(
2059: l_paper_special_docs_tab,

Line 3414: l_doc_rec iby_docs_payable_all%ROWTYPE;

3410: x_setupDocsTab IN OUT NOCOPY docsTabType,
3411: x_overflowDocsTab IN OUT NOCOPY overflowDocsTabType
3412: )
3413: IS
3414: l_doc_rec iby_docs_payable_all%ROWTYPE;
3415: l_pmt_rec IBY_PAYMENTS_ALL%ROWTYPE;
3416:
3417: l_payment_id IBY_PAYMENTS_ALL.payment_id%TYPE;
3418:

Line 3436: CURSOR c_document_data(p_payment_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE)

3432: l_begin_doc_index NUMBER := 0;
3433: l_end_doc_index NUMBER := 0;
3434:
3435: /* payments cursor */
3436: CURSOR c_document_data(p_payment_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE)
3437: IS
3438: SELECT
3439: document_payable_id,
3440: payment_id,

Line 3447: IBY_DOCS_PAYABLE_ALL

3443: formatting_payment_id,
3444: org_id,
3445: org_type
3446: FROM
3447: IBY_DOCS_PAYABLE_ALL
3448: WHERE
3449: payment_id = p_payment_id
3450: ORDER BY
3451: document_payable_id ASC