DBA Data[Home] [Help]

APPS.IBY_CHECKNUMBER_PUB dependencies on IBY_PAYINSTR_PUB

Line 107: l_pmtsInInstrRec IBY_PAYINSTR_PUB.pmtsInPmtInstrRecType;

103: l_ret_message VARCHAR2(2000);
104:
105: l_pmtInstrRec IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE;
106:
107: l_pmtsInInstrRec IBY_PAYINSTR_PUB.pmtsInPmtInstrRecType;
108: l_pmtsInInstrTab IBY_PAYINSTR_PUB.pmtsInpmtInstrTabType;
109:
110: l_error_code VARCHAR2(500);
111:

Line 108: l_pmtsInInstrTab IBY_PAYINSTR_PUB.pmtsInpmtInstrTabType;

104:
105: l_pmtInstrRec IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE;
106:
107: l_pmtsInInstrRec IBY_PAYINSTR_PUB.pmtsInPmtInstrRecType;
108: l_pmtsInInstrTab IBY_PAYINSTR_PUB.pmtsInpmtInstrTabType;
109:
110: l_error_code VARCHAR2(500);
111:
112: l_instruction_id NUMBER(15);

Line 710: x_pmtsInPmtInstrTab IN OUT NOCOPY IBY_PAYINSTR_PUB.pmtsInpmtInstrTabType

706: | NOTES:
707: |
708: *---------------------------------------------------------------------*/
709: PROCEDURE populateDocumentCount(
710: x_pmtsInPmtInstrTab IN OUT NOCOPY IBY_PAYINSTR_PUB.pmtsInpmtInstrTabType
711: )
712: IS
713:
714: l_module_name VARCHAR2(200) := G_PKG_NAME || '.populateDocumentCount';

Line 805: p_payInstrTab IN IBY_PAYINSTR_PUB.pmtInstrTabType

801: | NOTES:
802: |
803: *---------------------------------------------------------------------*/
804: PROCEDURE updatePaymentInstructions(
805: p_payInstrTab IN IBY_PAYINSTR_PUB.pmtInstrTabType
806: )
807: IS
808: l_module_name VARCHAR2(200) := G_PKG_NAME || '.updatePaymentInstructions';
809:

Line 1199: x_pmtsInPmtInstrTab IN OUT NOCOPY IBY_PAYINSTR_PUB.pmtsInpmtInstrTabType,

1195: *---------------------------------------------------------------------*/
1196: PROCEDURE performDBUpdates(
1197: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.
1198: payment_instruction_id%TYPE,
1199: x_pmtsInPmtInstrTab IN OUT NOCOPY IBY_PAYINSTR_PUB.pmtsInpmtInstrTabType,
1200: x_dummyPaperPmtsTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,
1201: x_setupDocsTab IN OUT NOCOPY docsTabType,
1202: x_overflowDocsTab IN OUT NOCOPY overflowDocsTabType,
1203: x_insErrorsTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

Line 1280: x_pmtsInPmtInstrTab IN OUT NOCOPY IBY_PAYINSTR_PUB.pmtsInpmtInstrTabType,

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,
1282: x_setupDocsTab IN OUT NOCOPY docsTabType,
1283: x_overflowDocsTab IN OUT NOCOPY overflowDocsTabType,
1284: x_instrErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

Line 1307: l_pmtsInPmtInstrRec IBY_PAYINSTR_PUB.pmtsInpmtInstrRecType;

1303:
1304: l_paper_special_docs_rec paperPmtsSpecialDocsRecType;
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

Line 1723: p_pmtsInPmtInstrTab IN IBY_PAYINSTR_PUB.pmtsInpmtInstrTabType

1719: |
1720: *---------------------------------------------------------------------*/
1721: FUNCTION getDocumentCountForPayment(
1722: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%TYPE,
1723: p_pmtsInPmtInstrTab IN IBY_PAYINSTR_PUB.pmtsInpmtInstrTabType
1724: )
1725: RETURN NUMBER
1726: IS
1727: l_doc_count NUMBER := -1;

Line 2774: l_pmtsInPmtInstrRec IBY_PAYINSTR_PUB.pmtsInPmtInstrRecType;

2770: l_pmt_rec IBY_PAYMENTS_ALL%ROWTYPE;
2771:
2772: l_payment_id IBY_PAYMENTS_ALL.payment_id%TYPE;
2773:
2774: l_pmtsInPmtInstrRec IBY_PAYINSTR_PUB.pmtsInPmtInstrRecType;
2775:
2776: --Bug 6486816
2777: -- Previously formatting_payment_id was updated for each document of payment but
2778: --after which x_overflowDocsTab was updates for next payment, losing the

Line 3508: p_pmtsInPayInstTab IN IBY_PAYINSTR_PUB.pmtsInpmtInstrTabType

3504: | NOTES:
3505: |
3506: *---------------------------------------------------------------------*/
3507: PROCEDURE updatePmtsWithCheckNumbers(
3508: p_pmtsInPayInstTab IN IBY_PAYINSTR_PUB.pmtsInpmtInstrTabType
3509: )
3510: IS
3511: l_module_name VARCHAR2(200) := G_PKG_NAME || '.updatePmtsWithCheckNumbers';
3512: