APPS.OE_TRANSACTION_TYPES_PKG 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_ORG_ID in number,
  X_TRANSACTION_TYPE_ID in NUMBER,
  X_TRANSACTION_TYPE_CODE in VARCHAR2,
  X_ORDER_CATEGORY_CODE in VARCHAR2,
  X_START_DATE_ACTIVE in DATE,
  X_END_DATE_ACTIVE in DATE,
  X_REQUEST_ID in NUMBER,
  X_CURRENCY_CODE in VARCHAR2,
  X_CONVERSION_TYPE_CODE in VARCHAR2,
  X_CUST_TRX_TYPE_ID in NUMBER,
  X_COST_OF_GOODS_SOLD_ACCOUNT in NUMBER,
  X_ENTRY_CREDIT_CHECK_RULE_ID in NUMBER,
  X_SHIPPING_CREDIT_CHECK_RULE_I in NUMBER,
  X_PICKING_CREDIT_CHECK_RULE_ID in NUMBER,
  X_PACKING_CREDIT_CHECK_RULE_ID in NUMBER,
  X_PRICE_LIST_ID in NUMBER,
  X_ENFORCE_LINE_PRICES_FLAG in VARCHAR2,
  X_WAREHOUSE_ID in NUMBER,
  X_DEMAND_CLASS_CODE in VARCHAR2,
  X_SHIPMENT_PRIORITY_CODE in VARCHAR2,
  X_SHIPPING_METHOD_CODE in VARCHAR2,
  X_FREIGHT_TERMS_CODE in VARCHAR2,
  X_FOB_POINT_CODE in VARCHAR2,
  X_SHIP_SOURCE_TYPE_CODE in VARCHAR2,
  X_AGREEMENT_TYPE_CODE in VARCHAR2,
  X_AGREEMENT_REQUIRED_FLAG in VARCHAR2,
  X_PO_REQUIRED_FLAG in VARCHAR2,
  X_INVOICING_RULE_ID in NUMBER,
  X_INVOICING_CREDIT_METHOD_CODE in VARCHAR2,
  X_ACCOUNTING_RULE_ID in NUMBER,
  X_ACCOUNTING_CREDIT_METHOD_COD in VARCHAR2,
  X_INVOICE_SOURCE_ID in VARCHAR2,
  X_NON_DELIVERY_INVOICE_SOURCE_ in VARCHAR2,
  X_DEFAULT_INBOUND_LINE_TYPE_ID in NUMBER,
  X_DEFAULT_OUTBOUND_LINE_TYPE_I in NUMBER,
  X_INSPECTION_REQUIRED_FLAG in VARCHAR2,
  X_DEPOT_REPAIR_CODE in VARCHAR2,
  X_AUTO_SCHEDULING_FLAG in VARCHAR2,
  X_SCHEDULING_LEVEL_CODE in VARCHAR2,
  X_CONTEXT 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_NAME in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_LAYOUT_TEMPLATE_ID in number,
  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_SALES_DOCUMENT_TYPE_CODE in VARCHAR2,
  X_TAX_CALCULATION_EVENT IN VARCHAR2 := NULL,
  X_MIN_MARGIN_PERCENT IN NUMBER,
  X_DEFAULT_FULFILLMENT_SET  IN VARCHAR2 DEFAULT NULL,
  X_DEFAULT_LINE_SET_CODE    IN VARCHAR2 DEFAULT NULL,
  X_def_transaction_phase_code     in VARCHAR2 default null,
  X_quote_num_as_ord_num_flag  in VARCHAR2 default null,
  X_CONTRACT_TEMPLATE_ID in number,
  X_CREDIT_CARD_REV_REAUTH_CODE in VARCHAR2 default null, --CC Reversal ER#16014135
  X_use_ame_approval IN VARCHAR2 default null-- AME ER 16084377

) is
  cursor C is select ROWID from OE_TRANSACTION_TYPES_ALL
    where TRANSACTION_TYPE_ID = X_TRANSACTION_TYPE_ID
    ;

Line: 84

  insert into OE_TRANSACTION_TYPES_ALL (
    TRANSACTION_TYPE_ID,
    TRANSACTION_TYPE_CODE,
    ORG_ID,
    ORDER_CATEGORY_CODE,
    START_DATE_ACTIVE,
    END_DATE_ACTIVE,
    REQUEST_ID,
    CURRENCY_CODE,
    CONVERSION_TYPE_CODE,
    CUST_TRX_TYPE_ID,
    COST_OF_GOODS_SOLD_ACCOUNT,
    ENTRY_CREDIT_CHECK_RULE_ID,
    SHIPPING_CREDIT_CHECK_RULE_ID,
    PICKING_CREDIT_CHECK_RULE_ID,
    PACKING_CREDIT_CHECK_RULE_ID,
    PRICE_LIST_ID,
    ENFORCE_LINE_PRICES_FLAG,
    WAREHOUSE_ID,
    DEMAND_CLASS_CODE,
    SHIPMENT_PRIORITY_CODE,
    SHIPPING_METHOD_CODE,
    FREIGHT_TERMS_CODE,
    FOB_POINT_CODE,
    SHIP_SOURCE_TYPE_CODE,
    AGREEMENT_TYPE_CODE,
    AGREEMENT_REQUIRED_FLAG,
    PO_REQUIRED_FLAG,
    INVOICING_RULE_ID,
    INVOICING_CREDIT_METHOD_CODE,
    ACCOUNTING_RULE_ID,
    ACCOUNTING_CREDIT_METHOD_CODE,
    INVOICE_SOURCE_ID,
    NON_DELIVERY_INVOICE_SOURCE_ID,
    DEFAULT_INBOUND_LINE_TYPE_ID,
    DEFAULT_OUTBOUND_LINE_TYPE_ID,
    INSPECTION_REQUIRED_FLAG,
    DEPOT_REPAIR_CODE,
    AUTO_SCHEDULING_FLAG,
    SCHEDULING_LEVEL_CODE,
    CONTEXT,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    LAYOUT_TEMPLATE_ID,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    SALES_DOCUMENT_TYPE_CODE,
    TAX_CALCULATION_EVENT_CODE,
    MIN_MARGIN_PERCENT,
    DEFAULT_FULFILLMENT_SET,
    DEFAULT_LINE_SET_CODE,
    def_transaction_phase_code,
    quote_num_as_ord_num_flag,
    contract_template_id ,
    credit_card_rev_reauth_code, --CC Reversal ER#16014135
    use_ame_approval -- ame er 16084377
  ) values (
    X_TRANSACTION_TYPE_ID,
    X_TRANSACTION_TYPE_CODE,
    X_ORG_ID,
    X_ORDER_CATEGORY_CODE,
    X_START_DATE_ACTIVE,
    X_END_DATE_ACTIVE,
    X_REQUEST_ID,
    X_CURRENCY_CODE,
    X_CONVERSION_TYPE_CODE,
    X_CUST_TRX_TYPE_ID,
    X_COST_OF_GOODS_SOLD_ACCOUNT,
    X_ENTRY_CREDIT_CHECK_RULE_ID,
    X_SHIPPING_CREDIT_CHECK_RULE_I,
    X_PICKING_CREDIT_CHECK_RULE_ID,
    X_PACKING_CREDIT_CHECK_RULE_ID,
    X_PRICE_LIST_ID,
    Nvl(X_ENFORCE_LINE_PRICES_FLAG, 'N'),
    X_WAREHOUSE_ID,
    X_DEMAND_CLASS_CODE,
    X_SHIPMENT_PRIORITY_CODE,
    X_SHIPPING_METHOD_CODE,
    X_FREIGHT_TERMS_CODE,
    X_FOB_POINT_CODE,
    X_SHIP_SOURCE_TYPE_CODE,
    X_AGREEMENT_TYPE_CODE,
    X_AGREEMENT_REQUIRED_FLAG,
    X_PO_REQUIRED_FLAG,
    X_INVOICING_RULE_ID,
    X_INVOICING_CREDIT_METHOD_CODE,
    X_ACCOUNTING_RULE_ID,
    X_ACCOUNTING_CREDIT_METHOD_COD,
    X_INVOICE_SOURCE_ID,
    X_NON_DELIVERY_INVOICE_SOURCE_,
    X_DEFAULT_INBOUND_LINE_TYPE_ID,
    X_DEFAULT_OUTBOUND_LINE_TYPE_I,
    X_INSPECTION_REQUIRED_FLAG,
    X_DEPOT_REPAIR_CODE,
    X_AUTO_SCHEDULING_FLAG,
    X_SCHEDULING_LEVEL_CODE,
    X_CONTEXT,
    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_LAYOUT_TEMPLATE_ID,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    nvl(X_SALES_DOCUMENT_TYPE_CODE,'O'),
    X_TAX_CALCULATION_EVENT,
    X_MIN_MARGIN_PERCENT,
    X_DEFAULT_FULFILLMENT_SET,
    X_DEFAULT_LINE_SET_CODE,
    X_def_transaction_phase_code,
    X_quote_num_as_ord_num_flag,
    X_CONTRACT_TEMPLATE_ID,
    X_CREDIT_CARD_REV_REAUTH_CODE, --CC Reversal ER#16014135
    X_use_ame_approval  -- AME ER 16084377
  );

Line: 230

  insert into OE_TRANSACTION_TYPES_TL (
    TRANSACTION_TYPE_ID,
    NAME,
    DESCRIPTION,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    PROGRAM_APPLICATION_ID,
    PROGRAM_ID,
    REQUEST_ID,
    LANGUAGE,
    SOURCE_LANG
  ) select
    X_TRANSACTION_TYPE_ID,
    X_NAME,
    X_DESCRIPTION,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    NULL,
    NULL,
    NULL,
    L.LANGUAGE_CODE,
    userenv('LANG')
  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from OE_TRANSACTION_TYPES_TL T
    where T.TRANSACTION_TYPE_ID = X_TRANSACTION_TYPE_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 274

end INSERT_ROW;

Line: 344

  cursor c is select
      TRANSACTION_TYPE_CODE,
      ORDER_CATEGORY_CODE,
      START_DATE_ACTIVE,
      END_DATE_ACTIVE,
      REQUEST_ID,
      CURRENCY_CODE,
      CONVERSION_TYPE_CODE,
      CUST_TRX_TYPE_ID,
      COST_OF_GOODS_SOLD_ACCOUNT,
      ENTRY_CREDIT_CHECK_RULE_ID,
      SHIPPING_CREDIT_CHECK_RULE_ID,
      PICKING_CREDIT_CHECK_RULE_ID,
      PACKING_CREDIT_CHECK_RULE_ID,
      PRICE_LIST_ID,
      ENFORCE_LINE_PRICES_FLAG,
      WAREHOUSE_ID,
      DEMAND_CLASS_CODE,
      SHIPMENT_PRIORITY_CODE,
      SHIPPING_METHOD_CODE,
      FREIGHT_TERMS_CODE,
      FOB_POINT_CODE,
      SHIP_SOURCE_TYPE_CODE,
      AGREEMENT_TYPE_CODE,
      AGREEMENT_REQUIRED_FLAG,
      PO_REQUIRED_FLAG,
      INVOICING_RULE_ID,
      INVOICING_CREDIT_METHOD_CODE,
      ACCOUNTING_RULE_ID,
      ACCOUNTING_CREDIT_METHOD_CODE,
      INVOICE_SOURCE_ID,
      NON_DELIVERY_INVOICE_SOURCE_ID,
      DEFAULT_INBOUND_LINE_TYPE_ID,
      DEFAULT_OUTBOUND_LINE_TYPE_ID,
      INSPECTION_REQUIRED_FLAG,
      DEPOT_REPAIR_CODE,
      AUTO_SCHEDULING_FLAG,
      SCHEDULING_LEVEL_CODE,
      CONTEXT,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      LAYOUT_TEMPLATE_ID,
      TAX_CALCULATION_EVENT_CODE,
      MIN_MARGIN_PERCENT,
      DEFAULT_FULFILLMENT_SET,
      DEFAULT_LINE_SET_CODE,
      def_transaction_phase_code,
      quote_num_as_ord_num_flag,
      CONTRACT_TEMPLATE_ID ,
      CREDIT_CARD_REV_REAUTH_CODE, --CC Reversal ER#16014135
      use_ame_approval --ame er 16084377
    from OE_TRANSACTION_TYPES_ALL
    where TRANSACTION_TYPE_ID = X_TRANSACTION_TYPE_ID
    for update of TRANSACTION_TYPE_ID nowait;

Line: 413

  cursor c1 is select
      NAME,
      DESCRIPTION,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from OE_TRANSACTION_TYPES_TL
    where TRANSACTION_TYPE_ID = X_TRANSACTION_TYPE_ID
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of TRANSACTION_TYPE_ID nowait;

Line: 426

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

Line: 576

procedure UPDATE_ROW (
  X_TRANSACTION_TYPE_ID in NUMBER,
  X_TRANSACTION_TYPE_CODE in VARCHAR2,
  X_ORDER_CATEGORY_CODE in VARCHAR2,
  X_START_DATE_ACTIVE in DATE,
  X_END_DATE_ACTIVE in DATE,
  X_REQUEST_ID in NUMBER,
  X_CURRENCY_CODE in VARCHAR2,
  X_CONVERSION_TYPE_CODE in VARCHAR2,
  X_CUST_TRX_TYPE_ID in NUMBER,
  X_COST_OF_GOODS_SOLD_ACCOUNT in NUMBER,
  X_ENTRY_CREDIT_CHECK_RULE_ID in NUMBER,
  X_SHIPPING_CREDIT_CHECK_RULE_I in NUMBER,
  X_PICKING_CREDIT_CHECK_RULE_ID in NUMBER,
  X_PACKING_CREDIT_CHECK_RULE_ID in NUMBER,
  X_PRICE_LIST_ID in NUMBER,
  X_ENFORCE_LINE_PRICES_FLAG in VARCHAR2,
  X_WAREHOUSE_ID in NUMBER,
  X_DEMAND_CLASS_CODE in VARCHAR2,
  X_SHIPMENT_PRIORITY_CODE in VARCHAR2,
  X_SHIPPING_METHOD_CODE in VARCHAR2,
  X_FREIGHT_TERMS_CODE in VARCHAR2,
  X_FOB_POINT_CODE in VARCHAR2,
  X_SHIP_SOURCE_TYPE_CODE in VARCHAR2,
  X_AGREEMENT_TYPE_CODE in VARCHAR2,
  X_AGREEMENT_REQUIRED_FLAG in VARCHAR2,
  X_PO_REQUIRED_FLAG in VARCHAR2,
  X_INVOICING_RULE_ID in NUMBER,
  X_INVOICING_CREDIT_METHOD_CODE in VARCHAR2,
  X_ACCOUNTING_RULE_ID in NUMBER,
  X_ACCOUNTING_CREDIT_METHOD_COD in VARCHAR2,
  X_INVOICE_SOURCE_ID in VARCHAR2,
  X_NON_DELIVERY_INVOICE_SOURCE_ in VARCHAR2,
  X_DEFAULT_INBOUND_LINE_TYPE_ID in NUMBER,
  X_DEFAULT_OUTBOUND_LINE_TYPE_I in NUMBER,
  X_INSPECTION_REQUIRED_FLAG in VARCHAR2,
  X_DEPOT_REPAIR_CODE in VARCHAR2,
  X_AUTO_SCHEDULING_FLAG in VARCHAR2,
  X_SCHEDULING_LEVEL_CODE in VARCHAR2,
  X_CONTEXT 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_NAME in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_LAYOUT_TEMPLATE_ID in number,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER,
  X_TAX_CALCULATION_EVENT IN VARCHAR2 default null,
  X_MIN_MARGIN_PERCENT IN NUMBER,
  X_DEFAULT_FULFILLMENT_SET  in VARCHAR2 default null,
  X_DEFAULT_LINE_SET_CODE    in VARCHAR2 default null,
  X_def_transaction_phase_code     in VARCHAR2 default null,
  X_quote_num_as_ord_num_flag  in VARCHAR2 default null,
  X_CONTRACT_TEMPLATE_ID in number,
  X_CREDIT_CARD_REV_REAUTH_CODE in VARCHAR2 default null ,--CC Reversal ER#16014135
  X_use_ame_approval IN VARCHAR2 default null -- AME ER 16084377
) is
begin
  update OE_TRANSACTION_TYPES_ALL set
    TRANSACTION_TYPE_CODE = X_TRANSACTION_TYPE_CODE,
    ORDER_CATEGORY_CODE = X_ORDER_CATEGORY_CODE,
    START_DATE_ACTIVE = X_START_DATE_ACTIVE,
    END_DATE_ACTIVE = X_END_DATE_ACTIVE,
    REQUEST_ID = X_REQUEST_ID,
    CURRENCY_CODE = X_CURRENCY_CODE,
    CONVERSION_TYPE_CODE = X_CONVERSION_TYPE_CODE,
    CUST_TRX_TYPE_ID = X_CUST_TRX_TYPE_ID,
    COST_OF_GOODS_SOLD_ACCOUNT = X_COST_OF_GOODS_SOLD_ACCOUNT,
    ENTRY_CREDIT_CHECK_RULE_ID = X_ENTRY_CREDIT_CHECK_RULE_ID,
    SHIPPING_CREDIT_CHECK_RULE_ID = X_SHIPPING_CREDIT_CHECK_RULE_I,
    PICKING_CREDIT_CHECK_RULE_ID = X_PICKING_CREDIT_CHECK_RULE_ID,
    PACKING_CREDIT_CHECK_RULE_ID = X_PACKING_CREDIT_CHECK_RULE_ID,
    PRICE_LIST_ID = X_PRICE_LIST_ID,
    ENFORCE_LINE_PRICES_FLAG = Nvl(X_ENFORCE_LINE_PRICES_FLAG, 'N'),
    WAREHOUSE_ID = X_WAREHOUSE_ID,
    DEMAND_CLASS_CODE = X_DEMAND_CLASS_CODE,
    SHIPMENT_PRIORITY_CODE = X_SHIPMENT_PRIORITY_CODE,
    SHIPPING_METHOD_CODE = X_SHIPPING_METHOD_CODE,
    FREIGHT_TERMS_CODE = X_FREIGHT_TERMS_CODE,
    FOB_POINT_CODE = X_FOB_POINT_CODE,
    SHIP_SOURCE_TYPE_CODE = X_SHIP_SOURCE_TYPE_CODE,
    AGREEMENT_TYPE_CODE = X_AGREEMENT_TYPE_CODE,
    AGREEMENT_REQUIRED_FLAG = X_AGREEMENT_REQUIRED_FLAG,
    PO_REQUIRED_FLAG = X_PO_REQUIRED_FLAG,
    INVOICING_RULE_ID = X_INVOICING_RULE_ID,
    INVOICING_CREDIT_METHOD_CODE = X_INVOICING_CREDIT_METHOD_CODE,
    ACCOUNTING_RULE_ID = X_ACCOUNTING_RULE_ID,
    ACCOUNTING_CREDIT_METHOD_CODE = X_ACCOUNTING_CREDIT_METHOD_COD,
    INVOICE_SOURCE_ID = X_INVOICE_SOURCE_ID,
    NON_DELIVERY_INVOICE_SOURCE_ID = X_NON_DELIVERY_INVOICE_SOURCE_,
    DEFAULT_INBOUND_LINE_TYPE_ID = X_DEFAULT_INBOUND_LINE_TYPE_ID,
    DEFAULT_OUTBOUND_LINE_TYPE_ID = X_DEFAULT_OUTBOUND_LINE_TYPE_I,
    INSPECTION_REQUIRED_FLAG = X_INSPECTION_REQUIRED_FLAG,
    DEPOT_REPAIR_CODE = X_DEPOT_REPAIR_CODE,
    AUTO_SCHEDULING_FLAG = X_AUTO_SCHEDULING_FLAG,
    SCHEDULING_LEVEL_CODE = X_SCHEDULING_LEVEL_CODE,
    CONTEXT = X_CONTEXT,
    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,
    LAYOUT_TEMPLATE_ID = X_LAYOUT_TEMPLATE_ID,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    TAX_CALCULATION_EVENT_CODE = X_TAX_CALCULATION_EVENT,
    MIN_MARGIN_PERCENT = X_MIN_MARGIN_PERCENT,
    DEFAULT_FULFILLMENT_SET =  X_DEFAULT_FULFILLMENT_SET,
    DEFAULT_LINE_SET_CODE   = X_DEFAULT_LINE_SET_CODE,
    def_transaction_phase_code = X_def_transaction_phase_code,
    quote_num_as_ord_num_flag = X_quote_num_as_ord_num_flag,
    CONTRACT_TEMPLATE_ID = X_CONTRACT_TEMPLATE_ID,
    CREDIT_CARD_REV_REAUTH_CODE = X_CREDIT_CARD_REV_REAUTH_CODE, --CC Reversal ER#16014135
    use_ame_approval = X_use_ame_approval --ame er 16084377
  where TRANSACTION_TYPE_ID = X_TRANSACTION_TYPE_ID;

Line: 721

  update OE_TRANSACTION_TYPES_TL set
    NAME = X_NAME,
    DESCRIPTION = X_DESCRIPTION,
    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 TRANSACTION_TYPE_ID = X_TRANSACTION_TYPE_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 734

end UPDATE_ROW;

Line: 736

procedure DELETE_ROW (
  X_TRANSACTION_TYPE_ID in NUMBER
) is
begin
  delete from OE_TRANSACTION_TYPES_TL
  where TRANSACTION_TYPE_ID = X_TRANSACTION_TYPE_ID;

Line: 747

  delete from OE_TRANSACTION_TYPES_ALL
  where TRANSACTION_TYPE_ID = X_TRANSACTION_TYPE_ID;

Line: 753

end DELETE_ROW;

Line: 758

  delete from OE_TRANSACTION_TYPES_TL T
  where not exists
    (select NULL
    from OE_TRANSACTION_TYPES_ALL B
    where B.TRANSACTION_TYPE_ID = T.TRANSACTION_TYPE_ID
    );

Line: 765

  update OE_TRANSACTION_TYPES_TL T set (
      NAME,
      DESCRIPTION
    ) = (select
      B.NAME,
      B.DESCRIPTION
    from OE_TRANSACTION_TYPES_TL B
    where B.TRANSACTION_TYPE_ID = T.TRANSACTION_TYPE_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.TRANSACTION_TYPE_ID,
      T.LANGUAGE
  ) in (select
      SUBT.TRANSACTION_TYPE_ID,
      SUBT.LANGUAGE
    from OE_TRANSACTION_TYPES_TL SUBB, OE_TRANSACTION_TYPES_TL SUBT
    where SUBB.TRANSACTION_TYPE_ID = SUBT.TRANSACTION_TYPE_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.NAME <> SUBT.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)
  ));

Line: 789

  insert into OE_TRANSACTION_TYPES_TL (
    TRANSACTION_TYPE_ID,
    NAME,
    DESCRIPTION,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    PROGRAM_APPLICATION_ID,
    PROGRAM_ID,
    REQUEST_ID,
    LANGUAGE,
    SOURCE_LANG
  ) select
    B.TRANSACTION_TYPE_ID,
    B.NAME,
    B.DESCRIPTION,
    B.CREATION_DATE,
    B.CREATED_BY,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATED_BY,
    B.LAST_UPDATE_LOGIN,
    B.PROGRAM_APPLICATION_ID,
    B.PROGRAM_ID,
    B.REQUEST_ID,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from OE_TRANSACTION_TYPES_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from OE_TRANSACTION_TYPES_TL T
    where T.TRANSACTION_TYPE_ID = B.TRANSACTION_TYPE_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 887

  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER,
  X_TAX_CALCULATION_EVENT IN VARCHAR2,
  X_DEFAULT_FULFILLMENT_SET     in VARCHAR2 default null,
  X_DEFAULT_LINE_SET_CODE       in VARCHAR2 default null,
  X_def_transaction_phase_code     in VARCHAR2 default null,
  X_quote_num_as_ord_num_flag  in VARCHAR2 default null,
  X_CONTRACT_TEMPLATE_ID in number ,
  X_CREDIT_CARD_REV_REAUTH_CODE in VARCHAR2 default null, --CC Reversal ER#16014135
  x_use_ame_approval IN VARCHAR2 default null -- AME ER 16084377
) is
BEGIN

NULL;

Line: 913

update oe_transaction_types_tl
set name = nvl(p_name,name),
description = nvl(p_Desc,description),
source_lang = userenv('LANG')
where Transaction_type_id = p_Transaction_type_id and
userenv('LANG') IN (source_lang,language) ;

Line: 976

  Select 'EXISTS' into
  lexists
  from oe_order_lines_all
  where header_id = l_header_id and
  rownum = 1;

Line: 1002

SELECT  name INTO l_name
 FROM oe_transaction_types_tl
WHERE LANGUAGE = p_language
AND  transaction_type_id =  p_transaction_id;

Line: 1008

  SELECT Count (oh.header_id) INTO l_count
  FROM oe_order_headers_all oh
  WHERE oh.order_type_id = p_transaction_id
  AND ROWNUM=1;

Line: 1014

     SELECT Count (ob.header_id) INTO l_count
      FROM oe_blanket_headers_all ob
     WHERE ob.order_type_id = p_transaction_id
     AND ROWNUM=1;

Line: 1023

     select count(transaction_type_id) into l_count
     from oe_transaction_types_tl
     where UPPER(name) = UPPER(p_name)
     and LANGUAGE = p_language
     and transaction_type_id <> p_transaction_id;