eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_CHECKNUMBER_PUB dependencies on IBY_PAY_INSTRUCTIONS_ALL

Line 87: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.

83: |
84: |
85: *---------------------------------------------------------------------*/
86: PROCEDURE performCheckNumbering(
87: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.
88: payment_instruction_id%TYPE,
89: p_pmt_document_id IN CE_PAYMENT_DOCUMENTS.
90: payment_document_id%TYPE,
91: p_user_assgn_num IN IBY_PAYMENTS_ALL.

Line 105: l_pmtInstrRec IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE;

101:
102: l_ret_status NUMBER := -1;
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:

Line 140: CURSOR c_pmts_in_instruction (p_instr_id IBY_PAY_INSTRUCTIONS_ALL.

136: /*
137: * Cursor to pick up the payments (and related fields)
138: * of a given payment instruction.
139: */
140: CURSOR c_pmts_in_instruction (p_instr_id IBY_PAY_INSTRUCTIONS_ALL.
141: payment_instruction_id%TYPE)
142: IS
143: SELECT
144: pmt.payment_id,

Line 157: IBY_PAY_INSTRUCTIONS_ALL instr,

153: pmt.separate_remit_advice_req_flag,
154: pmt.paper_document_number
155: FROM
156: IBY_PAYMENTS_ALL pmt,
157: IBY_PAY_INSTRUCTIONS_ALL instr,
158: IBY_PAYMENT_PROFILES prof
159: WHERE
160: instr.payment_instruction_id = p_instr_id AND
161: instr.payment_instruction_id = pmt.payment_instruction_id AND

Line 204: * from the IBY_PAY_INSTRUCTIONS_ALL table.

200: || p_instruction_id);
201:
202: /*
203: * Pick up all attributes of the given payment instruction
204: * from the IBY_PAY_INSTRUCTIONS_ALL table.
205: */
206: BEGIN
207:
208: SELECT

Line 317: IBY_PAY_INSTRUCTIONS_ALL

313: l_pmtInstrRec.attribute13,
314: l_pmtInstrRec.attribute14,
315: l_pmtInstrRec.attribute15
316: FROM
317: IBY_PAY_INSTRUCTIONS_ALL
318: WHERE
319: payment_instruction_id = p_instruction_id
320: ;
321:

Line 341: || ' not found in IBY_PAY_INSTRUCTIONS_ALL table. '

337: IF (l_pmtInstrRec.payment_instruction_id IS NULL) THEN
338:
339: print_debuginfo(l_module_name, 'Provided payment instruction id '
340: || p_instruction_id
341: || ' not found in IBY_PAY_INSTRUCTIONS_ALL table. '
342: || 'Processing cannot continue. Aborting program.'
343: );
344:
345: x_return_status := FND_API.G_RET_STS_ERROR;

Line 785: | table into IBY_PAY_INSTRUCTIONS_ALL table.

Line 788: | IBY_PAY_INSTRUCTIONS_ALL after grouping (and before validation).

Line 817: || ' were found to update IBY_PAY_INSTRUCTIONS_ALL table.');

813:
814: /* Normally, this shouldn't happen */
815: IF (p_payInstrTab.COUNT = 0) THEN
816: print_debuginfo(l_module_name, 'No payment instructions'
817: || ' were found to update IBY_PAY_INSTRUCTIONS_ALL table.');
818: RETURN;
819: END IF;
820:
821: FOR i in p_payInstrTab.FIRST..p_payInstrTab.LAST LOOP

Line 823: IBY_PAY_INSTRUCTIONS_ALL

819: END IF;
820:
821: FOR i in p_payInstrTab.FIRST..p_payInstrTab.LAST LOOP
822: UPDATE
823: IBY_PAY_INSTRUCTIONS_ALL
824: SET
825: payment_instruction_status = p_payInstrTab(i).
826: payment_instruction_status
827: WHERE

Line 1197: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.

1193: | NOTES:
1194: |
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,

Line 1279: x_pmtInstrRec IN OUT NOCOPY IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE,

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

Line 1769: x_pmtInstrRec IN OUT NOCOPY IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE,

1765: | This method will perform a COMMIT.
1766: |
1767: *---------------------------------------------------------------------*/
1768: PROCEDURE assignCheckNumbers(
1769: x_pmtInstrRec IN OUT NOCOPY IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE,
1770: p_payment_doc_id IN CE_PAYMENT_DOCUMENTS.payment_document_id%TYPE,
1771: p_user_assgn_num IN IBY_PAYMENTS_ALL.paper_document_number%TYPE,
1772: x_paperPmtsTab IN OUT NOCOPY paperPmtsSpecialDocsTabType,
1773: x_dummyPaperPmtsTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,

Line 1791: l_pmt_instr_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE;

1787: l_physical_stock_count NUMBER := 0;
1788: l_anticipated_last_check_num NUMBER := 0;
1789:
1790: l_pmt_doc_name VARCHAR2(200) := '';
1791: l_pmt_instr_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE;
1792:
1793: l_error_code IBY_TRANSACTION_ERRORS.error_code%TYPE;
1794: l_instr_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;
1795: l_token_rec IBY_TRXN_ERROR_TOKENS%ROWTYPE;

Line 1798: l_instr_status IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_status%TYPE;

1794: l_instr_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;
1795: l_token_rec IBY_TRXN_ERROR_TOKENS%ROWTYPE;
1796:
1797: l_send_to_file_flag VARCHAR2(1);
1798: l_instr_status IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_status%TYPE;
1799:
1800: l_single_pmt_flag BOOLEAN;
1801: l_nos_avlbl_flag BOOLEAN;
1802: l_used_flag BOOLEAN;

Line 1980: IBY_PAY_INSTRUCTIONS_ALL

1976: * Blindly update the payment instruction status
1977: * (see above comment).
1978: */
1979: UPDATE
1980: IBY_PAY_INSTRUCTIONS_ALL
1981: SET
1982: payment_instruction_status = l_instr_status
1983: WHERE
1984: payment_instruction_id = x_pmtInstrRec.payment_instruction_id;

Line 3465: p_instrId IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,

3461: | NOTES:
3462: |
3463: *---------------------------------------------------------------------*/
3464: PROCEDURE updateSetupDocsFlagForInstr(
3465: p_instrId IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,
3466: x_paperSpecialTab IN OUT NOCOPY paperPmtsSpecialDocsTabType
3467: )
3468: IS
3469: BEGIN

Line 4026: IBY_PAY_INSTRUCTIONS_ALL inst

4022: l_test_paper_doc_num,
4023: l_test_pmt_id
4024: FROM
4025: IBY_PAYMENTS_ALL pmt,
4026: IBY_PAY_INSTRUCTIONS_ALL inst
4027: WHERE
4028: pmt.payment_instruction_id = inst.payment_instruction_id AND
4029: inst.payment_document_id = p_payment_doc_id AND
4030: pmt.paper_document_number = l_paper_doc_num