APPS.AMS_METRICS_ALL_PKG SQL Statements

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

Line: 21

procedure INSERT_ROW  (
  X_ROWID in VARCHAR2,
  X_METRIC_ID in NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_ARC_METRIC_USED_FOR_OBJECT in VARCHAR2,
  X_METRIC_CALCULATION_TYPE in VARCHAR2,
  X_APPLICATION_ID in NUMBER,
  X_METRIC_CATEGORY in NUMBER,
  X_ACCRUAL_TYPE in VARCHAR2,
  X_VALUE_TYPE in VARCHAR2,
  X_SENSITIVE_DATA_FLAG in VARCHAR2,
  X_ENABLED_FLAG in VARCHAR2,
  X_METRIC_SUB_CATEGORY in NUMBER,
  X_FUNCTION_NAME in VARCHAR2,
  X_FUNCTION_TYPE in VARCHAR2,
  X_METRIC_PARENT_ID in NUMBER,
  X_SUMMARY_METRIC_ID in NUMBER,
  X_COMPUTE_USING_FUNCTION in VARCHAR2,
  X_DEFAULT_UOM_CODE in VARCHAR2,
  X_UOM_TYPE in VARCHAR2,
  X_FORMULA in VARCHAR2,
  X_DISPLAY_TYPE in VARCHAR2,
  X_METRICS_NAME in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_FORMULA_DISPLAY in VARCHAR2,
  X_TARGET_TYPE in VARCHAR2,
  X_DENORM_CODE in VARCHAR2,
  X_CREATION_DATE in DATE,
  X_CREATED_BY in NUMBER,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
  cursor C is select ROWID from AMS_METRICS_ALL_B
    where METRIC_ID = X_METRIC_ID
    ;

Line: 59

  insert into AMS_METRICS_ALL_B (
    METRIC_ID,
    OBJECT_VERSION_NUMBER,
    ARC_METRIC_USED_FOR_OBJECT,
    METRIC_CALCULATION_TYPE,
    APPLICATION_ID,
    METRIC_CATEGORY,
    ACCRUAL_TYPE,
    VALUE_TYPE,
    SENSITIVE_DATA_FLAG,
    ENABLED_FLAG,
    METRIC_SUB_CATEGORY,
    FUNCTION_NAME,
	 FUNCTION_TYPE,
    METRIC_PARENT_ID,
    SUMMARY_METRIC_ID,
    COMPUTE_USING_FUNCTION,
    DEFAULT_UOM_CODE,
    UOM_TYPE,
    FORMULA,
	 DISPLAY_TYPE,
   TARGET_TYPE,
   DENORM_CODE,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_METRIC_ID,
    X_OBJECT_VERSION_NUMBER,
    X_ARC_METRIC_USED_FOR_OBJECT,
    X_METRIC_CALCULATION_TYPE,
    X_APPLICATION_ID,
    X_METRIC_CATEGORY,
    X_ACCRUAL_TYPE,
    X_VALUE_TYPE,
    X_SENSITIVE_DATA_FLAG,
    X_ENABLED_FLAG,
    X_METRIC_SUB_CATEGORY,
    X_FUNCTION_NAME,
	 X_FUNCTION_TYPE,
    X_METRIC_PARENT_ID,
    X_SUMMARY_METRIC_ID,
    X_COMPUTE_USING_FUNCTION,
    X_DEFAULT_UOM_CODE,
    X_UOM_TYPE,
    X_FORMULA,
	 X_DISPLAY_TYPE,
   X_TARGET_TYPE,
   X_DENORM_CODE,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 117

  insert into AMS_METRICS_ALL_TL (
    METRICS_NAME,
    DESCRIPTION,
	 FORMULA_DISPLAY,
    METRIC_ID,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN,
    LANGUAGE,
    SOURCE_LANG
  ) select
    X_METRICS_NAME,
    X_DESCRIPTION,
    X_FORMULA_DISPLAY,
    X_METRIC_ID,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_LOGIN,
    L.LANGUAGE_CODE,
    userenv('LANG')
  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from AMS_METRICS_ALL_TL T
    where T.METRIC_ID = X_METRIC_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 157

end INSERT_ROW;

Line: 186

  cursor c is select
      OBJECT_VERSION_NUMBER,
      ARC_METRIC_USED_FOR_OBJECT,
      METRIC_CALCULATION_TYPE,
      APPLICATION_ID,
      METRIC_CATEGORY,
      ACCRUAL_TYPE,
      VALUE_TYPE,
      SENSITIVE_DATA_FLAG,
      ENABLED_FLAG,
      METRIC_SUB_CATEGORY,
      FUNCTION_NAME,
		FUNCTION_TYPE,
      METRIC_PARENT_ID,
      SUMMARY_METRIC_ID,
      COMPUTE_USING_FUNCTION,
      DEFAULT_UOM_CODE,
      UOM_TYPE,
      FORMULA,
		DISPLAY_TYPE,
    TARGET_TYPE,
    DENORM_CODE
    from AMS_METRICS_ALL_B
    where METRIC_ID = X_METRIC_ID
    for update of METRIC_ID nowait;

Line: 213

  cursor c1 is select
      METRICS_NAME,
      DESCRIPTION,
		FORMULA_DISPLAY,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from AMS_METRICS_ALL_TL
    where METRIC_ID = X_METRIC_ID
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of METRIC_ID nowait;

Line: 227

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

Line: 299

procedure UPDATE_ROW (
  X_METRIC_ID in NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_ARC_METRIC_USED_FOR_OBJECT in VARCHAR2,
  X_METRIC_CALCULATION_TYPE in VARCHAR2,
  X_APPLICATION_ID in NUMBER,
  X_METRIC_CATEGORY in NUMBER,
  X_ACCRUAL_TYPE in VARCHAR2,
  X_VALUE_TYPE in VARCHAR2,
  X_SENSITIVE_DATA_FLAG in VARCHAR2,
  X_ENABLED_FLAG in VARCHAR2,
  X_METRIC_SUB_CATEGORY in NUMBER,
  X_FUNCTION_NAME in VARCHAR2,
  X_FUNCTION_TYPE in VARCHAR2,
  X_METRIC_PARENT_ID in NUMBER,
  X_SUMMARY_METRIC_ID in NUMBER,
  X_COMPUTE_USING_FUNCTION in VARCHAR2,
  X_DEFAULT_UOM_CODE in VARCHAR2,
  X_UOM_TYPE in VARCHAR2,
  X_FORMULA in VARCHAR2,
  X_DISPLAY_TYPE in VARCHAR2,
  X_METRICS_NAME in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_FORMULA_DISPLAY in VARCHAR2,
  X_TARGET_TYPE in VARCHAR2,
  X_DENORM_CODE in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update AMS_METRICS_ALL_B set
    OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
    ARC_METRIC_USED_FOR_OBJECT = X_ARC_METRIC_USED_FOR_OBJECT,
    METRIC_CALCULATION_TYPE = X_METRIC_CALCULATION_TYPE,
    APPLICATION_ID = X_APPLICATION_ID,
    METRIC_CATEGORY = X_METRIC_CATEGORY,
    ACCRUAL_TYPE = X_ACCRUAL_TYPE,
    VALUE_TYPE = X_VALUE_TYPE,
    SENSITIVE_DATA_FLAG = X_SENSITIVE_DATA_FLAG,
    ENABLED_FLAG = X_ENABLED_FLAG,
    METRIC_SUB_CATEGORY = X_METRIC_SUB_CATEGORY,
    FUNCTION_NAME = X_FUNCTION_NAME,
    FUNCTION_TYPE = X_FUNCTION_TYPE,
    METRIC_PARENT_ID = X_METRIC_PARENT_ID,
    SUMMARY_METRIC_ID = X_SUMMARY_METRIC_ID,
    COMPUTE_USING_FUNCTION = X_COMPUTE_USING_FUNCTION,
    DEFAULT_UOM_CODE = X_DEFAULT_UOM_CODE,
    UOM_TYPE = X_UOM_TYPE,
    FORMULA = X_FORMULA,
    DISPLAY_TYPE = X_DISPLAY_TYPE,
    TARGET_TYPE = X_TARGET_TYPE,
    DENORM_CODE = X_DENORM_CODE,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where METRIC_ID = X_METRIC_ID;

Line: 361

  update AMS_METRICS_ALL_TL set
    METRICS_NAME = X_METRICS_NAME,
    DESCRIPTION = X_DESCRIPTION,
	  FORMULA_DISPLAY = X_FORMULA_DISPLAY,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    SOURCE_LANG = userenv('LANG')
  where METRIC_ID = X_METRIC_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 375

end UPDATE_ROW;

Line: 377

procedure DELETE_ROW (
  X_METRIC_ID in NUMBER
) is
begin
  delete from AMS_METRICS_ALL_TL
  where METRIC_ID = X_METRIC_ID;

Line: 388

  delete from AMS_METRICS_ALL_B
  where METRIC_ID = X_METRIC_ID;

Line: 394

end DELETE_ROW;

Line: 399

  delete from AMS_METRICS_ALL_TL T
  where not exists
    (select NULL
    from AMS_METRICS_ALL_B B
    where B.METRIC_ID = T.METRIC_ID
    );

Line: 406

  update AMS_METRICS_ALL_TL T set (
      METRICS_NAME,
      DESCRIPTION,
		FORMULA_DISPLAY
    ) = (select
      B.METRICS_NAME,
      B.DESCRIPTION,
		B.FORMULA_DISPLAY
    from AMS_METRICS_ALL_TL B
    where B.METRIC_ID = T.METRIC_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.METRIC_ID,
      T.LANGUAGE
  ) in (select
      SUBT.METRIC_ID,
      SUBT.LANGUAGE
    from AMS_METRICS_ALL_TL SUBB, AMS_METRICS_ALL_TL SUBT
    where SUBB.METRIC_ID = SUBT.METRIC_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.METRICS_NAME <> SUBT.METRICS_NAME
      or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
      or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
      or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
      or SUBB.FORMULA_DISPLAY <> SUBT.FORMULA_DISPLAY
      or (SUBB.FORMULA_DISPLAY is null and SUBT.FORMULA_DISPLAY is not null)
      or (SUBB.FORMULA_DISPLAY is not null and SUBT.FORMULA_DISPLAY is null)
  ));

Line: 435

  insert into AMS_METRICS_ALL_TL (
    METRICS_NAME,
    DESCRIPTION,
	 FORMULA_DISPLAY,
    METRIC_ID,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN,
    LANGUAGE,
    SOURCE_LANG
  ) select
    B.METRICS_NAME,
    B.DESCRIPTION,
	 B.FORMULA_DISPLAY,
    B.METRIC_ID,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATED_BY,
    B.CREATION_DATE,
    B.CREATED_BY,
    B.LAST_UPDATE_LOGIN,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from AMS_METRICS_ALL_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from AMS_METRICS_ALL_TL T
    where T.METRIC_ID = B.METRIC_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 477

    update AMS_METRICS_ALL_TL set
       metrics_name = nvl(x_metrics_name, metrics_name),
       description = nvl(x_description, description),
       formula_display = nvl(x_formula_display, formula_display),
       source_lang = userenv('LANG'),
       last_update_date = sysdate,
       last_updated_by = decode(x_owner, 'SEED', 1, 0),
       last_update_login = 0
    where  metric_id = x_metric_id
    and      userenv('LANG') in (language, source_lang);

Line: 526

  select last_updated_by, object_version_number
  from    AMS_METRICS_ALL_B
  where  metric_id =  X_METRIC_ID;

Line: 531

  select 'x'
  from   AMS_METRICS_ALL_B
  where  metric_id = X_METRIC_ID;

Line: 536

   select AMS_METRICS_ALL_B_S.nextval
   from dual;

Line: 566

 AMS_METRICS_ALL_PKG.INSERT_ROW (
  X_ROWID                       => l_row_id ,
  X_METRIC_ID                   => l_metric_id,
  X_OBJECT_VERSION_NUMBER       => l_obj_verno,
  X_ARC_METRIC_USED_FOR_OBJECT  => X_ARC_METRIC_USED_FOR_OBJECT,
  X_METRIC_CALCULATION_TYPE     => X_METRIC_CALCULATION_TYPE,
  X_APPLICATION_ID              => X_APPLICATION_ID,
  X_METRIC_CATEGORY             => X_METRIC_CATEGORY,
  X_ACCRUAL_TYPE                => X_ACCRUAL_TYPE,
  X_VALUE_TYPE                  => X_VALUE_TYPE,
  X_SENSITIVE_DATA_FLAG         => X_SENSITIVE_DATA_FLAG,
  X_ENABLED_FLAG                => X_ENABLED_FLAG,
  X_METRIC_SUB_CATEGORY         => X_METRIC_SUB_CATEGORY,
  X_FUNCTION_NAME               => X_FUNCTION_NAME,
  X_FUNCTION_TYPE               => X_FUNCTION_TYPE,
  X_METRIC_PARENT_ID            => X_METRIC_PARENT_ID,
  X_SUMMARY_METRIC_ID           => X_SUMMARY_METRIC_ID,
  X_COMPUTE_USING_FUNCTION      => X_COMPUTE_USING_FUNCTION,
  X_DEFAULT_UOM_CODE            => X_DEFAULT_UOM_CODE,
  X_UOM_TYPE                    => X_UOM_TYPE,
  X_FORMULA                     => X_FORMULA,
  X_DISPLAY_TYPE                => X_DISPLAY_TYPE,
  X_METRICS_NAME                => X_METRICS_NAME,
  X_DESCRIPTION                 => X_DESCRIPTION,
  X_FORMULA_DISPLAY             => X_FORMULA_DISPLAY,
  X_TARGET_TYPE                 => X_TARGET_TYPE,
  X_DENORM_CODE                 => X_DENORM_CODE,
  X_CREATION_DATE               => SYSDATE,
  X_CREATED_BY                  => l_user_id,
  X_LAST_UPDATE_DATE            => SYSDATE,
  X_LAST_UPDATED_BY             => l_user_id,
  X_LAST_UPDATE_LOGIN           => 0
) ;

Line: 607

    AMS_METRICS_ALL_PKG.UPDATE_ROW(
    X_METRIC_ID				      =>  X_METRIC_ID,
    X_OBJECT_VERSION_NUMBER       => l_obj_verno + 1,
    X_ARC_METRIC_USED_FOR_OBJECT  => X_ARC_METRIC_USED_FOR_OBJECT,
    X_METRIC_CALCULATION_TYPE     => X_METRIC_CALCULATION_TYPE,
    X_APPLICATION_ID              => X_APPLICATION_ID,
    X_METRIC_CATEGORY             => X_METRIC_CATEGORY,
    X_ACCRUAL_TYPE                => X_ACCRUAL_TYPE,
    X_VALUE_TYPE                  => X_VALUE_TYPE,
    X_SENSITIVE_DATA_FLAG         => X_SENSITIVE_DATA_FLAG,
    X_ENABLED_FLAG                => X_ENABLED_FLAG,
    X_METRIC_SUB_CATEGORY         => X_METRIC_SUB_CATEGORY,
    X_FUNCTION_NAME               => X_FUNCTION_NAME,
    X_FUNCTION_TYPE               => X_FUNCTION_TYPE,
    X_METRIC_PARENT_ID            => X_METRIC_PARENT_ID,
    X_SUMMARY_METRIC_ID           => X_SUMMARY_METRIC_ID,
    X_COMPUTE_USING_FUNCTION      => X_COMPUTE_USING_FUNCTION,
    X_DEFAULT_UOM_CODE            => X_DEFAULT_UOM_CODE,
    X_UOM_TYPE                    => X_UOM_TYPE,
    X_FORMULA                     => X_FORMULA,
    X_DISPLAY_TYPE                => X_DISPLAY_TYPE,
    X_METRICS_NAME                => X_METRICS_NAME,
    X_DESCRIPTION                 => X_DESCRIPTION,
    X_FORMULA_DISPLAY             => X_FORMULA_DISPLAY,
    X_TARGET_TYPE                 => X_TARGET_TYPE,
    X_DENORM_CODE                 => X_DENORM_CODE,
    X_LAST_UPDATE_DATE            => SYSDATE,
    X_LAST_UPDATED_BY             => l_user_id,
    X_LAST_UPDATE_LOGIN           => 0
  );