DBA Data[Home] [Help]

APPS.WIP_CLOSE_UTILITIES dependencies on WIP_DJ_CLOSE_TEMP

Line 84: WIP_DJ_CLOSE_TEMP WDCT

80: DECLARE CURSOR C1 IS
81: SELECT WDCT.STATUS_TYPE,
82: WDCT.rowid
83: FROM WIP_DISCRETE_JOBS WDJ,
84: WIP_DJ_CLOSE_TEMP WDCT
85: WHERE WDCT.WIP_ENTITY_ID = P_wip_entity_id
86: AND WDCT.ORGANIZATION_ID = P_organization_id
87: AND WDJ.WIP_ENTITY_ID = WDCT.WIP_ENTITY_ID
88: AND WDJ.STATUS_TYPE = WIP_CONSTANTS.PEND_CLOSE;

Line 100: DELETE FROM WIP_DJ_CLOSE_TEMP

96: CLOSE C1;
97: return(0);
98: END IF;
99:
100: DELETE FROM WIP_DJ_CLOSE_TEMP
101: WHERE ROWID = rid;
102:
103: CLOSE C1;
104: return(old_status);