APPS.AHL_RM_OP_ROUTE_AS_PVT SQL Statements

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

Line: 10

G_LAST_UPDATE_DATE 	DATE 		:= SYSDATE;

Line: 11

G_LAST_UPDATED_BY 	NUMBER(15) 	:= FND_GLOBAL.user_id;

Line: 12

G_LAST_UPDATE_LOGIN 	NUMBER(15) 	:= FND_GLOBAL.login_id;

Line: 291

SELECT  operation_id,
        concatenated_segments,
        step,
        check_point_flag,
        attribute_category,
        attribute1,
        attribute2,
        attribute3,
        attribute4,
        attribute5,
        attribute6,
        attribute7,
        attribute8,
        attribute9,
        attribute10,
        attribute11,
        attribute12,
        attribute13,
        attribute14,
        attribute15
FROM    AHL_ROUTE_OPERATIONS_V
WHERE   route_operation_id = c_route_operation_id;

Line: 522

      SELECT TO_NUMBER( p_route_operation_rec.step, '999999999999999999999999999999' )
      INTO   l_step
      FROM   DUAL;

Line: 575

SELECT          'X'
FROM            AHL_OPERATIONS_B
WHERE           operation_id = c_operation_id
AND             TRUNC( NVL( END_DATE_ACTIVE, SYSDATE + 1 ) ) > TRUNC( SYSDATE );

Line: 641

SELECT   step, concatenated_segments
FROM     AHL_ROUTE_OPERATIONS_V
WHERE    route_id = c_route_id
AND      NVL( end_date_active, SYSDATE + 1 ) > SYSDATE
ORDER BY step, concatenated_segments;

Line: 707

select revision_status_code
from ahl_routes_app_v
where route_id = p_route_id;

Line: 922

  	UPDATE ahl_routes_b
  	SET revision_status_code = 'DRAFT'
  	WHERE route_id = p_route_id;

Line: 940

        INSERT INTO AHL_ROUTE_OPERATIONS
        (
          ROUTE_OPERATION_ID,
          OBJECT_VERSION_NUMBER,
          ROUTE_ID,
          OPERATION_ID,
          STEP,
          CHECK_POINT_FLAG,
          ATTRIBUTE_CATEGORY,
          ATTRIBUTE1,
          ATTRIBUTE2,
          ATTRIBUTE3,
          ATTRIBUTE4,
          ATTRIBUTE5,
          ATTRIBUTE6,
          ATTRIBUTE7,
          ATTRIBUTE8,
          ATTRIBUTE9,
          ATTRIBUTE10,
          ATTRIBUTE11,
          ATTRIBUTE12,
          ATTRIBUTE13,
          ATTRIBUTE14,
          ATTRIBUTE15,
          LAST_UPDATE_DATE,
          LAST_UPDATED_BY,
          CREATION_DATE,
          CREATED_BY,
          LAST_UPDATE_LOGIN
        ) VALUES
        (
          AHL_ROUTE_OPERATIONS_S.NEXTVAL,
          p_x_route_operation_tbl(i).object_version_number,
          p_route_id,
          p_x_route_operation_tbl(i).operation_id,
          p_x_route_operation_tbl(i).step,
          p_x_route_operation_tbl(i).check_point_flag,
          p_x_route_operation_tbl(i).attribute_category,
          p_x_route_operation_tbl(i).attribute1,
          p_x_route_operation_tbl(i).attribute2,
          p_x_route_operation_tbl(i).attribute3,
          p_x_route_operation_tbl(i).attribute4,
          p_x_route_operation_tbl(i).attribute5,
          p_x_route_operation_tbl(i).attribute6,
          p_x_route_operation_tbl(i).attribute7,
          p_x_route_operation_tbl(i).attribute8,
          p_x_route_operation_tbl(i).attribute9,
          p_x_route_operation_tbl(i).attribute10,
          p_x_route_operation_tbl(i).attribute11,
          p_x_route_operation_tbl(i).attribute12,
          p_x_route_operation_tbl(i).attribute13,
          p_x_route_operation_tbl(i).attribute14,
          p_x_route_operation_tbl(i).attribute15,
          G_LAST_UPDATE_DATE,
	  G_LAST_UPDATED_BY,
	  G_CREATION_DATE,
	  G_CREATED_BY,
	  G_LAST_UPDATE_LOGIN
        ) RETURNING route_operation_id INTO l_route_operation_id;

Line: 1006

            FND_MESSAGE.set_token( 'FIELD', 'INSERT : ' || to_char(p_x_route_operation_tbl(i).step) );

Line: 1015

	    			'AHL_OPERATIONS_B insert error = ['||SQLERRM||']'
	    		);

Line: 1027

        UPDATE AHL_ROUTE_OPERATIONS SET
          object_version_number   = object_version_number + 1,
          operation_id            = p_x_route_operation_tbl(i).operation_id,
          step                    = p_x_route_operation_tbl(i).step,
          check_point_flag        = p_x_route_operation_tbl(i).check_point_flag,
          attribute_category      = p_x_route_operation_tbl(i).attribute_category,
          attribute1              = p_x_route_operation_tbl(i).attribute1,
          attribute2              = p_x_route_operation_tbl(i).attribute2,
          attribute3              = p_x_route_operation_tbl(i).attribute3,
          attribute4              = p_x_route_operation_tbl(i).attribute4,
          attribute5              = p_x_route_operation_tbl(i).attribute5,
          attribute6              = p_x_route_operation_tbl(i).attribute6,
          attribute7              = p_x_route_operation_tbl(i).attribute7,
          attribute8              = p_x_route_operation_tbl(i).attribute8,
          attribute9              = p_x_route_operation_tbl(i).attribute9,
          attribute10             = p_x_route_operation_tbl(i).attribute10,
          attribute11             = p_x_route_operation_tbl(i).attribute11,
          attribute12             = p_x_route_operation_tbl(i).attribute12,
          attribute13             = p_x_route_operation_tbl(i).attribute13,
          attribute14             = p_x_route_operation_tbl(i).attribute14,
          attribute15             = p_x_route_operation_tbl(i).attribute15,
          last_update_date        = G_LAST_UPDATE_DATE,
          last_updated_by         = G_LAST_UPDATED_BY,
          last_update_login       = G_LAST_UPDATE_LOGIN
        WHERE route_operation_id   = p_x_route_operation_tbl(i).route_operation_id
        AND object_version_number = p_x_route_operation_tbl(i).object_version_number;

Line: 1077

      DELETE FROM AHL_ROUTE_OPERATIONS
      WHERE route_operation_id   = p_x_route_operation_tbl(i).route_operation_id
      AND object_version_number = p_x_route_operation_tbl(i).object_version_number;