APPS.IBY_CHECKNUMBER_PUB dependencies on IBY_PAYMENTS_ALL

Line 14: payment_id IBY_PAYMENTS_ALL.payment_id%TYPE,

10: -- This data structure holds all payments that have processing
11: -- type set to 'PAPER' - i.e., payment payments.
12: --
13: TYPE paperPmtsSpecialDocsRecType IS RECORD (
14: payment_id IBY_PAYMENTS_ALL.payment_id%TYPE,
15: instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,
16: num_setup_docs NUMBER,
17: num_overflow_docs NUMBER,
18:

Line 72: payment_id IBY_PAYMENTS_ALL.

68: -- under a payment.
69: --
70: TYPE docsInPmtCountRecType IS RECORD (
71: doc_count NUMBER,
72: payment_id IBY_PAYMENTS_ALL.
73: payment_id%TYPE
74: );
75:
76: --

Line 142: p_user_assgn_num IN IBY_PAYMENTS_ALL.

138: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.
139: payment_instruction_id%TYPE,
140: p_pmt_document_id IN CE_PAYMENT_DOCUMENTS.
141: payment_document_id%TYPE,
142: p_user_assgn_num IN IBY_PAYMENTS_ALL.
143: paper_document_number%TYPE,
144: x_return_status IN OUT NOCOPY VARCHAR2,
145: x_return_message IN OUT NOCOPY VARCHAR2,
146: x_msg_count IN OUT NOCOPY NUMBER,

Line 257: p_user_assgn_num IN IBY_PAYMENTS_ALL.paper_document_number%TYPE,

253: |
254: *---------------------------------------------------------------------*/
255: PROCEDURE processPaperPayments(
256: p_pmt_document_id IN CE_PAYMENT_DOCUMENTS.payment_document_id%TYPE,
257: p_user_assgn_num IN IBY_PAYMENTS_ALL.paper_document_number%TYPE,
258: x_pmtInstrRec IN OUT NOCOPY IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE,
259: x_pmtsInPmtInstrTab IN OUT NOCOPY IBY_PAYINSTR_PUB.pmtsInpmtInstrTabType,
260: x_dummyPaperPmtsTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,
261: x_setupDocsTab IN OUT NOCOPY docsTabType,

Line 316: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%TYPE,

312: | NOTES:
313: |
314: *---------------------------------------------------------------------*/
315: FUNCTION getDocumentCountForPayment(
316: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%TYPE,
317: p_pmtsInPmtInstrTab IN IBY_PAYINSTR_PUB.pmtsInpmtInstrTabType
318: )
319: RETURN NUMBER;
320:

Line 471: p_user_assgn_num IN IBY_PAYMENTS_ALL.paper_document_number%TYPE,

467: *---------------------------------------------------------------------*/
468: PROCEDURE assignCheckNumbers(
469: x_pmtInstrRec IN OUT NOCOPY IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE,
470: p_payment_doc_id IN CE_PAYMENT_DOCUMENTS.payment_document_id%TYPE,
471: p_user_assgn_num IN IBY_PAYMENTS_ALL.paper_document_number%TYPE,
472: x_paperPmtsTab IN OUT NOCOPY paperPmtsSpecialDocsTabType,
473: x_dummyPaperPmtsTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,
474: x_instrErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
475: x_insTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.

Line 507: p_user_assgn_num IN IBY_PAYMENTS_ALL.paper_document_number%TYPE,

503: *---------------------------------------------------------------------*/
504: PROCEDURE assignElectronicCheckNumbers(
505: x_pmtInstrRec IN OUT NOCOPY IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE,
506: p_payment_doc_id IN CE_PAYMENT_DOCUMENTS.payment_document_id%TYPE,
507: p_user_assgn_num IN IBY_PAYMENTS_ALL.paper_document_number%TYPE,
508: x_paperPmtsTab IN OUT NOCOPY paperPmtsSpecialDocsTabType,
509: x_dummyPaperPmtsTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,
510: x_instrErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
511: x_insTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.

Line 588: p_start_number IN IBY_PAYMENTS_ALL.paper_document_number%TYPE,

584: |
585: *---------------------------------------------------------------------*/
586: FUNCTION isContigPaperNumAvlbl(
587: p_payment_doc_id IN CE_PAYMENT_DOCUMENTS.payment_document_id%TYPE,
588: p_start_number IN IBY_PAYMENTS_ALL.paper_document_number%TYPE,
589: p_end_number IN IBY_PAYMENTS_ALL.paper_document_number%TYPE
590: ) RETURN BOOLEAN;
591:
592: /*--------------------------------------------------------------------

Line 589: p_end_number IN IBY_PAYMENTS_ALL.paper_document_number%TYPE

585: *---------------------------------------------------------------------*/
586: FUNCTION isContigPaperNumAvlbl(
587: p_payment_doc_id IN CE_PAYMENT_DOCUMENTS.payment_document_id%TYPE,
588: p_start_number IN IBY_PAYMENTS_ALL.paper_document_number%TYPE,
589: p_end_number IN IBY_PAYMENTS_ALL.paper_document_number%TYPE
590: ) RETURN BOOLEAN;
591:
592: /*--------------------------------------------------------------------
593: | NAME:

Line 614: p_start_number IN IBY_PAYMENTS_ALL.paper_document_number%TYPE,

610: |
611: *---------------------------------------------------------------------*/
612: FUNCTION isPaperNosUsedOnExistPmt(
613: p_payment_doc_id IN CE_PAYMENT_DOCUMENTS.payment_document_id%TYPE,
614: p_start_number IN IBY_PAYMENTS_ALL.paper_document_number%TYPE,
615: p_end_number IN IBY_PAYMENTS_ALL.paper_document_number%TYPE
616: ) RETURN BOOLEAN;
617:
618: END IBY_CHECKNUMBER_PUB;

Line 615: p_end_number IN IBY_PAYMENTS_ALL.paper_document_number%TYPE

611: *---------------------------------------------------------------------*/
612: FUNCTION isPaperNosUsedOnExistPmt(
613: p_payment_doc_id IN CE_PAYMENT_DOCUMENTS.payment_document_id%TYPE,
614: p_start_number IN IBY_PAYMENTS_ALL.paper_document_number%TYPE,
615: p_end_number IN IBY_PAYMENTS_ALL.paper_document_number%TYPE
616: ) RETURN BOOLEAN;
617:
618: END IBY_CHECKNUMBER_PUB;