Database Administration (MOSC)

MOSC Banner

Create procedure compiled with warning

edited Dec 17, 2012 4:42AM in Database Administration (MOSC) 3 commentsAnswered
CREATE OR REPLACE PROCEDURE SV_CHECK_MOVE_PROC
(
        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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center