APPS.MSC_CL_GMP_UTILITY dependencies on MSC_ST_NET_RES_INST_AVAIL

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

1289:
1290: f_date date_idx_tbl;
1291: t_date date_idx_tbl;
1292:
1293: TYPE serial_number IS TABLE OF msc_st_net_res_inst_avail.serial_number%TYPE
1294: INDEX BY BINARY_INTEGER;
1295: emp_serial_number serial_number;
1296: msc_serial_number serial_number;
1297:

Line 17447: /* Final rows for msc_st_net_res_inst_avail */

17443:
17444: EXECUTE immediate upd_res_avl;
17445: COMMIT ;
17446:
17447: /* Final rows for msc_st_net_res_inst_avail */
17448: stmt_no := 81;
17449: inst_resavl := null;
17450:
17451: inst_resavl := ' SELECT '

Line 17513: || ' FROM msc_st_net_res_inst_avail '

17509: || ' lead(to_time,1) '
17510: || ' over(order by organization_id,Department_id,resource_id,res_instance_id, '
17511: || ' equipment_item_id,serial_number, shift_date,shift_num,from_time,to_time) '
17512: || ' as lead_tt '
17513: || ' FROM msc_st_net_res_inst_avail '
17514: || ' WHERE sr_instance_id = :inst_id '
17515: || ' ) net '
17516: || ' WHERE '
17517: || ' net.organization_id = net.lead_iid '

Line 17542: sqlstmt := ' DELETE FROM msc_st_net_res_inst_avail '

17538: LOOP
17539: FETCH r_inst_assembly INTO inst_record_aps;
17540: EXIT WHEN r_inst_assembly%NOTFOUND;
17541:
17542: sqlstmt := ' DELETE FROM msc_st_net_res_inst_avail '
17543: || ' WHERE organization_id = :org_id '
17544: || ' AND Department_id = :dept_id '
17545: || ' AND sr_instance_id = :inst_id '
17546: || ' AND resource_id = :prid '

Line 17571: INSERT INTO msc_st_net_res_inst_avail

17567: inst_record_aps.to_time ;
17568:
17569: stmt_no := 84;
17570:
17571: INSERT INTO msc_st_net_res_inst_avail
17572: ( Organization_Id,
17573: Department_id,
17574: sr_instance_id,
17575: Resource_Id,

Line 17606: sqlstmt := 'UPDATE msc_st_net_res_inst_avail '

17602: /* Bug: 6030499 of conditionalised code */
17603:
17604: stmt_no := 85;
17605: sqlstmt := null ;
17606: sqlstmt := 'UPDATE msc_st_net_res_inst_avail '
17607: ||' SET to_time = 86400 '
17608: ||' WHERE to_time = 86399 '
17609: ||' AND shift_num >= 99999 ' ;
17610:

Line 17614: sqlstmt := 'UPDATE msc_st_net_res_inst_avail '

17610:
17611: EXECUTE immediate sqlstmt;
17612: sqlstmt := null ;
17613: stmt_no := 86;
17614: sqlstmt := 'UPDATE msc_st_net_res_inst_avail '
17615: ||' SET shift_num = (shift_num - 99999) '
17616: ||' WHERE shift_num >= 99999 ' ;
17617:
17618: EXECUTE immediate sqlstmt;

Line 18520: INSERT INTO msc_st_net_res_inst_avail

18516: IF collect_ps_data THEN
18517:
18518: FORALL i IN resource_id.FIRST..resource_id.LAST
18519:
18520: INSERT INTO msc_st_net_res_inst_avail
18521: ( Organization_Id,
18522: Department_id,
18523: sr_instance_id ,
18524: Resource_Id,

Line 18615: INSERT INTO msc_st_net_res_inst_avail

18611: /* bug: 6030499 conditionalising the following code */
18612: IF collect_ps_data THEN
18613:
18614: FORALL i IN resource_id.FIRST..resource_id.LAST
18615: INSERT INTO msc_st_net_res_inst_avail
18616: ( Organization_Id,
18617: Department_id,
18618: sr_instance_id ,
18619: Resource_Id,