APPS.PSA_IMPLEMENTATION_ALL_PKG SQL Statements

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

Line: 14

procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_PSA_FEATURE in VARCHAR2,
  X_ORG_ID in NUMBER,
  X_STATUS in VARCHAR2,
  X_ALLOCATION_METHOD in VARCHAR2,
  X_MAPPING_REQUIRED in VARCHAR2,
  X_PROGRAM_INSTALLED in VARCHAR2,
  X_MODE in VARCHAR2
  ) is
    cursor C is select ROWID from PSA_IMPLEMENTATION_ALL
      where PSA_FEATURE = X_PSA_FEATURE
      and ORG_ID = X_ORG_ID;

Line: 27

    X_LAST_UPDATE_DATE DATE;

Line: 28

    X_LAST_UPDATED_BY NUMBER;

Line: 29

    X_LAST_UPDATE_LOGIN NUMBER;

Line: 32

    l_full_path VARCHAR2(100) := g_path || 'INSERT_ROW';

Line: 38

  X_LAST_UPDATE_DATE := SYSDATE;

Line: 40

    X_LAST_UPDATED_BY := 1;

Line: 41

    X_LAST_UPDATE_LOGIN := 0;

Line: 43

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 44

    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 47

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 48

    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 58

  insert into PSA_IMPLEMENTATION_ALL (
    PSA_FEATURE,
    STATUS,
    ORG_ID,
    ALLOCATION_METHOD,
    MAPPING_REQUIRED,
    PROGRAM_INSTALLED,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_PSA_FEATURE,
    X_STATUS,
    X_ORG_ID,
    X_ALLOCATION_METHOD,
    X_MAPPING_REQUIRED,
    X_PROGRAM_INSTALLED,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 97

end INSERT_ROW;

Line: 107

  cursor c1 is select
      STATUS,
      ALLOCATION_METHOD,
      MAPPING_REQUIRED,
      PROGRAM_INSTALLED
    from PSA_IMPLEMENTATION_ALL
    where PSA_FEATURE = X_PSA_FEATURE
    and ORG_ID = X_ORG_ID
    for update of PSA_FEATURE nowait;

Line: 158

procedure UPDATE_ROW (
  X_PSA_FEATURE in VARCHAR2,
  X_ORG_ID in NUMBER,
  X_STATUS in VARCHAR2,
  X_ALLOCATION_METHOD in VARCHAR2,
  X_MAPPING_REQUIRED in VARCHAR2,
  X_PROGRAM_INSTALLED in VARCHAR2,
  X_MODE in VARCHAR2
  ) is
    X_LAST_UPDATE_DATE DATE;

Line: 168

    X_LAST_UPDATED_BY NUMBER;

Line: 169

    X_LAST_UPDATE_LOGIN NUMBER;

Line: 171

    l_full_path VARCHAR2(100) := g_path || 'UPDATE_ROW';

Line: 174

  X_LAST_UPDATE_DATE := SYSDATE;

Line: 176

    X_LAST_UPDATED_BY := 1;

Line: 177

    X_LAST_UPDATE_LOGIN := 0;

Line: 179

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 180

    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 183

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 184

    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 194

  update PSA_IMPLEMENTATION_ALL set
    STATUS = X_STATUS,
    ALLOCATION_METHOD = X_ALLOCATION_METHOD,
    MAPPING_REQUIRED = X_MAPPING_REQUIRED,
    PROGRAM_INSTALLED = X_PROGRAM_INSTALLED,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where PSA_FEATURE = X_PSA_FEATURE
  and ORG_ID = X_ORG_ID
  ;

Line: 208

end UPDATE_ROW;

Line: 220

  cursor c1 is select rowid from PSA_IMPLEMENTATION_ALL
     where PSA_FEATURE = X_PSA_FEATURE
     and ORG_ID = X_ORG_ID
  ;

Line: 232

    INSERT_ROW (
     X_ROWID,
     X_PSA_FEATURE,
     X_ORG_ID,
     X_STATUS,
     X_ALLOCATION_METHOD,
     X_MAPPING_REQUIRED,
     X_PROGRAM_INSTALLED,
     X_MODE);

Line: 244

  UPDATE_ROW (
   X_PSA_FEATURE,
   X_ORG_ID,
   X_STATUS,
   X_ALLOCATION_METHOD,
   X_MAPPING_REQUIRED,
   X_PROGRAM_INSTALLED,
   X_MODE);

Line: 259

procedure DELETE_ROW (
  X_PSA_FEATURE in VARCHAR2,
  X_ORG_ID in NUMBER
) is
begin
  delete from PSA_IMPLEMENTATION_ALL
  where PSA_FEATURE = X_PSA_FEATURE
  and ORG_ID = X_ORG_ID;

Line: 270

end DELETE_ROW;