APPS.EAM_REQUEST_VALIDATE_PVT dependencies on WIP_CONSTANTS

Line 222: WHERE wdj.STATUS_TYPE IN (WIP_CONSTANTS.DRAFT,WIP_CONSTANTS.UNRELEASED,WIP_CONSTANTS.RELEASED,

218: begin
219: SELECT 1
220: INTO g_dummy
221: FROM WIP_DISCRETE_JOBS wdj
222: WHERE wdj.STATUS_TYPE IN (WIP_CONSTANTS.DRAFT,WIP_CONSTANTS.UNRELEASED,WIP_CONSTANTS.RELEASED,
223: WIP_CONSTANTS.HOLD,WIP_CONSTANTS.COMP_CHRG,WIP_CONSTANTS.COMP_NOCHRG)
224: AND wdj.wip_entity_id = p_eam_request_rec.wip_entity_id ;
225:
226: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 223: WIP_CONSTANTS.HOLD,WIP_CONSTANTS.COMP_CHRG,WIP_CONSTANTS.COMP_NOCHRG)

219: SELECT 1
220: INTO g_dummy
221: FROM WIP_DISCRETE_JOBS wdj
222: WHERE wdj.STATUS_TYPE IN (WIP_CONSTANTS.DRAFT,WIP_CONSTANTS.UNRELEASED,WIP_CONSTANTS.RELEASED,
223: WIP_CONSTANTS.HOLD,WIP_CONSTANTS.COMP_CHRG,WIP_CONSTANTS.COMP_NOCHRG)
224: AND wdj.wip_entity_id = p_eam_request_rec.wip_entity_id ;
225:
226: x_return_status := FND_API.G_RET_STS_SUCCESS;
227: exception

Line 253: WHERE wdj.STATUS_TYPE IN (WIP_CONSTANTS.DRAFT,WIP_CONSTANTS.UNRELEASED,WIP_CONSTANTS.RELEASED,

249: begin
250: SELECT 1
251: INTO g_dummy
252: FROM WIP_DISCRETE_JOBS wdj
253: WHERE wdj.STATUS_TYPE IN (WIP_CONSTANTS.DRAFT,WIP_CONSTANTS.UNRELEASED,WIP_CONSTANTS.RELEASED,
254: WIP_CONSTANTS.HOLD,WIP_CONSTANTS.COMP_CHRG,WIP_CONSTANTS.COMP_NOCHRG)
255: AND wdj.wip_entity_id = p_eam_request_rec.wip_entity_id ;
256:
257: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 254: WIP_CONSTANTS.HOLD,WIP_CONSTANTS.COMP_CHRG,WIP_CONSTANTS.COMP_NOCHRG)

250: SELECT 1
251: INTO g_dummy
252: FROM WIP_DISCRETE_JOBS wdj
253: WHERE wdj.STATUS_TYPE IN (WIP_CONSTANTS.DRAFT,WIP_CONSTANTS.UNRELEASED,WIP_CONSTANTS.RELEASED,
254: WIP_CONSTANTS.HOLD,WIP_CONSTANTS.COMP_CHRG,WIP_CONSTANTS.COMP_NOCHRG)
255: AND wdj.wip_entity_id = p_eam_request_rec.wip_entity_id ;
256:
257: x_return_status := FND_API.G_RET_STS_SUCCESS;
258: