APPS.PER_QUESTION_TYPES_PKG SQL Statements

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

Line: 7

  X_LAST_UPDATE_DATE out DATE,
  X_LAST_UPDATED_BY out NUMBER,
  X_LAST_UPDATE_LOGIN out NUMBER
) is
begin
  if X_OWNER = 'SEED' then
    X_CREATED_BY := 1;

Line: 14

    X_LAST_UPDATED_BY := 1;

Line: 17

    X_LAST_UPDATED_BY := 0;

Line: 20

  X_LAST_UPDATE_DATE := sysdate;

Line: 21

  X_LAST_UPDATE_LOGIN := 0;

Line: 24

procedure INSERT_ROW (
  X_PROPOSAL_QUESTION_NAME in VARCHAR2,
  X_ALIGN                  in VARCHAR2,
  X_HTML_TYPE              in VARCHAR2,
  X_WIDTH_SIZE             in NUMBER,
  X_HEIGHT_SIZE            in NUMBER,
  X_MAXLENGTH              in NUMBER,
  X_DEFAULT_VALUE_TYPE     in VARCHAR2,
  X_LOOKUP_TYPE            in VARCHAR2,
  X_OPTION_SQL_TEXT        in VARCHAR2,
  X_PROVIDE_FIND           in VARCHAR2,
  X_FIND_FILTER_COLUMN     in VARCHAR2,
  X_FIND_SELECT_SQL        in VARCHAR2,
  X_TYPE                   in VARCHAR2,
  X_DEFAULT_VALUE          in VARCHAR2,
  X_FULL_TEXT              in VARCHAR2,
  X_QUESTION_HEADER        in VARCHAR2,
  X_HELP_TEXT              in VARCHAR2,
  X_NOTE_TEXT              in VARCHAR2,
  X_CREATION_DATE in DATE,
  X_CREATED_BY in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in VARCHAR2,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  insert into PER_PROPOSAL_QUESTION_TYPES (
    PROPOSAL_QUESTION_NAME,
    ALIGN,
    HTML_TYPE,
    WIDTH_SIZE,
    HEIGHT_SIZE,
    MAXLENGTH,
    DEFAULT_VALUE_TYPE,
    LOOKUP_TYPE,
    OPTION_SQL_TEXT,
    PROVIDE_FIND,
    FIND_FILTER_COLUMN,
    FIND_SELECT_SQL,
    TYPE,
    DEFAULT_VALUE,
    FULL_TEXT,
    QUESTION_HEADER,
    HELP_TEXT,
    NOTE_TEXT,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_PROPOSAL_QUESTION_NAME,
    X_ALIGN,
    X_HTML_TYPE,
    X_WIDTH_SIZE,
    X_HEIGHT_SIZE,
    X_MAXLENGTH,
    X_DEFAULT_VALUE_TYPE,
    X_LOOKUP_TYPE,
    X_OPTION_SQL_TEXT,
    X_PROVIDE_FIND,
    X_FIND_FILTER_COLUMN,
    X_FIND_SELECT_SQL,
    X_TYPE,
    X_DEFAULT_VALUE,
    X_FULL_TEXT,
    X_QUESTION_HEADER,
    X_HELP_TEXT,
    X_NOTE_TEXT,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 99

end INSERT_ROW;

Line: 107

    select PROPOSAL_QUESTION_NAME
    from   PER_PROPOSAL_QUESTION_TYPES
    where  PROPOSAL_QUESTION_NAME = X_PROPOSAL_QUESTION_NAME
    for update of PROPOSAL_QUESTION_NAME nowait;

Line: 117

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

Line: 123

procedure UPDATE_ROW (
  X_PROPOSAL_QUESTION_NAME in VARCHAR2,
  X_ALIGN                  in VARCHAR2,
  X_HTML_TYPE              in VARCHAR2,
  X_WIDTH_SIZE             in NUMBER,
  X_HEIGHT_SIZE            in NUMBER,
  X_MAXLENGTH              in NUMBER,
  X_DEFAULT_VALUE_TYPE     in VARCHAR2,
  X_LOOKUP_TYPE            in VARCHAR2,
  X_OPTION_SQL_TEXT        in VARCHAR2,
  X_PROVIDE_FIND           in VARCHAR2,
  X_FIND_FILTER_COLUMN     in VARCHAR2,
  X_FIND_SELECT_SQL        in VARCHAR2,
  X_TYPE                   in VARCHAR2,
  X_DEFAULT_VALUE          in VARCHAR2,
  X_FULL_TEXT              in VARCHAR2,
  X_QUESTION_HEADER        in VARCHAR2,
  X_HELP_TEXT              in VARCHAR2,
  X_NOTE_TEXT              in VARCHAR2,
  X_LAST_UPDATE_DATE       in DATE,
  X_LAST_UPDATED_BY        in VARCHAR2,
  X_LAST_UPDATE_LOGIN      in NUMBER
) is
begin
  update PER_PROPOSAL_QUESTION_TYPES set
    ALIGN = X_ALIGN,
    HTML_TYPE = X_HTML_TYPE,
    WIDTH_SIZE = X_WIDTH_SIZE,
    HEIGHT_SIZE = X_HEIGHT_SIZE,
    MAXLENGTH = X_MAXLENGTH,
    DEFAULT_VALUE_TYPE = X_DEFAULT_VALUE_TYPE,
    LOOKUP_TYPE = X_LOOKUP_TYPE,
    OPTION_SQL_TEXT = X_OPTION_SQL_TEXT,
    PROVIDE_FIND = X_PROVIDE_FIND,
    FIND_FILTER_COLUMN = X_FIND_FILTER_COLUMN,
    FIND_SELECT_SQL = X_FIND_SELECT_SQL,
    TYPE = X_TYPE,
    DEFAULT_VALUE = X_DEFAULT_VALUE,
    FULL_TEXT = X_FULL_TEXT,
    QUESTION_HEADER = X_QUESTION_HEADER,
    HELP_TEXT = X_HELP_TEXT,
    NOTE_TEXT = X_NOTE_TEXT,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where PROPOSAL_QUESTION_NAME = X_PROPOSAL_QUESTION_NAME;

Line: 172

end UPDATE_ROW;

Line: 174

procedure DELETE_ROW (
  X_PROPOSAL_QUESTION_NAME in VARCHAR2
) is
begin
  delete from PER_PROPOSAL_QUESTION_TYPES
  where PROPOSAL_QUESTION_NAME = X_PROPOSAL_QUESTION_NAME;

Line: 183

end DELETE_ROW;

Line: 197

  X_FIND_SELECT_SQL        in VARCHAR2,
  X_TYPE                   in VARCHAR2,
  X_DEFAULT_VALUE          in VARCHAR2,
  X_FULL_TEXT              in VARCHAR2,
  X_QUESTION_HEADER        in VARCHAR2,
  X_HELP_TEXT              in VARCHAR2,
  X_NOTE_TEXT              in VARCHAR2,
  X_OWNER in VARCHAR2
) is
  X_CREATION_DATE DATE;

Line: 208

  X_LAST_UPDATE_DATE DATE;

Line: 209

  X_LAST_UPDATED_BY NUMBER;

Line: 210

  X_LAST_UPDATE_LOGIN NUMBER;

Line: 216

    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 221

    UPDATE_ROW (
      X_PROPOSAL_QUESTION_NAME,
      X_ALIGN,
      X_HTML_TYPE,
      X_WIDTH_SIZE,
      X_HEIGHT_SIZE,
      X_MAXLENGTH,
      X_DEFAULT_VALUE_TYPE,
      X_LOOKUP_TYPE,
      X_OPTION_SQL_TEXT,
      X_PROVIDE_FIND,
      X_FIND_FILTER_COLUMN,
      X_FIND_SELECT_SQL,
      X_TYPE,
      X_DEFAULT_VALUE,
      X_FULL_TEXT,
      X_QUESTION_HEADER,
      X_HELP_TEXT,
      X_NOTE_TEXT,
      X_LAST_UPDATE_DATE,
      X_LAST_UPDATED_BY,
      X_LAST_UPDATE_LOGIN
    );

Line: 246

      INSERT_ROW (
        X_PROPOSAL_QUESTION_NAME,
        X_ALIGN,
        X_HTML_TYPE,
        X_WIDTH_SIZE,
        X_HEIGHT_SIZE,
        X_MAXLENGTH,
        X_DEFAULT_VALUE_TYPE,
        X_LOOKUP_TYPE,
        X_OPTION_SQL_TEXT,
        X_PROVIDE_FIND,
        X_FIND_FILTER_COLUMN,
        X_FIND_SELECT_SQL,
        X_TYPE,
        X_DEFAULT_VALUE,
        X_FULL_TEXT,
        X_QUESTION_HEADER,
        X_HELP_TEXT,
        X_NOTE_TEXT,
        X_CREATION_DATE,
        X_CREATED_BY,
        X_LAST_UPDATE_DATE,
        X_LAST_UPDATED_BY,
        X_LAST_UPDATE_LOGIN
      );

Line: 285

  X_LAST_UPDATE_DATE DATE;

Line: 286

  X_LAST_UPDATED_BY NUMBER;

Line: 287

  X_LAST_UPDATE_LOGIN NUMBER;

Line: 293

    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 297

  update PER_PROPOSAL_QUESTION_TYPES
  set DEFAULT_VALUE = X_DEFAULT_VALUE,
      FULL_TEXT = X_FULL_TEXT,
      QUESTION_HEADER = X_QUESTION_HEADER,
      HELP_TEXT = X_HELP_TEXT,
      NOTE_TEXT = X_NOTE_TEXT,
      LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
      LAST_UPDATED_BY = X_LAST_UPDATED_BY,
      LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where PROPOSAL_QUESTION_NAME = X_PROPOSAL_QUESTION_NAME
  and userenv('LANG') =   (Select language_code
  from FND_LANGUAGES where installed_flag = 'B');