APPS.MRP_RHX_RESOURCE_AVAILABILITY dependencies on MRP_NET_RESOURCE_AVAIL

Line 44: UPDATE mrp_net_resource_avail

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

Line 58: DELETE from mrp_net_resource_avail

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

Line 100: INSERT into mrp_net_resource_avail(

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

Line 188: FROM mrp_net_resource_avail

184: DECODE(LEAST(to_time, from_time),
185: to_time, to_time + 24*3600,
186: to_time) to_time,
187: rowid
188: FROM mrp_net_resource_avail
189: WHERE department_id = arg_department_id
190: AND resource_id = arg_resource_id
191: AND simulation_set = arg_simulation_set
192: AND organization_id = arg_organization_id

Line 205: insert into mrp_net_resource_avail(

201: ORDER BY 2, 3;
202: begin
203: var_gt_user_id := fnd_global.user_id;
204: if arg_24hr_flag = 2 THEN
205: insert into mrp_net_resource_avail(
206: organization_id,
207: department_id,
208: resource_id,
209: shift_num,

Line 261: insert into mrp_net_resource_avail(

257: AND changes.shift_num = dates.shift_num
258: AND changes.from_date = dates.shift_date
259: AND changes.action_type = DELETE_WORKDAY);
260: else
261: insert into mrp_net_resource_avail(
262: organization_id,
263: department_id,
264: resource_id,
265: shift_num,

Line 637: INSERT into mrp_net_resource_avail(

633: close avail;
634: end loop;
635: -- Finally add the availability from the add workday type modifications
636:
637: INSERT into mrp_net_resource_avail(
638: organization_id,
639: department_id,
640: resource_id,
641: shift_num,

Line 693: delete from mrp_net_resource_avail

689: var_cutoff_date DATE;
690: begin
691: var_gt_debug := FND_PROFILE.VALUE('MRP_DEBUG') = 'Y';
692: --dbms_output.enable(100000);
693: delete from mrp_net_resource_avail
694: where organization_id = arg_organization_id
695: and (arg_simulation_set is null or simulation_set = arg_simulation_set);
696:
697: if arg_cutoff_date is null then