APPS.WIP_DISCRETE_JOBS_BRU dependencies on WIP_CONSTANTS

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

56: wip_scheduling_exceptions when the job status is changed
57: to complete/cancelled/closed */
58:
59: if ( :new.status_type in
60: (WIP_CONSTANTS.COMP_CHRG,WIP_CONSTANTS.CANCELLED,WIP_CONSTANTS.CLOSED)
61: and :old.status_type not in
62: (WIP_CONSTANTS.COMP_CHRG,WIP_CONSTANTS.CANCELLED,WIP_CONSTANTS.CLOSED))
63: then
64: delete from wip_scheduling_exceptions

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

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