APPS.MRP_PRINT_PK SQL Statements

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

Line: 7

    UPDATE  mrp_messages_tmp
    SET     end_date = SYSDATE,
            row_count = arg_row_count
    WHERE   request_id = arg_request_id
      AND   transaction_id = arg_transaction_id;

Line: 47

    SELECT  mrp_messages_tmp_s.nextval
    INTO    var_transaction_id
    FROM    dual;

Line: 51

    INSERT INTO mrp_messages_tmp
                (transaction_id,
                request_id,
                last_update_date,
                last_updated_by,
                creation_date,
                created_by,
                last_update_login,
                message_name,
                start_date,
                end_date,
                token1,
                token_value1,
                translate_token1,
                token2,
                token_value2,
                translate_token2,
                row_count)
    VALUES      (var_transaction_id,
                arg_request_id,
                SYSDATE,
                arg_user_id,
                SYSDATE,
                arg_user_id,
                -1,
                arg_message_name,
                SYSDATE,
                NULL,
                arg_token1,
                arg_token_value1,
                DECODE(arg_translate1, 'Y', SYS_YES, SYS_NO),
                arg_token2,
                arg_token_value2,
                DECODE(arg_translate2, 'Y', SYS_YES, SYS_NO),
                0);

Line: 135

    DELETE FROM     mrp_messages_tmp
    WHERE           request_id = arg_request_id;