APPS.WPS_RES_INSTANCE_AVAILABILITY dependencies on MRP_NET_RESOURCE_AVAIL

Line 43: UPDATE mrp_net_resource_avail

39: if var_time1 < var_from_time then
40: var_date1 := var_date1 + 1;
41: end if;
42:
43: UPDATE mrp_net_resource_avail
44: SET shift_date = var_date1,
45: from_time = var_time1,
46: to_time = var_time2
47: WHERE rowid = var_rowid;

Line 57: DELETE from mrp_net_resource_avail

53: if var_gt_debug then
54: dbms_output.put_line('about to delete');
55: end if;
56: */
57: DELETE from mrp_net_resource_avail
58: WHERE rowid = var_rowid;
59: end delete_avail;
60:
61: procedure insert_avail( var_date in DATE,

Line 101: INSERT into mrp_net_resource_avail(

97: ' to time '|| to_char(var_to_time/3600) ||
98: ' units '|| to_char(var_cap_units));
99: end if;
100: */
101: INSERT into mrp_net_resource_avail(
102: department_id,
103: resource_id,
104: instance_id,
105: serial_number,

Line 212: FROM mrp_net_resource_avail

208: DECODE(LEAST(to_time, from_time),
209: to_time, to_time + 24*3600,
210: to_time) to_time,
211: rowid
212: FROM mrp_net_resource_avail
213: WHERE department_id = arg_department_id
214: AND resource_id = arg_resource_id
215: AND instance_id = arg_instance_id
216: AND nvl(serial_number,-1) = nvl(arg_serial_num, -1)

Line 227: insert into mrp_net_resource_avail(

223: begin
224: var_gt_user_id := fnd_global.user_id;
225:
226: if arg_24hr_flag = 2 THEN
227: insert into mrp_net_resource_avail(
228: organization_id,
229: department_id,
230: resource_id,
231: instance_id,

Line 297: FROM mrp_net_resource_avail

293:
294: -- debug
295: /*
296: select count(*) into var_rowcount
297: FROM mrp_net_resource_avail
298: where resource_id = arg_resource_id
299: and instance_id = arg_instance_id
300: and department_id = arg_department_id;
301:

Line 306: insert into mrp_net_resource_avail(

302: dbms_output.put_line(' Inserted '|| to_char(var_rowcount)||' avails'); */
303:
304:
305: else
306: insert into mrp_net_resource_avail(
307: organization_id,
308: department_id,
309: resource_id,
310: instance_id,

Line 491: INSERT into mrp_net_resource_avail(

487: close changes;
488:
489: -- Finally add the availability from the add workday type modifications
490: -- dbms_output.put_line('going to insert added workdays');
491: INSERT into mrp_net_resource_avail(
492: organization_id,
493: department_id,
494: resource_id,
495: instance_id,