APPS.AR_BPA_URL_PARAMS_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_URL_PARAM_ID in NUMBER,
  X_URL_ID in NUMBER,
  X_PARAM_TYPE in VARCHAR2,
  X_PARAM_NAME in VARCHAR2,
  X_PARAM_VALUE in VARCHAR2,
  X_ITEM_ID in NUMBER,
  X_ENCRYPTED_FLAG 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
) is
  cursor C is select ROWID from AR_BPA_URL_PARAMS
    where URL_PARAM_ID = X_URL_PARAM_ID
    ;

Line: 22

  insert into AR_BPA_URL_PARAMS (
    URL_PARAM_ID,
    URL_ID,
    PARAM_TYPE,
    PARAM_NAME,
    PARAM_VALUE,
    ITEM_ID,
    ENCRYPTED_FLAG,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN
  ) select
    X_URL_PARAM_ID,
    X_URL_ID,
    X_PARAM_TYPE,
    X_PARAM_NAME,
    X_PARAM_VALUE,
    X_ITEM_ID,
    X_ENCRYPTED_FLAG,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_LOGIN
  from dual;

Line: 58

end INSERT_ROW;

Line: 69

  cursor c is select
      URL_PARAM_ID,
      URL_ID,
      PARAM_TYPE,
      PARAM_NAME,
      PARAM_VALUE,
      ITEM_ID,
      ENCRYPTED_FLAG
    from AR_BPA_URL_PARAMS
    where URL_PARAM_ID = X_URL_PARAM_ID
    for update of URL_PARAM_ID nowait;

Line: 87

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

Line: 111

procedure UPDATE_ROW (
  X_URL_PARAM_ID in NUMBER,
  X_URL_ID in NUMBER,
  X_PARAM_TYPE in VARCHAR2,
  X_PARAM_NAME in VARCHAR2,
  X_PARAM_VALUE in VARCHAR2,
  X_ITEM_ID in NUMBER,
  X_ENCRYPTED_FLAG in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update AR_BPA_URL_PARAMS set
    URL_PARAM_ID = X_URL_PARAM_ID,
    URL_ID = X_URL_ID,
    PARAM_TYPE = X_PARAM_TYPE,
    PARAM_NAME = X_PARAM_NAME,
    PARAM_VALUE = X_PARAM_VALUE,
    ITEM_ID = X_ITEM_ID,
    ENCRYPTED_FLAG = X_ENCRYPTED_FLAG,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where URL_PARAM_ID = X_URL_PARAM_ID;

Line: 140

end UPDATE_ROW;

Line: 142

procedure DELETE_ROW (
  X_URL_PARAM_ID in NUMBER
) is
begin
  delete from AR_BPA_URL_PARAMS
  where URL_PARAM_ID = X_URL_PARAM_ID;

Line: 153

end DELETE_ROW;

Line: 174

    AR_BPA_URL_PARAMS_PKG.UPDATE_ROW (
        X_URL_PARAM_ID 		=> X_URL_PARAM_ID,
        X_URL_ID 			=> X_URL_ID,
        X_PARAM_TYPE		=> X_PARAM_TYPE,
        X_PARAM_NAME		=> X_PARAM_NAME,
        X_PARAM_VALUE		=> X_PARAM_VALUE,
        X_ITEM_ID			=> X_ITEM_ID,
        X_ENCRYPTED_FLAG	=> X_ENCRYPTED_FLAG,
        X_LAST_UPDATE_DATE 		=> sysdate,
        X_LAST_UPDATED_BY 		=> user_id,
        X_LAST_UPDATE_LOGIN 	=> 0);

Line: 187

           AR_BPA_URL_PARAMS_PKG.INSERT_ROW (
                X_ROWID 				=> row_id,
		        X_URL_PARAM_ID 			=> X_URL_PARAM_ID,
		        X_URL_ID 				=> X_URL_ID,
		        X_PARAM_TYPE			=> X_PARAM_TYPE,
		        X_PARAM_NAME			=> X_PARAM_NAME,
		        X_PARAM_VALUE			=> X_PARAM_VALUE,
		        X_ITEM_ID				=> X_ITEM_ID,
		        X_ENCRYPTED_FLAG		=> X_ENCRYPTED_FLAG,
				X_CREATION_DATE 		=> sysdate,
                X_CREATED_BY 			=> user_id,
                X_LAST_UPDATE_DATE 		=> sysdate,
                X_LAST_UPDATED_BY 		=> user_id,
                X_LAST_UPDATE_LOGIN 	=> 0);