APPS.WSM_LBJ_INTERFACE_PVT dependencies on WSM_COPY_OP_NETWORKS

Line 2828: from wsm_copy_op_networks

2824: exit when (l_fm_op IS NULL);
2825: BEGIN
2826: select 1
2827: into l_xst
2828: from wsm_copy_op_networks
2829: where wip_entity_id = p_wip_entity_id
2830: and from_op_seq_num = l_fm_op
2831: and to_op_seq_num = l_to_op;
2832: EXCEPTION

Line 15132: from wsm_copy_op_networks

15128: c_wip_entity_id number,
15129: c_end_op_seq_num number) is
15130: select from_op_seq_num,
15131: to_op_seq_num
15132: from wsm_copy_op_networks
15133: start with (to_op_seq_num = c_end_op_seq_num and
15134: recommended = 'Y' and
15135: wip_entity_id = c_wip_entity_id)
15136: connect by (to_op_seq_num = prior from_op_seq_num and

Line 16282: delete wsm_copy_op_networks

16278: v_wljdi_substitution_type(l_d) in (WSM_SUB_ADD,WSM_SUB_DEL) )
16279: loop
16280: if v_wljdi_substitution_type(l_d) = WSM_SUB_DEL then
16281:
16282: delete wsm_copy_op_networks
16283: where wip_entity_id= p_wip_entity_id
16284: and from_op_seq_num= v_wljdi_routing_op_seq_num(l_d)
16285: and to_op_seq_num = v_wljdi_next_rtg_op_seq_num(l_d);
16286:

Line 16296: from wsm_copy_op_networks

16292: end if;
16293: else /* This is for substitution_type add. */
16294: begin
16295: select 1 into l_link_exists
16296: from wsm_copy_op_networks
16297: where wip_entity_id = p_wip_entity_id and
16298: from_op_seq_num = v_wljdi_routing_op_seq_num(l_d) and
16299: to_op_seq_num = v_wljdi_next_rtg_op_seq_num(l_d);
16300: exception

Line 16344: insert into wsm_copy_op_networks(

16340: p_error_code := - 1;
16341: raise e_wljdi_common_error;
16342: end;
16343:
16344: insert into wsm_copy_op_networks(
16345: wip_entity_id,
16346: from_op_seq_num,
16347: to_op_seq_num,
16348: from_op_seq_id,

Line 16505: update wsm_copy_op_networks

16501: l_v_links(l_to_op).from_op_seq_num := l_fm_op;
16502: l_v_links(l_to_op).to_op_seq_num := l_to_op;
16503: l_path_changed := true;
16504: end if;*/
16505: update wsm_copy_op_networks
16506: set recommended = decode(l_sub_type,WSM_SUB_DIS,'N',
16507: WSM_SUB_REC,'Y',
16508: WSM_SUB_CHG,'Y',recommended),
16509: last_update_date = p_last_updt_date,

Line 16612: update wsm_copy_op_networks

16608: -- Lot Based Job Form to infinte schedule a job if he chooses to
16609:
16610: l_stmt_num := 70.1;
16611: -- reset WCON
16612: update wsm_copy_op_networks
16613: set recommended = 'N',
16614: last_update_date = p_last_updt_date,
16615: last_updated_by = p_last_updt_by,
16616: last_update_login = p_last_updt_login,

Line 16627: update wsm_copy_op_networks

16623: l_stmt_num := 70.2;
16624: -- update WCON
16625: if(l_v_fm_ops.count <> 0) then
16626: forall i in l_v_fm_ops.first..l_v_fm_ops.last
16627: update wsm_copy_op_networks
16628: set recommended = 'Y',
16629: last_update_date = p_last_updt_date,
16630: last_updated_by = p_last_updt_by,
16631: last_update_login = p_last_updt_login,

Line 16987: from wsm_copy_op_networks

16983: select 1
16984: into l_temp
16985: from dual
16986: where exists ( select 1
16987: from wsm_copy_op_networks
16988: where wip_entity_id = p_wip_entity_id
16989: and from_op_seq_num = l_rtg_op_seq_num
16990: UNION ALL
16991: select 1

Line 16992: from wsm_copy_op_networks

16988: where wip_entity_id = p_wip_entity_id
16989: and from_op_seq_num = l_rtg_op_seq_num
16990: UNION ALL
16991: select 1
16992: from wsm_copy_op_networks
16993: where wip_entity_id = p_wip_entity_id
16994: and to_op_seq_num = l_rtg_op_seq_num);
16995:
16996: if l_temp=1 THEN

Line 20614: from wsm_copy_op_networks

20610: cursor the_path_cur is (
20611: select from_op_seq_num,
20612: from_op_seq_id,
20613: level
20614: from wsm_copy_op_networks
20615: start with (to_op_seq_num = l_rtg_op_seq_num0 and
20616: recommended = 'Y' and
20617: wip_entity_id = p_wip_entity_id)
20618: connect by (to_op_seq_num = prior from_op_seq_num and