DBA Data[Home] [Help]

APPS.INV_TRANSACTION_FLOW_PUB_W SQL Statements

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

Line: 881

  procedure update_transaction_flow(x_return_status out nocopy  VARCHAR2
    , x_msg_data out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , p_api_version  NUMBER
    , p_init_msg_list  VARCHAR2
    , p_validation_level  NUMBER
    , p_header_id  NUMBER
    , p_flow_type  NUMBER
    , p_start_date  DATE
    , p_end_date  DATE
    , p_attribute_category  VARCHAR2
    , p_attribute1  VARCHAR2
    , p_attribute2  VARCHAR2
    , p_attribute3  VARCHAR2
    , p_attribute4  VARCHAR2
    , p_attribute5  VARCHAR2
    , p_attribute6  VARCHAR2
    , p_attribute7  VARCHAR2
    , p_attribute8  VARCHAR2
    , p_attribute9  VARCHAR2
    , p_attribute10  VARCHAR2
    , p_attribute11  VARCHAR2
    , p_attribute12  VARCHAR2
    , p_attribute13  VARCHAR2
    , p_attribute14  VARCHAR2
    , p_attribute15  VARCHAR2
    , p_line_number_tbl JTF_NUMBER_TABLE
    , p_line_attribute_category_tbl JTF_VARCHAR2_TABLE_200
    , p_line_attribute1_tbl JTF_VARCHAR2_TABLE_200
    , p_line_attribute2_tbl JTF_VARCHAR2_TABLE_200
    , p_line_attribute3_tbl JTF_VARCHAR2_TABLE_200
    , p_line_attribute4_tbl JTF_VARCHAR2_TABLE_200
    , p_line_attribute5_tbl JTF_VARCHAR2_TABLE_200
    , p_line_attribute6_tbl JTF_VARCHAR2_TABLE_200
    , p_line_attribute7_tbl JTF_VARCHAR2_TABLE_200
    , p_line_attribute8_tbl JTF_VARCHAR2_TABLE_200
    , p_line_attribute9_tbl JTF_VARCHAR2_TABLE_200
    , p_line_attribute10_tbl JTF_VARCHAR2_TABLE_200
    , p_line_attribute11_tbl JTF_VARCHAR2_TABLE_200
    , p_line_attribute12_tbl JTF_VARCHAR2_TABLE_200
    , p_line_attribute13_tbl JTF_VARCHAR2_TABLE_200
    , p_line_attribute14_tbl JTF_VARCHAR2_TABLE_200
    , p_line_attribute15_tbl JTF_VARCHAR2_TABLE_200
    , p_ship_organization_id_tbl JTF_NUMBER_TABLE
    , p_sell_organization_id_tbl JTF_NUMBER_TABLE
    , p_vendor_id_tbl JTF_NUMBER_TABLE
    , p_vendor_site_id_tbl JTF_NUMBER_TABLE
    , p_customer_id_tbl JTF_NUMBER_TABLE
    , p_address_id_tbl JTF_NUMBER_TABLE
    , p_customer_site_id_tbl JTF_NUMBER_TABLE
    , p_cust_trx_type_id_tbl JTF_NUMBER_TABLE
    , p_ic_attribute_category_tbl JTF_VARCHAR2_TABLE_200
    , p_ic_attribute1_tbl JTF_VARCHAR2_TABLE_200
    , p_ic_attribute2_tbl JTF_VARCHAR2_TABLE_200
    , p_ic_attribute3_tbl JTF_VARCHAR2_TABLE_200
    , p_ic_attribute4_tbl JTF_VARCHAR2_TABLE_200
    , p_ic_attribute5_tbl JTF_VARCHAR2_TABLE_200
    , p_ic_attribute6_tbl JTF_VARCHAR2_TABLE_200
    , p_ic_attribute7_tbl JTF_VARCHAR2_TABLE_200
    , p_ic_attribute8_tbl JTF_VARCHAR2_TABLE_200
    , p_ic_attribute9_tbl JTF_VARCHAR2_TABLE_200
    , p_ic_attribute10_tbl JTF_VARCHAR2_TABLE_200
    , p_ic_attribute11_tbl JTF_VARCHAR2_TABLE_200
    , p_ic_attribute12_tbl JTF_VARCHAR2_TABLE_200
    , p_ic_attribute13_tbl JTF_VARCHAR2_TABLE_200
    , p_ic_attribute14_tbl JTF_VARCHAR2_TABLE_200
    , p_ic_attribute15_tbl JTF_VARCHAR2_TABLE_200
    , p_revalue_average_flag_tbl JTF_VARCHAR2_TABLE_200
    , p_freight_code_comb_id_tbl JTF_NUMBER_TABLE
    , p_inv_currency_code_tbl JTF_NUMBER_TABLE
    , p_ic_cogs_acct_id_tbl JTF_NUMBER_TABLE
    , p_inv_accrual_acct_id_tbl JTF_NUMBER_TABLE
    , p_exp_accrual_acct_id_tbl JTF_NUMBER_TABLE
  )

  as
    ddp_line_number_tbl inv_transaction_flow_pub.number_tbl;
Line: 1104

    inv_transaction_flow_pub.update_transaction_flow(x_return_status,
      x_msg_data,
      x_msg_count,
      p_api_version,
      p_init_msg_list,
      p_validation_level,
      p_header_id,
      p_flow_type,
      p_start_date,
      p_end_date,
      p_attribute_category,
      p_attribute1,
      p_attribute2,
      p_attribute3,
      p_attribute4,
      p_attribute5,
      p_attribute6,
      p_attribute7,
      p_attribute8,
      p_attribute9,
      p_attribute10,
      p_attribute11,
      p_attribute12,
      p_attribute13,
      p_attribute14,
      p_attribute15,
      ddp_line_number_tbl,
      ddp_line_attr_category_tbl,
      ddp_line_attribute1_tbl,
      ddp_line_attribute2_tbl,
      ddp_line_attribute3_tbl,
      ddp_line_attribute4_tbl,
      ddp_line_attribute5_tbl,
      ddp_line_attribute6_tbl,
      ddp_line_attribute7_tbl,
      ddp_line_attribute8_tbl,
      ddp_line_attribute9_tbl,
      ddp_line_attribute10_tbl,
      ddp_line_attribute11_tbl,
      ddp_line_attribute12_tbl,
      ddp_line_attribute13_tbl,
      ddp_line_attribute14_tbl,
      ddp_line_attribute15_tbl,
      ddp_ship_organization_id_tbl,
      ddp_sell_organization_id_tbl,
      ddp_vendor_id_tbl,
      ddp_vendor_site_id_tbl,
      ddp_customer_id_tbl,
      ddp_address_id_tbl,
      ddp_customer_site_id_tbl,
      ddp_cust_trx_type_id_tbl,
      ddp_ic_attribute_category_tbl,
      ddp_ic_attribute1_tbl,
      ddp_ic_attribute2_tbl,
      ddp_ic_attribute3_tbl,
      ddp_ic_attribute4_tbl,
      ddp_ic_attribute5_tbl,
      ddp_ic_attribute6_tbl,
      ddp_ic_attribute7_tbl,
      ddp_ic_attribute8_tbl,
      ddp_ic_attribute9_tbl,
      ddp_ic_attribute10_tbl,
      ddp_ic_attribute11_tbl,
      ddp_ic_attribute12_tbl,
      ddp_ic_attribute13_tbl,
      ddp_ic_attribute14_tbl,
      ddp_ic_attribute15_tbl,
      ddp_revalue_average_flag_tbl,
      ddp_freight_code_comb_id_tbl,
      ddp_inv_currency_code_tbl,
      ddp_ic_cogs_acct_id_tbl,
      ddp_inv_accrual_acct_id_tbl,
      ddp_exp_accrual_acct_id_tbl);