APPS.MSC_CL_GMP_UTILITY dependencies on MSC_ST_NET_RES_INST_AVAIL

Line 1273: TYPE serial_number IS TABLE OF msc_st_net_res_inst_avail.serial_number%TYPE

1269:
1270: f_date date_idx_tbl;
1271: t_date date_idx_tbl;
1272:
1273: TYPE serial_number IS TABLE OF msc_st_net_res_inst_avail.serial_number%TYPE
1274: INDEX BY BINARY_INTEGER;
1275: emp_serial_number serial_number;
1276: msc_serial_number serial_number;
1277:

Line 16610: /* Final rows for msc_st_net_res_inst_avail */

16606:
16607: EXECUTE immediate upd_res_avl;
16608: COMMIT ;
16609:
16610: /* Final rows for msc_st_net_res_inst_avail */
16611: stmt_no := 81;
16612: inst_resavl := null;
16613:
16614: inst_resavl := ' SELECT '

Line 16676: || ' FROM msc_st_net_res_inst_avail '

16672: || ' lead(to_time,1) '
16673: || ' over(order by organization_id,Department_id,resource_id,res_instance_id, '
16674: || ' equipment_item_id,serial_number, shift_date,shift_num,from_time,to_time) '
16675: || ' as lead_tt '
16676: || ' FROM msc_st_net_res_inst_avail '
16677: || ' WHERE sr_instance_id = :inst_id '
16678: || ' ) net '
16679: || ' WHERE '
16680: || ' net.organization_id = net.lead_iid '

Line 16705: sqlstmt := ' DELETE FROM msc_st_net_res_inst_avail '

16701: LOOP
16702: FETCH r_inst_assembly INTO inst_record_aps;
16703: EXIT WHEN r_inst_assembly%NOTFOUND;
16704:
16705: sqlstmt := ' DELETE FROM msc_st_net_res_inst_avail '
16706: || ' WHERE organization_id = :org_id '
16707: || ' AND Department_id = :dept_id '
16708: || ' AND sr_instance_id = :inst_id '
16709: || ' AND resource_id = :prid '

Line 16734: INSERT INTO msc_st_net_res_inst_avail

16730: inst_record_aps.to_time ;
16731:
16732: stmt_no := 84;
16733:
16734: INSERT INTO msc_st_net_res_inst_avail
16735: ( Organization_Id,
16736: Department_id,
16737: sr_instance_id,
16738: Resource_Id,

Line 16766: sqlstmt := 'UPDATE msc_st_net_res_inst_avail '

16762: CLOSE r_inst_assembly;
16763:
16764: stmt_no := 85;
16765: sqlstmt := null ;
16766: sqlstmt := 'UPDATE msc_st_net_res_inst_avail '
16767: ||' SET to_time = 86400 '
16768: ||' WHERE to_time = 86399 '
16769: ||' AND shift_num >= 99999 ' ;
16770:

Line 16774: sqlstmt := 'UPDATE msc_st_net_res_inst_avail '

16770:
16771: EXECUTE immediate sqlstmt;
16772: sqlstmt := null ;
16773: stmt_no := 86;
16774: sqlstmt := 'UPDATE msc_st_net_res_inst_avail '
16775: ||' SET shift_num = (shift_num - 99999) '
16776: ||' WHERE shift_num >= 99999 ' ;
16777:
16778: EXECUTE immediate sqlstmt;

Line 17661: INSERT INTO msc_st_net_res_inst_avail

17657: IF ((p_usage = 'APS') OR (p_usage = 'BASED')) THEN /* Usage APS/BASED */
17658:
17659: FORALL i IN resource_id.FIRST..resource_id.LAST
17660:
17661: INSERT INTO msc_st_net_res_inst_avail
17662: ( Organization_Id,
17663: Department_id,
17664: sr_instance_id ,
17665: Resource_Id,

Line 17747: INSERT INTO msc_st_net_res_inst_avail

17743:
17744: IF ((p_usage = 'APS') OR (p_usage = 'BASED')) THEN /* Usage APS/BASED */
17745:
17746: FORALL i IN resource_id.FIRST..resource_id.LAST
17747: INSERT INTO msc_st_net_res_inst_avail
17748: ( Organization_Id,
17749: Department_id,
17750: sr_instance_id ,
17751: Resource_Id,