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 176: txn_id_Tab JTF_VARCHAR2_TABLE_100;

172: o_status VARCHAR2(80);
173: o_errcode VARCHAR2(80);
174: o_errmsg VARCHAR2(80);
175:
176: txn_id_Tab JTF_VARCHAR2_TABLE_100;
177: Status_Tab JTF_NUMBER_TABLE;
178: reqtype_Tab JTF_VARCHAR2_TABLE_100;
179: updatedt_Tab JTF_DATE_TABLE;
180: refcode_Tab JTF_VARCHAR2_TABLE_100;

Line 178: reqtype_Tab JTF_VARCHAR2_TABLE_100;

174: o_errmsg VARCHAR2(80);
175:
176: txn_id_Tab JTF_VARCHAR2_TABLE_100;
177: Status_Tab JTF_NUMBER_TABLE;
178: reqtype_Tab JTF_VARCHAR2_TABLE_100;
179: updatedt_Tab JTF_DATE_TABLE;
180: refcode_Tab JTF_VARCHAR2_TABLE_100;
181: o_statusindiv_Tab JTF_VARCHAR2_TABLE_100;
182:

Line 180: refcode_Tab JTF_VARCHAR2_TABLE_100;

176: txn_id_Tab JTF_VARCHAR2_TABLE_100;
177: Status_Tab JTF_NUMBER_TABLE;
178: reqtype_Tab JTF_VARCHAR2_TABLE_100;
179: updatedt_Tab JTF_DATE_TABLE;
180: refcode_Tab JTF_VARCHAR2_TABLE_100;
181: o_statusindiv_Tab JTF_VARCHAR2_TABLE_100;
182:
183: txn_mid_Tab txn_mid_TabTyp;
184:

Line 181: o_statusindiv_Tab JTF_VARCHAR2_TABLE_100;

177: Status_Tab JTF_NUMBER_TABLE;
178: reqtype_Tab JTF_VARCHAR2_TABLE_100;
179: updatedt_Tab JTF_DATE_TABLE;
180: refcode_Tab JTF_VARCHAR2_TABLE_100;
181: o_statusindiv_Tab JTF_VARCHAR2_TABLE_100;
182:
183: txn_mid_Tab txn_mid_TabTyp;
184:
185: -- String and cursors for dynamic PL/SQL

Line 301: txn_id_Tab := JTF_VARCHAR2_TABLE_100();

297:
298: OPEN ecapp_cursor(l_object_owner);
299: FETCH ecapp_cursor BULK COLLECT INTO l_ecappTab;
300:
301: txn_id_Tab := JTF_VARCHAR2_TABLE_100();
302: Status_Tab := JTF_NUMBER_TABLE();
303: reqtype_Tab := JTF_VARCHAR2_TABLE_100();
304: updatedt_Tab := JTF_DATE_TABLE();
305: refcode_Tab := JTF_VARCHAR2_TABLE_100();

Line 303: reqtype_Tab := JTF_VARCHAR2_TABLE_100();

299: FETCH ecapp_cursor BULK COLLECT INTO l_ecappTab;
300:
301: txn_id_Tab := JTF_VARCHAR2_TABLE_100();
302: Status_Tab := JTF_NUMBER_TABLE();
303: reqtype_Tab := JTF_VARCHAR2_TABLE_100();
304: updatedt_Tab := JTF_DATE_TABLE();
305: refcode_Tab := JTF_VARCHAR2_TABLE_100();
306: o_statusindiv_Tab := JTF_VARCHAR2_TABLE_100();
307:

Line 305: refcode_Tab := JTF_VARCHAR2_TABLE_100();

301: txn_id_Tab := JTF_VARCHAR2_TABLE_100();
302: Status_Tab := JTF_NUMBER_TABLE();
303: reqtype_Tab := JTF_VARCHAR2_TABLE_100();
304: updatedt_Tab := JTF_DATE_TABLE();
305: refcode_Tab := JTF_VARCHAR2_TABLE_100();
306: o_statusindiv_Tab := JTF_VARCHAR2_TABLE_100();
307:
308: iby_debug_pub.add('l_ecappTab.COUNT:' || l_ecappTab.COUNT,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
309:

Line 306: o_statusindiv_Tab := JTF_VARCHAR2_TABLE_100();

302: Status_Tab := JTF_NUMBER_TABLE();
303: reqtype_Tab := JTF_VARCHAR2_TABLE_100();
304: updatedt_Tab := JTF_DATE_TABLE();
305: refcode_Tab := JTF_VARCHAR2_TABLE_100();
306: o_statusindiv_Tab := JTF_VARCHAR2_TABLE_100();
307:
308: iby_debug_pub.add('l_ecappTab.COUNT:' || l_ecappTab.COUNT,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
309:
310: IF(l_ecappTab.COUNT>0) THEN

Line 471: txn_id_Tab JTF_VARCHAR2_TABLE_100;

467: o_status VARCHAR2(80);
468: o_errcode VARCHAR2(80);
469: o_errmsg VARCHAR2(80);
470:
471: txn_id_Tab JTF_VARCHAR2_TABLE_100;
472: Status_Tab JTF_NUMBER_TABLE;
473: reqtype_Tab JTF_VARCHAR2_TABLE_100;
474: updatedt_Tab JTF_DATE_TABLE;
475: refcode_Tab JTF_VARCHAR2_TABLE_100;

Line 473: reqtype_Tab JTF_VARCHAR2_TABLE_100;

469: o_errmsg VARCHAR2(80);
470:
471: txn_id_Tab JTF_VARCHAR2_TABLE_100;
472: Status_Tab JTF_NUMBER_TABLE;
473: reqtype_Tab JTF_VARCHAR2_TABLE_100;
474: updatedt_Tab JTF_DATE_TABLE;
475: refcode_Tab JTF_VARCHAR2_TABLE_100;
476: o_statusindiv_Tab JTF_VARCHAR2_TABLE_100;
477:

Line 475: refcode_Tab JTF_VARCHAR2_TABLE_100;

471: txn_id_Tab JTF_VARCHAR2_TABLE_100;
472: Status_Tab JTF_NUMBER_TABLE;
473: reqtype_Tab JTF_VARCHAR2_TABLE_100;
474: updatedt_Tab JTF_DATE_TABLE;
475: refcode_Tab JTF_VARCHAR2_TABLE_100;
476: o_statusindiv_Tab JTF_VARCHAR2_TABLE_100;
477:
478: txn_mid_Tab txn_mid_TabTyp;
479:

Line 476: o_statusindiv_Tab JTF_VARCHAR2_TABLE_100;

472: Status_Tab JTF_NUMBER_TABLE;
473: reqtype_Tab JTF_VARCHAR2_TABLE_100;
474: updatedt_Tab JTF_DATE_TABLE;
475: refcode_Tab JTF_VARCHAR2_TABLE_100;
476: o_statusindiv_Tab JTF_VARCHAR2_TABLE_100;
477:
478: txn_mid_Tab txn_mid_TabTyp;
479:
480: -- String and cursors for dynamic PL/SQL

Line 542: txn_id_Tab := JTF_VARCHAR2_TABLE_100();

538: WHERE iby_trans_pcard_v.needsupdt IN ('Y','F')
539: AND iby_trans_pcard_v.ecappid = cin_ecappid;
540:
541: BEGIN
542: txn_id_Tab := JTF_VARCHAR2_TABLE_100();
543: Status_Tab := JTF_NUMBER_TABLE();
544: reqtype_Tab := JTF_VARCHAR2_TABLE_100();
545: updatedt_Tab := JTF_DATE_TABLE();
546: refcode_Tab := JTF_VARCHAR2_TABLE_100();

Line 544: reqtype_Tab := JTF_VARCHAR2_TABLE_100();

540:
541: BEGIN
542: txn_id_Tab := JTF_VARCHAR2_TABLE_100();
543: Status_Tab := JTF_NUMBER_TABLE();
544: reqtype_Tab := JTF_VARCHAR2_TABLE_100();
545: updatedt_Tab := JTF_DATE_TABLE();
546: refcode_Tab := JTF_VARCHAR2_TABLE_100();
547: o_statusindiv_Tab := JTF_VARCHAR2_TABLE_100();
548:

Line 546: refcode_Tab := JTF_VARCHAR2_TABLE_100();

542: txn_id_Tab := JTF_VARCHAR2_TABLE_100();
543: Status_Tab := JTF_NUMBER_TABLE();
544: reqtype_Tab := JTF_VARCHAR2_TABLE_100();
545: updatedt_Tab := JTF_DATE_TABLE();
546: refcode_Tab := JTF_VARCHAR2_TABLE_100();
547: o_statusindiv_Tab := JTF_VARCHAR2_TABLE_100();
548:
549: -- Commented out the below piece of code as extending the tables upfront
550: -- may cause serious performance issues and also mismatch between the number

Line 547: o_statusindiv_Tab := JTF_VARCHAR2_TABLE_100();

543: Status_Tab := JTF_NUMBER_TABLE();
544: reqtype_Tab := JTF_VARCHAR2_TABLE_100();
545: updatedt_Tab := JTF_DATE_TABLE();
546: refcode_Tab := JTF_VARCHAR2_TABLE_100();
547: o_statusindiv_Tab := JTF_VARCHAR2_TABLE_100();
548:
549: -- Commented out the below piece of code as extending the tables upfront
550: -- may cause serious performance issues and also mismatch between the number
551: -- of columns initialized in the pl/sql table and the actual values sent

Line 778: i_errCode_arr IN JTF_VARCHAR2_TABLE_100,

774: procedure update_trxn_status( i_unchanged_status IN NUMBER,
775: i_numTrxns IN NUMBER,
776: i_status_arr IN JTF_NUMBER_TABLE,
777: i_errLoc_arr IN JTF_NUMBER_TABLE,
778: i_errCode_arr IN JTF_VARCHAR2_TABLE_100,
779: i_errMsg_arr IN JTF_VARCHAR2_TABLE_300,
780: i_tangibleId_arr IN JTF_VARCHAR2_TABLE_100,
781: i_trxnMId_arr IN JTF_NUMBER_TABLE,
782: i_srvrId_arr IN JTF_VARCHAR2_TABLE_100,

Line 780: i_tangibleId_arr IN JTF_VARCHAR2_TABLE_100,

776: i_status_arr IN JTF_NUMBER_TABLE,
777: i_errLoc_arr IN JTF_NUMBER_TABLE,
778: i_errCode_arr IN JTF_VARCHAR2_TABLE_100,
779: i_errMsg_arr IN JTF_VARCHAR2_TABLE_300,
780: i_tangibleId_arr IN JTF_VARCHAR2_TABLE_100,
781: i_trxnMId_arr IN JTF_NUMBER_TABLE,
782: i_srvrId_arr IN JTF_VARCHAR2_TABLE_100,
783: i_refCode_arr IN JTF_VARCHAR2_TABLE_100,
784: i_auxMsg_arr IN JTF_VARCHAR2_TABLE_300,

Line 782: i_srvrId_arr IN JTF_VARCHAR2_TABLE_100,

778: i_errCode_arr IN JTF_VARCHAR2_TABLE_100,
779: i_errMsg_arr IN JTF_VARCHAR2_TABLE_300,
780: i_tangibleId_arr IN JTF_VARCHAR2_TABLE_100,
781: i_trxnMId_arr IN JTF_NUMBER_TABLE,
782: i_srvrId_arr IN JTF_VARCHAR2_TABLE_100,
783: i_refCode_arr IN JTF_VARCHAR2_TABLE_100,
784: i_auxMsg_arr IN JTF_VARCHAR2_TABLE_300,
785: i_fee_arr IN JTF_NUMBER_TABLE,
786: o_status_arr OUT NOCOPY JTF_NUMBER_TABLE,

Line 783: i_refCode_arr IN JTF_VARCHAR2_TABLE_100,

779: i_errMsg_arr IN JTF_VARCHAR2_TABLE_300,
780: i_tangibleId_arr IN JTF_VARCHAR2_TABLE_100,
781: i_trxnMId_arr IN JTF_NUMBER_TABLE,
782: i_srvrId_arr IN JTF_VARCHAR2_TABLE_100,
783: i_refCode_arr IN JTF_VARCHAR2_TABLE_100,
784: i_auxMsg_arr IN JTF_VARCHAR2_TABLE_300,
785: i_fee_arr IN JTF_NUMBER_TABLE,
786: o_status_arr OUT NOCOPY JTF_NUMBER_TABLE,
787: o_error_code OUT NOCOPY NUMBER,