Create procedure compiled with warning
(
P_NOTIFICATION_ID NUMBER,
P_SOURCE_CODE VARCHAR2,
P_SOURCE_LINE_ID NUMBER,
P_ORGANIZATION_CODE VARCHAR2,
P_WIP_ENTITY_NAME VARCHAR2 )
IS
LV_PROCESSED_OK NUMBER;
LV_HAS_ERROR NUMBER;
LV_TRANSACTION_ID NUMBER;
LV_TXN_STATUS VARCHAR2(2);
BEGIN
SELECT DECODE(MAX(PROCESS_STATUS),3,'E',NULL,'P','R'),
DECODE(COUNT(*),0,1,0)
INTO LV_TXN_STATUS, LV_PROCESSED_OK
FROM
WIP_MOVE_TXN_INTERFACE
WHERE
SOURCE_CODE = P_SOURCE_CODE
AND ORGANIZATION_CODE = P_ORGANIZATION_CODE
AND SOURCE_LINE_ID = P_SOURCE_LINE_ID
AND PROCESS_PHASE IN (1,2);
IF (LV_TXN_STATUS = 'R') THEN