eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FM_FORM_MST_MLS SQL Statements

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

Line: 3


procedure INSERT_ROW (
  X_ROWID in OUT NOCOPY VARCHAR2,
  X_FORMULA_ID in NUMBER,
  X_MASTER_FORMULA_ID in NUMBER,
  X_OWNER_ORGANIZATION_ID in NUMBER,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_TEXT_CODE in NUMBER,
  X_DELETE_MARK in NUMBER,
  X_TOTAL_INPUT_QTY in NUMBER,
  X_PROJECT_ID in NUMBER,
  X_TOTAL_OUTPUT_QTY in NUMBER,
  X_YIELD_UOM	in VARCHAR2,
  X_FORMULA_STATUS in VARCHAR2,
  X_OWNER_ID in NUMBER,
  X_FORMULA_NO in VARCHAR2,
  X_FORMULA_VERS in NUMBER,
  X_FORMULA_TYPE in NUMBER,
  X_ATTRIBUTE5 in VARCHAR2,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ATTRIBUTE30 in VARCHAR2,
  X_IN_USE in NUMBER,
  X_INACTIVE_IND in NUMBER,
  X_ATTRIBUTE1 in VARCHAR2,
  X_SCALE_TYPE in NUMBER,
  X_FORMULA_CLASS in VARCHAR2,
  X_FMCONTROL_CLASS 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_ATTRIBUTE16 in VARCHAR2,
  X_ATTRIBUTE17 in VARCHAR2,
  X_ATTRIBUTE18 in VARCHAR2,
  X_ATTRIBUTE19 in VARCHAR2,
  X_ATTRIBUTE20 in VARCHAR2,
  X_ATTRIBUTE21 in VARCHAR2,
  X_ATTRIBUTE22 in VARCHAR2,
  X_ATTRIBUTE23 in VARCHAR2,
  X_ATTRIBUTE24 in VARCHAR2,
  X_ATTRIBUTE25 in VARCHAR2,
  X_ATTRIBUTE26 in VARCHAR2,
  X_ATTRIBUTE27 in VARCHAR2,
  X_ATTRIBUTE28 in VARCHAR2,
  X_ATTRIBUTE29 in VARCHAR2,
  X_FORMULA_DESC1 in VARCHAR2,
  X_FORMULA_DESC2 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,
  X_AUTO_PRODUCT_CALC in VARCHAR2 DEFAULT NULL
) is
  cursor C is select ROWID from FM_FORM_MST_B
    where FORMULA_ID = X_FORMULA_ID
    ;

Line: 68


  insert into FM_FORM_MST_B (
    OWNER_ORGANIZATION_ID,
    ATTRIBUTE_CATEGORY,
    TEXT_CODE,
    DELETE_MARK,
    TOTAL_INPUT_QTY,
    PROJECT_ID,
    TOTAL_OUTPUT_QTY,
    YIELD_UOM,
    FORMULA_STATUS,
    OWNER_ID,
    FORMULA_ID,
    MASTER_FORMULA_ID,
    FORMULA_NO,
    FORMULA_VERS,
    FORMULA_TYPE,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE30,
    IN_USE,
    INACTIVE_IND,
    ATTRIBUTE1,
    SCALE_TYPE,
    FORMULA_CLASS,
    FMCONTROL_CLASS,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    ATTRIBUTE16,
    ATTRIBUTE17,
    ATTRIBUTE18,
    ATTRIBUTE19,
    ATTRIBUTE20,
    ATTRIBUTE21,
    ATTRIBUTE22,
    ATTRIBUTE23,
    ATTRIBUTE24,
    ATTRIBUTE25,
    ATTRIBUTE26,
    ATTRIBUTE27,
    ATTRIBUTE28,
    ATTRIBUTE29,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    AUTO_PRODUCT_CALC
  ) values (
    X_OWNER_ORGANIZATION_ID,
    X_ATTRIBUTE_CATEGORY,
    X_TEXT_CODE,
    X_DELETE_MARK,
    X_TOTAL_INPUT_QTY,
    X_PROJECT_ID,
    X_TOTAL_OUTPUT_QTY,
    X_YIELD_UOM,
    X_FORMULA_STATUS,
    X_OWNER_ID,
    X_FORMULA_ID,
    X_MASTER_FORMULA_ID,
    X_FORMULA_NO,
    X_FORMULA_VERS,
    X_FORMULA_TYPE,
    X_ATTRIBUTE5,
    X_ATTRIBUTE6,
    X_ATTRIBUTE7,
    X_ATTRIBUTE2,
    X_ATTRIBUTE3,
    X_ATTRIBUTE4,
    X_ATTRIBUTE30,
    X_IN_USE,
    X_INACTIVE_IND,
    X_ATTRIBUTE1,
    X_SCALE_TYPE,
    X_FORMULA_CLASS,
    X_FMCONTROL_CLASS,
    X_ATTRIBUTE8,
    X_ATTRIBUTE9,
    X_ATTRIBUTE10,
    X_ATTRIBUTE11,
    X_ATTRIBUTE12,
    X_ATTRIBUTE13,
    X_ATTRIBUTE14,
    X_ATTRIBUTE15,
    X_ATTRIBUTE16,
    X_ATTRIBUTE17,
    X_ATTRIBUTE18,
    X_ATTRIBUTE19,
    X_ATTRIBUTE20,
    X_ATTRIBUTE21,
    X_ATTRIBUTE22,
    X_ATTRIBUTE23,
    X_ATTRIBUTE24,
    X_ATTRIBUTE25,
    X_ATTRIBUTE26,
    X_ATTRIBUTE27,
    X_ATTRIBUTE28,
    X_ATTRIBUTE29,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_AUTO_PRODUCT_CALC
  );

Line: 184


  insert into FM_FORM_MST_TL (
    FORMULA_ID,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    CREATION_DATE,
    LAST_UPDATED_BY,
    CREATED_BY,
    FORMULA_DESC1,
    FORMULA_DESC2,
    LANGUAGE,
    SOURCE_LANG
  ) select
    X_FORMULA_ID,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATE_LOGIN,
    X_CREATION_DATE,
    X_LAST_UPDATED_BY,
    X_CREATED_BY,
    X_FORMULA_DESC1,
    X_FORMULA_DESC2,
    L.LANGUAGE_CODE,
    userenv('LANG')
  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from FM_FORM_MST_TL T
    where T.FORMULA_ID = X_FORMULA_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 222


end INSERT_ROW;

Line: 230


  X_DELETE_MARK in NUMBER,
  X_TOTAL_INPUT_QTY in NUMBER,
  X_PROJECT_ID in NUMBER,
  X_TOTAL_OUTPUT_QTY in NUMBER,
  X_YIELD_UOM	in VARCHAR2,
  X_FORMULA_STATUS in VARCHAR2,
  X_OWNER_ID in NUMBER,
  X_FORMULA_NO in VARCHAR2,
  X_FORMULA_VERS in NUMBER,
  X_FORMULA_TYPE in NUMBER,
  X_ATTRIBUTE5 in VARCHAR2,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ATTRIBUTE30 in VARCHAR2,
  X_IN_USE in NUMBER,
  X_INACTIVE_IND in NUMBER,
  X_ATTRIBUTE1 in VARCHAR2,
  X_SCALE_TYPE in NUMBER,
  X_FORMULA_CLASS in VARCHAR2,
  X_FMCONTROL_CLASS 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_ATTRIBUTE16 in VARCHAR2,
  X_ATTRIBUTE17 in VARCHAR2,
  X_ATTRIBUTE18 in VARCHAR2,
  X_ATTRIBUTE19 in VARCHAR2,
  X_ATTRIBUTE20 in VARCHAR2,
  X_ATTRIBUTE21 in VARCHAR2,
  X_ATTRIBUTE22 in VARCHAR2,
  X_ATTRIBUTE23 in VARCHAR2,
  X_ATTRIBUTE24 in VARCHAR2,
  X_ATTRIBUTE25 in VARCHAR2,
  X_ATTRIBUTE26 in VARCHAR2,
  X_ATTRIBUTE27 in VARCHAR2,
  X_ATTRIBUTE28 in VARCHAR2,
  X_ATTRIBUTE29 in VARCHAR2,
  X_FORMULA_DESC1 in VARCHAR2,
  X_FORMULA_DESC2 in VARCHAR2,
  X_AUTO_PRODUCT_CALC in VARCHAR2 DEFAULT NULL
) is
  cursor c is select
      OWNER_ORGANIZATION_ID,
      MASTER_FORMULA_ID,
      ATTRIBUTE_CATEGORY,
      TEXT_CODE,
      DELETE_MARK,
      TOTAL_INPUT_QTY,
      PROJECT_ID,
      TOTAL_OUTPUT_QTY,
      YIELD_UOM,
      FORMULA_STATUS,
      OWNER_ID,
      FORMULA_NO,
      FORMULA_VERS,
      FORMULA_TYPE,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE30,
      IN_USE,
      INACTIVE_IND,
      ATTRIBUTE1,
      SCALE_TYPE,
      FORMULA_CLASS,
      FMCONTROL_CLASS,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      ATTRIBUTE16,
      ATTRIBUTE17,
      ATTRIBUTE18,
      ATTRIBUTE19,
      ATTRIBUTE20,
      ATTRIBUTE21,
      ATTRIBUTE22,
      ATTRIBUTE23,
      ATTRIBUTE24,
      ATTRIBUTE25,
      ATTRIBUTE26,
      ATTRIBUTE27,
      ATTRIBUTE28,
      ATTRIBUTE29,
      AUTO_PRODUCT_CALC
    from FM_FORM_MST_B
    where FORMULA_ID = X_FORMULA_ID
    for update of FORMULA_ID nowait;

Line: 335


  cursor c1 is select
      FORMULA_DESC1,
      FORMULA_DESC2,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from FM_FORM_MST_TL
    where FORMULA_ID = X_FORMULA_ID
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of FORMULA_ID nowait;

Line: 348


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

Line: 360


      AND (recinfo.DELETE_MARK = X_DELETE_MARK)
      AND ((recinfo.TOTAL_INPUT_QTY = X_TOTAL_INPUT_QTY)
           OR ((recinfo.TOTAL_INPUT_QTY is null) AND (X_TOTAL_INPUT_QTY is null)))
      AND ((recinfo.PROJECT_ID = X_PROJECT_ID)
           OR ((recinfo.PROJECT_ID is null) AND (X_PROJECT_ID is null)))
      AND ((recinfo.TOTAL_OUTPUT_QTY = X_TOTAL_OUTPUT_QTY)
           OR ((recinfo.TOTAL_OUTPUT_QTY is null) AND (X_TOTAL_OUTPUT_QTY is null)))
      AND ((recinfo.YIELD_UOM = X_YIELD_UOM)
           OR ((recinfo.YIELD_UOM is null) AND (X_YIELD_UOM is null)))
      AND ((recinfo.FORMULA_STATUS = X_FORMULA_STATUS)
           OR ((recinfo.FORMULA_STATUS is null) AND (X_FORMULA_STATUS is null)))
      AND ((recinfo.OWNER_ID = X_OWNER_ID)
           OR ((recinfo.OWNER_ID is null) AND (X_OWNER_ID is null)))
      AND (recinfo.FORMULA_NO = X_FORMULA_NO)
      AND (recinfo.FORMULA_VERS = X_FORMULA_VERS)
      AND (recinfo.FORMULA_TYPE = X_FORMULA_TYPE)
      AND ((recinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
           OR ((recinfo.ATTRIBUTE5 is null) AND (X_ATTRIBUTE5 is null)))
      AND ((recinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
           OR ((recinfo.ATTRIBUTE6 is null) AND (X_ATTRIBUTE6 is null)))
      AND ((recinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
           OR ((recinfo.ATTRIBUTE7 is null) AND (X_ATTRIBUTE7 is null)))
      AND ((recinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
           OR ((recinfo.ATTRIBUTE2 is null) AND (X_ATTRIBUTE2 is null)))
      AND ((recinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
           OR ((recinfo.ATTRIBUTE3 is null) AND (X_ATTRIBUTE3 is null)))
      AND ((recinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
           OR ((recinfo.ATTRIBUTE4 is null) AND (X_ATTRIBUTE4 is null)))
      AND ((recinfo.ATTRIBUTE30 = X_ATTRIBUTE30)
           OR ((recinfo.ATTRIBUTE30 is null) AND (X_ATTRIBUTE30 is null)))
      AND ((recinfo.IN_USE = X_IN_USE)
           OR ((recinfo.IN_USE is null) AND (X_IN_USE is null)))
      AND (recinfo.INACTIVE_IND = X_INACTIVE_IND)
      AND ((recinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
           OR ((recinfo.ATTRIBUTE1 is null) AND (X_ATTRIBUTE1 is null)))
      AND (recinfo.SCALE_TYPE = X_SCALE_TYPE)
      AND ((recinfo.FORMULA_CLASS = X_FORMULA_CLASS)
           OR ((recinfo.FORMULA_CLASS is null) AND (X_FORMULA_CLASS is null)))
      AND ((recinfo.FMCONTROL_CLASS = X_FMCONTROL_CLASS)
           OR ((recinfo.FMCONTROL_CLASS is null) AND (X_FMCONTROL_CLASS is null)))
      AND ((recinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
           OR ((recinfo.ATTRIBUTE8 is null) AND (X_ATTRIBUTE8 is null)))
      AND ((recinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
           OR ((recinfo.ATTRIBUTE9 is null) AND (X_ATTRIBUTE9 is null)))
      AND ((recinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
           OR ((recinfo.ATTRIBUTE10 is null) AND (X_ATTRIBUTE10 is null)))
      AND ((recinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
           OR ((recinfo.ATTRIBUTE11 is null) AND (X_ATTRIBUTE11 is null)))
      AND ((recinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
           OR ((recinfo.ATTRIBUTE12 is null) AND (X_ATTRIBUTE12 is null)))
      AND ((recinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
           OR ((recinfo.ATTRIBUTE13 is null) AND (X_ATTRIBUTE13 is null)))
      AND ((recinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
           OR ((recinfo.ATTRIBUTE14 is null) AND (X_ATTRIBUTE14 is null)))
      AND ((recinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
           OR ((recinfo.ATTRIBUTE15 is null) AND (X_ATTRIBUTE15 is null)))
      AND ((recinfo.ATTRIBUTE16 = X_ATTRIBUTE16)
           OR ((recinfo.ATTRIBUTE16 is null) AND (X_ATTRIBUTE16 is null)))
      AND ((recinfo.ATTRIBUTE17 = X_ATTRIBUTE17)
           OR ((recinfo.ATTRIBUTE17 is null) AND (X_ATTRIBUTE17 is null)))
      AND ((recinfo.ATTRIBUTE18 = X_ATTRIBUTE18)
           OR ((recinfo.ATTRIBUTE18 is null) AND (X_ATTRIBUTE18 is null)))
      AND ((recinfo.ATTRIBUTE19 = X_ATTRIBUTE19)
           OR ((recinfo.ATTRIBUTE19 is null) AND (X_ATTRIBUTE19 is null)))
      AND ((recinfo.ATTRIBUTE20 = X_ATTRIBUTE20)
           OR ((recinfo.ATTRIBUTE20 is null) AND (X_ATTRIBUTE20 is null)))
      AND ((recinfo.ATTRIBUTE21 = X_ATTRIBUTE21)
           OR ((recinfo.ATTRIBUTE21 is null) AND (X_ATTRIBUTE21 is null)))
      AND ((recinfo.ATTRIBUTE22 = X_ATTRIBUTE22)
           OR ((recinfo.ATTRIBUTE22 is null) AND (X_ATTRIBUTE22 is null)))
      AND ((recinfo.ATTRIBUTE23 = X_ATTRIBUTE23)
           OR ((recinfo.ATTRIBUTE23 is null) AND (X_ATTRIBUTE23 is null)))
      AND ((recinfo.ATTRIBUTE24 = X_ATTRIBUTE24)
           OR ((recinfo.ATTRIBUTE24 is null) AND (X_ATTRIBUTE24 is null)))
      AND ((recinfo.ATTRIBUTE25 = X_ATTRIBUTE25)
           OR ((recinfo.ATTRIBUTE25 is null) AND (X_ATTRIBUTE25 is null)))
      AND ((recinfo.ATTRIBUTE26 = X_ATTRIBUTE26)
           OR ((recinfo.ATTRIBUTE26 is null) AND (X_ATTRIBUTE26 is null)))
      AND ((recinfo.ATTRIBUTE27 = X_ATTRIBUTE27)
           OR ((recinfo.ATTRIBUTE27 is null) AND (X_ATTRIBUTE27 is null)))
      AND ((recinfo.ATTRIBUTE28 = X_ATTRIBUTE28)
           OR ((recinfo.ATTRIBUTE28 is null) AND (X_ATTRIBUTE28 is null)))
      AND ((recinfo.ATTRIBUTE29 = X_ATTRIBUTE29)
           OR ((recinfo.ATTRIBUTE29 is null) AND (X_ATTRIBUTE29 is null)))
      AND ((recinfo.AUTO_PRODUCT_CALC = X_AUTO_PRODUCT_CALC)
          OR ((recinfo.AUTO_PRODUCT_CALC is null) AND (X_AUTO_PRODUCT_CALC is null)))
  ) then
    null;

Line: 469


procedure UPDATE_ROW (
  X_FORMULA_ID in NUMBER,
  X_OWNER_ORGANIZATION_ID in NUMBER,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_TEXT_CODE in NUMBER,
  X_DELETE_MARK in NUMBER,
  X_TOTAL_INPUT_QTY in NUMBER,
  X_PROJECT_ID in NUMBER,
  X_TOTAL_OUTPUT_QTY in NUMBER,
  X_YIELD_UOM in VARCHAR2,
  X_FORMULA_STATUS in VARCHAR2,
  X_OWNER_ID in NUMBER,
  X_FORMULA_NO in VARCHAR2,
  X_FORMULA_VERS in NUMBER,
  X_FORMULA_TYPE in NUMBER,
  X_ATTRIBUTE5 in VARCHAR2,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ATTRIBUTE30 in VARCHAR2,
  X_IN_USE in NUMBER,
  X_INACTIVE_IND in NUMBER,
  X_ATTRIBUTE1 in VARCHAR2,
  X_SCALE_TYPE in NUMBER,
  X_FORMULA_CLASS in VARCHAR2,
  X_FMCONTROL_CLASS 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_ATTRIBUTE16 in VARCHAR2,
  X_ATTRIBUTE17 in VARCHAR2,
  X_ATTRIBUTE18 in VARCHAR2,
  X_ATTRIBUTE19 in VARCHAR2,
  X_ATTRIBUTE20 in VARCHAR2,
  X_ATTRIBUTE21 in VARCHAR2,
  X_ATTRIBUTE22 in VARCHAR2,
  X_ATTRIBUTE23 in VARCHAR2,
  X_ATTRIBUTE24 in VARCHAR2,
  X_ATTRIBUTE25 in VARCHAR2,
  X_ATTRIBUTE26 in VARCHAR2,
  X_ATTRIBUTE27 in VARCHAR2,
  X_ATTRIBUTE28 in VARCHAR2,
  X_ATTRIBUTE29 in VARCHAR2,
  X_FORMULA_DESC1 in VARCHAR2,
  X_FORMULA_DESC2 in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER,
  X_AUTO_PRODUCT_CALC in VARCHAR2 DEFAULT NULL
) is
begin
  update FM_FORM_MST_B set
    OWNER_ORGANIZATION_ID = X_OWNER_ORGANIZATION_ID,
    ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
    TEXT_CODE = X_TEXT_CODE,
    DELETE_MARK = X_DELETE_MARK,
--    TOTAL_INPUT_QTY = X_TOTAL_INPUT_QTY,
    PROJECT_ID = X_PROJECT_ID,
--    TOTAL_OUTPUT_QTY = X_TOTAL_OUTPUT_QTY,
--    FORMULA_UOM = X_FORMULA_UOM,
-- Bug #3018075 (JKB) Commented above.
    FORMULA_STATUS = X_FORMULA_STATUS,
    OWNER_ID = X_OWNER_ID,
    FORMULA_NO = X_FORMULA_NO,
    FORMULA_VERS = X_FORMULA_VERS,
    FORMULA_TYPE = X_FORMULA_TYPE,
    ATTRIBUTE5 = X_ATTRIBUTE5,
    ATTRIBUTE6 = X_ATTRIBUTE6,
    ATTRIBUTE7 = X_ATTRIBUTE7,
    ATTRIBUTE2 = X_ATTRIBUTE2,
    ATTRIBUTE3 = X_ATTRIBUTE3,
    ATTRIBUTE4 = X_ATTRIBUTE4,
    ATTRIBUTE30 = X_ATTRIBUTE30,
    IN_USE = X_IN_USE,
    INACTIVE_IND = X_INACTIVE_IND,
    ATTRIBUTE1 = X_ATTRIBUTE1,
    SCALE_TYPE = X_SCALE_TYPE,
    FORMULA_CLASS = X_FORMULA_CLASS,
    FMCONTROL_CLASS = X_FMCONTROL_CLASS,
    ATTRIBUTE8 = X_ATTRIBUTE8,
    ATTRIBUTE9 = X_ATTRIBUTE9,
    ATTRIBUTE10 = X_ATTRIBUTE10,
    ATTRIBUTE11 = X_ATTRIBUTE11,
    ATTRIBUTE12 = X_ATTRIBUTE12,
    ATTRIBUTE13 = X_ATTRIBUTE13,
    ATTRIBUTE14 = X_ATTRIBUTE14,
    ATTRIBUTE15 = X_ATTRIBUTE15,
    ATTRIBUTE16 = X_ATTRIBUTE16,
    ATTRIBUTE17 = X_ATTRIBUTE17,
    ATTRIBUTE18 = X_ATTRIBUTE18,
    ATTRIBUTE19 = X_ATTRIBUTE19,
    ATTRIBUTE20 = X_ATTRIBUTE20,
    ATTRIBUTE21 = X_ATTRIBUTE21,
    ATTRIBUTE22 = X_ATTRIBUTE22,
    ATTRIBUTE23 = X_ATTRIBUTE23,
    ATTRIBUTE24 = X_ATTRIBUTE24,
    ATTRIBUTE25 = X_ATTRIBUTE25,
    ATTRIBUTE26 = X_ATTRIBUTE26,
    ATTRIBUTE27 = X_ATTRIBUTE27,
    ATTRIBUTE28 = X_ATTRIBUTE28,
    ATTRIBUTE29 = X_ATTRIBUTE29,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    AUTO_PRODUCT_CALC = X_AUTO_PRODUCT_CALC
  where FORMULA_ID = X_FORMULA_ID;

Line: 587


  update FM_FORM_MST_TL set
    FORMULA_DESC1 = X_FORMULA_DESC1,
    FORMULA_DESC2 = X_FORMULA_DESC2,
    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 FORMULA_ID = X_FORMULA_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 600


end UPDATE_ROW;

Line: 602


procedure DELETE_ROW (
  X_FORMULA_ID in NUMBER
) is
begin
  delete from FM_FORM_MST_TL
  where FORMULA_ID = X_FORMULA_ID;

Line: 613


  delete from FM_FORM_MST_B
  where FORMULA_ID = X_FORMULA_ID;

Line: 619


end DELETE_ROW;

Line: 624


  delete from FM_FORM_MST_TL T
  where not exists
    (select NULL
    from FM_FORM_MST_B B
    where B.FORMULA_ID = T.FORMULA_ID
    );

Line: 631


  update FM_FORM_MST_TL T set (
      FORMULA_DESC1,
      FORMULA_DESC2
    ) = (select
      B.FORMULA_DESC1,
      B.FORMULA_DESC2
    from FM_FORM_MST_TL B
    where B.FORMULA_ID = T.FORMULA_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.FORMULA_ID,
      T.LANGUAGE
  ) in (select
      SUBT.FORMULA_ID,
      SUBT.LANGUAGE
    from FM_FORM_MST_TL SUBB, FM_FORM_MST_TL SUBT
    where SUBB.FORMULA_ID = SUBT.FORMULA_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.FORMULA_DESC1 <> SUBT.FORMULA_DESC1
      or SUBB.FORMULA_DESC2 <> SUBT.FORMULA_DESC2
      or (SUBB.FORMULA_DESC2 is null and SUBT.FORMULA_DESC2 is not null)
      or (SUBB.FORMULA_DESC2 is not null and SUBT.FORMULA_DESC2 is null)
  ));

Line: 655


  insert into FM_FORM_MST_TL (
    FORMULA_ID,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    CREATION_DATE,
    LAST_UPDATED_BY,
    CREATED_BY,
    FORMULA_DESC1,
    FORMULA_DESC2,
    LANGUAGE,
    SOURCE_LANG
  ) select
    B.FORMULA_ID,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATE_LOGIN,
    B.CREATION_DATE,
    B.LAST_UPDATED_BY,
    B.CREATED_BY,
    B.FORMULA_DESC1,
    B.FORMULA_DESC2,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from FM_FORM_MST_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from FM_FORM_MST_TL T
    where T.FORMULA_ID = B.FORMULA_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);