APPS.AS_CURRENT_ENVIRONMENT_PKG SQL Statements

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

Line: 3

procedure INSERT_ROW (
  X_ROWID in out VARCHAR2,
  X_CURRENT_ENVIRONMENT_ID in out NUMBER,
  X_ADDRESS_ID in NUMBER,
  X_CUSTOMER_ID in NUMBER,
  X_ENABLED_FLAG in VARCHAR2,
  X_INTEREST_TYPE_ID in NUMBER,
  X_PRIMARY_INTEREST_CODE_ID in NUMBER,
  X_SECONDARY_INTEREST_CODE_ID in NUMBER,
  X_DESCRIPTION in VARCHAR2,
  X_SOURCE      in VARCHAR2,
  X_SOURCE_ID   in NUMBER,
  X_INVENTORY_ITEM_ID in NUMBER,
  X_QUANTITY in NUMBER,
  X_PRICE in NUMBER,
  X_AMOUNT in NUMBER,
  X_COMMENTS in VARCHAR2,
  X_USER_DEF_NUM1 in NUMBER,
  X_USER_DEF_NUM2 in NUMBER,
  X_USER_DEF_NUM3 in NUMBER,
  X_USER_DEF_TEXT1 in VARCHAR2,
  X_USER_DEF_TEXT2 in VARCHAR2,
  X_USER_DEF_TEXT3 in VARCHAR2,
  X_INSTALLATION_DATE in DATE,
  X_USER_DEF_DATE in DATE,
  X_REEVALUATION_DATE in DATE,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_ATTRIBUTE1 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ATTRIBUTE5 in VARCHAR2,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE8 in VARCHAR2,
  X_ATTRIBUTE9 in VARCHAR2,
  X_ATTRIBUTE10 in VARCHAR2,
  X_ATTRIBUTE11 in VARCHAR2,
  X_ATTRIBUTE12 in VARCHAR2,
  X_ATTRIBUTE13 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_ATTRIBUTE15 in VARCHAR2,
  X_LAST_UPDATE_DATE  DATE,
  X_LAST_UPDATED_BY   NUMBER,
  X_LAST_UPDATE_LOGIN NUMBER,
  X_CREATION_DATE     DATE,
  X_CREATED_BY        NUMBER,
  X_MODE in VARCHAR2 default 'R'
  ) is
    cursor C is select ROWID from AS_CURRENT_ENVIRONMENT
      where CURRENT_ENVIRONMENT_ID = X_CURRENT_ENVIRONMENT_ID;

Line: 56

      SELECT  AS_Current_Environment_S.nextval
      FROM sys.dual;

Line: 69

  insert into AS_CURRENT_ENVIRONMENT (

    CURRENT_ENVIRONMENT_ID,
    ADDRESS_ID,
    CUSTOMER_ID,
    ENABLED_FLAG,
    INTEREST_TYPE_ID,
    PRIMARY_INTEREST_CODE_ID,
    SECONDARY_INTEREST_CODE_ID,
    DESCRIPTION,
    SOURCE,
    SOURCE_ID,
    INVENTORY_ITEM_ID,
    QUANTITY,
    PRICE,
    AMOUNT,
    COMMENTS,
    USER_DEF_NUM1,
    USER_DEF_NUM2,
    USER_DEF_NUM3,
    USER_DEF_TEXT1,
    USER_DEF_TEXT2,
    USER_DEF_TEXT3,
    INSTALLATION_DATE,
    USER_DEF_DATE,
    REEVALUATION_DATE,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (

    X_CURRENT_ENVIRONMENT_ID,
    X_ADDRESS_ID,
    X_CUSTOMER_ID,
    X_ENABLED_FLAG,
    X_INTEREST_TYPE_ID,
    X_PRIMARY_INTEREST_CODE_ID,
    X_SECONDARY_INTEREST_CODE_ID,
    X_DESCRIPTION,
    X_SOURCE,
    X_SOURCE_ID,
    X_INVENTORY_ITEM_ID,
    X_QUANTITY,
    X_PRICE,
    X_AMOUNT,
    X_COMMENTS,
    X_USER_DEF_NUM1,
    X_USER_DEF_NUM2,
    X_USER_DEF_NUM3,
    X_USER_DEF_TEXT1,
    X_USER_DEF_TEXT2,
    X_USER_DEF_TEXT3,
    X_INSTALLATION_DATE,
    X_USER_DEF_DATE,
    X_REEVALUATION_DATE,
    X_ATTRIBUTE_CATEGORY,
    X_ATTRIBUTE1,
    X_ATTRIBUTE2,
    X_ATTRIBUTE3,
    X_ATTRIBUTE4,
    X_ATTRIBUTE5,
    X_ATTRIBUTE6,
    X_ATTRIBUTE7,
    X_ATTRIBUTE8,
    X_ATTRIBUTE9,
    X_ATTRIBUTE10,
    X_ATTRIBUTE11,
    X_ATTRIBUTE12,
    X_ATTRIBUTE13,
    X_ATTRIBUTE14,
    X_ATTRIBUTE15,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 173

end INSERT_ROW;

Line: 216

  X_LAST_UPDATE_DATE  DATE,
  X_LAST_UPDATED_BY   NUMBER,
  X_LAST_UPDATE_LOGIN NUMBER,
  X_CREATION_DATE     DATE,
  X_CREATED_BY        NUMBER
) is
  cursor c is select

      ADDRESS_ID,
      CUSTOMER_ID,
      ENABLED_FLAG,
      INTEREST_TYPE_ID,
      PRIMARY_INTEREST_CODE_ID,
      SECONDARY_INTEREST_CODE_ID,
      DESCRIPTION,
      SOURCE,
      SOURCE_ID,
      INVENTORY_ITEM_ID,
      QUANTITY,
      PRICE,
      AMOUNT,
      COMMENTS,
      USER_DEF_NUM1,
      USER_DEF_NUM2,
      USER_DEF_NUM3,
      USER_DEF_TEXT1,
      USER_DEF_TEXT2,
      USER_DEF_TEXT3,
      INSTALLATION_DATE,
      USER_DEF_DATE,
      REEVALUATION_DATE,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      LAST_UPDATE_DATE,
      LAST_UPDATED_BY,
      LAST_UPDATE_LOGIN,
      CREATION_DATE,
      CREATED_BY
    from AS_CURRENT_ENVIRONMENT
    where CURRENT_ENVIRONMENT_ID = X_CURRENT_ENVIRONMENT_ID
    for update  nowait;

Line: 278

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

Line: 393

      AND (recinfo.LAST_UPDATE_DATE = X_LAST_UPDATE_DATE)
      AND (recinfo.LAST_UPDATED_BY = X_LAST_UPDATED_BY)
      AND (recinfo.LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN)
      AND (recinfo.CREATION_DATE = X_CREATION_DATE)
      AND (recinfo.CREATED_BY = X_CREATED_BY)
  ) then
    null;

Line: 407

procedure UPDATE_ROW (
  X_CURRENT_ENVIRONMENT_ID in NUMBER,
  X_ADDRESS_ID in NUMBER,
  X_CUSTOMER_ID in NUMBER,
  X_ENABLED_FLAG in VARCHAR2,
  X_INTEREST_TYPE_ID in NUMBER,
  X_PRIMARY_INTEREST_CODE_ID in NUMBER,
  X_SECONDARY_INTEREST_CODE_ID in NUMBER,
  X_DESCRIPTION in VARCHAR2,
  X_SOURCE      in VARCHAR2,
  X_SOURCE_ID   in NUMBER,
  X_INVENTORY_ITEM_ID in NUMBER,
  X_QUANTITY in NUMBER,
  X_PRICE in NUMBER,
  X_AMOUNT in NUMBER,
  X_COMMENTS in VARCHAR2,
  X_USER_DEF_NUM1 in NUMBER,
  X_USER_DEF_NUM2 in NUMBER,
  X_USER_DEF_NUM3 in NUMBER,
  X_USER_DEF_TEXT1 in VARCHAR2,
  X_USER_DEF_TEXT2 in VARCHAR2,
  X_USER_DEF_TEXT3 in VARCHAR2,
  X_INSTALLATION_DATE in DATE,
  X_USER_DEF_DATE in DATE,
  X_REEVALUATION_DATE in DATE,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_ATTRIBUTE1 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ATTRIBUTE5 in VARCHAR2,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE8 in VARCHAR2,
  X_ATTRIBUTE9 in VARCHAR2,
  X_ATTRIBUTE10 in VARCHAR2,
  X_ATTRIBUTE11 in VARCHAR2,
  X_ATTRIBUTE12 in VARCHAR2,
  X_ATTRIBUTE13 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_ATTRIBUTE15 in VARCHAR2,
  X_LAST_UPDATE_DATE  DATE,
  X_LAST_UPDATED_BY   NUMBER,
  X_LAST_UPDATE_LOGIN NUMBER,
  X_MODE in VARCHAR2 default 'R'
  ) is

begin


    update AS_CURRENT_ENVIRONMENT set
      CURRENT_ENVIRONMENT_ID = X_CURRENT_ENVIRONMENT_ID,
      ADDRESS_ID = X_ADDRESS_ID,
      CUSTOMER_ID = X_CUSTOMER_ID,
      ENABLED_FLAG = X_ENABLED_FLAG,
      INTEREST_TYPE_ID = X_INTEREST_TYPE_ID,
      PRIMARY_INTEREST_CODE_ID = X_PRIMARY_INTEREST_CODE_ID,
      SECONDARY_INTEREST_CODE_ID = X_SECONDARY_INTEREST_CODE_ID,
      DESCRIPTION = X_DESCRIPTION,
      SOURCE      = X_SOURCE,
      SOURCE_ID   = X_SOURCE_ID,
      INVENTORY_ITEM_ID = X_INVENTORY_ITEM_ID,
      QUANTITY = X_QUANTITY,
      PRICE = X_PRICE,
      AMOUNT = X_AMOUNT,
      COMMENTS = X_COMMENTS,
      USER_DEF_NUM1 = X_USER_DEF_NUM1,
      USER_DEF_NUM2 = X_USER_DEF_NUM2,
      USER_DEF_NUM3 = X_USER_DEF_NUM3,
      USER_DEF_TEXT1 = X_USER_DEF_TEXT1,
      USER_DEF_TEXT2 = X_USER_DEF_TEXT2,
      USER_DEF_TEXT3 = X_USER_DEF_TEXT3,
      INSTALLATION_DATE = X_INSTALLATION_DATE,
      USER_DEF_DATE = X_USER_DEF_DATE,
      REEVALUATION_DATE = X_REEVALUATION_DATE,
      ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
      ATTRIBUTE1 = X_ATTRIBUTE1,
      ATTRIBUTE2 = X_ATTRIBUTE2,
      ATTRIBUTE3 = X_ATTRIBUTE3,
      ATTRIBUTE4 = X_ATTRIBUTE4,
      ATTRIBUTE5 = X_ATTRIBUTE5,
      ATTRIBUTE6 = X_ATTRIBUTE6,
      ATTRIBUTE7 = X_ATTRIBUTE7,
      ATTRIBUTE8 = X_ATTRIBUTE8,
      ATTRIBUTE9 = X_ATTRIBUTE9,
      ATTRIBUTE10 = X_ATTRIBUTE10,
      ATTRIBUTE11 = X_ATTRIBUTE11,
      ATTRIBUTE12 = X_ATTRIBUTE12,
      ATTRIBUTE13 = X_ATTRIBUTE13,
      ATTRIBUTE14 = X_ATTRIBUTE14,
      ATTRIBUTE15 = X_ATTRIBUTE15,
      LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
      LAST_UPDATED_BY = X_LAST_UPDATED_BY,
      LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
    where CURRENT_ENVIRONMENT_ID = X_CURRENT_ENVIRONMENT_ID;

Line: 506

end UPDATE_ROW;

Line: 508

procedure DELETE_ROW (
  X_CURRENT_ENVIRONMENT_ID in NUMBER
) is
begin
  delete from AS_CURRENT_ENVIRONMENT
  where CURRENT_ENVIRONMENT_ID = X_CURRENT_ENVIRONMENT_ID;

Line: 519

end DELETE_ROW;

Line: 522

PROCEDURE  SELECT_TOTAL_AMOUNT(X_CUSTOMER_ID IN NUMBER,
                               X_ADDRESS_ID  IN NUMBER,
                               X_TOTAL       IN OUT NUMBER,
                               X_TOTAL_RTOT_DB  IN OUT NUMBER) IS

BEGIN
     SELECT   NVL(SUM(Amount),0)
     INTO  X_TOTAL
     FROM  AS_CURRENT_ENVIRONMENT
     WHERE X_CUSTOMER_ID = Customer_Id AND
           X_ADDRESS_ID  = Address_Id;

Line: 536

END  SELECT_TOTAL_AMOUNT;

Line: 539

PROCEDURE  SELECT_TOTAL_USER_DEF_NUM1(X_CUSTOMER_ID IN NUMBER,
                               X_ADDRESS_ID  IN NUMBER,
                               X_TOTAL       IN OUT NUMBER,
                               X_TOTAL_RTOT_DB  IN OUT NUMBER) IS

BEGIN
     SELECT   NVL(SUM(User_Def_Num1),0)
     INTO  X_TOTAL
     FROM  AS_CURRENT_ENVIRONMENT
     WHERE X_CUSTOMER_ID = Customer_Id AND
           X_ADDRESS_ID  = Address_Id;

Line: 553

END  SELECT_TOTAL_USER_DEF_NUM1;