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_SCHED dependencies on JTF_VARCHAR2_TABLE_100

Line 172: txn_id_Tab JTF_VARCHAR2_TABLE_100;

168: o_status VARCHAR2(80);
169: o_errcode VARCHAR2(80);
170: o_errmsg VARCHAR2(80);
171:
172: txn_id_Tab JTF_VARCHAR2_TABLE_100;
173: Status_Tab JTF_NUMBER_TABLE;
174: reqtype_Tab JTF_VARCHAR2_TABLE_100;
175: updatedt_Tab JTF_DATE_TABLE;
176: refcode_Tab JTF_VARCHAR2_TABLE_100;

Line 174: reqtype_Tab JTF_VARCHAR2_TABLE_100;

170: o_errmsg VARCHAR2(80);
171:
172: txn_id_Tab JTF_VARCHAR2_TABLE_100;
173: Status_Tab JTF_NUMBER_TABLE;
174: reqtype_Tab JTF_VARCHAR2_TABLE_100;
175: updatedt_Tab JTF_DATE_TABLE;
176: refcode_Tab JTF_VARCHAR2_TABLE_100;
177: o_statusindiv_Tab JTF_VARCHAR2_TABLE_100;
178:

Line 176: refcode_Tab JTF_VARCHAR2_TABLE_100;

172: txn_id_Tab JTF_VARCHAR2_TABLE_100;
173: Status_Tab JTF_NUMBER_TABLE;
174: reqtype_Tab JTF_VARCHAR2_TABLE_100;
175: updatedt_Tab JTF_DATE_TABLE;
176: refcode_Tab JTF_VARCHAR2_TABLE_100;
177: o_statusindiv_Tab JTF_VARCHAR2_TABLE_100;
178:
179: txn_mid_Tab txn_mid_TabTyp;
180:

Line 177: o_statusindiv_Tab JTF_VARCHAR2_TABLE_100;

173: Status_Tab JTF_NUMBER_TABLE;
174: reqtype_Tab JTF_VARCHAR2_TABLE_100;
175: updatedt_Tab JTF_DATE_TABLE;
176: refcode_Tab JTF_VARCHAR2_TABLE_100;
177: o_statusindiv_Tab JTF_VARCHAR2_TABLE_100;
178:
179: txn_mid_Tab txn_mid_TabTyp;
180:
181: -- String and cursors for dynamic PL/SQL

Line 243: txn_id_Tab := JTF_VARCHAR2_TABLE_100();

239: -- r_trans_bankacct c_trans_bankacct%ROWTYPE;
240:
241: BEGIN
242:
243: txn_id_Tab := JTF_VARCHAR2_TABLE_100();
244: Status_Tab := JTF_NUMBER_TABLE();
245: reqtype_Tab := JTF_VARCHAR2_TABLE_100();
246: updatedt_Tab := JTF_DATE_TABLE();
247: refcode_Tab := JTF_VARCHAR2_TABLE_100();

Line 245: reqtype_Tab := JTF_VARCHAR2_TABLE_100();

241: BEGIN
242:
243: txn_id_Tab := JTF_VARCHAR2_TABLE_100();
244: Status_Tab := JTF_NUMBER_TABLE();
245: reqtype_Tab := JTF_VARCHAR2_TABLE_100();
246: updatedt_Tab := JTF_DATE_TABLE();
247: refcode_Tab := JTF_VARCHAR2_TABLE_100();
248: o_statusindiv_Tab := JTF_VARCHAR2_TABLE_100();
249:

Line 247: refcode_Tab := JTF_VARCHAR2_TABLE_100();

243: txn_id_Tab := JTF_VARCHAR2_TABLE_100();
244: Status_Tab := JTF_NUMBER_TABLE();
245: reqtype_Tab := JTF_VARCHAR2_TABLE_100();
246: updatedt_Tab := JTF_DATE_TABLE();
247: refcode_Tab := JTF_VARCHAR2_TABLE_100();
248: o_statusindiv_Tab := JTF_VARCHAR2_TABLE_100();
249:
250: -- finding the total number of rows
251: SELECT count(*)

Line 248: o_statusindiv_Tab := JTF_VARCHAR2_TABLE_100();

244: Status_Tab := JTF_NUMBER_TABLE();
245: reqtype_Tab := JTF_VARCHAR2_TABLE_100();
246: updatedt_Tab := JTF_DATE_TABLE();
247: refcode_Tab := JTF_VARCHAR2_TABLE_100();
248: o_statusindiv_Tab := JTF_VARCHAR2_TABLE_100();
249:
250: -- finding the total number of rows
251: SELECT count(*)
252: INTO totalRows

Line 431: i_errCode_arr IN JTF_VARCHAR2_TABLE_100,

427: procedure update_trxn_status( i_unchanged_status IN NUMBER,
428: i_numTrxns IN NUMBER,
429: i_status_arr IN JTF_NUMBER_TABLE,
430: i_errLoc_arr IN JTF_NUMBER_TABLE,
431: i_errCode_arr IN JTF_VARCHAR2_TABLE_100,
432: i_errMsg_arr IN JTF_VARCHAR2_TABLE_300,
433: i_tangibleId_arr IN JTF_VARCHAR2_TABLE_100,
434: i_trxnMId_arr IN JTF_NUMBER_TABLE,
435: i_srvrId_arr IN JTF_VARCHAR2_TABLE_100,

Line 433: i_tangibleId_arr IN JTF_VARCHAR2_TABLE_100,

429: i_status_arr IN JTF_NUMBER_TABLE,
430: i_errLoc_arr IN JTF_NUMBER_TABLE,
431: i_errCode_arr IN JTF_VARCHAR2_TABLE_100,
432: i_errMsg_arr IN JTF_VARCHAR2_TABLE_300,
433: i_tangibleId_arr IN JTF_VARCHAR2_TABLE_100,
434: i_trxnMId_arr IN JTF_NUMBER_TABLE,
435: i_srvrId_arr IN JTF_VARCHAR2_TABLE_100,
436: i_refCode_arr IN JTF_VARCHAR2_TABLE_100,
437: i_auxMsg_arr IN JTF_VARCHAR2_TABLE_300,

Line 435: i_srvrId_arr IN JTF_VARCHAR2_TABLE_100,

431: i_errCode_arr IN JTF_VARCHAR2_TABLE_100,
432: i_errMsg_arr IN JTF_VARCHAR2_TABLE_300,
433: i_tangibleId_arr IN JTF_VARCHAR2_TABLE_100,
434: i_trxnMId_arr IN JTF_NUMBER_TABLE,
435: i_srvrId_arr IN JTF_VARCHAR2_TABLE_100,
436: i_refCode_arr IN JTF_VARCHAR2_TABLE_100,
437: i_auxMsg_arr IN JTF_VARCHAR2_TABLE_300,
438: i_fee_arr IN JTF_NUMBER_TABLE,
439: o_status_arr OUT NOCOPY JTF_NUMBER_TABLE,

Line 436: i_refCode_arr IN JTF_VARCHAR2_TABLE_100,

432: i_errMsg_arr IN JTF_VARCHAR2_TABLE_300,
433: i_tangibleId_arr IN JTF_VARCHAR2_TABLE_100,
434: i_trxnMId_arr IN JTF_NUMBER_TABLE,
435: i_srvrId_arr IN JTF_VARCHAR2_TABLE_100,
436: i_refCode_arr IN JTF_VARCHAR2_TABLE_100,
437: i_auxMsg_arr IN JTF_VARCHAR2_TABLE_300,
438: i_fee_arr IN JTF_NUMBER_TABLE,
439: o_status_arr OUT NOCOPY JTF_NUMBER_TABLE,
440: o_error_code OUT NOCOPY NUMBER,