APPS.FND_EXECUTABLES_PKG SQL Statements

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

Line: 4

procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_APPLICATION_ID in NUMBER,
  X_EXECUTABLE_ID in NUMBER,
  X_EXECUTABLE_NAME in VARCHAR2,
  X_EXECUTION_METHOD_CODE in VARCHAR2,
  X_EXECUTION_FILE_NAME in VARCHAR2,
  X_SUBROUTINE_NAME in VARCHAR2,
  X_EXECUTION_FILE_PATH in VARCHAR2,
  X_USER_EXECUTABLE_NAME in VARCHAR2,
  X_DESCRIPTION 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 FND_EXECUTABLES
    where APPLICATION_ID = X_APPLICATION_ID
    and EXECUTABLE_ID = X_EXECUTABLE_ID
    ;

Line: 26

  insert into FND_EXECUTABLES (
    APPLICATION_ID,
    EXECUTABLE_ID,
    EXECUTABLE_NAME,
    EXECUTION_METHOD_CODE,
    EXECUTION_FILE_NAME,
    SUBROUTINE_NAME,
    EXECUTION_FILE_PATH,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_APPLICATION_ID,
    X_EXECUTABLE_ID,
    X_EXECUTABLE_NAME,
    X_EXECUTION_METHOD_CODE,
    X_EXECUTION_FILE_NAME,
    X_SUBROUTINE_NAME,
    X_EXECUTION_FILE_PATH,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 54

  insert into FND_EXECUTABLES_TL (
    APPLICATION_ID,
    EXECUTABLE_ID,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    USER_EXECUTABLE_NAME,
    DESCRIPTION,
    LANGUAGE,
    SOURCE_LANG
  ) select
    X_APPLICATION_ID,
    X_EXECUTABLE_ID,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_USER_EXECUTABLE_NAME,
    X_DESCRIPTION,
    L.LANGUAGE_CODE,
    userenv('LANG')
  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from FND_EXECUTABLES_TL T
    where T.APPLICATION_ID = X_APPLICATION_ID
    and T.EXECUTABLE_ID = X_EXECUTABLE_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 95

end INSERT_ROW;

Line: 108

  cursor c is select
      EXECUTABLE_NAME,
      EXECUTION_METHOD_CODE,
      EXECUTION_FILE_NAME,
      SUBROUTINE_NAME,
      EXECUTION_FILE_PATH
    from FND_EXECUTABLES
    where APPLICATION_ID = X_APPLICATION_ID
    and EXECUTABLE_ID = X_EXECUTABLE_ID
    for update of APPLICATION_ID nowait;

Line: 120

  cursor c1 is select
      USER_EXECUTABLE_NAME,
      DESCRIPTION
    from FND_EXECUTABLES_TL
    where APPLICATION_ID = X_APPLICATION_ID
    and EXECUTABLE_ID = X_EXECUTABLE_ID
    and LANGUAGE = userenv('LANG')
    for update of APPLICATION_ID nowait;

Line: 135

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

Line: 174

procedure UPDATE_ROW (
  X_APPLICATION_ID in NUMBER,
  X_EXECUTABLE_ID in NUMBER,
  X_EXECUTABLE_NAME in VARCHAR2,
  X_EXECUTION_METHOD_CODE in VARCHAR2,
  X_EXECUTION_FILE_NAME in VARCHAR2,
  X_SUBROUTINE_NAME in VARCHAR2,
  X_EXECUTION_FILE_PATH in VARCHAR2,
  X_USER_EXECUTABLE_NAME in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update FND_EXECUTABLES set
    EXECUTABLE_NAME = X_EXECUTABLE_NAME,
    EXECUTION_METHOD_CODE = X_EXECUTION_METHOD_CODE,
    EXECUTION_FILE_NAME = X_EXECUTION_FILE_NAME,
    SUBROUTINE_NAME = X_SUBROUTINE_NAME,
    EXECUTION_FILE_PATH = X_EXECUTION_FILE_PATH,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where APPLICATION_ID = X_APPLICATION_ID
  and EXECUTABLE_ID = X_EXECUTABLE_ID;

Line: 205

  update FND_EXECUTABLES_TL set
    USER_EXECUTABLE_NAME = nvl(X_USER_EXECUTABLE_NAME, USER_EXECUTABLE_NAME),
    DESCRIPTION = nvl(X_DESCRIPTION, DESCRIPTION),
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    SOURCE_LANG = userenv('LANG')
  where APPLICATION_ID = X_APPLICATION_ID
  and EXECUTABLE_ID = X_EXECUTABLE_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 219

end UPDATE_ROW;

Line: 238

    x_last_update_date => null);

Line: 250

  x_last_update_date		in varchar2)
is
  app_id   	number := 0;

Line: 255

  f_ludate	date;   -- entity update date in file

Line: 257

  db_ludate	date;   -- entity update in db

Line: 264

  f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);

Line: 267

    select APPLICATION_ID into app_id
    from   fnd_application
    where  APPLICATION_SHORT_NAME = x_application_short_name;

Line: 271

    select EXECUTABLE_ID into key_id
    from   fnd_executables
    where  EXECUTABLE_NAME = x_executable_name
    and    APPLICATION_ID = app_id;

Line: 276

    select LAST_UPDATED_BY, LAST_UPDATE_DATE
    into   db_luby, db_ludate
    from   FND_EXECUTABLES_TL
    where  APPLICATION_ID = app_id
    and    EXECUTABLE_ID = key_id
    and    LANGUAGE = userenv('LANG');

Line: 294

      update FND_EXECUTABLES_TL set
	USER_EXECUTABLE_NAME = nvl(x_user_executable_name,
				   USER_EXECUTABLE_NAME),
	DESCRIPTION          = nvl(x_description, DESCRIPTION),
	SOURCE_LANG	     = userenv('LANG'),
	LAST_UPDATE_DATE     = f_ludate,
	LAST_UPDATED_BY      = f_luby,
	LAST_UPDATE_LOGIN   = 0
      where  APPLICATION_ID = app_id
      and    EXECUTABLE_ID = key_id
      and    LANGUAGE = userenv('LANG');

Line: 336

    x_last_update_date =>	null);

Line: 352

  x_last_update_date	    in varchar2)
is
  app_id   	number := 0;

Line: 358

  f_ludate	date;   -- entity update date in file

Line: 360

  db_ludate	date;   -- entity update in db

Line: 367

  f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);

Line: 370

    select APPLICATION_ID into app_id
    from   fnd_application
    where  APPLICATION_SHORT_NAME = x_application_short_name;

Line: 374

    select EXECUTABLE_ID, LAST_UPDATED_BY, LAST_UPDATE_DATE
    into key_id, db_luby, db_ludate
    from   fnd_executables
    where  EXECUTABLE_NAME = x_executable_name
    and    APPLICATION_ID = app_id;

Line: 392

      fnd_executables_pkg.update_row(
  	x_application_id => 	   app_id,
  	x_executable_id => 	   key_id,
  	x_executable_name =>  	   x_executable_name,
  	x_execution_method_code => x_execution_method_code,
  	x_execution_file_name =>   x_execution_file_name,
  	x_subroutine_name => 	   x_subroutine_name,
  	x_execution_file_path =>   x_execution_file_path,
  	x_user_executable_name =>  x_user_executable_name,
  	x_description => 	   x_description,
  	x_last_update_date => 	   f_ludate,
  	X_last_updated_by => 	   f_luby,
  	x_last_update_login => 	   0);

Line: 407

    select meaning
    into exec_method
    from fnd_lookup_values
    where lookup_code = x_execution_method_code
    and lookup_type = 'CP_EXECUTION_METHOD_CODE'
    and enabled_flag = 'Y'
    and rownum = 1;

Line: 449

procedure DELETE_ROW (
  X_APPLICATION_ID in NUMBER,
  X_EXECUTABLE_ID in NUMBER
) is
begin
  delete from FND_EXECUTABLES
  where APPLICATION_ID = X_APPLICATION_ID
  and EXECUTABLE_ID = X_EXECUTABLE_ID;

Line: 462

  delete from FND_EXECUTABLES_TL
  where APPLICATION_ID = X_APPLICATION_ID
  and EXECUTABLE_ID = X_EXECUTABLE_ID;

Line: 469

end DELETE_ROW;

Line: 477

/* The following delete and update statements are commented out */
/* as a quick workaround to fix the time-consuming table handler issue */
/* Eventually we'll need to turn them into a separate fix_language procedure */
/*

  delete from FND_EXECUTABLES_TL T
  where not exists
    (select NULL
    from FND_EXECUTABLES B
    where B.APPLICATION_ID = T.APPLICATION_ID
    and B.EXECUTABLE_ID = T.EXECUTABLE_ID
    );

Line: 490

  update FND_EXECUTABLES_TL T set (
      USER_EXECUTABLE_NAME,
      DESCRIPTION
    ) = (select
      B.USER_EXECUTABLE_NAME,
      B.DESCRIPTION
    from FND_EXECUTABLES_TL B
    where B.APPLICATION_ID = T.APPLICATION_ID
    and B.EXECUTABLE_ID = T.EXECUTABLE_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.APPLICATION_ID,
      T.EXECUTABLE_ID,
      T.LANGUAGE
  ) in (select
      SUBT.APPLICATION_ID,
      SUBT.EXECUTABLE_ID,
      SUBT.LANGUAGE
    from FND_EXECUTABLES_TL SUBB, FND_EXECUTABLES_TL SUBT
    where SUBB.APPLICATION_ID = SUBT.APPLICATION_ID
    and SUBB.EXECUTABLE_ID = SUBT.EXECUTABLE_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.USER_EXECUTABLE_NAME <> SUBT.USER_EXECUTABLE_NAME
      or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
      or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
      or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
  ));

Line: 519

  insert into FND_EXECUTABLES_TL (
    APPLICATION_ID,
    EXECUTABLE_ID,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    USER_EXECUTABLE_NAME,
    DESCRIPTION,
    LANGUAGE,
    SOURCE_LANG
  ) select
    B.APPLICATION_ID,
    B.EXECUTABLE_ID,
    B.CREATION_DATE,
    B.CREATED_BY,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATED_BY,
    B.LAST_UPDATE_LOGIN,
    B.USER_EXECUTABLE_NAME,
    B.DESCRIPTION,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from FND_EXECUTABLES_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from FND_EXECUTABLES_TL T
    where T.APPLICATION_ID = B.APPLICATION_ID
    and T.EXECUTABLE_ID = B.EXECUTABLE_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);