APPS.PER_OFFER_PARAGRAPHS_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_PARAGRAPH_NO in VARCHAR2,
  X_BODY_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_OFFER_PARAGRAPHS (
    PARAGRAPH_NO,
    BODY_TEXT,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_PARAGRAPH_NO,
    X_BODY_TEXT,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 51

end INSERT_ROW;

Line: 59

    select PARAGRAPH_NO
    from   PER_PROPOSAL_OFFER_PARAGRAPHS
    where  PARAGRAPH_NO = X_PARAGRAPH_NO
    for update of PARAGRAPH_NO nowait;

Line: 69

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

Line: 75

procedure UPDATE_ROW (
  X_PARAGRAPH_NO in VARCHAR2,
  X_BODY_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_OFFER_PARAGRAPHS set
    BODY_TEXT = X_BODY_TEXT,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where PARAGRAPH_NO = X_PARAGRAPH_NO;

Line: 92

end UPDATE_ROW;

Line: 94

procedure DELETE_ROW (
  X_PARAGRAPH_NO in VARCHAR2
) is
begin
  delete from PER_PROPOSAL_OFFER_PARAGRAPHS
  where PARAGRAPH_NO = X_PARAGRAPH_NO;

Line: 103

end DELETE_ROW;

Line: 112

  X_LAST_UPDATE_DATE DATE;

Line: 113

  X_LAST_UPDATED_BY NUMBER;

Line: 114

  X_LAST_UPDATE_LOGIN NUMBER;

Line: 120

    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 125

    UPDATE_ROW (
      X_PARAGRAPH_NO,
      X_BODY_TEXT,
      X_LAST_UPDATE_DATE,
      X_LAST_UPDATED_BY,
      X_LAST_UPDATE_LOGIN
    );

Line: 134

      INSERT_ROW (
        X_PARAGRAPH_NO,
        X_BODY_TEXT,
        X_CREATION_DATE,
        X_CREATED_BY,
        X_LAST_UPDATE_DATE,
        X_LAST_UPDATED_BY,
        X_LAST_UPDATE_LOGIN
      );

Line: 153

  X_LAST_UPDATE_DATE DATE;

Line: 154

  X_LAST_UPDATED_BY NUMBER;

Line: 155

  X_LAST_UPDATE_LOGIN NUMBER;

Line: 161

    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 165

  update PER_PROPOSAL_OFFER_PARAGRAPHS
  set BODY_TEXT = X_BODY_TEXT,
      LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
      LAST_UPDATED_BY = X_LAST_UPDATED_BY,
      LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where PARAGRAPH_NO = X_PARAGRAPH_NO
  and userenv('LANG') =   (Select language_code
  from FND_LANGUAGES where installed_flag = 'B');