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;
177: o_statusindiv_Tab JTF_VARCHAR2_TABLE_100;
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();
248: o_statusindiv_Tab := JTF_VARCHAR2_TABLE_100();
425: -- information.
426:
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,
426:
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,
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,
438: i_fee_arr IN JTF_NUMBER_TABLE,
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,
441: o_error_msg OUT NOCOPY VARCHAR2
442: )
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,
441: o_error_msg OUT NOCOPY VARCHAR2
442: )
443: IS
448: c_SUCCESS NUMBER := 0;
449:
450: BEGIN
451:
452: o_status_arr := JTF_NUMBER_TABLE();
453: o_status_arr.extend( i_tangibleId_arr.count );
454:
455: o_error_code := 0;
456: