APPS.EAM_OPERATIONS_JSP dependencies on DUAL

Line 2919: --This procedure is not called in R12.This was added to maintain dual check in between R12->R12.1

2915:
2916: END insert_into_wro;
2917:
2918: --Start of bug 12631479
2919: --This procedure is not called in R12.This was added to maintain dual check in between R12->R12.1
2920: PROCEDURE insert_into_wro(
2921: p_api_version IN NUMBER
2922: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2923: ,p_commit IN VARCHAR2 := fnd_api.g_false

Line 4301: dual

4297: -- check Prior/Next Operation conflict with the modified Start and End Date .
4298: select
4299: count(*) into l_restrict_date_change
4300: from
4301: dual
4302: where
4303: exists
4304: (select '1' from eam_prior_operations_v
4305: where next_operation = p_from_operation

Line 4311: from dual

4307: and wip_entity_id = p_wip_entity_id);
4308:
4309: if(l_restrict_date_change = 0) then
4310: select count(*) into l_restrict_date_change
4311: from dual
4312: where
4313: exists
4314: (select '1' from eam_next_operations_v
4315: where prior_operation = p_from_operation

Line 4347: dual

4343: -- check Prior/Next Operation conflict with the modified Start and End Date .
4344: select
4345: count(*) into l_restrict_date_change
4346: from
4347: dual
4348: where
4349: exists
4350: (select '1' from eam_prior_operations_v
4351: where next_operation = p_to_operation

Line 4357: from dual

4353: and wip_entity_id = p_wip_entity_id);
4354:
4355: if(l_restrict_date_change = 0) then
4356: select count(*) into l_restrict_date_change
4357: from dual
4358: where
4359: exists
4360: (select '1' from eam_next_operations_v
4361: where prior_operation = p_to_operation

Line 4396: from dual

4392: end if;
4393:
4394: -- check for loop in the dependency network
4395: select count(1) into l_loop_available
4396: from dual
4397: where
4398: p_from_operation in (select next_operation
4399: from (select * from wip_operation_networks
4400: where next_operation <> p_to_operation and