APPS.WIP_EAM_UTILS dependencies on WIP_OPERATIONS

Line 820: FROM WIP_OPERATIONS WO

816:
817: begin
818: SELECT nvl(COUNT(*),0)
819: into l_operation_exist
820: FROM WIP_OPERATIONS WO
821: WHERE WO.WIP_ENTITY_ID = l_wip_entity_id;
822:
823: IF ((l_operation_exist=0)) then
824:

Line 861: insert into wip_operations

857: end if;
858:
859:
860: -- insert
861: insert into wip_operations
862: (
863: wip_entity_id
864: ,operation_seq_num
865: ,organization_id

Line 965: from wip_operations

961:
962: if l_count <> 0 then
963: select min(operation_seq_num)
964: into l_min_op_seq_num
965: from wip_operations
966: where organization_id = p_organization_id and
967: wip_entity_id = p_wip_entity_id;
968:
969: if (l_min_op_seq_num is not null) then

Line 971: from wip_operations

967: wip_entity_id = p_wip_entity_id;
968:
969: if (l_min_op_seq_num is not null) then
970: select department_id into l_department_id
971: from wip_operations
972: where organization_id = p_organization_id and
973: wip_entity_id = p_wip_entity_id
974: and operation_seq_num = l_min_op_seq_num;
975: end if;

Line 997: from wip_operations

993:
994: if l_count <> 0 then
995: select min(operation_seq_num)
996: into l_min_op_seq_num
997: from wip_operations
998: where organization_id = p_organization_id and
999: wip_entity_id = p_wip_entity_id;
1000:
1001: if (l_min_op_seq_num is not null) then

Line 1003: from wip_operations

999: wip_entity_id = p_wip_entity_id;
1000:
1001: if (l_min_op_seq_num is not null) then
1002: select department_id into l_department_id
1003: from wip_operations
1004: where organization_id = p_organization_id and
1005: wip_entity_id = p_wip_entity_id
1006: and operation_seq_num = l_min_op_seq_num;
1007: end if;