DBA Data[Home] [Help]

APPS.IBY_CHECKNUMBER_PUB dependencies on IBY_PAY_INSTRUCTIONS_ALL

Line 15: instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,

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: /*

Line 138: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.

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.

Line 179: | table into IBY_PAY_INSTRUCTIONS_ALL table.

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

Line 182: | IBY_PAY_INSTRUCTIONS_ALL after grouping. So we only need to

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:

Line 224: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.

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,

Line 258: x_pmtInstrRec IN OUT NOCOPY IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE,

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,

Line 392: p_instrId IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,

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: /*--------------------------------------------------------------------

Line 469: x_pmtInstrRec IN OUT NOCOPY IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE,

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,