217: IF p_eam_request_rec.transaction_type = 1 AND p_eam_request_rec.request_type =1 THEN
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:
248: IF p_eam_request_rec.transaction_type = 1 AND p_eam_request_rec.request_type =2 THEN
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: