[Home] [Help]
148: EXCEPTION WHEN NO_DATA_FOUND THEN
149: P_MOVE_TXN_INTERFACE := WIP_CONSTANTS.NO;
150: END;
151:
152: -- Check for WIP_COST_TXN_INTERFACE
153:
154: BEGIN
155:
156: SELECT WIP_CONSTANTS.YES
156: SELECT WIP_CONSTANTS.YES
157: INTO P_COST_TXN_INTERFACE
158: FROM DUAL
159: WHERE EXISTS (SELECT 1
160: FROM WIP_COST_TXN_INTERFACE
161: WHERE WIP_ENTITY_ID = P_WIP_ENTITY_ID
162: AND ORGANIZATION_ID = P_ORGANIZATION_ID);
163:
164: EXCEPTION WHEN NO_DATA_FOUND THEN