DBA Data[Home] [Help]

APPS.WSMPUTIL dependencies on WSM_COPY_OP_NETWORKS

Line 6179: operation wsm_copy_op_networks.from_op_seq_num%type,

6175: x_err_msg OUT NOCOPY VARCHAR2)
6176: RETURN NUMBER IS
6177:
6178: type network_links IS record (
6179: operation wsm_copy_op_networks.from_op_seq_num%type,
6180: prev_op wsm_copy_op_networks.from_op_seq_num%type,
6181: prev_op_rec_flag wsm_copy_op_networks.recommended%type,
6182: next_op wsm_copy_op_networks.to_op_seq_num%type,
6183: next_op_rec_flag wsm_copy_op_networks.recommended%type);

Line 6180: prev_op wsm_copy_op_networks.from_op_seq_num%type,

6176: RETURN NUMBER IS
6177:
6178: type network_links IS record (
6179: operation wsm_copy_op_networks.from_op_seq_num%type,
6180: prev_op wsm_copy_op_networks.from_op_seq_num%type,
6181: prev_op_rec_flag wsm_copy_op_networks.recommended%type,
6182: next_op wsm_copy_op_networks.to_op_seq_num%type,
6183: next_op_rec_flag wsm_copy_op_networks.recommended%type);
6184:

Line 6181: prev_op_rec_flag wsm_copy_op_networks.recommended%type,

6177:
6178: type network_links IS record (
6179: operation wsm_copy_op_networks.from_op_seq_num%type,
6180: prev_op wsm_copy_op_networks.from_op_seq_num%type,
6181: prev_op_rec_flag wsm_copy_op_networks.recommended%type,
6182: next_op wsm_copy_op_networks.to_op_seq_num%type,
6183: next_op_rec_flag wsm_copy_op_networks.recommended%type);
6184:
6185: type t_network_links is table of network_links index by binary_integer;

Line 6182: next_op wsm_copy_op_networks.to_op_seq_num%type,

6178: type network_links IS record (
6179: operation wsm_copy_op_networks.from_op_seq_num%type,
6180: prev_op wsm_copy_op_networks.from_op_seq_num%type,
6181: prev_op_rec_flag wsm_copy_op_networks.recommended%type,
6182: next_op wsm_copy_op_networks.to_op_seq_num%type,
6183: next_op_rec_flag wsm_copy_op_networks.recommended%type);
6184:
6185: type t_network_links is table of network_links index by binary_integer;
6186: v_network_links t_network_links;

Line 6183: next_op_rec_flag wsm_copy_op_networks.recommended%type);

6179: operation wsm_copy_op_networks.from_op_seq_num%type,
6180: prev_op wsm_copy_op_networks.from_op_seq_num%type,
6181: prev_op_rec_flag wsm_copy_op_networks.recommended%type,
6182: next_op wsm_copy_op_networks.to_op_seq_num%type,
6183: next_op_rec_flag wsm_copy_op_networks.recommended%type);
6184:
6185: type t_network_links is table of network_links index by binary_integer;
6186: v_network_links t_network_links;
6187:

Line 6206: FROM wsm_copy_op_networks

6202: FROM
6203: (SELECT from_op_seq_num op_seq,
6204: to_op_seq_num next_op,
6205: recommended next_op_reco
6206: FROM wsm_copy_op_networks
6207: WHERE wip_entity_id = p_wip_entity_id) a
6208: FULL OUTER JOIN
6209: (SELECT to_op_seq_num op_seq,
6210: from_op_seq_num prev_seq,

Line 6212: FROM wsm_copy_op_networks

6208: FULL OUTER JOIN
6209: (SELECT to_op_seq_num op_seq,
6210: from_op_seq_num prev_seq,
6211: recommended prev_op_reco
6212: FROM wsm_copy_op_networks
6213: WHERE wip_entity_id = p_wip_entity_id) b
6214: ON a.op_seq = b.op_seq
6215: ORDER BY 1,4;
6216: