APPS.FND_SIF_SETTINGS_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_HANDLER_CLASS in VARCHAR2,
  X_JAXB_INPUT in VARCHAR2,
  X_JAXB_OUTPUT in VARCHAR2,
  X_CALLBACK_AGENT in VARCHAR2,
  X_XSL_IN in VARCHAR2,
  X_XSL_OUT in VARCHAR2,
  X_CALLBACK_EVENT in VARCHAR2,
  X_ACTION in VARCHAR2,
  X_ACTION_ATTRIBUTE in VARCHAR2,
  X_LAST_UPDATE_DATE in VARCHAR2,
  X_OWNER in VARCHAR2
) is
  l_ROWID VARCHAR2(100);

Line: 20

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

Line: 21

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

Line: 24

  insert into FND_SIF_SETTINGS (
    HANDLER_CLASS,
    DEFINITION_NAME,
    JAXB_INPUT,
    JAXB_OUTPUT,
    CALLBACK_AGENT,
    XSL_IN,
    XSL_OUT,
    CALLBACK_EVENT,
    ACTION,
    ACTION_ATTRIBUTE,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    SECURITY_GROUP_ID
  ) values (
    X_HANDLER_CLASS,
    X_DEFINITION_NAME,
    X_JAXB_INPUT,
    X_JAXB_OUTPUT,
    X_CALLBACK_AGENT,
    X_XSL_IN,
    X_XSL_OUT,
    X_CALLBACK_EVENT,
    X_ACTION,
    X_ACTION_ATTRIBUTE,
    l_ludate,
    l_luby,
    l_ludate,
    l_luby,
    0,
    FND_GLOBAL.SECURITY_GROUP_ID);

Line: 63

    raise_application_error (-20000, 'FND_SIF_SETTINGS_PKG.INSERT_ROW: unable to create SIF setting '||X_DEFINITION_NAME);

Line: 67

end INSERT_ROW;

Line: 69

procedure UPDATE_ROW (
  X_DEFINITION_NAME in VARCHAR2,
  X_HANDLER_CLASS in VARCHAR2,
  X_JAXB_INPUT in VARCHAR2,
  X_JAXB_OUTPUT in VARCHAR2,
  X_CALLBACK_AGENT in VARCHAR2,
  X_XSL_IN in VARCHAR2,
  X_XSL_OUT in VARCHAR2,
  X_CALLBACK_EVENT in VARCHAR2,
  X_ACTION in VARCHAR2,
  X_ACTION_ATTRIBUTE in VARCHAR2,
  X_LAST_UPDATE_DATE in VARCHAR2,
  X_OWNER in VARCHAR2
) is
  l_luby    number := FND_LOAD_UTIL.OWNER_ID(X_OWNER);

Line: 84

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

Line: 86

  update FND_SIF_SETTINGS set
    HANDLER_CLASS = X_HANDLER_CLASS,
    JAXB_INPUT = X_JAXB_INPUT,
    JAXB_OUTPUT = X_JAXB_OUTPUT,
    CALLBACK_AGENT = X_CALLBACK_AGENT,
    XSL_IN = X_XSL_IN,
    XSL_OUT = X_XSL_OUT,
    CALLBACK_EVENT = X_CALLBACK_EVENT,
    DEFINITION_NAME = X_DEFINITION_NAME,
    ACTION = X_ACTION,
    ACTION_ATTRIBUTE = X_ACTION_ATTRIBUTE,
    LAST_UPDATE_DATE = l_ludate,
    LAST_UPDATED_BY = l_luby
  where DEFINITION_NAME = X_DEFINITION_NAME;

Line: 102

    INSERT_ROW(X_DEFINITION_NAME => UPDATE_ROW.X_DEFINITION_NAME,
               X_HANDLER_CLASS => UPDATE_ROW.X_HANDLER_CLASS,
               X_JAXB_INPUT => UPDATE_ROW.X_JAXB_INPUT,
               X_JAXB_OUTPUT => UPDATE_ROW.X_JAXB_OUTPUT,
               X_CALLBACK_AGENT => UPDATE_ROW.X_CALLBACK_AGENT,
               X_XSL_IN => UPDATE_ROW.X_XSL_IN,
               X_XSL_OUT => UPDATE_ROW.X_XSL_OUT,
               X_CALLBACK_EVENT => UPDATE_ROW.X_CALLBACK_EVENT,
               X_ACTION => UPDATE_ROW.X_ACTION,
               X_ACTION_ATTRIBUTE => UPDATE_ROW.X_ACTION_ATTRIBUTE,
               X_LAST_UPDATE_DATE => UPDATE_ROW.X_LAST_UPDATE_DATE,
               X_OWNER => UPDATE_ROW.X_OWNER);

Line: 115

end UPDATE_ROW;