APPS.PER_CATEGORY_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_CATEGORY_TYPE_ID in NUMBER,
  X_TYPE                   in VARCHAR2,
  X_HEADING_TEXT           in VARCHAR2,
  X_HELP_TEXT              in VARCHAR2,
  X_NOTE_TEXT              in VARCHAR2,
  X_FOOTER_TEXT            in VARCHAR2,
  X_CATEGORY_NAME          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_CATEGORY_TYPES (
    PROPOSAL_CATEGORY_TYPE_ID,
    CATEGORY_NAME,
    TYPE,
    HEADING_TEXT,
    HELP_TEXT,
    NOTE_TEXT,
    FOOTER_TEXT,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_PROPOSAL_CATEGORY_TYPE_ID,
    X_CATEGORY_NAME,
    X_TYPE,
    X_HEADING_TEXT,
    X_HELP_TEXT,
    X_NOTE_TEXT,
    X_FOOTER_TEXT,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 66

end INSERT_ROW;

Line: 74

    select CATEGORY_NAME
    from   PER_PROPOSAL_CATEGORY_TYPES
    where  PROPOSAL_CATEGORY_TYPE_ID = X_PROPOSAL_CATEGORY_TYPE_ID
    for update of CATEGORY_NAME nowait;

Line: 84

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

Line: 90

procedure UPDATE_ROW (
  X_PROPOSAL_CATEGORY_TYPE_ID   in NUMBER,
  X_TYPE                   in VARCHAR2,
  X_HEADING_TEXT           in VARCHAR2,
  X_HELP_TEXT              in VARCHAR2,
  X_NOTE_TEXT              in VARCHAR2,
  X_FOOTER_TEXT            in VARCHAR2,
  X_CATEGORY_NAME          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_CATEGORY_TYPES set
    CATEGORY_NAME = X_CATEGORY_NAME,
    TYPE = X_TYPE,
    HEADING_TEXT = X_HEADING_TEXT,
    HELP_TEXT = X_HELP_TEXT,
    NOTE_TEXT = X_NOTE_TEXT,
    FOOTER_TEXT = X_FOOTER_TEXT,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where PROPOSAL_CATEGORY_TYPE_ID = X_PROPOSAL_CATEGORY_TYPE_ID;

Line: 117

end UPDATE_ROW;

Line: 119

procedure DELETE_ROW (
  X_PROPOSAL_CATEGORY_TYPE_ID in NUMBER
) is
begin
  delete from PER_PROPOSAL_CATEGORY_TYPES
  where PROPOSAL_CATEGORY_TYPE_ID = X_PROPOSAL_CATEGORY_TYPE_ID;

Line: 128

end DELETE_ROW;

Line: 142

  X_LAST_UPDATE_DATE DATE;

Line: 143

  X_LAST_UPDATED_BY NUMBER;

Line: 144

  X_LAST_UPDATE_LOGIN NUMBER;

Line: 150

    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 155

    UPDATE_ROW (
      X_PROPOSAL_CATEGORY_TYPE_ID,
      X_TYPE,
      X_HEADING_TEXT,
      X_HELP_TEXT,
      X_NOTE_TEXT,
      X_FOOTER_TEXT,
      X_CATEGORY_NAME,
      X_LAST_UPDATE_DATE,
      X_LAST_UPDATED_BY,
      X_LAST_UPDATE_LOGIN
    );

Line: 169

      INSERT_ROW (
        X_PROPOSAL_CATEGORY_TYPE_ID,
        X_TYPE,
        X_HEADING_TEXT,
        X_HELP_TEXT,
        X_NOTE_TEXT,
        X_FOOTER_TEXT,
        X_CATEGORY_NAME,
        X_CREATION_DATE,
        X_CREATED_BY,
        X_LAST_UPDATE_DATE,
        X_LAST_UPDATED_BY,
        X_LAST_UPDATE_LOGIN
      );

Line: 197

  X_LAST_UPDATE_DATE DATE;

Line: 198

  X_LAST_UPDATED_BY NUMBER;

Line: 199

  X_LAST_UPDATE_LOGIN NUMBER;

Line: 205

    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 209

  update PER_PROPOSAL_CATEGORY_TYPES
  set CATEGORY_NAME = X_CATEGORY_NAME,
      HEADING_TEXT = X_HEADING_TEXT,
      HELP_TEXT = X_HELP_TEXT,
      NOTE_TEXT = X_NOTE_TEXT,
      FOOTER_TEXT = X_FOOTER_TEXT,
      LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
      LAST_UPDATED_BY = X_LAST_UPDATED_BY,
      LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where PROPOSAL_CATEGORY_TYPE_ID = X_PROPOSAL_CATEGORY_TYPE_ID
  and userenv('LANG') =   (Select language_code
  from FND_LANGUAGES where installed_flag = 'B');