APPS.AHL_ROUTE_APPROVAL_PVT SQL Statements

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

Line: 28

  Select route_id,
	route_no,
	Start_date_active,
	end_date_Active
  From ahl_routes_app_v
  Where route_id=c_route_id;

Line: 261

  select route_id,route_no,Start_date_active,end_date_Active
  from ahl_routes_app_v
  where route_id=c_route_id;

Line: 378

  select route_id,route_no,Start_date_active,end_date_active
  from ahl_routes_app_v
  where route_id=c_route_id;

Line: 489

  select route_id,route_no,Start_date_active,End_date_active
  from ahl_routes_app_v
  where route_id=c_route_id;

Line: 606

  select route_id,route_no,Start_date_active,end_date_active
  from ahl_routes_app_v
  where route_id=c_route_id;

Line: 723

  select route_id,route_no,Start_date_active,end_date_active
  from ahl_routes_app_v
  where route_id=c_route_id;

Line: 846

  select route_id,route_no,Start_date_Active,end_date_active
  from ahl_routes_app_v
  where route_id=c_route_id;

Line: 972

  select route_id,route_no,Start_date_active,end_date_active
  from ahl_routes_app_v
  where route_id=c_route_id;

Line: 1071

PROCEDURE Update_Status(
   itemtype    IN       VARCHAR2
  ,itemkey     IN       VARCHAR2
  ,actid       IN       NUMBER
  ,funcmode    IN       VARCHAR2
  ,resultout   OUT NOCOPY      VARCHAR2)
IS

l_error_msg                VARCHAR2(4000);

Line: 1089

 l_api_name     CONSTANT VARCHAR2(30) := 'Update_Status';

Line: 1109

  select route_id,route_no,Start_date_active,end_date_active,revision_status_code
  from ahl_routes_app_v
  where route_id=c_route_id;

Line: 1116

		  AHL_DEBUG_PUB.debug( 'Start UpdateStatus','+DebugWfRoute+');

Line: 1123

                          ,aname    => 'UPDATE_GEN_STATUS'
                        );

Line: 1126

		  AHL_DEBUG_PUB.debug( 'After GetItemAttrText UpdateStatus','+DebugWfRoute+');

Line: 1232

		  AHL_DEBUG_PUB.debug( 'Error G_exec UpdateSatus:'||sqlerrm,'+DebugWfRoute+');

Line: 1247

      wf_core.context('AHL_FMP_APRV_PVT','UPDATE_STATUS',
                      itemtype,itemkey,actid,funcmode,l_error_msg);

Line: 1253

		  AHL_DEBUG_PUB.debug( 'UpdateStatus Whenothers Err:'||sqlerrm,'+DebugWfRoute+');

Line: 1259

       ,'Update_Status'
       ,itemtype
       ,itemkey
       ,actid
       ,funcmode
       ,'Unexpected Error!'
     );

Line: 1268

END Update_Status;

Line: 1287

  select route_id,route_no,Start_date_active,end_date_active,revision_status_code
  from ahl_routes_app_v
  where route_id=c_route_id;

Line: 1327

              UPDATE AHL_ROUTES_B
                SET REVISION_STATUS_CODE = 'DRAFT',
                    object_version_number =l_object_version_number+1
              WHERE route_id = l_object_id
              and   object_Version_number=l_object_version_number;

Line: 1333

              UPDATE AHL_ROUTES_B
                SET REVISION_STATUS_CODE = 'COMPLETE',
                    object_version_number =l_object_version_number+1
              WHERE route_id = l_object_id
              and   object_Version_number=l_object_version_number;