APPS.IGW_PROP_LOCATIONS_TBH SQL Statements

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

Line: 3

procedure INSERT_ROW (
  X_ROWID  out NOCOPY ROWID,
  X_PROPOSAL_ID in NUMBER,
  X_PERFORMING_ORGANIZATION_ID in NUMBER,
  X_PARTY_ID                   in NUMBER,
  X_MODE in VARCHAR2 default 'R',
  X_RETURN_STATUS   OUT NOCOPY VARCHAR2
  ) is

    cursor C is select ROWID from IGW_PROP_LOCATIONS
    where PROPOSAL_ID = X_PROPOSAL_ID
    and   (PERFORMING_ORGANIZATION_ID = X_PERFORMING_ORGANIZATION_ID or PARTY_ID = X_PARTY_ID);

Line: 16

    X_LAST_UPDATE_DATE DATE;

Line: 17

    X_LAST_UPDATED_BY NUMBER;

Line: 18

    X_LAST_UPDATE_LOGIN NUMBER;

Line: 22

  X_LAST_UPDATE_DATE := SYSDATE;

Line: 24

    X_LAST_UPDATED_BY := 1;

Line: 25

    X_LAST_UPDATE_LOGIN := 0;

Line: 27

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 28

    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 31

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 32

    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 40

  insert into IGW_PROP_LOCATIONS (
    PROP_LOCATION_ID,
    PROPOSAL_ID,
    PERFORMING_ORGANIZATION_ID,
    PARTY_ID,
    RECORD_VERSION_NUMBER,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    IGW_PROP_LOCATIONS_S.NEXTVAL,
    X_PROPOSAL_ID,
    X_PERFORMING_ORGANIZATION_ID,
    X_PARTY_ID,
    1,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 74

                              ,p_procedure_name => 'INSERT_ROW' );

Line: 77

end INSERT_ROW;

Line: 80

procedure UPDATE_ROW (
  X_ROWID in ROWID,
  X_PROPOSAL_ID in NUMBER,
  X_PERFORMING_ORGANIZATION_ID in NUMBER,
  X_PARTY_ID                   in NUMBER,
  X_RECORD_VERSION_NUMBER      in number,
  X_MODE in VARCHAR2 default 'R',
  X_RETURN_STATUS   OUT NOCOPY VARCHAR2
  ) is
    X_LAST_UPDATE_DATE DATE;

Line: 90

    X_LAST_UPDATED_BY NUMBER;

Line: 91

    X_LAST_UPDATE_LOGIN NUMBER;

Line: 96

  SELECT rowid
  FROM   IGW_PROP_LOCATIONS
  WHERE  proposal_id = x_proposal_id
  AND   (PERFORMING_ORGANIZATION_ID = X_PERFORMING_ORGANIZATION_ID or PARTY_ID = X_PARTY_ID);

Line: 110

  X_LAST_UPDATE_DATE := SYSDATE;

Line: 112

    X_LAST_UPDATED_BY := 1;

Line: 113

    X_LAST_UPDATE_LOGIN := 0;

Line: 115

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 116

    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 119

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 120

    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 128

  update IGW_PROP_LOCATIONS set
    PERFORMING_ORGANIZATION_ID = X_PERFORMING_ORGANIZATION_ID,
    PARTY_ID = X_PARTY_ID,
    RECORD_VERSION_NUMBER = X_RECORD_VERSION_NUMBER + 1,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
    where ROWID = L_ROW_ID
    AND   RECORD_VERSION_NUMBER = X_RECORD_VERSION_NUMBER;

Line: 147

                              ,p_procedure_name => 'UPDATE_ROW' );

Line: 150

end UPDATE_ROW;

Line: 153

procedure DELETE_ROW (
  X_ROWID            IN ROWID
  ,X_PROPOSAL_ID                  IN NUMBER
  ,X_PERFORMING_ORGANIZATION_ID     IN NUMBER
  ,X_PARTY_ID                      in NUMBER
  ,X_RECORD_VERSION_NUMBER       IN NUMBER
  ,X_RETURN_STATUS   OUT NOCOPY VARCHAR2
) is


  l_row_id  ROWID := x_rowid;

Line: 166

  SELECT rowid
  FROM   IGW_PROP_LOCATIONS
  WHERE  proposal_id = x_proposal_id
  AND    (PERFORMING_ORGANIZATION_ID = X_PERFORMING_ORGANIZATION_ID or PARTY_ID = X_PARTY_ID);

Line: 182

  delete from IGW_PROP_LOCATIONS
  where ROWID = L_ROW_ID
  AND   RECORD_VERSION_NUMBER = X_RECORD_VERSION_NUMBER;

Line: 195

                              ,p_procedure_name => 'DELETE_ROW' );

Line: 198

end DELETE_ROW;