APPS.WIP_DISCRETE_JOBS_BRU dependencies on WIP_CONSTANTS

Line 57: (WIP_CONSTANTS.COMP_CHRG,WIP_CONSTANTS.CANCELLED,WIP_CONSTANTS.CLOSED)

53:
54:
55:
56: if ( :new.status_type in
57: (WIP_CONSTANTS.COMP_CHRG,WIP_CONSTANTS.CANCELLED,WIP_CONSTANTS.CLOSED)
58: and :old.status_type not in
59: (WIP_CONSTANTS.COMP_CHRG,WIP_CONSTANTS.CANCELLED,WIP_CONSTANTS.CLOSED))
60: then
61: delete from wip_scheduling_exceptions

Line 59: (WIP_CONSTANTS.COMP_CHRG,WIP_CONSTANTS.CANCELLED,WIP_CONSTANTS.CLOSED))

55:
56: if ( :new.status_type in
57: (WIP_CONSTANTS.COMP_CHRG,WIP_CONSTANTS.CANCELLED,WIP_CONSTANTS.CLOSED)
58: and :old.status_type not in
59: (WIP_CONSTANTS.COMP_CHRG,WIP_CONSTANTS.CANCELLED,WIP_CONSTANTS.CLOSED))
60: then
61: delete from wip_scheduling_exceptions
62: where wip_entity_id = :new.wip_entity_id
63: and organization_id = :new.organization_id;