APPS.AHL_OPERATIONS_APPROVAL_PVT SQL Statements

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

Line: 13

SELECT full_name FROM AHL_JTF_RS_EMP_V WHERE  USER_NAME=p_username;

Line: 54

  select OPERATION_ID,CONCATENATED_SEGMENTS SEGMENT
  from ahl_OPERATIONS_b_KFV
  where OPERATION_ID=c_OPERATION_ID;

Line: 264

  select OPERATION_ID,CONCATENATED_SEGMENTS SEGMENT
  from ahl_OPERATIONS_b_KFV
  where OPERATION_ID=c_OPERATION_ID;

Line: 383

  select OPERATION_ID,CONCATENATED_SEGMENTS SEGMENT
  from ahl_OPERATIONS_b_KFV
  where OPERATION_ID=c_OPERATION_ID;

Line: 501

  select OPERATION_ID,CONCATENATED_SEGMENTS SEGMENT
  from ahl_OPERATIONS_b_KFV
  where OPERATION_ID=c_OPERATION_ID;

Line: 608

  select OPERATION_ID,CONCATENATED_SEGMENTS SEGMENT
  from ahl_OPERATIONS_b_KFV
  where OPERATION_ID=c_OPERATION_ID;

Line: 726

  select OPERATION_ID,CONCATENATED_SEGMENTS SEGMENT
  from ahl_OPERATIONS_b_KFV
  where OPERATION_ID=c_OPERATION_ID;

Line: 854

  select OPERATION_ID,CONCATENATED_SEGMENTS SEGMENT
  from ahl_OPERATIONS_b_KFV
  where OPERATION_ID=c_OPERATION_ID;

Line: 979

  select OPERATION_ID,CONCATENATED_SEGMENTS SEGMENT
  from ahl_OPERATIONS_b_KFV
  where OPERATION_ID=c_OPERATION_ID;

Line: 1077

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: 1093

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

Line: 1114

  select OPERATION_ID,CONCATENATED_SEGMENTS SEGMENT
  from ahl_OPERATIONS_b_KFV
  where OPERATION_ID=c_OPERATION_ID;

Line: 1123

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

Line: 1130

                          ,aname    => 'UPDATE_GEN_STATUS'
                        );

Line: 1133

		  AHL_DEBUG_PUB.debug( 'Update Status After Getitemattrtext','+DebugWfOper+');

Line: 1242

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

Line: 1253

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

Line: 1262

END Update_Status;

Line: 1282

  select OPERATION_ID,CONCATENATED_SEGMENTS SEGMENT
  from ahl_OPERATIONS_b_KFV
  where OPERATION_ID=c_OPERATION_ID;

Line: 1316

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