APPS.MSC_CL_GMP_UTILITY dependencies on MSC_ST_NET_RESOURCE_AVAIL

Line 14140: INSERT INTO msc_st_net_resource_avail

14136: p_to_time IN NUMBER ) IS
14137: BEGIN
14138: stmt_no := 31;
14139: /* Call Unavail_rsrc_proc */
14140: INSERT INTO msc_st_net_resource_avail
14141: ( organization_id,
14142: sr_instance_id,
14143: resource_id,
14144: department_id,

Line 15772: INSERT INTO msc_st_net_resource_avail

15768:
15769: IF ((p_usage = 'APS') OR (p_usage = 'BASED')) THEN /* Usage APS/BASED */
15770:
15771: FORALL i IN resource_id.FIRST..resource_id.LAST
15772: INSERT INTO msc_st_net_resource_avail
15773: ( organization_id,
15774: sr_instance_id,
15775: resource_id,
15776: department_id,

Line 15857: INSERT INTO msc_st_net_resource_avail

15853:
15854: IF ((p_usage = 'APS') OR (p_usage = 'BASED')) THEN /* Usage APS/BASED */
15855:
15856: FORALL i IN resource_id.FIRST..resource_id.LAST
15857: INSERT INTO msc_st_net_resource_avail
15858: ( organization_id,
15859: sr_instance_id,
15860: resource_id,
15861: department_id,

Line 16525: || ' FROM msc_st_net_resource_avail '

16521: || ' lead(capacity_units,1) '
16522: || ' over(order by organization_id,simulation_set,'
16523: || ' resource_id,shift_date, shift_num,from_time,to_time,capacity_units) '
16524: || ' as lead_rc '
16525: || ' FROM msc_st_net_resource_avail '
16526: || ' WHERE sr_instance_id = :inst_id '
16527: || ' ) net '
16528: || ' WHERE net.resource_id = net.lead_rid '
16529: || ' AND net.organization_id = net.lead_iid '

Line 16549: sqlstmt := ' DELETE FROM msc_st_net_resource_avail '

16545: LOOP
16546: FETCH ri_assembly INTO interval_record_aps;
16547: EXIT WHEN ri_assembly%NOTFOUND;
16548:
16549: sqlstmt := ' DELETE FROM msc_st_net_resource_avail '
16550: || ' WHERE organization_id = :org_id '
16551: || ' AND simulation_set = :sim_set '
16552: || ' AND sr_instance_id = :inst_id '
16553: || ' AND resource_id = :prid '

Line 16594: upd_res_avl := 'UPDATE msc_st_net_resource_avail '

16590: CLOSE ri_assembly;
16591:
16592: stmt_no := 79;
16593: upd_res_avl := null ;
16594: upd_res_avl := 'UPDATE msc_st_net_resource_avail '
16595: ||' SET to_time = 86400 '
16596: ||' WHERE to_time = 86399 '
16597: ||' AND shift_num >= 99999 ' ;
16598:

Line 16603: upd_res_avl := 'UPDATE msc_st_net_resource_avail '

16599: EXECUTE immediate upd_res_avl;
16600:
16601: stmt_no := 80;
16602: upd_res_avl := null ;
16603: upd_res_avl := 'UPDATE msc_st_net_resource_avail '
16604: ||' SET shift_num = (shift_num - 99999) '
16605: ||' WHERE shift_num >= 99999 ' ;
16606:
16607: EXECUTE immediate upd_res_avl;