APPS.AHL_RM_RT_OPER_PANEL_PVT SQL Statements

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

Line: 9

G_LAST_UPDATE_DATE 	DATE 		:= SYSDATE;

Line: 10

G_LAST_UPDATED_BY 	NUMBER(15) 	:= FND_GLOBAL.user_id;

Line: 11

G_LAST_UPDATE_LOGIN 	NUMBER(15) 	:= FND_GLOBAL.login_id;

Line: 290

SELECT  panel_type_id,
        attribute_category,
        attribute1,
        attribute2,
        attribute3,
        attribute4,
        attribute5,
        attribute6,
        attribute7,
        attribute8,
        attribute9,
        attribute10,
        attribute11,
        attribute12,
        attribute13,
        attribute14,
        attribute15
FROM    AHL_RT_OPER_ACCESS_PANELS
WHERE   rt_oper_panel_id = c_rt_oper_panel_id;

Line: 520

SELECT   panel_type_id,
         panel_type
FROM     AHL_RT_OPER_ACCESS_PANELS_V
WHERE    object_id = c_object_id
AND      association_type_code = c_association_type_code
GROUP BY panel_type_id,
         panel_type
HAVING   count(*) > 1;

Line: 577

select revision_status_code
from ahl_routes_app_v
where route_id = p_route_id;

Line: 585

select revision_status_code
from ahl_operations_b
where operation_id = p_operation_id;

Line: 786

		-- Update route status from APPROVAL_REJECTED to DRAFT
  		OPEN get_oper_status (p_object_id);

Line: 791

			UPDATE ahl_operations_b
			SET revision_status_code = 'DRAFT'
			WHERE operation_id = p_object_id;

Line: 817

		-- Update route status from APPROVAL_REJECTED to DRAFT
  		OPEN get_route_status (p_object_id);

Line: 822

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

Line: 844

        INSERT INTO AHL_RT_OPER_ACCESS_PANELS
        (
          rt_oper_panel_id,
          OBJECT_VERSION_NUMBER,
          LAST_UPDATE_DATE,
          LAST_UPDATED_BY,
          CREATION_DATE,
          CREATED_BY,
          LAST_UPDATE_LOGIN,
          association_type_code,
          object_ID,
          panel_type_id,
          ATTRIBUTE_CATEGORY,
          ATTRIBUTE1,
          ATTRIBUTE2,
          ATTRIBUTE3,
          ATTRIBUTE4,
          ATTRIBUTE5,
          ATTRIBUTE6,
          ATTRIBUTE7,
          ATTRIBUTE8,
          ATTRIBUTE9,
          ATTRIBUTE10,
          ATTRIBUTE11,
          ATTRIBUTE12,
          ATTRIBUTE13,
          ATTRIBUTE14,
          ATTRIBUTE15
        ) VALUES
        (
          AHL_RT_OPER_ACCESS_PANELS_S.NEXTVAL,
          1,
          G_LAST_UPDATE_DATE,
          G_LAST_UPDATED_BY,
          G_CREATION_DATE,
          G_CREATED_BY,
          G_LAST_UPDATE_LOGIN,
          p_association_type_code,
          p_object_id,
          p_x_rt_oper_panel_tbl(i).panel_type_id,
          p_x_rt_oper_panel_tbl(i).attribute_category,
          p_x_rt_oper_panel_tbl(i).attribute1,
          p_x_rt_oper_panel_tbl(i).attribute2,
          p_x_rt_oper_panel_tbl(i).attribute3,
          p_x_rt_oper_panel_tbl(i).attribute4,
          p_x_rt_oper_panel_tbl(i).attribute5,
          p_x_rt_oper_panel_tbl(i).attribute6,
          p_x_rt_oper_panel_tbl(i).attribute7,
          p_x_rt_oper_panel_tbl(i).attribute8,
          p_x_rt_oper_panel_tbl(i).attribute9,
          p_x_rt_oper_panel_tbl(i).attribute10,
          p_x_rt_oper_panel_tbl(i).attribute11,
          p_x_rt_oper_panel_tbl(i).attribute12,
          p_x_rt_oper_panel_tbl(i).attribute13,
          p_x_rt_oper_panel_tbl(i).attribute14,
          p_x_rt_oper_panel_tbl(i).attribute15
        ) RETURNING rt_oper_panel_id INTO l_rt_oper_panel_id;

Line: 917

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

Line: 927

        UPDATE AHL_RT_OPER_ACCESS_PANELS SET
          object_version_number   = object_version_number + 1,
          last_update_date        = G_LAST_UPDATE_DATE,
          last_updated_by         = G_LAST_UPDATED_BY,
          last_update_login       = G_LAST_UPDATE_LOGIN,
          panel_type_id           = p_x_rt_oper_panel_tbl(i).panel_type_id,
          attribute_category      = p_x_rt_oper_panel_tbl(i).attribute_category,
          attribute1              = p_x_rt_oper_panel_tbl(i).attribute1,
          attribute2              = p_x_rt_oper_panel_tbl(i).attribute2,
          attribute3              = p_x_rt_oper_panel_tbl(i).attribute3,
          attribute4              = p_x_rt_oper_panel_tbl(i).attribute4,
          attribute5              = p_x_rt_oper_panel_tbl(i).attribute5,
          attribute6              = p_x_rt_oper_panel_tbl(i).attribute6,
          attribute7              = p_x_rt_oper_panel_tbl(i).attribute7,
          attribute8              = p_x_rt_oper_panel_tbl(i).attribute8,
          attribute9              = p_x_rt_oper_panel_tbl(i).attribute9,
          attribute10             = p_x_rt_oper_panel_tbl(i).attribute10,
          attribute11             = p_x_rt_oper_panel_tbl(i).attribute11,
          attribute12             = p_x_rt_oper_panel_tbl(i).attribute12,
          attribute13             = p_x_rt_oper_panel_tbl(i).attribute13,
          attribute14             = p_x_rt_oper_panel_tbl(i).attribute14,
          attribute15             = p_x_rt_oper_panel_tbl(i).attribute15
        WHERE rt_oper_panel_id = p_x_rt_oper_panel_tbl(i).rt_oper_panel_id
        AND object_version_number = p_x_rt_oper_panel_tbl(i).object_version_number;

Line: 974

			'AHL_RT_OPER_ACCESS_PANELS update error = ['||SQLERRM||']'
		);

Line: 983

      DELETE FROM AHL_RT_OPER_ACCESS_PANELS
      WHERE rt_oper_panel_id = p_x_rt_oper_panel_tbl(i).rt_oper_panel_id
      AND object_version_number = p_x_rt_oper_panel_tbl(i).object_version_number;