APPS.PA_UTILS_SQNUM_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 38

    SELECT  NEXT_UNIQUE_IDENTIFIER
    INTO    PL_DUMMY
    FROM    PA_UNIQUE_IDENTIFIER_CONTROL
    WHERE   TABLE_NAME = x_table_name
    AND     NEXT_UNIQUE_IDENTIFIER IS NOT NULL
    FOR UPDATE OF NEXT_UNIQUE_IDENTIFIER;

Line: 45

    SELECT  NEXT_UNIQUE_IDENTIFIER
    INTO    uniqueid
    FROM    PA_UNIQUE_IDENTIFIER_CONTROL
    WHERE   TABLE_NAME = x_table_name
    AND     NEXT_UNIQUE_IDENTIFIER IS NOT NULL
    FOR UPDATE OF NEXT_UNIQUE_IDENTIFIER;

Line: 52

    UPDATE  PA_UNIQUE_IDENTIFIER_CONTROL
    SET     NEXT_UNIQUE_IDENTIFIER = NEXT_UNIQUE_IDENTIFIER + 1,
            LAST_UPDATED_BY        = user_id,
            LAST_UPDATE_DATE       = trunc(SYSDATE)
    WHERE   TABLE_NAME             = x_table_name
    AND     NEXT_UNIQUE_IDENTIFIER IS NOT NULL;

Line: 108

    SELECT  decode(invoice_category, 'EXTERNAL-INVOICE',NEXT_AUTOMATIC_INVOICE_NUMBER,
                                     CC_NEXT_AUTOMATIC_INVOICE_NUM)
    INTO    PL_DUMMY
    FROM    PA_IMPLEMENTATIONS
    FOR UPDATE OF NEXT_AUTOMATIC_INVOICE_NUMBER,CC_NEXT_AUTOMATIC_INVOICE_NUM;

Line: 114

    SELECT  decode(invoice_category, 'EXTERNAL-INVOICE',NEXT_AUTOMATIC_INVOICE_NUMBER,
                                    CC_NEXT_AUTOMATIC_INVOICE_NUM)
    INTO    uniqueid
    FROM    PA_IMPLEMENTATIONS;

Line: 119

    UPDATE  PA_IMPLEMENTATIONS
    SET     NEXT_AUTOMATIC_INVOICE_NUMBER = decode(invoice_category,
                                                     'EXTERNAL-INVOICE',NEXT_AUTOMATIC_INVOICE_NUMBER + 1,
                                                     NEXT_AUTOMATIC_INVOICE_NUMBER),
         CC_NEXT_AUTOMATIC_INVOICE_NUM = decode(invoice_category,
                                                     'EXTERNAL-INVOICE',CC_NEXT_AUTOMATIC_INVOICE_NUM ,
                                                     CC_NEXT_AUTOMATIC_INVOICE_NUM+1),
            LAST_UPDATED_BY        = user_id,
            LAST_UPDATE_DATE       = trunc(SYSDATE);

Line: 165

    UPDATE  PA_UNIQUE_IDENTIFIER_CONTROL
    SET     NEXT_UNIQUE_IDENTIFIER = p_unique_number,
            LAST_UPDATED_BY        = p_user_id,
            LAST_UPDATE_DATE       = trunc(SYSDATE)
    WHERE   TABLE_NAME             = p_table_name
    AND     NEXT_UNIQUE_IDENTIFIER IS NOT NULL
    AND     NEXT_UNIQUE_IDENTIFIER = p_unique_number + 1 ;