APPS.IBY_CHECKNUMBER_PUB dependencies on IBY_USED_PAYMENT_DOCS

Line 2351: * unused if it is not present in IBY_USED_PAYMENT_DOCS

2347: END IF;
2348:
2349: /*
2350: * A paper document number (check number) is considered
2351: * unused if it is not present in IBY_USED_PAYMENT_DOCS
2352: * table.
2353: *
2354: * This logic will work when check numbering is invoked
2355: * from the Build Program. In this case, the numbering

Line 2365: * not yet have been inserted into the IBY_USED_PAYMENT_DOCS

2361: * payments, the user is allowed to provide the start
2362: * number for check numbering. It is possible that
2363: * a payment has already been numbered with the user
2364: * provided start number, but this paper document may
2365: * not yet have been inserted into the IBY_USED_PAYMENT_DOCS
2366: * table (because the user has not yet confirmed the
2367: * payment).
2368: *
2369: * Therefore, for single payments, when the user provides

Line 3573: p_payment_doc_id IN IBY_USED_PAYMENT_DOCS.payment_document_id%TYPE,

3569: | NOTES:
3570: |
3571: *---------------------------------------------------------------------*/
3572: PROCEDURE isPaperDocNumUsed(
3573: p_payment_doc_id IN IBY_USED_PAYMENT_DOCS.payment_document_id%TYPE,
3574: x_paper_doc_num IN IBY_USED_PAYMENT_DOCS.used_document_number%TYPE,
3575: x_return_status IN OUT NOCOPY VARCHAR2
3576: )
3577: IS

Line 3574: x_paper_doc_num IN IBY_USED_PAYMENT_DOCS.used_document_number%TYPE,

3570: |
3571: *---------------------------------------------------------------------*/
3572: PROCEDURE isPaperDocNumUsed(
3573: p_payment_doc_id IN IBY_USED_PAYMENT_DOCS.payment_document_id%TYPE,
3574: x_paper_doc_num IN IBY_USED_PAYMENT_DOCS.used_document_number%TYPE,
3575: x_return_status IN OUT NOCOPY VARCHAR2
3576: )
3577: IS
3578:

Line 3597: IBY_USED_PAYMENT_DOCS

3593: used_document_number
3594: INTO
3595: l_used_paper_doc_number
3596: FROM
3597: IBY_USED_PAYMENT_DOCS
3598: WHERE
3599: payment_document_id = p_payment_doc_id AND
3600: used_document_number = x_paper_doc_num
3601: ;

Line 3619: || ' from IBY_USED_PAYMENT_DOCS table.'

3615:
3616: print_debuginfo(l_module_name, 'Exception occured when '
3617: || 'attempting to get details of paper document '
3618: || x_paper_doc_num
3619: || ' from IBY_USED_PAYMENT_DOCS table.'
3620: );
3621:
3622: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE);
3623: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM);