APPS.PER_PROPOSAL_TEMPLATES_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_TEMPLATE_ID in NUMBER,
  X_PROPOSAL_NAME in VARCHAR2,
  X_DESCRIPTION   in VARCHAR2,
  X_TYPE          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_TEMPLATES (
    PROPOSAL_TEMPLATE_ID,
    PROPOSAL_NAME,
    DESCRIPTION,
    TYPE,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_PROPOSAL_TEMPLATE_ID,
    X_PROPOSAL_NAME,
    X_DESCRIPTION,
    X_TYPE,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 57

end INSERT_ROW;

Line: 65

    select PROPOSAL_NAME
    from   PER_PROPOSAL_TEMPLATES
    where  PROPOSAL_TEMPLATE_ID = X_PROPOSAL_TEMPLATE_ID
    for update of PROPOSAL_NAME nowait;

Line: 75

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

Line: 81

procedure UPDATE_ROW (
  X_PROPOSAL_TEMPLATE_ID in NUMBER,
  X_PROPOSAL_NAME in VARCHAR2,
  X_DESCRIPTION   in VARCHAR2,
  X_TYPE          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_TEMPLATES set
    PROPOSAL_NAME = X_PROPOSAL_NAME,
    DESCRIPTION = X_DESCRIPTION,
    TYPE = X_TYPE,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where PROPOSAL_TEMPLATE_ID = X_PROPOSAL_TEMPLATE_ID;

Line: 102

end UPDATE_ROW;

Line: 104

procedure DELETE_ROW (
  X_PROPOSAL_TEMPLATE_ID in NUMBER
) is
begin
  delete from PER_PROPOSAL_TEMPLATES
  where PROPOSAL_TEMPLATE_ID = X_PROPOSAL_TEMPLATE_ID;

Line: 113

end DELETE_ROW;

Line: 124

  X_LAST_UPDATE_DATE DATE;

Line: 125

  X_LAST_UPDATED_BY NUMBER;

Line: 126

  X_LAST_UPDATE_LOGIN NUMBER;

Line: 132

    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 137

    UPDATE_ROW (
	 X_PROPOSAL_TEMPLATE_ID,
      X_PROPOSAL_NAME,
      X_DESCRIPTION,
      X_TYPE,
      X_LAST_UPDATE_DATE,
      X_LAST_UPDATED_BY,
      X_LAST_UPDATE_LOGIN
    );

Line: 148

      INSERT_ROW (
	   X_PROPOSAL_TEMPLATE_ID,
	   X_PROPOSAL_NAME,
        X_DESCRIPTION,
        X_TYPE,
        X_CREATION_DATE,
        X_CREATED_BY,
        X_LAST_UPDATE_DATE,
        X_LAST_UPDATED_BY,
        X_LAST_UPDATE_LOGIN
      );

Line: 170

  X_LAST_UPDATE_DATE DATE;

Line: 171

  X_LAST_UPDATED_BY NUMBER;

Line: 172

  X_LAST_UPDATE_LOGIN NUMBER;

Line: 178

    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 182

  update PER_PROPOSAL_TEMPLATES
  set PROPOSAL_NAME = X_PROPOSAL_NAME,
      DESCRIPTION = X_DESCRIPTION,
      LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
      LAST_UPDATED_BY = X_LAST_UPDATED_BY,
      LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where PROPOSAL_TEMPLATE_ID = X_PROPOSAL_TEMPLATE_ID
  and userenv('LANG') =   (Select language_code
  from FND_LANGUAGES where installed_flag = 'B');