APPS.FND_FORM_FUNCTIONS_PKG SQL Statements

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

Line: 242

    select lower(application_short_name)
    into applname
    from fnd_application
    where application_id = FUNCTION_VALIDATION.application_id;

Line: 510

procedure INSERT_ROW (
  X_ROWID in out nocopy VARCHAR2,
  X_FUNCTION_ID in NUMBER,
  X_WEB_HOST_NAME in VARCHAR2,
  X_WEB_AGENT_NAME in VARCHAR2,
  X_WEB_HTML_CALL in VARCHAR2,
  X_WEB_ENCRYPT_PARAMETERS in VARCHAR2,
  X_WEB_SECURED in VARCHAR2,
  X_WEB_ICON in VARCHAR2,
  X_OBJECT_ID in NUMBER,
  X_REGION_APPLICATION_ID in NUMBER,
  X_REGION_CODE in VARCHAR2,
  X_FUNCTION_NAME in VARCHAR2,
  X_APPLICATION_ID in NUMBER,
  X_FORM_ID in NUMBER,
  X_PARAMETERS in VARCHAR2,
  X_TYPE in VARCHAR2,
  X_USER_FUNCTION_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
begin
      fnd_form_functions_pkg.INSERT_ROW(
       X_ROWID                  => X_ROWID,
       X_FUNCTION_ID            => X_FUNCTION_ID,
       X_WEB_HOST_NAME          => X_WEB_HOST_NAME,
       X_WEB_AGENT_NAME         => X_WEB_AGENT_NAME,
       X_WEB_HTML_CALL          => X_WEB_HTML_CALL,
       X_WEB_ENCRYPT_PARAMETERS => X_WEB_ENCRYPT_PARAMETERS,
       X_WEB_SECURED            => X_WEB_SECURED,
       X_WEB_ICON               => X_WEB_ICON,
       X_OBJECT_ID              => X_OBJECT_ID,
       X_REGION_APPLICATION_ID  => X_REGION_APPLICATION_ID,
       X_REGION_CODE            => X_REGION_CODE,
       X_FUNCTION_NAME          => X_FUNCTION_NAME,
       X_APPLICATION_ID         => X_APPLICATION_ID,
       X_FORM_ID                => X_FORM_ID,
       X_PARAMETERS             => X_PARAMETERS,
       X_TYPE                   => X_TYPE,
       X_USER_FUNCTION_NAME     => X_USER_FUNCTION_NAME,
       X_DESCRIPTION            => X_DESCRIPTION,
       X_CREATION_DATE          => X_CREATION_DATE,
       X_CREATED_BY             => X_CREATED_BY,
       X_LAST_UPDATE_DATE       => X_LAST_UPDATE_DATE,
       X_LAST_UPDATED_BY        => X_LAST_UPDATED_BY,
       X_LAST_UPDATE_LOGIN      => X_LAST_UPDATE_LOGIN,
       X_MAINTENANCE_MODE_SUPPORT => NULL,
       X_CONTEXT_DEPENDENCE       => NULL,
       X_JRAD_REF_PATH          => NULL);

Line: 563

end INSERT_ROW;

Line: 609

procedure UPDATE_ROW (
  X_FUNCTION_ID in NUMBER,
  X_WEB_HOST_NAME in VARCHAR2,
  X_WEB_AGENT_NAME in VARCHAR2,
  X_WEB_HTML_CALL in VARCHAR2,
  X_WEB_ENCRYPT_PARAMETERS in VARCHAR2,
  X_WEB_SECURED in VARCHAR2,
  X_WEB_ICON in VARCHAR2,
  X_OBJECT_ID in NUMBER,
  X_REGION_APPLICATION_ID in NUMBER,
  X_REGION_CODE in VARCHAR2,
  X_FUNCTION_NAME in VARCHAR2,
  X_APPLICATION_ID in NUMBER,
  X_FORM_ID in NUMBER,
  X_PARAMETERS in VARCHAR2,
  X_TYPE in VARCHAR2,
  X_USER_FUNCTION_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
      fnd_form_functions_pkg.UPDATE_ROW(
       X_FUNCTION_ID            => X_FUNCTION_ID,
       X_WEB_HOST_NAME          => X_WEB_HOST_NAME,
       X_WEB_AGENT_NAME         => X_WEB_AGENT_NAME,
       X_WEB_HTML_CALL          => X_WEB_HTML_CALL,
       X_WEB_ENCRYPT_PARAMETERS => X_WEB_ENCRYPT_PARAMETERS,
       X_WEB_SECURED            => X_WEB_SECURED,
       X_WEB_ICON               => X_WEB_ICON,
       X_OBJECT_ID              => X_OBJECT_ID,
       X_REGION_APPLICATION_ID  => X_REGION_APPLICATION_ID,
       X_REGION_CODE            => X_REGION_CODE,
       X_FUNCTION_NAME          => X_FUNCTION_NAME,
       X_APPLICATION_ID         => X_APPLICATION_ID,
       X_FORM_ID                => X_FORM_ID,
       X_PARAMETERS             => X_PARAMETERS,
       X_TYPE                   => X_TYPE,
       X_USER_FUNCTION_NAME     => X_USER_FUNCTION_NAME,
       X_DESCRIPTION            => X_DESCRIPTION,
       X_LAST_UPDATE_DATE       => X_LAST_UPDATE_DATE,
       X_LAST_UPDATED_BY        => X_LAST_UPDATED_BY,
       X_LAST_UPDATE_LOGIN      => X_LAST_UPDATE_LOGIN,
       X_MAINTENANCE_MODE_SUPPORT => NULL,
       X_CONTEXT_DEPENDENCE       => NULL,
       X_JRAD_REF_PATH          => NULL);

Line: 656

end UPDATE_ROW;

Line: 699

    X_LAST_UPDATE_DATE        => NULL,
    X_MAINTENANCE_MODE_SUPPORT => NULL,
    X_CONTEXT_DEPENDENCE       => NULL,
    X_JRAD_REF_PATH           => NULL
  );

Line: 726

  X_LAST_UPDATE_DATE in VARCHAR2,
  X_MAINTENANCE_MODE_SUPPORT in VARCHAR2, /* NULL='NONE' */
  X_CONTEXT_DEPENDENCE in VARCHAR2,       /* NULL='RESP' */
  X_JRAD_REF_PATH in VARCHAR2 default NULL
) is
 -- The following four variables could be null;

Line: 739

 f_ludate  date;    -- entity update date in file

Line: 741

 db_ludate date;    -- entity update date in db

Line: 771

    select application_id into app_id
    from   fnd_application
    where  application_short_name = X_APPLICATION_SHORT_NAME;

Line: 780

  select decode(X_PARAMETERS, fnd_load_util.null_value, null,
                null, X_PARAMETERS, X_PARAMETERS),
         decode(X_WEB_HOST_NAME, fnd_load_util.null_value, null,
                null, X_WEB_HOST_NAME, X_WEB_HOST_NAME),
         decode(X_WEB_AGENT_NAME, fnd_load_util.null_value, null,
		null, X_WEB_AGENT_NAME, X_WEB_AGENT_NAME),
         decode(X_WEB_HTML_CALL, fnd_load_util.null_value, null,
		null, X_WEB_HTML_CALL, X_WEB_HTML_CALL),
         decode(X_WEB_ENCRYPT_PARAMETERS, fnd_load_util.null_value, null,
		null, X_WEB_ENCRYPT_PARAMETERS, X_WEB_ENCRYPT_PARAMETERS),
         decode(X_WEB_SECURED, fnd_load_util.null_value, null,
		null, X_WEB_SECURED, X_WEB_SECURED),
	 decode(X_WEB_ICON, fnd_load_util.null_value, null,
		null, X_WEB_ICON, X_WEB_ICON),
	 decode(X_REGION_CODE, fnd_load_util.null_value, null,
		null, X_REGION_CODE, X_REGION_CODE),
	 decode(X_JRAD_REF_PATH, fnd_load_util.null_value, null,
		null, X_JRAD_REF_PATH, X_JRAD_REF_PATH)
         into l_parameters, l_web_host_name, l_web_agent_name,
	      l_web_html_call, l_web_encrypt_parameters, l_web_secured,
              l_web_icon, l_region_code, L_JRAD_REF_PATH
         from dual;

Line: 803

  select decode(X_FORM_NAME,
                fnd_load_util.null_value, null,
                null, X_FORM_NAME,
                X_FORM_NAME) into l_form_name from dual;

Line: 810

    select form_id into frm_id
    from fnd_form
    where form_name = X_FORM_NAME
    and   application_id = app_id;

Line: 820

  select decode(X_OBJECT_NAME,
                fnd_load_util.null_value, null,
                null, X_OBJECT_NAME,
                X_OBJECT_NAME) into l_object_name from dual;

Line: 827

    select object_id into obj_id
    from fnd_objects
    where obj_name = X_OBJECT_NAME;

Line: 836

  select decode(X_REGION_APPLICATION_NAME,
                fnd_load_util.null_value, null,
                null, X_REGION_APPLICATION_NAME,
                X_REGION_APPLICATION_NAME)
         into l_region_application_name from dual;

Line: 844

    select application_id into rapp_id
    from   fnd_application
    where  application_short_name = X_REGION_APPLICATION_NAME;

Line: 857

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

Line: 859

  select function_id, last_updated_by, last_update_date
  into fun_id, db_luby, db_ludate
  from fnd_form_functions
  where function_name = X_FUNCTION_NAME;

Line: 866

    fnd_form_functions_pkg.UPDATE_ROW (
       X_FUNCTION_ID            => fun_id,
       X_WEB_HOST_NAME          => l_WEB_HOST_NAME,
       X_WEB_AGENT_NAME         => l_WEB_AGENT_NAME,
       X_WEB_HTML_CALL          => l_WEB_HTML_CALL,
       X_WEB_ENCRYPT_PARAMETERS => l_WEB_ENCRYPT_PARAMETERS,
       X_WEB_SECURED            => l_WEB_SECURED,
       X_WEB_ICON               => l_WEB_ICON,
       X_OBJECT_ID              => obj_id,
       X_REGION_APPLICATION_ID  => rapp_id,
       X_REGION_CODE            => l_REGION_CODE,
       X_FUNCTION_NAME          => X_FUNCTION_NAME,
       X_APPLICATION_ID         => app_id,
       X_FORM_ID                => frm_id,
       X_PARAMETERS             => l_PARAMETERS,
       X_TYPE                   => X_TYPE,
       X_USER_FUNCTION_NAME     => X_USER_FUNCTION_NAME,
       X_DESCRIPTION            => X_DESCRIPTION,
       X_LAST_UPDATE_DATE       => f_ludate,
       X_LAST_UPDATED_BY        => f_luby,
       X_LAST_UPDATE_LOGIN      => 0,
       X_MAINTENANCE_MODE_SUPPORT => L_MAINTENANCE_MODE_SUPPORT,
       X_CONTEXT_DEPENDENCE       => L_CONTEXT_DEPENDENCE,
       X_JRAD_REF_PATH          => L_JRAD_REF_PATH);

Line: 895

      select fnd_form_functions_s.nextval into fun_id from dual;

Line: 897

      fnd_form_functions_pkg.INSERT_ROW(
       X_ROWID                  => row_id,
       X_FUNCTION_ID            => fun_id,
       X_WEB_HOST_NAME          => l_WEB_HOST_NAME,
       X_WEB_AGENT_NAME         => l_WEB_AGENT_NAME,
       X_WEB_HTML_CALL          => l_WEB_HTML_CALL,
       X_WEB_ENCRYPT_PARAMETERS => l_WEB_ENCRYPT_PARAMETERS,
       X_WEB_SECURED            => l_WEB_SECURED,
       X_WEB_ICON               => l_WEB_ICON,
       X_OBJECT_ID              => obj_id,
       X_REGION_APPLICATION_ID  => rapp_id,
       X_REGION_CODE            => l_REGION_CODE,
       X_FUNCTION_NAME          => X_FUNCTION_NAME,
       X_APPLICATION_ID         => app_id,
       X_FORM_ID                => frm_id,
       X_PARAMETERS             => l_PARAMETERS,
       X_TYPE                   => X_TYPE,
       X_USER_FUNCTION_NAME     => X_USER_FUNCTION_NAME,
       X_DESCRIPTION            => X_DESCRIPTION,
       X_CREATION_DATE          => f_ludate,
       X_CREATED_BY             => f_luby,
       X_LAST_UPDATE_DATE       => f_ludate,
       X_LAST_UPDATED_BY        => f_luby,
       X_LAST_UPDATE_LOGIN      => 0,
       X_MAINTENANCE_MODE_SUPPORT => L_MAINTENANCE_MODE_SUPPORT,
       X_CONTEXT_DEPENDENCE       => L_CONTEXT_DEPENDENCE,
       X_JRAD_REF_PATH          => L_JRAD_REF_PATH);

Line: 926

procedure DELETE_ROW (
  X_FUNCTION_ID in NUMBER
) is
begin
  delete from FND_FORM_FUNCTIONS
  where FUNCTION_ID = X_FUNCTION_ID;

Line: 936

		-- This means that a function was deleted.
		-- Added for Function Security Cache Invalidation Project
		fnd_function_security_cache.delete_function(X_FUNCTION_ID);

Line: 941

  delete from FND_FORM_FUNCTIONS_TL
  where FUNCTION_ID = X_FUNCTION_ID;

Line: 947

end DELETE_ROW;

Line: 953

/* 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_FORM_FUNCTIONS_TL T
  where not exists
    (select NULL
    from FND_FORM_FUNCTIONS B
    where B.FUNCTION_ID = T.FUNCTION_ID
    );

Line: 965

  update FND_FORM_FUNCTIONS_TL T set (
      USER_FUNCTION_NAME,
      DESCRIPTION
    ) = (select
      B.USER_FUNCTION_NAME,
      B.DESCRIPTION
    from FND_FORM_FUNCTIONS_TL B
    where B.FUNCTION_ID = T.FUNCTION_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.FUNCTION_ID,
      T.LANGUAGE
  ) in (select
      SUBT.FUNCTION_ID,
      SUBT.LANGUAGE
    from FND_FORM_FUNCTIONS_TL SUBB, FND_FORM_FUNCTIONS_TL SUBT
    where SUBB.FUNCTION_ID = SUBT.FUNCTION_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.USER_FUNCTION_NAME <> SUBT.USER_FUNCTION_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: 990

  insert /*+ append parallel(TT) */ into
  FND_FORM_FUNCTIONS_TL TT(
    FUNCTION_ID,
    USER_FUNCTION_NAME,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    DESCRIPTION,
    LANGUAGE,
    SOURCE_LANG
  ) select /*+ parallel(V) parallel(T) use_nl(T)  */ V.* from
    (   select /*+ no_merge ordered parallel(B) */
             B.FUNCTION_ID,
             B.USER_FUNCTION_NAME,
             B.CREATION_DATE,
             B.CREATED_BY,
             B.LAST_UPDATE_DATE,
             B.LAST_UPDATED_BY,
             B.LAST_UPDATE_LOGIN,
             B.DESCRIPTION,
             L.LANGUAGE_CODE,
             B.SOURCE_LANG
         from FND_FORM_FUNCTIONS_TL B, FND_LANGUAGES L
         where L.INSTALLED_FLAG in ('I', 'B')
         and B.LANGUAGE = userenv('LANG')
    )V,  FND_FORM_FUNCTIONS_TL T
    where T.function_id(+) = V.function_id
    and   T.language(+) = V.language_code
    and   T.function_id is NULL;

Line: 1038

    X_LAST_UPDATE_DATE => null
  );

Line: 1049

  X_LAST_UPDATE_DATE in VARCHAR2
) is
  f_luby    number;  -- entity owner in file

Line: 1052

  f_ludate  date;    -- entity update date in file

Line: 1054

  db_ludate date;    -- entity update date in db

Line: 1060

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

Line: 1062

  select LAST_UPDATED_BY, LAST_UPDATE_DATE
  into db_luby, db_ludate
  from FND_FORM_FUNCTIONS_TL
  where FUNCTION_ID = X_FUNCTION_ID
  and userenv('LANG') = LANGUAGE;

Line: 1070

    update FND_FORM_FUNCTIONS_TL set
      USER_FUNCTION_NAME = X_USER_FUNCTION_NAME,
      DESCRIPTION = X_DESCRIPTION,
      LAST_UPDATE_DATE = f_ludate,
      LAST_UPDATED_BY = f_luby,
      LAST_UPDATE_LOGIN = 0,
      SOURCE_LANG = userenv('LANG')
    where FUNCTION_ID = X_FUNCTION_ID
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 1086

procedure INSERT_ROW (
  X_ROWID in out nocopy VARCHAR2,
  X_FUNCTION_ID in NUMBER,
  X_WEB_HOST_NAME in VARCHAR2,
  X_WEB_AGENT_NAME in VARCHAR2,
  X_WEB_HTML_CALL in VARCHAR2,
  X_WEB_ENCRYPT_PARAMETERS in VARCHAR2,
  X_WEB_SECURED in VARCHAR2,
  X_WEB_ICON in VARCHAR2,
  X_OBJECT_ID in NUMBER,
  X_REGION_APPLICATION_ID in NUMBER,
  X_REGION_CODE in VARCHAR2,
  X_FUNCTION_NAME in VARCHAR2,
  X_APPLICATION_ID in NUMBER,
  X_FORM_ID in NUMBER,
  X_PARAMETERS in VARCHAR2,
  X_TYPE in VARCHAR2,
  X_USER_FUNCTION_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,
  X_MAINTENANCE_MODE_SUPPORT in VARCHAR2, /* NULL='NONE' */
  X_CONTEXT_DEPENDENCE in VARCHAR2,       /* NULL='RESP' */
  X_JRAD_REF_PATH in VARCHAR2 default NULL
) is
  cursor C is select ROWID from FND_FORM_FUNCTIONS
    where FUNCTION_ID = X_FUNCTION_ID;

Line: 1157

  insert into FND_FORM_FUNCTIONS (
    WEB_ICON,
    WEB_HOST_NAME,
    WEB_AGENT_NAME,
    WEB_HTML_CALL,
    WEB_ENCRYPT_PARAMETERS,
    WEB_SECURED,
    OBJECT_ID,
    REGION_APPLICATION_ID,
    REGION_CODE,
    FUNCTION_ID,
    FUNCTION_NAME,
    APPLICATION_ID,
    FORM_ID,
    PARAMETERS,
    TYPE,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    MAINTENANCE_MODE_SUPPORT,
    CONTEXT_DEPENDENCE,
    JRAD_REF_PATH
  ) values (
    X_WEB_ICON,
    X_WEB_HOST_NAME,
    X_WEB_AGENT_NAME,
    L_WEB_HTML_CALL,
    X_WEB_ENCRYPT_PARAMETERS,
    X_WEB_SECURED,
    X_OBJECT_ID,
    L_REGION_APPLICATION_ID,
    L_REGION_CODE,
    X_FUNCTION_ID,
    X_FUNCTION_NAME,
    L_APPLICATION_ID,
    L_FORM_ID,
    L_PARAMETERS,
    L_TYPE,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    L_MAINTENANCE_MODE_SUPPORT,
    L_CONTEXT_DEPENDENCE,
    X_JRAD_REF_PATH
  );

Line: 1208

	fnd_function_security_cache.insert_function(X_FUNCTION_ID);

Line: 1218

  insert into FND_FORM_FUNCTIONS_TL (
    FUNCTION_ID,
    USER_FUNCTION_NAME,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    DESCRIPTION,
    LANGUAGE,
    SOURCE_LANG
  ) select
    X_FUNCTION_ID,
    X_USER_FUNCTION_NAME,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    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_FORM_FUNCTIONS_TL T
    where T.FUNCTION_ID = X_FUNCTION_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 1256

end INSERT_ROW;

Line: 1281

  cursor c is select
      WEB_ICON,
      WEB_HOST_NAME,
      WEB_AGENT_NAME,
      WEB_HTML_CALL,
      WEB_ENCRYPT_PARAMETERS,
      WEB_SECURED,
      OBJECT_ID,
      REGION_APPLICATION_ID,
      REGION_CODE,
      FUNCTION_NAME,
      APPLICATION_ID,
      FORM_ID,
      PARAMETERS,
      TYPE,
      MAINTENANCE_MODE_SUPPORT,
      CONTEXT_DEPENDENCE,
      JRAD_REF_PATH
    from FND_FORM_FUNCTIONS
    where FUNCTION_ID = X_FUNCTION_ID
    for update of FUNCTION_ID nowait;

Line: 1304

  cursor c1 is select
      USER_FUNCTION_NAME,
      DESCRIPTION
    from FND_FORM_FUNCTIONS_TL
    where FUNCTION_ID = X_FUNCTION_ID
    and LANGUAGE = userenv('LANG')
    for update of FUNCTION_ID nowait;

Line: 1328

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

Line: 1391

procedure UPDATE_ROW (
  X_FUNCTION_ID in NUMBER,
  X_WEB_HOST_NAME in VARCHAR2,
  X_WEB_AGENT_NAME in VARCHAR2,
  X_WEB_HTML_CALL in VARCHAR2,
  X_WEB_ENCRYPT_PARAMETERS in VARCHAR2,
  X_WEB_SECURED in VARCHAR2,
  X_WEB_ICON in VARCHAR2,
  X_OBJECT_ID in NUMBER,
  X_REGION_APPLICATION_ID in NUMBER,
  X_REGION_CODE in VARCHAR2,
  X_FUNCTION_NAME in VARCHAR2,
  X_APPLICATION_ID in NUMBER,
  X_FORM_ID in NUMBER,
  X_PARAMETERS in VARCHAR2,
  X_TYPE in VARCHAR2,
  X_USER_FUNCTION_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,
  X_MAINTENANCE_MODE_SUPPORT in VARCHAR2, /* NULL='NONE' */
  X_CONTEXT_DEPENDENCE in VARCHAR2,       /* NULL='RESP' */
  X_JRAD_REF_PATH in VARCHAR2 default NULL
) is
  L_MAINTENANCE_MODE_SUPPORT VARCHAR2(8) := X_MAINTENANCE_MODE_SUPPORT;

Line: 1455

  update FND_FORM_FUNCTIONS set
    WEB_ICON = X_WEB_ICON,
    WEB_HOST_NAME = X_WEB_HOST_NAME,
    WEB_AGENT_NAME = X_WEB_AGENT_NAME,
    WEB_HTML_CALL = L_WEB_HTML_CALL,
    WEB_ENCRYPT_PARAMETERS = X_WEB_ENCRYPT_PARAMETERS,
    WEB_SECURED = X_WEB_SECURED,
    OBJECT_ID = X_OBJECT_ID,
    REGION_APPLICATION_ID = L_REGION_APPLICATION_ID,
    REGION_CODE = L_REGION_CODE,
    APPLICATION_ID = L_APPLICATION_ID,
    FORM_ID = L_FORM_ID,
    PARAMETERS = L_PARAMETERS,
    TYPE = L_TYPE,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    MAINTENANCE_MODE_SUPPORT = L_MAINTENANCE_MODE_SUPPORT,
    CONTEXT_DEPENDENCE = L_CONTEXT_DEPENDENCE,
    JRAD_REF_PATH = X_JRAD_REF_PATH
  where FUNCTION_ID = X_FUNCTION_ID;

Line: 1488

	-- This means that a function was updated.
	-- Added for Function Security Cache Invalidation Project
    fnd_function_security_cache.update_function(X_FUNCTION_ID);

Line: 1493

  update FND_FORM_FUNCTIONS_TL set
    USER_FUNCTION_NAME = X_USER_FUNCTION_NAME,
    DESCRIPTION = X_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 FUNCTION_ID = X_FUNCTION_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 1506

end UPDATE_ROW;

Line: 1518

    select 1 into valid_mode
    from dual
    where x_function_mode in (
      select lv.lookup_code
      from fnd_lookup_values lv
      where lv.lookup_type = 'APPS_MAINTENANCE_MODE_SUPPORT'
      and lv.language = userenv('LANG'));

Line: 1532

  update fnd_form_functions
  set maintenance_mode_support = x_function_mode
  where function_name like x_function_name;