APPS.WSM_LBJ_INTERFACE_PVT dependencies on WSM_COPY_OP_NETWORKS

Line 2833: from wsm_copy_op_networks

2829: exit when (l_fm_op IS NULL);
2830: BEGIN
2831: select 1
2832: into l_xst
2833: from wsm_copy_op_networks
2834: where wip_entity_id = p_wip_entity_id
2835: and from_op_seq_num = l_fm_op
2836: and to_op_seq_num = l_to_op;
2837: EXCEPTION

Line 15254: from wsm_copy_op_networks

15250: c_wip_entity_id number,
15251: c_end_op_seq_num number) is
15252: select from_op_seq_num,
15253: to_op_seq_num
15254: from wsm_copy_op_networks
15255: start with (to_op_seq_num = c_end_op_seq_num and
15256: recommended = 'Y' and
15257: wip_entity_id = c_wip_entity_id)
15258: connect by (to_op_seq_num = prior from_op_seq_num and

Line 16658: delete wsm_copy_op_networks

16654: v_wljdi_substitution_type(l_d) in (WSM_SUB_ADD,WSM_SUB_DEL) )
16655: loop
16656: if v_wljdi_substitution_type(l_d) = WSM_SUB_DEL then
16657:
16658: delete wsm_copy_op_networks
16659: where wip_entity_id= p_wip_entity_id
16660: and from_op_seq_num= v_wljdi_routing_op_seq_num(l_d)
16661: and to_op_seq_num = v_wljdi_next_rtg_op_seq_num(l_d);
16662:

Line 16672: from wsm_copy_op_networks

16668: end if;
16669: else /* This is for substitution_type add. */
16670: begin
16671: select 1 into l_link_exists
16672: from wsm_copy_op_networks
16673: where wip_entity_id = p_wip_entity_id and
16674: from_op_seq_num = v_wljdi_routing_op_seq_num(l_d) and
16675: to_op_seq_num = v_wljdi_next_rtg_op_seq_num(l_d);
16676: exception

Line 16720: insert into wsm_copy_op_networks(

16716: p_error_code := - 1;
16717: raise e_wljdi_common_error;
16718: end;
16719:
16720: insert into wsm_copy_op_networks(
16721: wip_entity_id,
16722: from_op_seq_num,
16723: to_op_seq_num,
16724: from_op_seq_id,

Line 16883: update wsm_copy_op_networks

16879: l_v_links(l_to_op).from_op_seq_num := l_fm_op;
16880: l_v_links(l_to_op).to_op_seq_num := l_to_op;
16881: l_path_changed := true;
16882: end if;*/
16883: update wsm_copy_op_networks
16884: set recommended = decode(l_sub_type,WSM_SUB_DIS,'N',
16885: WSM_SUB_REC,'Y',
16886: WSM_SUB_CHG,'Y',recommended),
16887: last_update_date = p_last_updt_date,

Line 17006: update wsm_copy_op_networks

17002: -- Lot Based Job Form to infinte schedule a job if he chooses to
17003:
17004: l_stmt_num := 70.1;
17005: -- reset WCON
17006: update wsm_copy_op_networks
17007: set recommended = 'N',
17008: last_update_date = p_last_updt_date,
17009: last_updated_by = p_last_updt_by,
17010: last_update_login = p_last_updt_login,

Line 17021: update wsm_copy_op_networks

17017: l_stmt_num := 70.2;
17018: -- update WCON
17019: if(l_v_fm_ops.count <> 0) then
17020: forall i in l_v_fm_ops.first..l_v_fm_ops.last
17021: update wsm_copy_op_networks
17022: set recommended = 'Y',
17023: last_update_date = p_last_updt_date,
17024: last_updated_by = p_last_updt_by,
17025: last_update_login = p_last_updt_login,

Line 17429: from wsm_copy_op_networks

17425: select 1
17426: into l_temp
17427: from dual
17428: where exists ( select 1
17429: from wsm_copy_op_networks
17430: where wip_entity_id = p_wip_entity_id
17431: and from_op_seq_num = l_rtg_op_seq_num
17432: UNION ALL
17433: select 1

Line 17434: from wsm_copy_op_networks

17430: where wip_entity_id = p_wip_entity_id
17431: and from_op_seq_num = l_rtg_op_seq_num
17432: UNION ALL
17433: select 1
17434: from wsm_copy_op_networks
17435: where wip_entity_id = p_wip_entity_id
17436: and to_op_seq_num = l_rtg_op_seq_num);
17437:
17438: if l_temp=1 THEN

Line 21279: from wsm_copy_op_networks

21275: cursor the_path_cur is (
21276: select from_op_seq_num,
21277: from_op_seq_id,
21278: level
21279: from wsm_copy_op_networks
21280: start with (to_op_seq_num = l_rtg_op_seq_num0 and
21281: recommended = 'Y' and
21282: wip_entity_id = p_wip_entity_id)
21283: connect by (to_op_seq_num = prior from_op_seq_num and