DBA Data[Home] [Help]

APPS.WSMPUTIL dependencies on WSM_COPY_OP_NETWORKS

Line 6176: operation wsm_copy_op_networks.from_op_seq_num%type,

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);

Line 6177: prev_op wsm_copy_op_networks.from_op_seq_num%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:

Line 6178: prev_op_rec_flag wsm_copy_op_networks.recommended%type,

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;

Line 6179: next_op wsm_copy_op_networks.to_op_seq_num%type,

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;

Line 6180: next_op_rec_flag wsm_copy_op_networks.recommended%type);

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:

Line 6203: FROM wsm_copy_op_networks

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,

Line 6209: FROM wsm_copy_op_networks

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: