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 CE_PAYMENT_DOCUMENTS

Line 89: p_pmt_document_id IN CE_PAYMENT_DOCUMENTS.

85: *---------------------------------------------------------------------*/
86: PROCEDURE performCheckNumbering(
87: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.
88: payment_instruction_id%TYPE,
89: p_pmt_document_id IN CE_PAYMENT_DOCUMENTS.
90: payment_document_id%TYPE,
91: p_user_assgn_num IN IBY_PAYMENTS_ALL.
92: paper_document_number%TYPE,
93: x_return_status IN OUT NOCOPY VARCHAR2,

Line 449: CE_PAYMENT_DOCUMENTS ce

445: ce.payment_instruction_id
446: INTO
447: l_instruction_id
448: FROM
449: CE_PAYMENT_DOCUMENTS ce
450: WHERE
451: ce.payment_document_id = p_pmt_document_id
452: ;
453:

Line 485: || ' from CE_PAYMENT_DOCUMENTS table.',

481:
482: print_debuginfo(l_module_name, 'Exception occured when '
483: || 'getting details of payment document id '
484: || p_pmt_document_id
485: || ' from CE_PAYMENT_DOCUMENTS table.',
486: FND_LOG.LEVEL_UNEXPECTED
487: );
488:
489: print_debuginfo(l_module_name, 'SQL code: '

Line 1277: p_pmt_document_id IN CE_PAYMENT_DOCUMENTS.payment_document_id%TYPE,

1273: | NOTES:
1274: |
1275: *---------------------------------------------------------------------*/
1276: PROCEDURE processPaperPayments(
1277: p_pmt_document_id IN CE_PAYMENT_DOCUMENTS.payment_document_id%TYPE,
1278: p_user_assgn_num IN IBY_PAYMENTS_ALL.paper_document_number%TYPE,
1279: x_pmtInstrRec IN OUT NOCOPY IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE,
1280: x_pmtsInPmtInstrTab IN OUT NOCOPY IBY_PAYINSTR_PUB.pmtsInpmtInstrTabType,
1281: x_dummyPaperPmtsTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,

Line 1309: CURSOR c_paper_stock (p_pmt_doc_id IN CE_PAYMENT_DOCUMENTS.

1305: l_paper_special_docs_tab paperPmtsSpecialDocsTabType;
1306:
1307: l_pmtsInPmtInstrRec IBY_PAYINSTR_PUB.pmtsInpmtInstrRecType;
1308:
1309: CURSOR c_paper_stock (p_pmt_doc_id IN CE_PAYMENT_DOCUMENTS.
1310: payment_document_id%TYPE)
1311: IS
1312: SELECT
1313: payment_document_id,

Line 1318: CE_PAYMENT_DOCUMENTS

1314: payment_document_name,
1315: NVL(number_of_setup_documents, 0),
1316: number_of_lines_per_remit_stub
1317: FROM
1318: CE_PAYMENT_DOCUMENTS
1319: WHERE
1320: payment_document_id = p_pmt_doc_id
1321: ;
1322:

Line 1338: || 'document from CE_PAYMENT_DOCUMENTS for payment '

1334: */
1335: IF (l_paper_stocks_tab.COUNT <> 1) THEN
1336:
1337: print_debuginfo(l_module_name, 'Unable to get matching payment '
1338: || 'document from CE_PAYMENT_DOCUMENTS for payment '
1339: || 'document id: '
1340: || p_pmt_document_id
1341: || '. Number of payment documents retrieved: '
1342: || l_paper_stocks_tab.COUNT

Line 1770: p_payment_doc_id IN CE_PAYMENT_DOCUMENTS.payment_document_id%TYPE,

1766: |
1767: *---------------------------------------------------------------------*/
1768: PROCEDURE assignCheckNumbers(
1769: x_pmtInstrRec IN OUT NOCOPY IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE,
1770: p_payment_doc_id IN CE_PAYMENT_DOCUMENTS.payment_document_id%TYPE,
1771: p_user_assgn_num IN IBY_PAYMENTS_ALL.paper_document_number%TYPE,
1772: x_paperPmtsTab IN OUT NOCOPY paperPmtsSpecialDocsTabType,
1773: x_dummyPaperPmtsTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,
1774: x_instrErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

Line 2033: CE_PAYMENT_DOCUMENTS

2029: l_last_avail_check_num,
2030: l_pmt_doc_name,
2031: l_pmt_instr_id
2032: FROM
2033: CE_PAYMENT_DOCUMENTS
2034: WHERE
2035: payment_document_id = p_payment_doc_id
2036: FOR UPDATE
2037: ;

Line 2289: * stock number in CE_PAYMENT_DOCUMENTS.

2285: /*
2286: * If sufficient paper stock is available, we will be using
2287: * up the paper stock by assigning it to the available
2288: * paper payments. Therefore, update the last used paper
2289: * stock number in CE_PAYMENT_DOCUMENTS.
2290: *
2291: * That way if another instance of the payment instruction
2292: * creation program is operating concurrently, it will
2293: * be blocked by the SELECT .. FOR UPDATE statement in

Line 2434: CE_PAYMENT_DOCUMENTS

2430: * Update the check stock to reflect the latest used
2431: * check number.
2432: */
2433: UPDATE
2434: CE_PAYMENT_DOCUMENTS
2435: SET
2436: last_issued_document_number = l_anticipated_last_check_num
2437: WHERE
2438: payment_document_id = p_payment_doc_id

Line 2452: CE_PAYMENT_DOCUMENTS

2448: * Update the check stock to reflect the latest used
2449: * check number, and lock the check stock.
2450: */
2451: UPDATE
2452: CE_PAYMENT_DOCUMENTS
2453: SET
2454: last_issued_document_number = l_anticipated_last_check_num,
2455: payment_instruction_id = x_pmtInstrRec.payment_instruction_id
2456: WHERE

Line 2463: || 'available check number in CE_PAYMENT_DOCUMENTS. '

2459:
2460: END IF;
2461:
2462: print_debuginfo(l_module_name, 'Finished updating the last '
2463: || 'available check number in CE_PAYMENT_DOCUMENTS. '
2464: || 'Current last check number: '
2465: || l_anticipated_last_check_num
2466: );
2467:

Line 3826: p_payment_doc_id IN CE_PAYMENT_DOCUMENTS.payment_document_id%TYPE,

3822: | NOTES:
3823: |
3824: *---------------------------------------------------------------------*/
3825: FUNCTION isContigPaperNumAvlbl(
3826: p_payment_doc_id IN CE_PAYMENT_DOCUMENTS.payment_document_id%TYPE,
3827: p_start_number IN IBY_PAYMENTS_ALL.paper_document_number%TYPE,
3828: p_end_number IN IBY_PAYMENTS_ALL.paper_document_number%TYPE
3829: ) RETURN BOOLEAN
3830: IS

Line 3965: p_payment_doc_id IN CE_PAYMENT_DOCUMENTS.payment_document_id%TYPE,

3961: | NOTES:
3962: |
3963: *---------------------------------------------------------------------*/
3964: FUNCTION isPaperNosUsedOnExistPmt(
3965: p_payment_doc_id IN CE_PAYMENT_DOCUMENTS.payment_document_id%TYPE,
3966: p_start_number IN IBY_PAYMENTS_ALL.paper_document_number%TYPE,
3967: p_end_number IN IBY_PAYMENTS_ALL.paper_document_number%TYPE
3968: ) RETURN BOOLEAN
3969: IS