APPS.EAM_WO_COMP_VALIDATE_PVT dependencies on WIP_CONSTANTS

Line 808: AND wdj.status_type NOT IN (WIP_CONSTANTS.COMP_CHRG,

804: FROM wip_discrete_jobs wdj, wip_entities we
805: WHERE wdj.wip_entity_id = we.wip_entity_id
806: AND wdj.parent_wip_entity_id = p_eam_wo_comp_rec.wip_entity_id
807: AND wdj.manual_rebuild_flag = 'Y'
808: AND wdj.status_type NOT IN (WIP_CONSTANTS.COMP_CHRG,
809: WIP_CONSTANTS.COMP_NOCHRG,WIP_CONSTANTS.CLOSED));
810:
811: if (child_job_var = '1') then
812: raise fnd_api.g_exc_unexpected_error;

Line 809: WIP_CONSTANTS.COMP_NOCHRG,WIP_CONSTANTS.CLOSED));

805: WHERE wdj.wip_entity_id = we.wip_entity_id
806: AND wdj.parent_wip_entity_id = p_eam_wo_comp_rec.wip_entity_id
807: AND wdj.manual_rebuild_flag = 'Y'
808: AND wdj.status_type NOT IN (WIP_CONSTANTS.COMP_CHRG,
809: WIP_CONSTANTS.COMP_NOCHRG,WIP_CONSTANTS.CLOSED));
810:
811: if (child_job_var = '1') then
812: raise fnd_api.g_exc_unexpected_error;
813: end if;

Line 886: AND status_type NOT IN (WIP_CONSTANTS.COMP_CHRG,

882: WHERE parent_relationship_type =1
883: START WITH parent_object_id = p_eam_wo_comp_rec.wip_entity_id AND parent_relationship_type = 1
884: CONNECT BY parent_object_id = prior child_object_id AND parent_relationship_type = 1
885: )
886: AND status_type NOT IN (WIP_CONSTANTS.COMP_CHRG,
887: WIP_CONSTANTS.COMP_NOCHRG,WIP_CONSTANTS.CLOSED, WIP_CONSTANTS.CANCELLED )
888:
889: );
890:

Line 887: WIP_CONSTANTS.COMP_NOCHRG,WIP_CONSTANTS.CLOSED, WIP_CONSTANTS.CANCELLED )

883: START WITH parent_object_id = p_eam_wo_comp_rec.wip_entity_id AND parent_relationship_type = 1
884: CONNECT BY parent_object_id = prior child_object_id AND parent_relationship_type = 1
885: )
886: AND status_type NOT IN (WIP_CONSTANTS.COMP_CHRG,
887: WIP_CONSTANTS.COMP_NOCHRG,WIP_CONSTANTS.CLOSED, WIP_CONSTANTS.CANCELLED )
888:
889: );
890:
891: if (network_child_job_var = '1') then --In the network Work Order has Uncompleted Child Work Orders

Line 934: AND status_type NOT IN (WIP_CONSTANTS.COMP_CHRG,

930: FROM eam_wo_relationships
931: WHERE parent_relationship_type =2 and
932: child_object_id = p_eam_wo_comp_rec.wip_entity_id
933: )
934: AND status_type NOT IN (WIP_CONSTANTS.COMP_CHRG,
935: WIP_CONSTANTS.COMP_NOCHRG,WIP_CONSTANTS.CLOSED)
936: );
937:
938: IF (sibling_parent_job_var = '1') THEN

Line 935: WIP_CONSTANTS.COMP_NOCHRG,WIP_CONSTANTS.CLOSED)

931: WHERE parent_relationship_type =2 and
932: child_object_id = p_eam_wo_comp_rec.wip_entity_id
933: )
934: AND status_type NOT IN (WIP_CONSTANTS.COMP_CHRG,
935: WIP_CONSTANTS.COMP_NOCHRG,WIP_CONSTANTS.CLOSED)
936: );
937:
938: IF (sibling_parent_job_var = '1') THEN
939: raise fnd_api.g_exc_unexpected_error;

Line 979: IF(l_parent_status_type = WIP_CONSTANTS.COMP_CHRG) THEN

975: INTO l_parent_status_type
976: FROM WIP_DISCRETE_JOBS
977: WHERE wip_entity_id = l_parent_wip_entity_id;
978:
979: IF(l_parent_status_type = WIP_CONSTANTS.COMP_CHRG) THEN
980: raise fnd_api.g_exc_unexpected_error;
981: END IF;
982:
983: END IF;