APPS.MSC_UPDATE_RESOURCE dependencies on MSC_NET_RES_INST_AVAIL

Line 143: FROM msc_net_res_inst_avail

139: CREATED_BY,
140: LAST_UPDATE_LOGIN,
141: shift_date,
142: shift_num
143: FROM msc_net_res_inst_avail
144: WHERE plan_id=g_plan_id
145: AND organization_id = g_org_id
146: AND sr_instance_id =g_instance_id
147: AND department_id = g_department_id

Line 946: select msc_net_res_inst_avail_s.nextval

942:
943: FUNCTION get_inst_trx_id RETURN NUMBER IS
944: v_trx_id NUMBER;
945: BEGIN
946: select msc_net_res_inst_avail_s.nextval
947: into v_trx_id
948: from dual;
949: return v_trx_id;
950: END;

Line 1008: update msc_net_res_inst_avail

1004: end if;
1005:
1006: if (g_res_inst_set_data) then
1007: For m in 1 .. g_res_inst_tab.LAST LOOP
1008: update msc_net_res_inst_avail
1009: set capacity_units = 0,
1010: status =0,
1011: applied =2
1012: where plan_id = g_plan_id

Line 1113: update msc_net_res_inst_avail

1109: dbms_output.put_line('INSTANCE res-inst trx/shift/from/to/units '||g_res_inst_tab(m).transaction_id
1110: ||' - '||g_shift_number||' - '||g_res_tab(m).from_time||' - '||g_res_tab(m).to_time||' - '|| l_res_inst_units);
1111: */
1112:
1113: update msc_net_res_inst_avail
1114: set capacity_units = l_res_inst_units,
1115: shift_date = g_shift_date,
1116: shift_num = g_shift_number,
1117: from_time = g_res_tab(m).from_time,

Line 1139: insert into msc_net_res_inst_avail (

1135: end if;
1136:
1137: if (sql%rowcount = 0 or m > g_res_inst_tab.last) then
1138: l_res_inst_trx_id := get_inst_trx_id;
1139: insert into msc_net_res_inst_avail (
1140: inst_transaction_id,
1141: last_update_date, last_updated_by, creation_date, created_by, last_update_login,
1142: plan_id, sr_instance_id, organization_id, department_id, resource_id,
1143: res_instance_id, serial_number, shift_num, shift_date,