APPS.IBY_CHECKNUMBER_PUB dependencies on IBY_USED_PAYMENT_DOCS

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

2969: END IF;
2970:
2971: /*
2972: * A paper document number (check number) is considered
2973: * unused if it is not present in IBY_USED_PAYMENT_DOCS
2974: * table.
2975: *
2976: * This logic will work when check numbering is invoked
2977: * from the Build Program. In this case, the numbering

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

2983: * payments, the user is allowed to provide the start
2984: * number for check numbering. It is possible that
2985: * a payment has already been numbered with the user
2986: * provided start number, but this paper document may
2987: * not yet have been inserted into the IBY_USED_PAYMENT_DOCS
2988: * table (because the user has not yet confirmed the
2989: * payment).
2990: *
2991: * Therefore, for single payments, when the user provides

Line 4252: p_payment_doc_id IN IBY_USED_PAYMENT_DOCS.payment_document_id%TYPE,

4248: | NOTES:
4249: |
4250: *---------------------------------------------------------------------*/
4251: PROCEDURE isPaperDocNumUsed(
4252: p_payment_doc_id IN IBY_USED_PAYMENT_DOCS.payment_document_id%TYPE,
4253: x_paper_doc_num IN IBY_USED_PAYMENT_DOCS.used_document_number%TYPE,
4254: x_return_status IN OUT NOCOPY VARCHAR2
4255: )
4256: IS

Line 4253: x_paper_doc_num IN IBY_USED_PAYMENT_DOCS.used_document_number%TYPE,

4249: |
4250: *---------------------------------------------------------------------*/
4251: PROCEDURE isPaperDocNumUsed(
4252: p_payment_doc_id IN IBY_USED_PAYMENT_DOCS.payment_document_id%TYPE,
4253: x_paper_doc_num IN IBY_USED_PAYMENT_DOCS.used_document_number%TYPE,
4254: x_return_status IN OUT NOCOPY VARCHAR2
4255: )
4256: IS
4257:

Line 4278: IBY_USED_PAYMENT_DOCS

4274: used_document_number
4275: INTO
4276: l_used_paper_doc_number
4277: FROM
4278: IBY_USED_PAYMENT_DOCS
4279: WHERE
4280: payment_document_id = p_payment_doc_id AND
4281: used_document_number = x_paper_doc_num
4282: ;

Line 4303: || ' from IBY_USED_PAYMENT_DOCS table.'

4299: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4300: print_debuginfo(l_module_name, 'Exception occured when '
4301: || 'attempting to get details of paper document '
4302: || x_paper_doc_num
4303: || ' from IBY_USED_PAYMENT_DOCS table.'
4304: );
4305:
4306: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE);
4307: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM);

Line 4728: IBY_USED_PAYMENT_DOCS

4724: (
4725: SELECT
4726: used_document_number
4727: FROM
4728: IBY_USED_PAYMENT_DOCS
4729: WHERE
4730: payment_document_id = p_payment_doc_id AND
4731: document_use <> 'SKIPPED' AND
4732: used_document_number >= p_start_number AND

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

5632: END IF;
5633:
5634: /*
5635: * A paper document number (check number) is considered
5636: * unused if it is not present in IBY_USED_PAYMENT_DOCS
5637: * table.
5638: *
5639: * This logic will work when check numbering is invoked
5640: * from the Build Program. In this case, the numbering

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

5646: * payments, the user is allowed to provide the start
5647: * number for check numbering. It is possible that
5648: * a payment has already been numbered with the user
5649: * provided start number, but this paper document may
5650: * not yet have been inserted into the IBY_USED_PAYMENT_DOCS
5651: * table (because the user has not yet confirmed the
5652: * payment).
5653: *
5654: * Therefore, for single payments, when the user provides