APPS.AS_MULTI_CURRENCIES_PKG_W SQL Statements

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

Line: 46

          t(ddindx).updateable_flag := a4(indx);

Line: 47

          t(ddindx).deleteable_flag := a5(indx);

Line: 48

          t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a6(indx));

Line: 49

          t(ddindx).last_updated_by := rosetta_g_miss_num_map(a7(indx));

Line: 52

          t(ddindx).last_update_login := rosetta_g_miss_num_map(a10(indx));

Line: 124

          a4(indx) := t(ddindx).updateable_flag;

Line: 125

          a5(indx) := t(ddindx).deleteable_flag;

Line: 126

          a6(indx) := t(ddindx).last_update_date;

Line: 127

          a7(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);

Line: 130

          a10(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);

Line: 213

  procedure insert_type_mappings(p0_a0 JTF_VARCHAR2_TABLE_100
    , p0_a1 JTF_VARCHAR2_TABLE_100
    , p0_a2 JTF_VARCHAR2_TABLE_100
    , p0_a3 JTF_VARCHAR2_TABLE_100
    , p0_a4 JTF_VARCHAR2_TABLE_100
    , p0_a5 JTF_VARCHAR2_TABLE_100
    , p0_a6 JTF_DATE_TABLE
    , p0_a7 JTF_NUMBER_TABLE
    , p0_a8 JTF_DATE_TABLE
    , p0_a9 JTF_NUMBER_TABLE
    , p0_a10 JTF_NUMBER_TABLE
    , p0_a11 JTF_NUMBER_TABLE
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
  )

  as
    ddp_type_mappings_tbl as_multi_currencies_pkg.type_mappings_tbl_type;

Line: 254

    as_multi_currencies_pkg.insert_type_mappings(ddp_type_mappings_tbl,
      x_return_status,
      x_msg_count,
      x_msg_data);

Line: 265

  procedure update_type_mappings(p0_a0 JTF_VARCHAR2_TABLE_100
    , p0_a1 JTF_VARCHAR2_TABLE_100
    , p0_a2 JTF_VARCHAR2_TABLE_100
    , p0_a3 JTF_VARCHAR2_TABLE_100
    , p0_a4 JTF_VARCHAR2_TABLE_100
    , p0_a5 JTF_VARCHAR2_TABLE_100
    , p0_a6 JTF_DATE_TABLE
    , p0_a7 JTF_NUMBER_TABLE
    , p0_a8 JTF_DATE_TABLE
    , p0_a9 JTF_NUMBER_TABLE
    , p0_a10 JTF_NUMBER_TABLE
    , p0_a11 JTF_NUMBER_TABLE
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
  )

  as
    ddp_type_mappings_tbl as_multi_currencies_pkg.type_mappings_tbl_type;

Line: 306

    as_multi_currencies_pkg.update_type_mappings(ddp_type_mappings_tbl,
      x_return_status,
      x_msg_count,
      x_msg_data);

Line: 317

  procedure delete_type_mappings(p0_a0 JTF_VARCHAR2_TABLE_100
    , p0_a1 JTF_VARCHAR2_TABLE_100
    , p0_a2 JTF_VARCHAR2_TABLE_100
    , p0_a3 JTF_VARCHAR2_TABLE_100
    , p0_a4 JTF_VARCHAR2_TABLE_100
    , p0_a5 JTF_VARCHAR2_TABLE_100
    , p0_a6 JTF_DATE_TABLE
    , p0_a7 JTF_NUMBER_TABLE
    , p0_a8 JTF_DATE_TABLE
    , p0_a9 JTF_NUMBER_TABLE
    , p0_a10 JTF_NUMBER_TABLE
    , p0_a11 JTF_NUMBER_TABLE
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
  )

  as
    ddp_type_mappings_tbl as_multi_currencies_pkg.type_mappings_tbl_type;

Line: 358

    as_multi_currencies_pkg.delete_type_mappings(ddp_type_mappings_tbl,
      x_return_status,
      x_msg_count,
      x_msg_data);

Line: 369

  procedure insert_period_rates(p0_a0 JTF_VARCHAR2_TABLE_100
    , p0_a1 JTF_VARCHAR2_TABLE_100
    , p0_a2 JTF_DATE_TABLE
    , p0_a3 JTF_VARCHAR2_TABLE_100
    , p0_a4 JTF_NUMBER_TABLE
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
  )

  as
    ddp_period_rates_tbl as_multi_currencies_pkg.period_rates_tbl_type;

Line: 396

    as_multi_currencies_pkg.insert_period_rates(ddp_period_rates_tbl,
      x_return_status,
      x_msg_count,
      x_msg_data);

Line: 407

  procedure update_period_rates(p0_a0 JTF_VARCHAR2_TABLE_100
    , p0_a1 JTF_VARCHAR2_TABLE_100
    , p0_a2 JTF_DATE_TABLE
    , p0_a3 JTF_VARCHAR2_TABLE_100
    , p0_a4 JTF_NUMBER_TABLE
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
  )

  as
    ddp_period_rates_tbl as_multi_currencies_pkg.period_rates_tbl_type;

Line: 434

    as_multi_currencies_pkg.update_period_rates(ddp_period_rates_tbl,
      x_return_status,
      x_msg_count,
      x_msg_data);

Line: 445

  procedure delete_period_rates(p0_a0 JTF_VARCHAR2_TABLE_100
    , p0_a1 JTF_VARCHAR2_TABLE_100
    , p0_a2 JTF_DATE_TABLE
    , p0_a3 JTF_VARCHAR2_TABLE_100
    , p0_a4 JTF_NUMBER_TABLE
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
  )

  as
    ddp_period_rates_tbl as_multi_currencies_pkg.period_rates_tbl_type;

Line: 472

    as_multi_currencies_pkg.delete_period_rates(ddp_period_rates_tbl,
      x_return_status,
      x_msg_count,
      x_msg_data);