APPS.AHL_FMP_MR_APPROVAL_PVT SQL Statements

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

Line: 30

  Select mr_header_id,
	 title,
	 effective_from,
	 Version_number,
         mr_status_code
  from ahl_mr_headers_b
  where mr_header_id=c_mr_header_id;

Line: 330

  Select mr_header_id,
	 title,
	 effective_from,
         effective_to,
	 Version_number
  from ahl_mr_headers_b
  where mr_header_id=c_mr_header_id;

Line: 461

  select mr_header_id,title,effective_from,VERSION_NUMBER
  from ahl_mr_headers_b
  where mr_header_id=c_mr_header_id;

Line: 581

  select mr_header_id,title,effective_from,version_number
  from ahl_mr_headers_b
  where mr_header_id=c_mr_header_id;

Line: 707

  select mr_header_id,title,effective_from,VERSION_NUMBER
  from ahl_mr_headers_b
  where mr_header_id=c_mr_header_id;

Line: 832

  select mr_header_id,title,effective_from,version_number
  from ahl_mr_headers_b
  where mr_header_id=c_mr_header_id;

Line: 958

  select mr_header_id,title,effective_from,version_number
  from ahl_mr_headers_b
  where mr_header_id=c_mr_header_id;

Line: 1080

  select mr_header_id,title,effective_from,VERSION_NUMBER
  from ahl_mr_headers_b
  where mr_header_id=c_mr_header_id;

Line: 1179

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

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

Line: 1214

	  AHL_DEBUG_PUB.debug( 'Start Update Status API','+UPDATE_STATUS+');

Line: 1221

                          ,aname    => 'UPDATE_GEN_STATUS'
                        );

Line: 1271

	  AHL_DEBUG_PUB.debug( 'After complete Update Status');

Line: 1306

        AHL_DEBUG_PUB.debug( ' Error in workflow:'||sqlerrm||'Update_status');

Line: 1322

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

Line: 1331

             AHL_DEBUG_PUB.debug( ' Error ...2..'||sqlerrm||'<--From-->UPDATE_STATUS');

Line: 1336

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

Line: 1348

END Update_Status;

Line: 1368

  select mr_header_id,title,effective_from
  from ahl_mr_headers_b
  where mr_header_id=c_mr_header_id;

Line: 1404

     UPDATE AHL_MR_HEADERS_B
        SET MR_STATUS_CODE = 'DRAFT',
            object_version_number =l_object_version_number+1
      WHERE mr_header_id = l_object_id
      and   object_Version_number=l_object_version_number;