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 95: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.

91: |
92: |
93: *---------------------------------------------------------------------*/
94: PROCEDURE performCheckNumbering(
95: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.
96: payment_instruction_id%TYPE,
97: p_pmt_document_id IN CE_PAYMENT_DOCUMENTS.
98: payment_document_id%TYPE,
99: p_user_assgn_num IN IBY_PAYMENTS_ALL.

Line 113: l_pmtInstrRec IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE;

109:
110: l_ret_status NUMBER := -1;
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:

Line 148: CURSOR c_pmts_in_instruction (p_instr_id IBY_PAY_INSTRUCTIONS_ALL.

144: /*
145: * Cursor to pick up the payments (and related fields)
146: * of a given payment instruction.
147: */
148: CURSOR c_pmts_in_instruction (p_instr_id IBY_PAY_INSTRUCTIONS_ALL.
149: payment_instruction_id%TYPE)
150: IS
151: SELECT
152: pmt.payment_id,

Line 165: IBY_PAY_INSTRUCTIONS_ALL instr,

161: pmt.separate_remit_advice_req_flag,
162: pmt.paper_document_number
163: FROM
164: IBY_PAYMENTS_ALL pmt,
165: IBY_PAY_INSTRUCTIONS_ALL instr,
166: IBY_PAYMENT_PROFILES prof
167: WHERE
168: instr.payment_instruction_id = p_instr_id AND
169: instr.payment_instruction_id = pmt.payment_instruction_id AND

Line 214: * from the IBY_PAY_INSTRUCTIONS_ALL table.

210:
211: END IF;
212: /*
213: * Pick up all attributes of the given payment instruction
214: * from the IBY_PAY_INSTRUCTIONS_ALL table.
215: */
216: BEGIN
217:
218: SELECT

Line 327: IBY_PAY_INSTRUCTIONS_ALL

323: l_pmtInstrRec.attribute13,
324: l_pmtInstrRec.attribute14,
325: l_pmtInstrRec.attribute15
326: FROM
327: IBY_PAY_INSTRUCTIONS_ALL
328: WHERE
329: payment_instruction_id = p_instruction_id
330: ;
331:

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

350:
351: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
352: print_debuginfo(l_module_name, 'Provided payment instruction id '
353: || p_instruction_id
354: || ' not found in IBY_PAY_INSTRUCTIONS_ALL table. '
355: || 'Processing cannot continue. Aborting program.'
356: );
357:
358: END IF;

Line 844: | table into IBY_PAY_INSTRUCTIONS_ALL table.

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

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

875: /* Normally, this shouldn't happen */
876: IF (p_payInstrTab.COUNT = 0) THEN
877: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
878: print_debuginfo(l_module_name, 'No payment instructions'
879: || ' were found to update IBY_PAY_INSTRUCTIONS_ALL table.');
880: END IF;
881: RETURN;
882: END IF;
883:

Line 886: IBY_PAY_INSTRUCTIONS_ALL

882: END IF;
883:
884: FOR i in p_payInstrTab.FIRST..p_payInstrTab.LAST LOOP
885: UPDATE
886: IBY_PAY_INSTRUCTIONS_ALL
887: SET
888: payment_instruction_status = p_payInstrTab(i).
889: payment_instruction_status
890: WHERE

Line 1286: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.

1282: | NOTES:
1283: |
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,

Line 1374: x_pmtInstrRec IN OUT NOCOPY IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE,

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

Line 2256: x_pmtInstrRec IN OUT NOCOPY IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE,

2252: | This method will perform a COMMIT.
2253: |
2254: *---------------------------------------------------------------------*/
2255: PROCEDURE assignCheckNumbers(
2256: x_pmtInstrRec IN OUT NOCOPY IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE,
2257: p_payment_doc_id IN CE_PAYMENT_DOCUMENTS.payment_document_id%TYPE,
2258: p_user_assgn_num IN IBY_PAYMENTS_ALL.paper_document_number%TYPE,
2259: x_paperPmtsTab IN OUT NOCOPY paperPmtsSpecialDocsTabType,
2260: x_dummyPaperPmtsTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,

Line 2278: l_pmt_instr_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE;

2274: l_physical_stock_count NUMBER := 0;
2275: l_anticipated_last_check_num NUMBER := 0;
2276:
2277: l_pmt_doc_name VARCHAR2(200) := '';
2278: l_pmt_instr_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE;
2279:
2280: l_error_code IBY_TRANSACTION_ERRORS.error_code%TYPE;
2281: l_instr_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;
2282: l_token_rec IBY_TRXN_ERROR_TOKENS%ROWTYPE;

Line 2285: l_instr_status IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_status%TYPE;

2281: l_instr_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;
2282: l_token_rec IBY_TRXN_ERROR_TOKENS%ROWTYPE;
2283:
2284: l_send_to_file_flag VARCHAR2(1);
2285: l_instr_status IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_status%TYPE;
2286:
2287: l_single_pmt_flag BOOLEAN;
2288: l_nos_avlbl_flag BOOLEAN;
2289: l_used_flag BOOLEAN;

Line 2479: IBY_PAY_INSTRUCTIONS_ALL

2475: * Blindly update the payment instruction status
2476: * (see above comment).
2477: */
2478: UPDATE
2479: IBY_PAY_INSTRUCTIONS_ALL
2480: SET
2481: payment_instruction_status = l_instr_status
2482: WHERE
2483: payment_instruction_id = x_pmtInstrRec.payment_instruction_id;

Line 4136: p_instrId IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,

4132: | NOTES:
4133: |
4134: *---------------------------------------------------------------------*/
4135: PROCEDURE updateSetupDocsFlagForInstr(
4136: p_instrId IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,
4137: x_paperSpecialTab IN OUT NOCOPY paperPmtsSpecialDocsTabType
4138: )
4139: IS
4140: BEGIN

Line 4923: IBY_PAY_INSTRUCTIONS_ALL inst

4919: l_test_paper_doc_num,
4920: l_test_pmt_id
4921: FROM
4922: IBY_PAYMENTS_ALL pmt,
4923: IBY_PAY_INSTRUCTIONS_ALL inst
4924: WHERE
4925: pmt.payment_instruction_id = inst.payment_instruction_id AND
4926: inst.payment_document_id = p_payment_doc_id AND
4927: pmt.paper_document_number = l_paper_doc_num

Line 5049: x_pmtInstrRec IN OUT NOCOPY IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE,

5045: | This method will perform a COMMIT.
5046: |
5047: *---------------------------------------------------------------------*/
5048: PROCEDURE assignElectronicCheckNumbers(
5049: x_pmtInstrRec IN OUT NOCOPY IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE,
5050: p_payment_doc_id IN CE_PAYMENT_DOCUMENTS.payment_document_id%TYPE,
5051: p_user_assgn_num IN IBY_PAYMENTS_ALL.paper_document_number%TYPE,
5052: x_paperPmtsTab IN OUT NOCOPY paperPmtsSpecialDocsTabType,
5053: x_dummyPaperPmtsTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,

Line 5071: l_pmt_instr_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE;

5067: l_physical_stock_count NUMBER := 0;
5068: l_anticipated_last_check_num NUMBER := 0;
5069:
5070: l_pmt_doc_name VARCHAR2(200) := '';
5071: l_pmt_instr_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE;
5072:
5073: l_error_code IBY_TRANSACTION_ERRORS.error_code%TYPE;
5074: l_instr_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;
5075: l_token_rec IBY_TRXN_ERROR_TOKENS%ROWTYPE;

Line 5078: l_instr_status IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_status%TYPE;

5074: l_instr_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;
5075: l_token_rec IBY_TRXN_ERROR_TOKENS%ROWTYPE;
5076:
5077: l_send_to_file_flag VARCHAR2(1);
5078: l_instr_status IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_status%TYPE;
5079:
5080: l_single_pmt_flag BOOLEAN;
5081: l_nos_avlbl_flag BOOLEAN;
5082: l_used_flag BOOLEAN;