APPS.OKE_NOTIFICATIONS_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_ID                          in      NUMBER
, 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_TARGET_DATE         	in 	VARCHAR2
, X_BEFORE_AFTER                in      VARCHAR2
, X_DURATION_DAYS		in 	NUMBER
, X_RECIPIENT    		in 	VARCHAR2
, X_ROLE_ID		        in 	NUMBER
) is
  cursor C is select ROWID from OKE_NOTIFICATIONS
    where ID = X_ID
    ;

Line: 23

  insert into OKE_NOTIFICATIONS (
  ID
, SOURCE_CODE
, USAGE_CODE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, TARGET_DATE
, BEFORE_AFTER
, DURATION_DAYS
, RECIPIENT
, ROLE_ID
  ) values (
  X_ID
, 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_TARGET_DATE
, X_BEFORE_AFTER
, X_DURATION_DAYS
, X_RECIPIENT
, X_ROLE_ID
);

Line: 61

end INSERT_ROW;

Line: 74

    select
       ID
     , TARGET_DATE
     , BEFORE_AFTER
     , DURATION_DAYS
     , RECIPIENT
     , ROLE_ID
    from OKE_NOTIFICATIONS
    where ID = X_ID
    for update nowait;

Line: 93

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

Line: 120

procedure UPDATE_ROW (
  X_ID 	        		in      NUMBER
, 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_TARGET_DATE         	in 	VARCHAR2
, X_BEFORE_AFTER                in      VARCHAR2
, X_DURATION_DAYS		in 	NUMBER
, X_RECIPIENT    		in 	VARCHAR2
, X_ROLE_ID		        in 	NUMBER
)
is
begin
  update OKE_NOTIFICATIONS
  set
  LAST_UPDATE_DATE      	= X_LAST_UPDATE_DATE
, LAST_UPDATED_BY 		= X_LAST_UPDATED_BY
, LAST_UPDATE_LOGIN   		= X_LAST_UPDATE_LOGIN
, TARGET_DATE     		= X_TARGET_DATE
, BEFORE_AFTER         		= X_BEFORE_AFTER
, DURATION_DAYS    		= X_DURATION_DAYS
, RECIPIENT      		= X_RECIPIENT
, ROLE_ID		        = X_ROLE_ID
  where ID                      = X_ID
;

Line: 152

end UPDATE_ROW;

Line: 154

procedure DELETE_ROW (
  X_ID  			in 	NUMBER
) is
begin
  delete OKE_NOTIFICATIONS
  where ID 	= X_ID
  ;

Line: 166

end DELETE_ROW;