44: return number; -- nonzero if rows were updated.
45:
46: procedure update_trxn_status( i_unchanged_status IN NUMBER,
47: i_numTrxns IN NUMBER,
48: i_status_arr IN JTF_NUMBER_TABLE,
49: i_errLoc_arr IN JTF_NUMBER_TABLE,
50: i_errCode_arr IN JTF_VARCHAR2_TABLE_100,
51: i_errMsg_arr IN JTF_VARCHAR2_TABLE_300,
52: i_tangibleId_arr IN JTF_VARCHAR2_TABLE_100,
45:
46: procedure update_trxn_status( i_unchanged_status IN NUMBER,
47: i_numTrxns IN NUMBER,
48: i_status_arr IN JTF_NUMBER_TABLE,
49: i_errLoc_arr IN JTF_NUMBER_TABLE,
50: i_errCode_arr IN JTF_VARCHAR2_TABLE_100,
51: i_errMsg_arr IN JTF_VARCHAR2_TABLE_300,
52: i_tangibleId_arr IN JTF_VARCHAR2_TABLE_100,
53: i_trxnMId_arr IN JTF_NUMBER_TABLE,
49: i_errLoc_arr IN JTF_NUMBER_TABLE,
50: i_errCode_arr IN JTF_VARCHAR2_TABLE_100,
51: i_errMsg_arr IN JTF_VARCHAR2_TABLE_300,
52: i_tangibleId_arr IN JTF_VARCHAR2_TABLE_100,
53: i_trxnMId_arr IN JTF_NUMBER_TABLE,
54: i_srvrId_arr IN JTF_VARCHAR2_TABLE_100,
55: i_refCode_arr IN JTF_VARCHAR2_TABLE_100,
56: i_auxMsg_arr IN JTF_VARCHAR2_TABLE_300,
57: i_fee_arr IN JTF_NUMBER_TABLE,
53: i_trxnMId_arr IN JTF_NUMBER_TABLE,
54: i_srvrId_arr IN JTF_VARCHAR2_TABLE_100,
55: i_refCode_arr IN JTF_VARCHAR2_TABLE_100,
56: i_auxMsg_arr IN JTF_VARCHAR2_TABLE_300,
57: i_fee_arr IN JTF_NUMBER_TABLE,
58: o_status_arr OUT NOCOPY JTF_NUMBER_TABLE,
59: o_error_code OUT NOCOPY NUMBER,
60: o_error_msg OUT NOCOPY VARCHAR2
61: );
54: i_srvrId_arr IN JTF_VARCHAR2_TABLE_100,
55: i_refCode_arr IN JTF_VARCHAR2_TABLE_100,
56: i_auxMsg_arr IN JTF_VARCHAR2_TABLE_300,
57: i_fee_arr IN JTF_NUMBER_TABLE,
58: o_status_arr OUT NOCOPY JTF_NUMBER_TABLE,
59: o_error_code OUT NOCOPY NUMBER,
60: o_error_msg OUT NOCOPY VARCHAR2
61: );
62: