APPS.ASO_TERRITORY_ACCESSES_PKG SQL Statements

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

Line: 7

procedure INSERT_ROW (
  P_ACCESS_ID			IN NUMBER,
  P_TERRITORY_ID		IN NUMBER,
  P_LAST_UPDATE_DATE		IN DATE,
  P_LAST_UPDATED_BY		IN NUMBER,
  P_CREATION_DATE		IN DATE,
  P_CREATED_BY			IN NUMBER,
  P_LAST_UPDATE_LOGIN		IN NUMBER,
  P_REQUEST_ID			IN NUMBER,
  P_PROGRAM_APPLICATION_ID	IN NUMBER,
  P_PROGRAM_ID			IN NUMBER,
  P_PROGRAM_UPDATE_DATE		IN DATE,
  P_CONC_REQUEST_ID		IN NUMBER
)
IS

BEGIN
  insert into ASO_TERRITORY_ACCESSES (
    ACCESS_ID,
    TERRITORY_ID,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN,
    REQUEST_ID,
    PROGRAM_APPLICATION_ID,
    PROGRAM_ID,
    PROGRAM_UPDATE_DATE,
    CONC_REQUEST_ID
  ) VALUES
  (
    decode( P_ACCESS_ID, FND_API.G_MISS_NUM, NULL, P_ACCESS_ID),
    decode( P_TERRITORY_ID, FND_API.G_MISS_NUM, NULL, P_TERRITORY_ID),
    ASO_UTILITY_PVT.decode( P_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
    decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
    ASO_UTILITY_PVT.decode( P_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
    decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
    decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
    decode( P_REQUEST_ID, FND_API.G_MISS_NUM, NULL, P_REQUEST_ID),
    decode( P_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, P_PROGRAM_APPLICATION_ID),
    decode( P_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, P_PROGRAM_ID),
    ASO_UTILITY_PVT.decode( P_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, P_PROGRAM_UPDATE_DATE),
    decode( P_CONC_REQUEST_ID, FND_API.G_MISS_NUM, NULL, P_CONC_REQUEST_ID)
   );

Line: 53

end INSERT_ROW;

Line: 55

procedure UPDATE_ROW (
  P_ACCESS_ID			IN NUMBER,
  P_TERRITORY_ID		IN NUMBER,
  P_LAST_UPDATE_DATE		IN DATE,
  P_LAST_UPDATED_BY		IN NUMBER,
  P_CREATION_DATE		IN DATE,
  P_CREATED_BY			IN NUMBER,
  P_LAST_UPDATE_LOGIN		IN NUMBER,
  P_REQUEST_ID			IN NUMBER,
  P_PROGRAM_APPLICATION_ID	IN NUMBER,
  P_PROGRAM_ID			IN NUMBER,
  P_PROGRAM_UPDATE_DATE		IN DATE,
  P_CONC_REQUEST_ID		IN NUMBER)
IS
BEGIN
  update ASO_TERRITORY_ACCESSES
  set
  ACCESS_ID = decode( P_ACCESS_ID, FND_API.G_MISS_NUM, ACCESS_ID, P_ACCESS_ID),
  TERRITORY_ID = decode( P_TERRITORY_ID, FND_API.G_MISS_NUM, TERRITORY_ID, P_TERRITORY_ID),
  LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
  LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
  LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
  REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
  PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM,PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
  PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
  PROGRAM_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
  CONC_REQUEST_ID = decode( P_CONC_REQUEST_ID, FND_API.G_MISS_NUM, CONC_REQUEST_ID, P_CONC_REQUEST_ID)
  WHERE ACCESS_ID = P_ACCESS_ID
  AND TERRITORY_ID = P_TERRITORY_ID ;

Line: 89

end UPDATE_ROW;

Line: 91

procedure DELETE_ROW (
  P_ACCESS_ID			IN NUMBER,
  P_TERRITORY_ID		IN NUMBER
) is
begin
  delete from ASO_TERRITORY_ACCESSES
  where ACCESS_ID = P_ACCESS_ID
  and TERRITORY_ID = P_TERRITORY_ID;

Line: 104

end DELETE_ROW;

Line: 109

  P_LAST_UPDATE_DATE		IN DATE,
  P_LAST_UPDATED_BY		IN NUMBER,
  P_CREATION_DATE		IN DATE,
  P_CREATED_BY			IN NUMBER,
  P_LAST_UPDATE_LOGIN		IN NUMBER,
  P_REQUEST_ID			IN NUMBER,
  P_PROGRAM_APPLICATION_ID	IN NUMBER,
  P_PROGRAM_ID			IN NUMBER,
  P_PROGRAM_UPDATE_DATE		IN DATE,
  P_CONC_REQUEST_ID		IN NUMBER)
IS
  cursor c1 is select
  ACCESS_ID,
  TERRITORY_ID,
  LAST_UPDATE_DATE,
  LAST_UPDATED_BY,
  CREATION_DATE,
  CREATED_BY,
  LAST_UPDATE_LOGIN,
  REQUEST_ID,
  PROGRAM_APPLICATION_ID,
  PROGRAM_ID,
  PROGRAM_UPDATE_DATE,
  CONC_REQUEST_ID
  from ASO_TERRITORY_ACCESSES
     where ACCESS_ID = P_ACCESS_ID
     and TERRITORY_ID = P_TERRITORY_ID
     for update of CONC_REQUEST_ID nowait;

Line: 144

      FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');

Line: 150

   if  (    ( Recinfo.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE)
            OR (    ( Recinfo.LAST_UPDATE_DATE IS NULL )
                AND (  p_LAST_UPDATE_DATE IS NULL ))) then
       return;