6172: x_err_msg OUT NOCOPY VARCHAR2)
6173: RETURN NUMBER IS
6174:
6175: type network_links IS record (
6176: operation wsm_copy_op_networks.from_op_seq_num%type,
6177: prev_op wsm_copy_op_networks.from_op_seq_num%type,
6178: prev_op_rec_flag wsm_copy_op_networks.recommended%type,
6179: next_op wsm_copy_op_networks.to_op_seq_num%type,
6180: next_op_rec_flag wsm_copy_op_networks.recommended%type);
6173: RETURN NUMBER IS
6174:
6175: type network_links IS record (
6176: operation wsm_copy_op_networks.from_op_seq_num%type,
6177: prev_op wsm_copy_op_networks.from_op_seq_num%type,
6178: prev_op_rec_flag wsm_copy_op_networks.recommended%type,
6179: next_op wsm_copy_op_networks.to_op_seq_num%type,
6180: next_op_rec_flag wsm_copy_op_networks.recommended%type);
6181:
6174:
6175: type network_links IS record (
6176: operation wsm_copy_op_networks.from_op_seq_num%type,
6177: prev_op wsm_copy_op_networks.from_op_seq_num%type,
6178: prev_op_rec_flag wsm_copy_op_networks.recommended%type,
6179: next_op wsm_copy_op_networks.to_op_seq_num%type,
6180: next_op_rec_flag wsm_copy_op_networks.recommended%type);
6181:
6182: type t_network_links is table of network_links index by binary_integer;
6175: type network_links IS record (
6176: operation wsm_copy_op_networks.from_op_seq_num%type,
6177: prev_op wsm_copy_op_networks.from_op_seq_num%type,
6178: prev_op_rec_flag wsm_copy_op_networks.recommended%type,
6179: next_op wsm_copy_op_networks.to_op_seq_num%type,
6180: next_op_rec_flag wsm_copy_op_networks.recommended%type);
6181:
6182: type t_network_links is table of network_links index by binary_integer;
6183: v_network_links t_network_links;
6176: operation wsm_copy_op_networks.from_op_seq_num%type,
6177: prev_op wsm_copy_op_networks.from_op_seq_num%type,
6178: prev_op_rec_flag wsm_copy_op_networks.recommended%type,
6179: next_op wsm_copy_op_networks.to_op_seq_num%type,
6180: next_op_rec_flag wsm_copy_op_networks.recommended%type);
6181:
6182: type t_network_links is table of network_links index by binary_integer;
6183: v_network_links t_network_links;
6184:
6199: FROM
6200: (SELECT from_op_seq_num op_seq,
6201: to_op_seq_num next_op,
6202: recommended next_op_reco
6203: FROM wsm_copy_op_networks
6204: WHERE wip_entity_id = p_wip_entity_id) a
6205: FULL OUTER JOIN
6206: (SELECT to_op_seq_num op_seq,
6207: from_op_seq_num prev_seq,
6205: FULL OUTER JOIN
6206: (SELECT to_op_seq_num op_seq,
6207: from_op_seq_num prev_seq,
6208: recommended prev_op_reco
6209: FROM wsm_copy_op_networks
6210: WHERE wip_entity_id = p_wip_entity_id) b
6211: ON a.op_seq = b.op_seq
6212: ORDER BY 1,4;
6213: