APPS.FND_SIF_DEFINITIONS_PKG SQL Statements

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

Line: 4

procedure INSERT_ROW (
  X_DEFINITION_NAME in VARCHAR2,
  X_WSDL_TNS in VARCHAR2,
  X_WSDL_URL in VARCHAR2,
  X_APPLICATION_ID in NUMBER,
  X_STATUS in VARCHAR2,
  X_INTERACTION_TYPE in VARCHAR2,
  X_SERVICE in VARCHAR2,
  X_PORT in VARCHAR2,
  X_OPERATION in VARCHAR2,
  X_DISPLAY_NAME in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_LAST_UPDATE_DATE in VARCHAR2,
  X_OWNER in VARCHAR2
) is
  l_ROWID VARCHAR2(100);

Line: 21

  l_ludate  date   := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);

Line: 22

  cursor C is select ROWID from FND_SIF_DEFINITIONS
    where DEFINITION_NAME = X_DEFINITION_NAME;

Line: 25

  insert into FND_SIF_DEFINITIONS (
    WSDL_TNS,
    ATTR1,
    DEFINITION_NAME,
    APPLICATION_ID,
    STATUS,
    INTERACTION_TYPE,
    SERVICE,
    PORT,
    OPERATION,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    SECURITY_GROUP_ID
  ) values (
    X_WSDL_TNS,
    X_WSDL_URL,
    X_DEFINITION_NAME,
    X_APPLICATION_ID,
    X_STATUS,
    X_INTERACTION_TYPE,
    X_SERVICE,
    X_PORT,
    X_OPERATION,
    l_ludate,
    l_luby,
    l_ludate,
    l_luby,
    0,
    FND_GLOBAL.SECURITY_GROUP_ID
  );

Line: 59

  insert into FND_SIF_DEFINITIONS_TL (
    DEFINITION_NAME,
    DISPLAY_NAME,
    DESCRIPTION,
    LANGUAGE,
    SOURCE_LANG,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    SECURITY_GROUP_ID
  ) select
    X_DEFINITION_NAME,
    X_DISPLAY_NAME,
    X_DESCRIPTION,
    L.LANGUAGE_CODE,
    userenv('LANG'),
    l_ludate,
    l_luby,
    l_ludate,
    l_luby,
    0,
    FND_GLOBAL.SECURITY_GROUP_ID
  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from FND_SIF_DEFINITIONS_TL T
    where T.DEFINITION_NAME = X_DEFINITION_NAME
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 95

    raise_application_error (-20000, 'FND_SIF_DEFINITIONS_PKG.INSERT_ROW: unable to create definition '||X_DEFINITION_NAME);

Line: 98

end INSERT_ROW;

Line: 104

  X_LAST_UPDATE_DATE in VARCHAR2,
  X_OWNER in VARCHAR2
) is
  l_luby    number := FND_LOAD_UTIL.OWNER_ID(X_OWNER);

Line: 108

  l_ludate  date   := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);

Line: 110

  update FND_SIF_DEFINITIONS_TL
  set DISPLAY_NAME = X_DISPLAY_NAME,
      DESCRIPTION = X_DESCRIPTION,
      LAST_UPDATE_DATE = l_ludate,
      LAST_UPDATED_BY = l_luby,
      SOURCE_LANG = userenv('LANG')
  where DEFINITION_NAME = X_DEFINITION_NAME
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 124

procedure UPDATE_ROW (
  X_DEFINITION_NAME in VARCHAR2,
  X_WSDL_TNS in VARCHAR2,
  X_WSDL_URL in VARCHAR2,
  X_APPLICATION_ID in NUMBER,
  X_STATUS in VARCHAR2,
  X_INTERACTION_TYPE in VARCHAR2,
  X_SERVICE in VARCHAR2,
  X_PORT in VARCHAR2,
  X_OPERATION in VARCHAR2,
  X_DISPLAY_NAME in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_LAST_UPDATE_DATE in VARCHAR2,
  X_OWNER in VARCHAR2
) is
  l_luby    number := FND_LOAD_UTIL.OWNER_ID(X_OWNER);

Line: 140

  l_ludate  date   := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);

Line: 142

  update FND_SIF_DEFINITIONS set
    WSDL_TNS = X_WSDL_TNS,
    ATTR1 = X_WSDL_URL,
    APPLICATION_ID = X_APPLICATION_ID,
    STATUS = X_STATUS,
    INTERACTION_TYPE = X_INTERACTION_TYPE,
    SERVICE = X_SERVICE,
    PORT = X_PORT,
    OPERATION = X_OPERATION,
    LAST_UPDATE_DATE = l_ludate,
    LAST_UPDATED_BY = l_luby
  where DEFINITION_NAME = X_DEFINITION_NAME;

Line: 156

    INSERT_ROW (X_DEFINITION_NAME => UPDATE_ROW.X_DEFINITION_NAME,
                X_WSDL_TNS => UPDATE_ROW.X_WSDL_TNS,
                X_WSDL_URL => UPDATE_ROW.X_WSDL_URL,
                X_APPLICATION_ID => UPDATE_ROW.X_APPLICATION_ID,
                X_STATUS => UPDATE_ROW.X_STATUS,
                X_INTERACTION_TYPE => UPDATE_ROW.X_INTERACTION_TYPE,
                X_SERVICE => UPDATE_ROW.X_SERVICE,
                X_PORT => UPDATE_ROW.X_PORT,
                X_OPERATION => UPDATE_ROW.X_OPERATION,
                X_DISPLAY_NAME => UPDATE_ROW.X_DISPLAY_NAME,
                X_DESCRIPTION => UPDATE_ROW.X_DESCRIPTION,
                X_LAST_UPDATE_DATE => UPDATE_ROW.X_LAST_UPDATE_DATE,
                X_OWNER => UPDATE_ROW.X_OWNER);

Line: 170

    TRANSLATE_ROW (X_DEFINITION_NAME => UPDATE_ROW.X_DEFINITION_NAME,
                   X_DISPLAY_NAME => UPDATE_ROW.X_DISPLAY_NAME,
                   X_DESCRIPTION => UPDATE_ROW.X_DESCRIPTION,
                   X_LAST_UPDATE_DATE => UPDATE_ROW.X_LAST_UPDATE_DATE,
                   X_OWNER => UPDATE_ROW.X_OWNER);

Line: 176

end UPDATE_ROW;

Line: 180

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