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.IEX_WEBDIR_PVT_W SQL Statements

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

Line: 149


    ddp_assist_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a3);

Line: 150


    ddp_assist_rec.last_updated_by := rosetta_g_miss_num_map(p7_a4);

Line: 153


    ddp_assist_rec.last_update_login := rosetta_g_miss_num_map(p7_a7);

Line: 163


    ddp_web_assist_rec.last_update_date := rosetta_g_miss_date_in_map(p8_a6);

Line: 165


    ddp_web_assist_rec.last_updated_by := rosetta_g_miss_num_map(p8_a8);

Line: 166


    ddp_web_assist_rec.last_update_login := rosetta_g_miss_num_map(p8_a9);

Line: 191


    ddp_web_search_rec.last_update_date := rosetta_g_miss_date_in_map(p9_a5);

Line: 193


    ddp_web_search_rec.last_updated_by := rosetta_g_miss_num_map(p9_a7);

Line: 194


    ddp_web_search_rec.last_update_login := rosetta_g_miss_num_map(p9_a8);

Line: 222


    ddp_query_string_rec.last_update_date := rosetta_g_miss_date_in_map(p10_a4);

Line: 224


    ddp_query_string_rec.last_updated_by := rosetta_g_miss_num_map(p10_a6);

Line: 225


    ddp_query_string_rec.last_update_login := rosetta_g_miss_num_map(p10_a7);

Line: 275


  procedure update_webassist(p_api_version  NUMBER
    , p_init_msg_list  VARCHAR2
    , p_commit  VARCHAR2
    , p_validation_level  NUMBER
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
    , p7_a0  NUMBER := 0-1962.0724
    , p7_a1  NUMBER := 0-1962.0724
    , p7_a2  NUMBER := 0-1962.0724
    , p7_a3  DATE := fnd_api.g_miss_date
    , p7_a4  NUMBER := 0-1962.0724
    , p7_a5  DATE := fnd_api.g_miss_date
    , p7_a6  NUMBER := 0-1962.0724
    , p7_a7  NUMBER := 0-1962.0724
    , p7_a8  VARCHAR2 := fnd_api.g_miss_char
    , p7_a9  VARCHAR2 := fnd_api.g_miss_char
    , p8_a0  NUMBER := 0-1962.0724
    , p8_a1  VARCHAR2 := fnd_api.g_miss_char
    , p8_a2  VARCHAR2 := fnd_api.g_miss_char
    , p8_a3  VARCHAR2 := fnd_api.g_miss_char
    , p8_a4  NUMBER := 0-1962.0724
    , p8_a5  DATE := fnd_api.g_miss_date
    , p8_a6  DATE := fnd_api.g_miss_date
    , p8_a7  NUMBER := 0-1962.0724
    , p8_a8  NUMBER := 0-1962.0724
    , p8_a9  NUMBER := 0-1962.0724
    , p8_a10  NUMBER := 0-1962.0724
    , p8_a11  NUMBER := 0-1962.0724
    , p8_a12  VARCHAR2 := fnd_api.g_miss_char
    , p8_a13  VARCHAR2 := fnd_api.g_miss_char
    , p8_a14  VARCHAR2 := fnd_api.g_miss_char
    , p8_a15  VARCHAR2 := fnd_api.g_miss_char
    , p8_a16  VARCHAR2 := fnd_api.g_miss_char
    , p8_a17  VARCHAR2 := fnd_api.g_miss_char
    , p8_a18  VARCHAR2 := fnd_api.g_miss_char
    , p8_a19  VARCHAR2 := fnd_api.g_miss_char
    , p8_a20  VARCHAR2 := fnd_api.g_miss_char
    , p8_a21  VARCHAR2 := fnd_api.g_miss_char
    , p8_a22  VARCHAR2 := fnd_api.g_miss_char
    , p8_a23  VARCHAR2 := fnd_api.g_miss_char
    , p8_a24  VARCHAR2 := fnd_api.g_miss_char
    , p8_a25  VARCHAR2 := fnd_api.g_miss_char
    , p8_a26  VARCHAR2 := fnd_api.g_miss_char
    , p8_a27  VARCHAR2 := fnd_api.g_miss_char
    , p9_a0  NUMBER := 0-1962.0724
    , p9_a1  VARCHAR2 := fnd_api.g_miss_char
    , p9_a2  NUMBER := 0-1962.0724
    , p9_a3  NUMBER := 0-1962.0724
    , p9_a4  DATE := fnd_api.g_miss_date
    , p9_a5  DATE := fnd_api.g_miss_date
    , p9_a6  NUMBER := 0-1962.0724
    , p9_a7  NUMBER := 0-1962.0724
    , p9_a8  NUMBER := 0-1962.0724
    , p9_a9  VARCHAR2 := fnd_api.g_miss_char
    , p9_a10  VARCHAR2 := fnd_api.g_miss_char
    , p9_a11  VARCHAR2 := fnd_api.g_miss_char
    , p9_a12  NUMBER := 0-1962.0724
    , p9_a13  NUMBER := 0-1962.0724
    , p9_a14  VARCHAR2 := fnd_api.g_miss_char
    , p9_a15  VARCHAR2 := fnd_api.g_miss_char
    , p9_a16  VARCHAR2 := fnd_api.g_miss_char
    , p9_a17  VARCHAR2 := fnd_api.g_miss_char
    , p9_a18  VARCHAR2 := fnd_api.g_miss_char
    , p9_a19  VARCHAR2 := fnd_api.g_miss_char
    , p9_a20  VARCHAR2 := fnd_api.g_miss_char
    , p9_a21  VARCHAR2 := fnd_api.g_miss_char
    , p9_a22  VARCHAR2 := fnd_api.g_miss_char
    , p9_a23  VARCHAR2 := fnd_api.g_miss_char
    , p9_a24  VARCHAR2 := fnd_api.g_miss_char
    , p9_a25  VARCHAR2 := fnd_api.g_miss_char
    , p9_a26  VARCHAR2 := fnd_api.g_miss_char
    , p9_a27  VARCHAR2 := fnd_api.g_miss_char
    , p9_a28  VARCHAR2 := fnd_api.g_miss_char
    , p9_a29  VARCHAR2 := fnd_api.g_miss_char
    , p9_a30  VARCHAR2 := fnd_api.g_miss_char
    , p10_a0  NUMBER := 0-1962.0724
    , p10_a1  NUMBER := 0-1962.0724
    , p10_a2  NUMBER := 0-1962.0724
    , p10_a3  DATE := fnd_api.g_miss_date
    , p10_a4  DATE := fnd_api.g_miss_date
    , p10_a5  NUMBER := 0-1962.0724
    , p10_a6  NUMBER := 0-1962.0724
    , p10_a7  NUMBER := 0-1962.0724
    , p10_a8  VARCHAR2 := fnd_api.g_miss_char
    , p10_a9  VARCHAR2 := fnd_api.g_miss_char
    , p10_a10  VARCHAR2 := fnd_api.g_miss_char
    , p10_a11  NUMBER := 0-1962.0724
    , p10_a12  VARCHAR2 := fnd_api.g_miss_char
    , p10_a13  VARCHAR2 := fnd_api.g_miss_char
    , p10_a14  VARCHAR2 := fnd_api.g_miss_char
    , p10_a15  VARCHAR2 := fnd_api.g_miss_char
    , p10_a16  VARCHAR2 := fnd_api.g_miss_char
    , p10_a17  VARCHAR2 := fnd_api.g_miss_char
    , p10_a18  VARCHAR2 := fnd_api.g_miss_char
    , p10_a19  VARCHAR2 := fnd_api.g_miss_char
    , p10_a20  VARCHAR2 := fnd_api.g_miss_char
    , p10_a21  VARCHAR2 := fnd_api.g_miss_char
    , p10_a22  VARCHAR2 := fnd_api.g_miss_char
    , p10_a23  VARCHAR2 := fnd_api.g_miss_char
    , p10_a24  VARCHAR2 := fnd_api.g_miss_char
    , p10_a25  VARCHAR2 := fnd_api.g_miss_char
    , p10_a26  VARCHAR2 := fnd_api.g_miss_char
    , p10_a27  VARCHAR2 := fnd_api.g_miss_char
    , p10_a28  VARCHAR2 := fnd_api.g_miss_char
    , p10_a29  VARCHAR2 := fnd_api.g_miss_char
  )

  as
    ddp_assist_rec iex_webdir_pvt.assist_rec_type;

Line: 402


    ddp_assist_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a3);

Line: 403


    ddp_assist_rec.last_updated_by := rosetta_g_miss_num_map(p7_a4);

Line: 406


    ddp_assist_rec.last_update_login := rosetta_g_miss_num_map(p7_a7);

Line: 416


    ddp_web_assist_rec.last_update_date := rosetta_g_miss_date_in_map(p8_a6);

Line: 418


    ddp_web_assist_rec.last_updated_by := rosetta_g_miss_num_map(p8_a8);

Line: 419


    ddp_web_assist_rec.last_update_login := rosetta_g_miss_num_map(p8_a9);

Line: 444


    ddp_web_search_rec.last_update_date := rosetta_g_miss_date_in_map(p9_a5);

Line: 446


    ddp_web_search_rec.last_updated_by := rosetta_g_miss_num_map(p9_a7);

Line: 447


    ddp_web_search_rec.last_update_login := rosetta_g_miss_num_map(p9_a8);

Line: 475


    ddp_query_string_rec.last_update_date := rosetta_g_miss_date_in_map(p10_a4);

Line: 477


    ddp_query_string_rec.last_updated_by := rosetta_g_miss_num_map(p10_a6);

Line: 478


    ddp_query_string_rec.last_update_login := rosetta_g_miss_num_map(p10_a7);

Line: 503


    iex_webdir_pvt.update_webassist(p_api_version,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      x_return_status,
      x_msg_count,
      x_msg_data,
      ddp_assist_rec,
      ddp_web_assist_rec,
      ddp_web_search_rec,
      ddp_query_string_rec);