eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKE_CHG_REQUESTS_PKG SQL Statements

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

Line: 9


    SELECT wf_item_type
    ,      wf_item_key
    FROM   oke_chg_logs
    WHERE  chg_log_id = X_Last_Chg_Log_ID;

Line: 35


procedure INSERT_ROW
( X_ROWID                       in out NOCOPY  VARCHAR2
, X_CHG_REQUEST_ID              in out NOCOPY  NUMBER
, X_CREATION_DATE               in      DATE
, X_CREATED_BY                  in      NUMBER
, X_LAST_UPDATE_DATE            in      DATE
, X_LAST_UPDATED_BY             in      NUMBER
, X_LAST_UPDATE_LOGIN           in      NUMBER
, X_K_HEADER_ID                 in      NUMBER
, X_CHG_REQUEST_NUM             in out NOCOPY  VARCHAR2
, X_CHG_TYPE_CODE               in      VARCHAR2
, X_CHG_STATUS_CODE             in      VARCHAR2
, X_CHG_REASON_CODE             in      VARCHAR2
, X_IMPACT_FUNDING_FLAG         in      VARCHAR2
, X_EFFECTIVE_DATE              in      DATE
, X_REQUESTED_BY_PERSON_ID      in      NUMBER
, X_REQUESTED_DATE              in      DATE
, X_RECEIVE_DATE                in      DATE
, X_APPROVE_DATE                in out NOCOPY  DATE
, X_IMPLEMENT_DATE              in out NOCOPY  DATE
, X_PREV_VERSION                in      NUMBER
, X_NEW_VERSION                 in      NUMBER
, X_DESCRIPTION                 in      VARCHAR2
, X_CHG_TEXT                    in      VARCHAR2
, X_LAST_CHG_LOG_ID             in out NOCOPY  NUMBER
, X_ATTRIBUTE_CATEGORY          in      VARCHAR2
, X_ATTRIBUTE1                  in      VARCHAR2
, X_ATTRIBUTE2                  in      VARCHAR2
, X_ATTRIBUTE3                  in      VARCHAR2
, X_ATTRIBUTE4                  in      VARCHAR2
, X_ATTRIBUTE5                  in      VARCHAR2
, X_ATTRIBUTE6                  in      VARCHAR2
, X_ATTRIBUTE7                  in      VARCHAR2
, X_ATTRIBUTE8                  in      VARCHAR2
, X_ATTRIBUTE9                  in      VARCHAR2
, X_ATTRIBUTE10                 in      VARCHAR2
, X_ATTRIBUTE11                 in      VARCHAR2
, X_ATTRIBUTE12                 in      VARCHAR2
, X_ATTRIBUTE13                 in      VARCHAR2
, X_ATTRIBUTE14                 in      VARCHAR2
, X_ATTRIBUTE15                 in      VARCHAR2
) is

  cursor C1 is
    SELECT oke_chg_requests_s.nextval
    FROM   dual;

Line: 83


    SELECT ROWID
    ,      LAST_CHG_LOG_ID
    ,      APPROVE_DATE
    ,      IMPLEMENT_DATE
    FROM oke_chg_requests
    WHERE chg_request_id = X_CHG_REQUEST_ID
    ;

Line: 107


  SAVEPOINT OKE_CHG_REQUESTS_INSERT;

Line: 109


  insert into OKE_CHG_REQUESTS (
  CHG_REQUEST_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, K_HEADER_ID
, CHG_REQUEST_NUM
, CHG_TYPE_CODE
, CHG_STATUS_CODE
, CHG_REASON_CODE
, IMPACT_FUNDING_FLAG
, EFFECTIVE_DATE
, REQUESTED_BY_PERSON_ID
, REQUESTED_DATE
, RECEIVE_DATE
, APPROVE_DATE
, IMPLEMENT_DATE
, PREV_VERSION
, NEW_VERSION
, DESCRIPTION
, CHG_TEXT
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
  ) values (
  X_CHG_REQUEST_ID
, X_CREATION_DATE
, X_CREATED_BY
, X_LAST_UPDATE_DATE
, X_LAST_UPDATED_BY
, X_LAST_UPDATE_LOGIN
, X_K_HEADER_ID
, X_CHG_REQUEST_NUM
, X_CHG_TYPE_CODE
, X_CHG_STATUS_CODE
, X_CHG_REASON_CODE
, X_IMPACT_FUNDING_FLAG
, X_EFFECTIVE_DATE
, X_REQUESTED_BY_PERSON_ID
, X_REQUESTED_DATE
, X_RECEIVE_DATE
, X_APPROVE_DATE
, X_IMPLEMENT_DATE
, X_PREV_VERSION
, X_NEW_VERSION
, X_DESCRIPTION
, X_CHG_TEXT
, X_ATTRIBUTE_CATEGORY
, X_ATTRIBUTE1
, X_ATTRIBUTE2
, X_ATTRIBUTE3
, X_ATTRIBUTE4
, X_ATTRIBUTE5
, X_ATTRIBUTE6
, X_ATTRIBUTE7
, X_ATTRIBUTE8
, X_ATTRIBUTE9
, X_ATTRIBUTE10
, X_ATTRIBUTE11
, X_ATTRIBUTE12
, X_ATTRIBUTE13
, X_ATTRIBUTE14
, X_ATTRIBUTE15
);

Line: 207


    UPDATE oke_chg_requests
    SET    Chg_Request_Num = X_Chg_Request_Num
    WHERE  Chg_Request_ID  = X_Chg_Request_ID;

Line: 217


  ROLLBACK TO SAVEPOINT OKE_CHG_REQUESTS_INSERT;

Line: 220


end INSERT_ROW;

Line: 257


  cursor c is select
       CHG_REQUEST_ID
     , K_HEADER_ID
     , CHG_REQUEST_NUM
     , CHG_TYPE_CODE
     , CHG_STATUS_CODE
     , CHG_REASON_CODE
     , IMPACT_FUNDING_FLAG
     , EFFECTIVE_DATE
     , REQUESTED_BY_PERSON_ID
     , REQUESTED_DATE
     , RECEIVE_DATE
     , APPROVE_DATE
     , IMPLEMENT_DATE
     , PREV_VERSION
     , NEW_VERSION
     , DESCRIPTION
     , CHG_TEXT
     , ATTRIBUTE_CATEGORY
     , ATTRIBUTE1
     , ATTRIBUTE2
     , ATTRIBUTE3
     , ATTRIBUTE4
     , ATTRIBUTE5
     , ATTRIBUTE6
     , ATTRIBUTE7
     , ATTRIBUTE8
     , ATTRIBUTE9
     , ATTRIBUTE10
     , ATTRIBUTE11
     , ATTRIBUTE12
     , ATTRIBUTE13
     , ATTRIBUTE14
     , ATTRIBUTE15
    from OKE_CHG_REQUESTS
    where CHG_REQUEST_ID = X_CHG_REQUEST_ID
    for update of CHG_REQUEST_ID nowait;

Line: 301


    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 381


procedure UPDATE_ROW
( X_CHG_REQUEST_ID              in      NUMBER
, X_LAST_UPDATE_DATE            in      DATE
, X_LAST_UPDATED_BY             in      NUMBER
, X_LAST_UPDATE_LOGIN           in      NUMBER
, X_K_HEADER_ID                 in      NUMBER
, X_CHG_REQUEST_NUM             in      VARCHAR2
, X_CHG_TYPE_CODE               in      VARCHAR2
, X_CHG_STATUS_CODE             in      VARCHAR2
, X_CHG_REASON_CODE             in      VARCHAR2
, X_IMPACT_FUNDING_FLAG         in      VARCHAR2
, X_EFFECTIVE_DATE              in      DATE
, X_REQUESTED_BY_PERSON_ID      in      NUMBER
, X_REQUESTED_DATE              in      DATE
, X_RECEIVE_DATE                in      DATE
, X_APPROVE_DATE                in out NOCOPY  DATE
, X_IMPLEMENT_DATE              in out NOCOPY  DATE
, X_PREV_VERSION                in      NUMBER
, X_NEW_VERSION                 in      NUMBER
, X_DESCRIPTION                 in      VARCHAR2
, X_CHG_TEXT                    in      VARCHAR2
, X_LAST_CHG_LOG_ID             in out NOCOPY  NUMBER
, X_ATTRIBUTE_CATEGORY          in      VARCHAR2
, X_ATTRIBUTE1                  in      VARCHAR2
, X_ATTRIBUTE2                  in      VARCHAR2
, X_ATTRIBUTE3                  in      VARCHAR2
, X_ATTRIBUTE4                  in      VARCHAR2
, X_ATTRIBUTE5                  in      VARCHAR2
, X_ATTRIBUTE6                  in      VARCHAR2
, X_ATTRIBUTE7                  in      VARCHAR2
, X_ATTRIBUTE8                  in      VARCHAR2
, X_ATTRIBUTE9                  in      VARCHAR2
, X_ATTRIBUTE10                 in      VARCHAR2
, X_ATTRIBUTE11                 in      VARCHAR2
, X_ATTRIBUTE12                 in      VARCHAR2
, X_ATTRIBUTE13                 in      VARCHAR2
, X_ATTRIBUTE14                 in      VARCHAR2
, X_ATTRIBUTE15                 in      VARCHAR2
) is

  cursor C is
    SELECT LAST_CHG_LOG_ID
    ,      APPROVE_DATE
    ,      IMPLEMENT_DATE
    FROM oke_chg_requests
    WHERE chg_request_id = X_CHG_REQUEST_ID
    ;

Line: 430


    SELECT LAST_CHG_LOG_ID
    FROM oke_chg_requests
    WHERE chg_request_id = X_CHG_REQUEST_ID
    ;

Line: 443


  update OKE_CHG_REQUESTS set
  LAST_UPDATE_DATE      	= X_LAST_UPDATE_DATE
, LAST_UPDATED_BY 		= X_LAST_UPDATED_BY
, LAST_UPDATE_LOGIN   		= X_LAST_UPDATE_LOGIN
, K_HEADER_ID   		= X_K_HEADER_ID
, CHG_REQUEST_NUM   		= X_CHG_REQUEST_NUM
, CHG_TYPE_CODE   		= X_CHG_TYPE_CODE
, CHG_STATUS_CODE   		= X_CHG_STATUS_CODE
, CHG_REASON_CODE   		= X_CHG_REASON_CODE
, IMPACT_FUNDING_FLAG  		= X_IMPACT_FUNDING_FLAG
, EFFECTIVE_DATE   		= X_EFFECTIVE_DATE
, REQUESTED_BY_PERSON_ID	= X_REQUESTED_BY_PERSON_ID
, REQUESTED_DATE   		= X_REQUESTED_DATE
, RECEIVE_DATE   		= X_RECEIVE_DATE
, APPROVE_DATE   		= X_APPROVE_DATE
, IMPLEMENT_DATE   		= X_IMPLEMENT_DATE
, PREV_VERSION   		= X_PREV_VERSION
, NEW_VERSION   		= X_NEW_VERSION
, DESCRIPTION   		= X_DESCRIPTION
, CHG_TEXT   	        	= X_CHG_TEXT
, ATTRIBUTE_CATEGORY		= X_ATTRIBUTE_CATEGORY
, ATTRIBUTE1            	= X_ATTRIBUTE1
, ATTRIBUTE2			= X_ATTRIBUTE2
, ATTRIBUTE3    		= X_ATTRIBUTE3
, ATTRIBUTE4        		= X_ATTRIBUTE4
, ATTRIBUTE5            	= X_ATTRIBUTE5
, ATTRIBUTE6			= X_ATTRIBUTE6
, ATTRIBUTE7    		= X_ATTRIBUTE7
, ATTRIBUTE8        		= X_ATTRIBUTE8
, ATTRIBUTE9            	= X_ATTRIBUTE9
, ATTRIBUTE10           	= X_ATTRIBUTE10
, ATTRIBUTE11			= X_ATTRIBUTE11
, ATTRIBUTE12    		= X_ATTRIBUTE12
, ATTRIBUTE13        		= X_ATTRIBUTE13
, ATTRIBUTE14           	= X_ATTRIBUTE14
, ATTRIBUTE15           	= X_ATTRIBUTE15
where CHG_REQUEST_ID 	        = X_CHG_REQUEST_ID
;

Line: 500


end UPDATE_ROW;

Line: 517


     SELECT count(1)
     FROM   oke_chg_requests
     WHERE  K_Header_ID = C_K_Header_ID
     AND    Chg_Request_Num = C_Chg_Request_Num
     AND    (  C_Chg_Request_ID IS NULL
            OR Chg_Request_ID <> C_Chg_Request_ID );

Line: 529


    select Manual_ChgReq_Num_type
      into Chg_Req_Num_Type
      from oke_number_options N,
           oke_k_headers EH,
           okc_k_headers_b CH
     WHERE EH.K_Header_ID = X_K_HEADER_ID
       AND CH.ID          = EH.K_Header_ID
       AND N.K_Type_Code  = EH.K_Type_Code
       AND N.Buy_Or_Sell = CH.Buy_Or_Sell;

Line: 578


   select Manual_ChgReq_Num_Type
     into Num_Type
     from OKE_NUMBER_OPTIONS N,
          OKE_K_HEADERS EH,
          OKC_K_HEADERS_B CH
    WHERE EH.K_HEADER_ID = X_K_HEADER_ID
      AND CH.ID = EH.K_HEADER_ID
      AND N.K_TYPE_CODE = EH.K_TYPE_CODE
      AND N.BUY_OR_SELL = CH.BUY_OR_SELL;

Line: 596


   select ChgReq_Num_Mode
     into Num_Mode
     from OKE_NUMBER_OPTIONS N,
          OKE_K_HEADERS EH,
          OKC_K_HEADERS_B CH
    WHERE EH.K_HEADER_ID = X_K_HEADER_ID
      AND CH.ID = EH.K_HEADER_ID
      AND N.K_TYPE_CODE = EH.K_TYPE_CODE
      AND N.BUY_OR_SELL = CH.BUY_OR_SELL;