APPS.GMS_AWARDS_TC_PKG SQL Statements

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

Line: 3

procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_AWARD_ID in NUMBER,
  X_CATEGORY_ID in NUMBER,
  X_TERM_ID in NUMBER,
  X_OPERAND in VARCHAR2,
  X_VALUE in NUMBER,
  X_MODE in VARCHAR2 default 'R'
  ) is
    cursor C is select ROWID from GMS_AWARDS_TERMS_CONDITIONS
      where AWARD_ID = X_AWARD_ID
      and CATEGORY_ID = X_CATEGORY_ID
      and TERM_ID = X_TERM_ID;

Line: 16

    X_LAST_UPDATE_DATE DATE;

Line: 17

    X_LAST_UPDATED_BY NUMBER;

Line: 18

    X_LAST_UPDATE_LOGIN NUMBER;

Line: 20

  X_LAST_UPDATE_DATE := SYSDATE;

Line: 22

    X_LAST_UPDATED_BY := 1;

Line: 23

    X_LAST_UPDATE_LOGIN := 0;

Line: 25

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 26

    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 29

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 30

    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 37

  insert into GMS_AWARDS_TERMS_CONDITIONS (
    AWARD_ID,
    CATEGORY_ID,
    TERM_ID,
    OPERAND,
    VALUE,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_AWARD_ID,
    X_CATEGORY_ID,
    X_TERM_ID,
    X_OPERAND,
    X_VALUE,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 67

end INSERT_ROW;

Line: 75

  cursor c1 is select
      OPERAND,
      VALUE
    from GMS_AWARDS_TERMS_CONDITIONS
    where AWARD_ID = X_AWARD_ID
    and CATEGORY_ID = X_CATEGORY_ID
    and TERM_ID = X_TERM_ID
    for update of AWARD_ID nowait;

Line: 108

procedure UPDATE_ROW (
  X_AWARD_ID in NUMBER,
  X_CATEGORY_ID in NUMBER,
  X_TERM_ID in NUMBER,
  X_OPERAND in VARCHAR2,
  X_VALUE in NUMBER,
  X_MODE in VARCHAR2 default 'R'
  ) is
    X_LAST_UPDATE_DATE DATE;

Line: 117

    X_LAST_UPDATED_BY NUMBER;

Line: 118

    X_LAST_UPDATE_LOGIN NUMBER;

Line: 120

  X_LAST_UPDATE_DATE := SYSDATE;

Line: 122

    X_LAST_UPDATED_BY := 1;

Line: 123

    X_LAST_UPDATE_LOGIN := 0;

Line: 125

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 126

    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 129

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 130

    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 137

  update GMS_AWARDS_TERMS_CONDITIONS set
    OPERAND = X_OPERAND,
    VALUE = X_VALUE,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where AWARD_ID = X_AWARD_ID
  and CATEGORY_ID = X_CATEGORY_ID
  and TERM_ID = X_TERM_ID
  ;

Line: 150

end UPDATE_ROW;

Line: 151

procedure DELETE_ROW (
  X_AWARD_ID in NUMBER,
  X_CATEGORY_ID in NUMBER,
  X_TERM_ID in NUMBER
) is
begin
  delete from GMS_AWARDS_TERMS_CONDITIONS
  where AWARD_ID = X_AWARD_ID
  and CATEGORY_ID = X_CATEGORY_ID
  and TERM_ID = X_TERM_ID;

Line: 164

end DELETE_ROW;