APPS.IBE_DISPLAYCONTEXT_GRP_W SQL Statements

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

Line: 39

          t(ddindx).context_delete := a0(indx);

Line: 102

          a0(indx) := t(ddindx).context_delete;

Line: 150

    ddp_display_context_rec.context_delete := p6_a0;

Line: 176

    p6_a0 := ddp_display_context_rec.context_delete;

Line: 187

  procedure save_delete_display_context(p_api_version  NUMBER
    , p_init_msg_list  VARCHAR2
    , p_commit  VARCHAR2
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
    , p6_a0 in out nocopy JTF_VARCHAR2_TABLE_100
    , p6_a1 in out nocopy JTF_NUMBER_TABLE
    , p6_a2 in out nocopy JTF_NUMBER_TABLE
    , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_100
    , p6_a4 in out nocopy JTF_VARCHAR2_TABLE_100
    , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_300
    , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
    , p6_a7 in out nocopy JTF_VARCHAR2_TABLE_100
    , p6_a8 in out nocopy JTF_NUMBER_TABLE
  )

  as
    ddp_display_context_tbl ibe_displaycontext_grp.display_context_tbl_type;

Line: 228

    ibe_displaycontext_grp.save_delete_display_context(p_api_version,
      p_init_msg_list,
      p_commit,
      x_return_status,
      x_msg_count,
      x_msg_data,
      ddp_display_context_tbl);

Line: 255

  procedure delete_display_context(p_api_version  NUMBER
    , p_init_msg_list  VARCHAR2
    , p_commit  VARCHAR2
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
    , p6_a0 in out nocopy  VARCHAR2
    , p6_a1 in out nocopy  NUMBER
    , p6_a2 in out nocopy  NUMBER
    , p6_a3 in out nocopy  VARCHAR2
    , p6_a4 in out nocopy  VARCHAR2
    , p6_a5 in out nocopy  VARCHAR2
    , p6_a6 in out nocopy  VARCHAR2
    , p6_a7 in out nocopy  VARCHAR2
    , p6_a8 in out nocopy  NUMBER
  )

  as
    ddp_display_context_rec ibe_displaycontext_grp.display_context_rec_type;

Line: 284

    ddp_display_context_rec.context_delete := p6_a0;

Line: 295

    ibe_displaycontext_grp.delete_display_context(p_api_version,
      p_init_msg_list,
      p_commit,
      x_return_status,
      x_msg_count,
      x_msg_data,
      ddp_display_context_rec);

Line: 310

    p6_a0 := ddp_display_context_rec.context_delete;

Line: 321

  procedure insert_row(x_rowid in out nocopy  VARCHAR2
    , x_context_id  NUMBER
    , x_object_version_number  NUMBER
    , x_access_name  VARCHAR2
    , x_context_type_code  VARCHAR2
    , x_item_id  NUMBER
    , x_name  VARCHAR2
    , x_description  VARCHAR2
    , x_creation_date  date
    , x_created_by  NUMBER
    , x_last_update_date  date
    , x_last_updated_by  NUMBER
    , x_last_update_login  NUMBER
    , x_component_type_code  VARCHAR2
  )

  as
    ddx_creation_date date;

Line: 339

    ddx_last_update_date date;

Line: 355

    ddx_last_update_date := rosetta_g_miss_date_in_map(x_last_update_date);

Line: 361

    ibe_displaycontext_grp.insert_row(x_rowid,
      x_context_id,
      x_object_version_number,
      x_access_name,
      x_context_type_code,
      x_item_id,
      x_name,
      x_description,
      ddx_creation_date,
      x_created_by,
      ddx_last_update_date,
      x_last_updated_by,
      x_last_update_login,
      x_component_type_code);

Line: 392

  procedure update_row(x_context_id  NUMBER
    , x_object_version_number  NUMBER
    , x_access_name  VARCHAR2
    , x_context_type_code  VARCHAR2
    , x_item_id  NUMBER
    , x_name  VARCHAR2
    , x_description  VARCHAR2
    , x_last_update_date  date
    , x_last_updated_by  NUMBER
    , x_last_update_login  NUMBER
    , x_component_type_code  VARCHAR2
  )

  as
    ddx_last_update_date date;

Line: 418

    ddx_last_update_date := rosetta_g_miss_date_in_map(x_last_update_date);

Line: 424

    ibe_displaycontext_grp.update_row(x_context_id,
      x_object_version_number,
      x_access_name,
      x_context_type_code,
      x_item_id,
      x_name,
      x_description,
      ddx_last_update_date,
      x_last_updated_by,
      x_last_update_login,
      x_component_type_code);