3065: l_txn_usage NUMBER;
3066: l_instance_id NUMBER;
3067: l_reason_id NUMBER;
3068: l_usage_time NUMBER;
3069: l_hour_um sy_uoms_mst.um_code%TYPE;
3070: l_rsrc_txn_rec gme_resource_txns%ROWTYPE;
3071:
3072:
3073: --Rishi Varma B3856541 02-09-2004
3562: l_usage_time NUMBER;
3563: l_inv_trans_count NUMBER;
3564: l_line_id NUMBER;
3565: l_rsrc_trans_count NUMBER;
3566: l_hour_um sy_uoms_mst.um_code%TYPE;
3567: l_trans_date DATE;
3568: l_rsrc_txn_rec gme_resource_txns%ROWTYPE;
3569:
3570: --siva added following variables