APPS.WIP_OPERATION_VALIDATE dependencies on WIP_OPERATIONS

Line 368: wip_operations wo

364: and organization_id = p_organization_id
365: and department_id is not null
366: and exists (select 1
367: from wip_operation_resources wor,
368: wip_operations wo
369: where wo.wip_entity_id = wjdi.wip_entity_id
370: and wo.operation_seq_num = wjdi.operation_seq_num
371: and wo.organization_id = wjdi.organization_id
372: and wo.wip_entity_id = wor.wip_entity_id

Line 413: wip_operations wo

409: and organization_id = p_organization_id
410: and department_id is not null
411: and exists (select 1
412: from wip_operation_resources wor,
413: wip_operations wo
414: where wo.wip_entity_id = wjdi.wip_entity_id
415: and wo.operation_seq_num = wjdi.operation_seq_num
416: and wo.organization_id = wjdi.organization_id
417: and wo.wip_entity_id = wor.wip_entity_id

Line 693: CHECK THAT NO RECORDS EXIST IN WIP_OPERATIONS TABLE WITH THE GIVEN

689:
690:
691:
692: /*****************************************************************
693: CHECK THAT NO RECORDS EXIST IN WIP_OPERATIONS TABLE WITH THE GIVEN
694: WIP_ENTITY_ID, ORGANIZATION_ID AND OPERATION_SEQ_NUM.
695: *****************************************************************/
696: procedure val_add_op_seq_num(p_group_id in number,
697: p_wip_entity_id in number,

Line 711: from wip_operations

707: and substitution_type = wip_job_details.wip_add
708: and wip_entity_id = p_wip_entity_id
709: and organization_id = p_organization_id
710: and (exists (select 1
711: from wip_operations
712: where wip_entity_id = wjdi.wip_entity_id
713: and organization_id = wjdi.organization_id
714: and operation_seq_num = wjdi.operation_seq_num) or
715: operation_seq_num <= 0);

Line 753: from wip_operations

749: wip_constants.warning)
750: and wip_entity_id = p_wip_entity_id
751: and organization_id = p_organization_id
752: and (exists (select 1
753: from wip_operations
754: where wip_entity_id = wjdi.wip_entity_id
755: and organization_id = wjdi.organization_id
756: and operation_seq_num = wjdi.operation_seq_num)
757: or operation_seq_num <= 0);

Line 910: CHECK THAT A RECORD EXISTS IN WIP_OPERATIONS TABLE WITH THE GIVEN

906:
907:
908:
909: /*****************************************************************
910: CHECK THAT A RECORD EXISTS IN WIP_OPERATIONS TABLE WITH THE GIVEN
911: WIP_ENTITY_ID, ORGANIZATION_ID AND OPERATION_SEQ_NUM.
912: *****************************************************************/
913: procedure val_change_op_seq_num(p_group_id in number,
914: p_wip_entity_id in number,

Line 927: from wip_operations

923: and load_type = wip_job_details.wip_operation
924: and substitution_type = wip_job_details.wip_change
925: and wip_entity_id = p_wip_entity_id
926: and not exists (select 1
927: from wip_operations
928: where wip_entity_id = wjdi.wip_entity_id
929: and organization_id = wjdi.organization_id
930: and operation_seq_num = wjdi.operation_seq_num);
931:

Line 959: from wip_operations

955: and process_status in (wip_constants.running,
956: wip_constants.warning)
957: and wip_entity_id = p_wip_entity_id
958: and not exists (select 1
959: from wip_operations
960: where wip_entity_id = wjdi.wip_entity_id
961: and organization_id = wjdi.organization_id
962: and operation_seq_num = wjdi.operation_seq_num);
963: end if;

Line 990: from wip_operations wo

986: or wjdi.first_unit_completion_date is not null
987: or wjdi.last_unit_completion_date is not null
988: )
989: and exists (select 1
990: from wip_operations wo
991: where (
992: /* bug#3669728 begin */
993: (nvl(wjdi.first_unit_start_date, wo.first_unit_start_date)) >
994: (nvl(wjdi.last_unit_start_date, wo.last_unit_start_date))

Line 1045: from wip_operations wo

1041: or wjdi.first_unit_completion_date is not null
1042: or wjdi.last_unit_completion_date is not null
1043: )
1044: and exists (select 1
1045: from wip_operations wo
1046: where (
1047: /* bug#3669728 begin */
1048: (nvl(wjdi.first_unit_start_date, wo.first_unit_start_date)) >
1049: (nvl(wjdi.last_unit_start_date, wo.last_unit_start_date))