APPS.WIP_EAM_UTILS dependencies on WIP_OPERATIONS

Line 807: FROM WIP_OPERATIONS WO

803:
804: begin
805: SELECT nvl(COUNT(*),0)
806: into l_operation_exist
807: FROM WIP_OPERATIONS WO
808: WHERE WO.WIP_ENTITY_ID = l_wip_entity_id;
809:
810: IF ((l_operation_exist=0)) then
811:

Line 848: insert into wip_operations

844: end if;
845:
846:
847: -- insert
848: insert into wip_operations
849: (
850: wip_entity_id
851: ,operation_seq_num
852: ,organization_id

Line 952: from wip_operations

948:
949: if l_count <> 0 then
950: select min(operation_seq_num)
951: into l_min_op_seq_num
952: from wip_operations
953: where organization_id = p_organization_id and
954: wip_entity_id = p_wip_entity_id;
955:
956: if (l_min_op_seq_num is not null) then

Line 958: from wip_operations

954: wip_entity_id = p_wip_entity_id;
955:
956: if (l_min_op_seq_num is not null) then
957: select department_id into l_department_id
958: from wip_operations
959: where organization_id = p_organization_id and
960: wip_entity_id = p_wip_entity_id
961: and operation_seq_num = l_min_op_seq_num;
962: end if;

Line 984: from wip_operations

980:
981: if l_count <> 0 then
982: select min(operation_seq_num)
983: into l_min_op_seq_num
984: from wip_operations
985: where organization_id = p_organization_id and
986: wip_entity_id = p_wip_entity_id;
987:
988: if (l_min_op_seq_num is not null) then

Line 990: from wip_operations

986: wip_entity_id = p_wip_entity_id;
987:
988: if (l_min_op_seq_num is not null) then
989: select department_id into l_department_id
990: from wip_operations
991: where organization_id = p_organization_id and
992: wip_entity_id = p_wip_entity_id
993: and operation_seq_num = l_min_op_seq_num;
994: end if;