65: EXCEPTION WHEN NO_DATA_FOUND THEN
66: P_MATERIAL_ISSUED := WIP_CONSTANTS.NO;
67: END;
68:
69: -- Check for MTL_MATERIAL_TRANSACTIONS_TEMP
70:
71: BEGIN
72:
73: SELECT WIP_CONSTANTS.YES
73: SELECT WIP_CONSTANTS.YES
74: INTO P_MTL_TXNS_TEMP
75: FROM DUAL
76: WHERE EXISTS (SELECT 1
77: FROM MTL_MATERIAL_TRANSACTIONS_TEMP
78: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
79: AND TRANSACTION_SOURCE_ID = P_WIP_ENTITY_ID
80: AND TRANSACTION_SOURCE_TYPE_ID = 5);
81:
90: SELECT WIP_CONSTANTS.YES
91: INTO P_UNCOSTED_MTL_TXNS
92: FROM DUAL
93: WHERE EXISTS (SELECT 1
94: FROM MTL_MATERIAL_TRANSACTIONS
95: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
96: AND TRANSACTION_SOURCE_ID = P_WIP_ENTITY_ID
97: AND COSTED_FLAG IN ('N','E')
98: AND TRANSACTION_SOURCE_TYPE_ID = 5);