APPS.FND_SIF_POLICIES_PKG SQL Statements

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

Line: 4

procedure INSERT_ROW (
  X_POLICY_NAME in VARCHAR2,
  X_POLICY_REF_XML in CLOB,
  X_TYPE in VARCHAR2,
  X_LAST_UPDATE_DATE in VARCHAR2,
  X_OWNER in VARCHAR2
) is
  l_ROWID VARCHAR2(100);

Line: 13

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

Line: 14

  cursor C is select ROWID from FND_SIF_POLICIES
    where POLICY_NAME = X_POLICY_NAME;

Line: 17

  insert into FND_SIF_POLICIES (
    POLICY_REF_XML,
    POLICY_NAME,
    TYPE,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    SECURITY_GROUP_ID
  ) values (
    X_POLICY_REF_XML,
    X_POLICY_NAME,
    X_TYPE,
    l_ludate,
    l_luby,
    l_ludate,
    l_luby,
    0,
    FND_GLOBAL.SECURITY_GROUP_ID);

Line: 42

    raise_application_error (-20000, 'FND_SIF_POLICIES_PKG.INSERT_ROW: unable to create policy '||X_POLICY_NAME);

Line: 45

end INSERT_ROW;

Line: 47

procedure UPDATE_ROW (
  X_POLICY_NAME in VARCHAR2,
  X_POLICY_REF_XML in CLOB,
  X_TYPE in VARCHAR2,
  X_LAST_UPDATE_DATE in VARCHAR2,
  X_OWNER in VARCHAR2
) is
  l_luby    number := FND_LOAD_UTIL.OWNER_ID(X_OWNER);

Line: 55

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

Line: 57

  update FND_SIF_POLICIES set
    POLICY_REF_XML = X_POLICY_REF_XML,
    POLICY_NAME = X_POLICY_NAME,
    TYPE = X_TYPE,
    LAST_UPDATE_DATE = l_ludate,
    LAST_UPDATED_BY = l_luby
  where POLICY_NAME = X_POLICY_NAME;

Line: 66

    INSERT_ROW(X_POLICY_NAME => UPDATE_ROW.X_POLICY_NAME,
               X_POLICY_REF_XML => UPDATE_ROW.X_POLICY_REF_XML,
               X_TYPE => X_TYPE,
               X_LAST_UPDATE_DATE => UPDATE_ROW.X_LAST_UPDATE_DATE,
               X_OWNER => UPDATE_ROW.X_OWNER);

Line: 72

end UPDATE_ROW;