23: x_return_status := FND_API.G_RET_STS_SUCCESS;
24:
25: select entity_type
26: into l_entityType
27: from wip_entities
28: where wip_entity_id = p_wip_entity_id;
29:
30: if(l_entityType = wip_constants.flow) then --flow schedule
31: return;
116: SAVEPOINT WIP_ISSUE_MATERIAL_START;
117: x_return_status := FND_API.G_RET_STS_SUCCESS;
118: select entity_type
119: into l_entityType
120: from wip_entities
121: where wip_entity_id = p_wip_entity_id;
122:
123: if(l_entityType <> wip_constants.REPETITIVE) then
124: select wdj.status_type
256: x_quantity_allocated := 0;
257:
258: select entity_type
259: into l_entityType
260: from wip_entities
261: where wip_entity_id = p_wip_entity_id;
262: if(l_entityType = wip_constants.flow) then --flow schedule
263: select allocated_flag
264: into l_flow
810: x_return_status := FND_API.G_RET_STS_SUCCESS;
811:
812: select entity_type
813: into l_entityType
814: from wip_entities
815: where wip_entity_id = p_wip_entity_id;
816:
817: If (l_entityType = wip_constants.flow) then
818: Return;
886: x_return_status := FND_API.G_RET_STS_SUCCESS;
887:
888: select entity_type
889: into l_entityType
890: from wip_entities
891: where wip_entity_id = p_wip_entity_id;
892:
893: If (l_entityType = wip_constants.flow) then
894: Return;