APPS.OKE_WORKFLOWS_PKG SQL Statements

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

Line: 3

procedure INSERT_ROW (
  X_ROWID 			in out NOCOPY VARCHAR2
, X_SOURCE_CODE 	        in 	VARCHAR2
, X_USAGE_CODE 	                in 	VARCHAR2
, 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_WF_ITEM_TYPE		in 	VARCHAR2
, X_WF_PROCESS  		in 	VARCHAR2
) is
  cursor C is select ROWID from OKE_WORKFLOWS
    where SOURCE_CODE = X_SOURCE_CODE
    and   USAGE_CODE  = X_USAGE_CODE
    ;

Line: 20

  insert into OKE_WORKFLOWS (
  SOURCE_CODE
, USAGE_CODE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, WF_ITEM_TYPE
, WF_PROCESS
  ) values (
  X_SOURCE_CODE
, X_USAGE_CODE
, X_CREATION_DATE
, X_CREATED_BY
, X_LAST_UPDATE_DATE
, X_LAST_UPDATED_BY
, X_LAST_UPDATE_LOGIN
, X_WF_ITEM_TYPE
, X_WF_PROCESS
);

Line: 50

end INSERT_ROW;

Line: 58

  cursor c is select
       SOURCE_CODE
     , USAGE_CODE
     , WF_ITEM_TYPE
     , WF_PROCESS
    from OKE_WORKFLOWS
    where SOURCE_CODE = X_SOURCE_CODE
    and   USAGE_CODE  = X_USAGE_CODE
    for update nowait;

Line: 74

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

Line: 95

procedure UPDATE_ROW (
  X_SOURCE_CODE 	        in 	VARCHAR2
, X_USAGE_CODE 	                in 	VARCHAR2
, X_LAST_UPDATE_DATE 		in 	DATE
, X_LAST_UPDATED_BY 		in 	NUMBER
, X_LAST_UPDATE_LOGIN 		in 	NUMBER
, X_WF_ITEM_TYPE		in 	VARCHAR2
, X_WF_PROCESS  		in 	VARCHAR2
) is
begin
  update OKE_WORKFLOWS set
  LAST_UPDATE_DATE      	= X_LAST_UPDATE_DATE
, LAST_UPDATED_BY 		= X_LAST_UPDATED_BY
, LAST_UPDATE_LOGIN   		= X_LAST_UPDATE_LOGIN
, WF_ITEM_TYPE			= X_WF_ITEM_TYPE
, WF_PROCESS  			= X_WF_PROCESS
  where SOURCE_CODE 	        = X_SOURCE_CODE
  and   USAGE_CODE 	        = X_USAGE_CODE
  ;

Line: 119

end UPDATE_ROW;