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_PAYMENTS_ALL

Line 99: p_user_assgn_num IN IBY_PAYMENTS_ALL.

95: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.
96: payment_instruction_id%TYPE,
97: p_pmt_document_id IN CE_PAYMENT_DOCUMENTS.
98: payment_document_id%TYPE,
99: p_user_assgn_num IN IBY_PAYMENTS_ALL.
100: paper_document_number%TYPE,
101: x_return_status IN OUT NOCOPY VARCHAR2,
102: x_return_message IN OUT NOCOPY VARCHAR2,
103: x_msg_count IN OUT NOCOPY NUMBER,

Line 164: IBY_PAYMENTS_ALL pmt,

160: -1, /* document_count */
161: pmt.separate_remit_advice_req_flag,
162: pmt.paper_document_number
163: FROM
164: IBY_PAYMENTS_ALL pmt,
165: IBY_PAY_INSTRUCTIONS_ALL instr,
166: IBY_PAYMENT_PROFILES prof
167: WHERE
168: instr.payment_instruction_id = p_instr_id AND

Line 533: * from the IBY_PAYMENTS_ALL table.

529: END IF;
530:
531: /*
532: * Pick up all payments of the given payment instruction
533: * from the IBY_PAYMENTS_ALL table.
534: */
535: OPEN c_pmts_in_instruction(p_instruction_id);
536: FETCH c_pmts_in_instruction BULK COLLECT INTO l_pmtsInInstrTab;
537: CLOSE c_pmts_in_instruction;

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 967: INSERT INTO IBY_PAYMENTS_ALL VALUES l_setup_pmts_tab(i);

963:
964: END IF;
965: /* setup payments can be bulk inserted */
966: FORALL i in l_setup_pmts_tab.FIRST..l_setup_pmts_tab.LAST
967: INSERT INTO IBY_PAYMENTS_ALL VALUES l_setup_pmts_tab(i);
968:
969: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
970: print_debuginfo(l_module_name, 'Inserting '
971: || p_setupDocsTab.COUNT

Line 996: INSERT INTO IBY_PAYMENTS_ALL VALUES l_overflow_pmts_tab(i);

992:
993: END IF;
994: /* overflow payments can be bulk inserted */
995: FORALL i in l_overflow_pmts_tab.FIRST..l_overflow_pmts_tab.LAST
996: INSERT INTO IBY_PAYMENTS_ALL VALUES l_overflow_pmts_tab(i);
997:
998:
999: /*
1000: * Fix for bug 6765314:

Line 1023: iby_payments_all overflow

1019: END IF;
1020: FOR i in l_overflow_pmts_tab.FIRST..l_overflow_pmts_tab.LAST LOOP
1021:
1022: UPDATE
1023: iby_payments_all overflow
1024: SET
1025: (
1026: overflow.payment_method_code,
1027: overflow.internal_bank_account_id,

Line 1136: iby_payments_all real

1132: real.payee_supplier_id,
1133: real.payee_supplier_site_name,
1134: real.payee_supplier_site_alt_name
1135: FROM
1136: iby_payments_all real
1137: WHERE
1138: real.payment_id = overflow.external_bank_account_id
1139: )
1140: WHERE overflow.payment_id = l_overflow_pmts_tab(i).payment_id

Line 1373: p_user_assgn_num IN IBY_PAYMENTS_ALL.paper_document_number%TYPE,

1369: |
1370: *---------------------------------------------------------------------*/
1371: PROCEDURE processPaperPayments(
1372: p_pmt_document_id IN CE_PAYMENT_DOCUMENTS.payment_document_id%TYPE,
1373: p_user_assgn_num IN IBY_PAYMENTS_ALL.paper_document_number%TYPE,
1374: x_pmtInstrRec IN OUT NOCOPY IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE,
1375: x_pmtsInPmtInstrTab IN OUT NOCOPY IBY_PAYINSTR_PUB.pmtsInpmtInstrTabType,
1376: x_dummyPaperPmtsTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,
1377: x_setupDocsTab IN OUT NOCOPY docsTabType,

Line 1664: * IBY_PAYMENTS_ALL tables to account for setup

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 :=
1668: x_pmtsInPmtInstrTab(j).payment_id;

Line 1752: * of dummy payments (to insert into IBY_PAYMENTS_ALL table)

1748: * and 'num setup docs' has been populated for each
1749: * paper payment in the l_paper_special_docs_tab 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(

Line 2007: * IBY_PAYMENTS_ALL tables to account for setup

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 :=
2011: x_pmtsInPmtInstrTab(j).payment_id;

Line 2053: * of dummy payments (to insert into IBY_PAYMENTS_ALL table)

2049: * and 'num setup docs' has been populated for each
2050: * paper payment in the l_paper_special_docs_tab 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*/

Line 2209: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%TYPE,

2205: | NOTES:
2206: |
2207: *---------------------------------------------------------------------*/
2208: FUNCTION getDocumentCountForPayment(
2209: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%TYPE,
2210: p_pmtsInPmtInstrTab IN IBY_PAYINSTR_PUB.pmtsInpmtInstrTabType
2211: )
2212: RETURN NUMBER
2213: IS

Line 2258: p_user_assgn_num IN IBY_PAYMENTS_ALL.paper_document_number%TYPE,

2254: *---------------------------------------------------------------------*/
2255: PROCEDURE assignCheckNumbers(
2256: x_pmtInstrRec IN OUT NOCOPY IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE,
2257: p_payment_doc_id IN CE_PAYMENT_DOCUMENTS.payment_document_id%TYPE,
2258: p_user_assgn_num IN IBY_PAYMENTS_ALL.paper_document_number%TYPE,
2259: x_paperPmtsTab IN OUT NOCOPY paperPmtsSpecialDocsTabType,
2260: x_dummyPaperPmtsTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,
2261: x_instrErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
2262: x_insTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.

Line 3415: l_pmt_rec IBY_PAYMENTS_ALL%ROWTYPE;

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:
3419: l_pmtsInPmtInstrRec IBY_PAYINSTR_PUB.pmtsInPmtInstrRecType;

Line 3417: l_payment_id IBY_PAYMENTS_ALL.payment_id%TYPE;

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:
3419: l_pmtsInPmtInstrRec IBY_PAYINSTR_PUB.pmtsInPmtInstrRecType;
3420:
3421: --Bug 6486816

Line 3495: * Insert a dummy payment into IBY_PAYMENTS_ALL

3491:
3492: FOR j IN 1 .. x_paperSpecialTab(i).num_setup_docs LOOP
3493:
3494: /*
3495: * Insert a dummy payment into IBY_PAYMENTS_ALL
3496: * table for each setup document.
3497: */
3498:
3499: /*

Line 3794: * Insert a dummy payment into IBY_PAYMENTS_ALL

3790:
3791: FOR j IN 1 .. x_paperSpecialTab(i).num_overflow_docs LOOP
3792:
3793: /*
3794: * Insert a dummy payment into IBY_PAYMENTS_ALL
3795: * table for each set of overflow documents.
3796: */
3797:
3798: /*

Line 3898: * IBY_PAYMENTS_ALL.

3894: * related to which real payment.
3895: *
3896: * The l_pmt_rec structure cannot store the real payment
3897: * id because it is exactly mapped to a row in
3898: * IBY_PAYMENTS_ALL.
3899: *
3900: * Instead of creating a new data structure to hold
3901: * (real payment id, dummy payment id), we use an
3902: * optional field in the l_pmt_rec record to store the

Line 4195: || 'IBY_PAYMENTS_ALL table. Possible data '

4191: IF (p_pmtsInPayInstTab.COUNT = 0) THEN
4192: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4193: print_debuginfo(l_module_name, 'No payments '
4194: || 'were provided to update '
4195: || 'IBY_PAYMENTS_ALL table. Possible data '
4196: || 'corruption issue.');
4197: END IF;
4198: RETURN;
4199: END IF;

Line 4217: IBY_PAYMENTS_ALL

4213: || p_pmtsInPayInstTab(i).payment_id);
4214:
4215: END IF;
4216: UPDATE
4217: IBY_PAYMENTS_ALL
4218: SET
4219: paper_document_number = p_pmtsInPayInstTab(i).check_number
4220: WHERE
4221: payment_id = p_pmtsInPayInstTab(i).payment_id

Line 4442: IBY_PAYMENTS_ALL pmt

4438: INTO
4439: l_process_type
4440: FROM
4441: IBY_PAY_SERVICE_REQUESTS req,
4442: IBY_PAYMENTS_ALL pmt
4443: WHERE
4444: req.payment_service_request_id =
4445: pmt.payment_service_request_id AND
4446: pmt.payment_id = l_pmt_rec.payment_id

Line 4539: p_start_number IN IBY_PAYMENTS_ALL.paper_document_number%TYPE,

4535: |
4536: *---------------------------------------------------------------------*/
4537: FUNCTION isContigPaperNumAvlbl(
4538: p_payment_doc_id IN CE_PAYMENT_DOCUMENTS.payment_document_id%TYPE,
4539: p_start_number IN IBY_PAYMENTS_ALL.paper_document_number%TYPE,
4540: p_end_number IN IBY_PAYMENTS_ALL.paper_document_number%TYPE
4541: ) RETURN BOOLEAN
4542: IS
4543:

Line 4540: p_end_number IN IBY_PAYMENTS_ALL.paper_document_number%TYPE

4536: *---------------------------------------------------------------------*/
4537: FUNCTION isContigPaperNumAvlbl(
4538: p_payment_doc_id IN CE_PAYMENT_DOCUMENTS.payment_document_id%TYPE,
4539: p_start_number IN IBY_PAYMENTS_ALL.paper_document_number%TYPE,
4540: p_end_number IN IBY_PAYMENTS_ALL.paper_document_number%TYPE
4541: ) RETURN BOOLEAN
4542: IS
4543:
4544: l_module_name VARCHAR2(200) := G_PKG_NAME || '.isContigPaperNumAvlbl';

Line 4546: l_paper_doc_num IBY_PAYMENTS_ALL.paper_document_number%TYPE;

4542: IS
4543:
4544: l_module_name VARCHAR2(200) := G_PKG_NAME || '.isContigPaperNumAvlbl';
4545: l_retflag BOOLEAN;
4546: l_paper_doc_num IBY_PAYMENTS_ALL.paper_document_number%TYPE;
4547:
4548: l_api_version CONSTANT NUMBER := 1.0;
4549: l_return_status VARCHAR2 (100);
4550:

Line 4857: p_start_number IN IBY_PAYMENTS_ALL.paper_document_number%TYPE,

4853: |
4854: *---------------------------------------------------------------------*/
4855: FUNCTION isPaperNosUsedOnExistPmt(
4856: p_payment_doc_id IN CE_PAYMENT_DOCUMENTS.payment_document_id%TYPE,
4857: p_start_number IN IBY_PAYMENTS_ALL.paper_document_number%TYPE,
4858: p_end_number IN IBY_PAYMENTS_ALL.paper_document_number%TYPE
4859: ) RETURN BOOLEAN
4860: IS
4861:

Line 4858: p_end_number IN IBY_PAYMENTS_ALL.paper_document_number%TYPE

4854: *---------------------------------------------------------------------*/
4855: FUNCTION isPaperNosUsedOnExistPmt(
4856: p_payment_doc_id IN CE_PAYMENT_DOCUMENTS.payment_document_id%TYPE,
4857: p_start_number IN IBY_PAYMENTS_ALL.paper_document_number%TYPE,
4858: p_end_number IN IBY_PAYMENTS_ALL.paper_document_number%TYPE
4859: ) RETURN BOOLEAN
4860: IS
4861:
4862: l_module_name VARCHAR2(200) := G_PKG_NAME || '.isPaperNosUsedOnExistPmt';

Line 4865: l_paper_doc_num IBY_PAYMENTS_ALL.paper_document_number%TYPE;

4861:
4862: l_module_name VARCHAR2(200) := G_PKG_NAME || '.isPaperNosUsedOnExistPmt';
4863: l_retflag BOOLEAN;
4864:
4865: l_paper_doc_num IBY_PAYMENTS_ALL.paper_document_number%TYPE;
4866: l_test_paper_doc_num IBY_PAYMENTS_ALL.paper_document_number%TYPE;
4867: l_test_pmt_id IBY_PAYMENTS_ALL.payment_id%TYPE;
4868:
4869: BEGIN

Line 4866: l_test_paper_doc_num IBY_PAYMENTS_ALL.paper_document_number%TYPE;

4862: l_module_name VARCHAR2(200) := G_PKG_NAME || '.isPaperNosUsedOnExistPmt';
4863: l_retflag BOOLEAN;
4864:
4865: l_paper_doc_num IBY_PAYMENTS_ALL.paper_document_number%TYPE;
4866: l_test_paper_doc_num IBY_PAYMENTS_ALL.paper_document_number%TYPE;
4867: l_test_pmt_id IBY_PAYMENTS_ALL.payment_id%TYPE;
4868:
4869: BEGIN
4870:

Line 4867: l_test_pmt_id IBY_PAYMENTS_ALL.payment_id%TYPE;

4863: l_retflag BOOLEAN;
4864:
4865: l_paper_doc_num IBY_PAYMENTS_ALL.paper_document_number%TYPE;
4866: l_test_paper_doc_num IBY_PAYMENTS_ALL.paper_document_number%TYPE;
4867: l_test_pmt_id IBY_PAYMENTS_ALL.payment_id%TYPE;
4868:
4869: BEGIN
4870:
4871: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 4922: IBY_PAYMENTS_ALL pmt,

4918: INTO
4919: l_test_paper_doc_num,
4920: l_test_pmt_id
4921: FROM
4922: IBY_PAYMENTS_ALL pmt,
4923: IBY_PAY_INSTRUCTIONS_ALL inst
4924: WHERE
4925: pmt.payment_instruction_id = inst.payment_instruction_id AND
4926: inst.payment_document_id = p_payment_doc_id AND

Line 5051: p_user_assgn_num IN IBY_PAYMENTS_ALL.paper_document_number%TYPE,

5047: *---------------------------------------------------------------------*/
5048: PROCEDURE assignElectronicCheckNumbers(
5049: x_pmtInstrRec IN OUT NOCOPY IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE,
5050: p_payment_doc_id IN CE_PAYMENT_DOCUMENTS.payment_document_id%TYPE,
5051: p_user_assgn_num IN IBY_PAYMENTS_ALL.paper_document_number%TYPE,
5052: x_paperPmtsTab IN OUT NOCOPY paperPmtsSpecialDocsTabType,
5053: x_dummyPaperPmtsTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,
5054: x_instrErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
5055: x_insTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.