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:
19: /*
134: | NOTES:
135: |
136: *---------------------------------------------------------------------*/
137: PROCEDURE performCheckNumbering(
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.
175: | updatePaymentInstructions
176: |
177: | PURPOSE:
178: | Performs an update of all created instructions from PLSQL
179: | table into IBY_PAY_INSTRUCTIONS_ALL table.
180: |
181: | The created instructions have already been inserted into
182: | IBY_PAY_INSTRUCTIONS_ALL after grouping. So we only need to
183: | update certain fields of the instruction that have been
178: | Performs an update of all created instructions from PLSQL
179: | table into IBY_PAY_INSTRUCTIONS_ALL table.
180: |
181: | The created instructions have already been inserted into
182: | IBY_PAY_INSTRUCTIONS_ALL after grouping. So we only need to
183: | update certain fields of the instruction that have been
184: | changed after the grouping was performed.
185: |
186: | PARAMETERS:
220: | NOTES:
221: |
222: *---------------------------------------------------------------------*/
223: PROCEDURE performDBUpdates(
224: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.
225: payment_instruction_id%TYPE,
226: x_pmtsInPmtInstrTab IN OUT NOCOPY IBY_PAYINSTR_PUB.pmtsInpmtInstrTabType,
227: x_dummyPaperPmtsTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,
228: x_setupDocsTab IN OUT NOCOPY docsTabType,
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,
262: x_overflowDocsTab IN OUT NOCOPY overflowDocsTabType,
388: | NOTES:
389: |
390: *---------------------------------------------------------------------*/
391: PROCEDURE updateSetupDocsFlagForInstr(
392: p_instrId IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,
393: x_paperSpecialTab IN OUT NOCOPY paperPmtsSpecialDocsTabType
394: );
395:
396: /*--------------------------------------------------------------------
465: | NOTES:
466: |
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,