DBA Data[Home] [Help]

APPS.IBY_CHECKNUMBER_PUB dependencies on IBY_PAYINSTR_PUB

Line 115: l_pmtsInInstrRec IBY_PAYINSTR_PUB.pmtsInPmtInstrRecType;

111: l_ret_message VARCHAR2(2000);
112:
113: l_pmtInstrRec IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE;
114:
115: l_pmtsInInstrRec IBY_PAYINSTR_PUB.pmtsInPmtInstrRecType;
116: l_pmtsInInstrTab IBY_PAYINSTR_PUB.pmtsInpmtInstrTabType;
117:
118: l_error_code VARCHAR2(500);
119:

Line 116: l_pmtsInInstrTab IBY_PAYINSTR_PUB.pmtsInpmtInstrTabType;

112:
113: l_pmtInstrRec IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE;
114:
115: l_pmtsInInstrRec IBY_PAYINSTR_PUB.pmtsInPmtInstrRecType;
116: l_pmtsInInstrTab IBY_PAYINSTR_PUB.pmtsInpmtInstrTabType;
117:
118: l_error_code VARCHAR2(500);
119:
120: l_instruction_id NUMBER(15);

Line 762: x_pmtsInPmtInstrTab IN OUT NOCOPY IBY_PAYINSTR_PUB.pmtsInpmtInstrTabType

758: | NOTES:
759: |
760: *---------------------------------------------------------------------*/
761: PROCEDURE populateDocumentCount(
762: x_pmtsInPmtInstrTab IN OUT NOCOPY IBY_PAYINSTR_PUB.pmtsInpmtInstrTabType
763: )
764: IS
765:
766: l_module_name VARCHAR2(200) := G_PKG_NAME || '.populateDocumentCount';

Line 864: p_payInstrTab IN IBY_PAYINSTR_PUB.pmtInstrTabType

860: | NOTES:
861: |
862: *---------------------------------------------------------------------*/
863: PROCEDURE updatePaymentInstructions(
864: p_payInstrTab IN IBY_PAYINSTR_PUB.pmtInstrTabType
865: )
866: IS
867: l_module_name VARCHAR2(200) := G_PKG_NAME || '.updatePaymentInstructions';
868:

Line 1288: x_pmtsInPmtInstrTab IN OUT NOCOPY IBY_PAYINSTR_PUB.pmtsInpmtInstrTabType,

1284: *---------------------------------------------------------------------*/
1285: PROCEDURE performDBUpdates(
1286: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.
1287: payment_instruction_id%TYPE,
1288: x_pmtsInPmtInstrTab IN OUT NOCOPY IBY_PAYINSTR_PUB.pmtsInpmtInstrTabType,
1289: x_dummyPaperPmtsTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,
1290: x_setupDocsTab IN OUT NOCOPY docsTabType,
1291: x_overflowDocsTab IN OUT NOCOPY overflowDocsTabType,
1292: x_insErrorsTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

Line 1375: x_pmtsInPmtInstrTab IN OUT NOCOPY IBY_PAYINSTR_PUB.pmtsInpmtInstrTabType,

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,
1378: x_overflowDocsTab IN OUT NOCOPY overflowDocsTabType,
1379: x_instrErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

Line 1402: l_pmtsInPmtInstrRec IBY_PAYINSTR_PUB.pmtsInpmtInstrRecType;

1398:
1399: l_paper_special_docs_rec paperPmtsSpecialDocsRecType;
1400: l_paper_special_docs_tab paperPmtsSpecialDocsTabType;
1401:
1402: l_pmtsInPmtInstrRec IBY_PAYINSTR_PUB.pmtsInpmtInstrRecType;
1403:
1404: CURSOR c_paper_stock (p_pmt_doc_id IN CE_PAYMENT_DOCUMENTS.
1405: payment_document_id%TYPE)
1406: IS

Line 2210: p_pmtsInPmtInstrTab IN IBY_PAYINSTR_PUB.pmtsInpmtInstrTabType

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
2214: l_doc_count NUMBER := -1;

Line 3419: l_pmtsInPmtInstrRec IBY_PAYINSTR_PUB.pmtsInPmtInstrRecType;

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
3422: -- Previously formatting_payment_id was updated for each document of payment but
3423: --after which x_overflowDocsTab was updates for next payment, losing the

Line 4179: p_pmtsInPayInstTab IN IBY_PAYINSTR_PUB.pmtsInpmtInstrTabType

4175: | NOTES:
4176: |
4177: *---------------------------------------------------------------------*/
4178: PROCEDURE updatePmtsWithCheckNumbers(
4179: p_pmtsInPayInstTab IN IBY_PAYINSTR_PUB.pmtsInpmtInstrTabType
4180: )
4181: IS
4182: l_module_name VARCHAR2(200) := G_PKG_NAME || '.updatePmtsWithCheckNumbers';
4183: