DBA Data[Home] [Help]

APPS.IBY_SCHED dependencies on JTF_NUMBER_TABLE

Line 177: Status_Tab JTF_NUMBER_TABLE;

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;
181: o_statusindiv_Tab JTF_VARCHAR2_TABLE_100;

Line 302: Status_Tab := JTF_NUMBER_TABLE();

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();
306: o_statusindiv_Tab := JTF_VARCHAR2_TABLE_100();

Line 472: Status_Tab JTF_NUMBER_TABLE;

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;
476: o_statusindiv_Tab JTF_VARCHAR2_TABLE_100;

Line 543: Status_Tab := JTF_NUMBER_TABLE();

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();
547: o_statusindiv_Tab := JTF_VARCHAR2_TABLE_100();

Line 776: i_status_arr IN JTF_NUMBER_TABLE,

772: -- information.
773:
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,

Line 777: i_errLoc_arr IN JTF_NUMBER_TABLE,

773:
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,

Line 781: i_trxnMId_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,
785: i_fee_arr IN JTF_NUMBER_TABLE,

Line 785: i_fee_arr IN JTF_NUMBER_TABLE,

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,
788: o_error_msg OUT NOCOPY VARCHAR2
789: )

Line 786: o_status_arr OUT NOCOPY 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,
788: o_error_msg OUT NOCOPY VARCHAR2
789: )
790: IS

Line 799: o_status_arr := JTF_NUMBER_TABLE();

795: c_SUCCESS NUMBER := 0;
796:
797: BEGIN
798:
799: o_status_arr := JTF_NUMBER_TABLE();
800: o_status_arr.extend( i_tangibleId_arr.count );
801:
802: o_error_code := 0;
803: