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

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

Line: 61


    ddp_ovtv_rec.last_updated_by := rosetta_g_miss_num_map(p0_a7);

Line: 62


    ddp_ovtv_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a8);

Line: 63


    ddp_ovtv_rec.last_update_login := rosetta_g_miss_num_map(p0_a9);

Line: 91


    p3_a7 := rosetta_g_miss_num_map(ddx_ovtv_rec.last_updated_by);

Line: 92


    p3_a8 := ddx_ovtv_rec.last_update_date;

Line: 93


    p3_a9 := rosetta_g_miss_num_map(ddx_ovtv_rec.last_update_login);

Line: 96


  procedure insert_ovdtemplates(p_api_version  NUMBER
    , p_init_msg_list  VARCHAR2
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
    , p9_a0 out nocopy  NUMBER
    , p9_a1 out nocopy  NUMBER
    , p9_a2 out nocopy  NUMBER
    , p9_a3 out nocopy  NUMBER
    , p9_a4 out nocopy  NUMBER
    , p9_a5 out nocopy  NUMBER
    , p9_a6 out nocopy  DATE
    , p9_a7 out nocopy  NUMBER
    , p9_a8 out nocopy  DATE
    , p9_a9 out nocopy  NUMBER
    , p5_a0  NUMBER := 0-1962.0724
    , p5_a1  NUMBER := 0-1962.0724
    , p5_a2  VARCHAR2 := fnd_api.g_miss_char
    , p5_a3  VARCHAR2 := fnd_api.g_miss_char
    , p5_a4  DATE := fnd_api.g_miss_date
    , p5_a5  DATE := fnd_api.g_miss_date
    , p5_a6  VARCHAR2 := fnd_api.g_miss_char
    , p5_a7  VARCHAR2 := fnd_api.g_miss_char
    , p5_a8  VARCHAR2 := fnd_api.g_miss_char
    , p5_a9  VARCHAR2 := fnd_api.g_miss_char
    , p5_a10  VARCHAR2 := fnd_api.g_miss_char
    , p5_a11  VARCHAR2 := fnd_api.g_miss_char
    , p5_a12  VARCHAR2 := fnd_api.g_miss_char
    , p5_a13  VARCHAR2 := fnd_api.g_miss_char
    , p5_a14  VARCHAR2 := fnd_api.g_miss_char
    , p5_a15  VARCHAR2 := fnd_api.g_miss_char
    , p5_a16  VARCHAR2 := fnd_api.g_miss_char
    , p5_a17  VARCHAR2 := fnd_api.g_miss_char
    , p5_a18  VARCHAR2 := fnd_api.g_miss_char
    , p5_a19  VARCHAR2 := fnd_api.g_miss_char
    , p5_a20  VARCHAR2 := fnd_api.g_miss_char
    , p5_a21  VARCHAR2 := fnd_api.g_miss_char
    , p5_a22  NUMBER := 0-1962.0724
    , p5_a23  DATE := fnd_api.g_miss_date
    , p5_a24  NUMBER := 0-1962.0724
    , p5_a25  DATE := fnd_api.g_miss_date
    , p5_a26  NUMBER := 0-1962.0724
    , p6_a0  NUMBER := 0-1962.0724
    , p6_a1  NUMBER := 0-1962.0724
    , p6_a2  NUMBER := 0-1962.0724
    , p6_a3  VARCHAR2 := fnd_api.g_miss_char
    , p6_a4  VARCHAR2 := fnd_api.g_miss_char
    , p6_a5  DATE := fnd_api.g_miss_date
    , p6_a6  DATE := fnd_api.g_miss_date
    , p6_a7  NUMBER := 0-1962.0724
    , p6_a8  DATE := fnd_api.g_miss_date
    , p6_a9  NUMBER := 0-1962.0724
    , p6_a10  DATE := fnd_api.g_miss_date
    , p6_a11  NUMBER := 0-1962.0724
    , p7_a0  NUMBER := 0-1962.0724
    , p7_a1  VARCHAR2 := fnd_api.g_miss_char
    , p7_a2  NUMBER := 0-1962.0724
    , p7_a3  NUMBER := 0-1962.0724
    , p7_a4  NUMBER := 0-1962.0724
    , p7_a5  VARCHAR2 := fnd_api.g_miss_char
    , p7_a6  VARCHAR2 := fnd_api.g_miss_char
    , p7_a7  NUMBER := 0-1962.0724
    , p7_a8  NUMBER := 0-1962.0724
    , p7_a9  VARCHAR2 := fnd_api.g_miss_char
    , p7_a10  NUMBER := 0-1962.0724
    , p7_a11  DATE := fnd_api.g_miss_date
    , p7_a12  NUMBER := 0-1962.0724
    , p7_a13  DATE := fnd_api.g_miss_date
    , p7_a14  NUMBER := 0-1962.0724
    , p8_a0  NUMBER := 0-1962.0724
    , p8_a1  NUMBER := 0-1962.0724
    , p8_a2  NUMBER := 0-1962.0724
    , p8_a3  NUMBER := 0-1962.0724
    , p8_a4  NUMBER := 0-1962.0724
    , p8_a5  NUMBER := 0-1962.0724
    , p8_a6  DATE := fnd_api.g_miss_date
    , p8_a7  NUMBER := 0-1962.0724
    , p8_a8  DATE := fnd_api.g_miss_date
    , p8_a9  NUMBER := 0-1962.0724
  )

  as
    ddp_optv_rec okl_setupovdtemplates_pvt.optv_rec_type;

Line: 216


    ddp_optv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a24);

Line: 217


    ddp_optv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a25);

Line: 218


    ddp_optv_rec.last_update_login := rosetta_g_miss_num_map(p5_a26);

Line: 229


    ddp_ovev_rec.last_updated_by := rosetta_g_miss_num_map(p6_a9);

Line: 230


    ddp_ovev_rec.last_update_date := rosetta_g_miss_date_in_map(p6_a10);

Line: 231


    ddp_ovev_rec.last_update_login := rosetta_g_miss_num_map(p6_a11);

Line: 245


    ddp_ovdv_rec.last_updated_by := rosetta_g_miss_num_map(p7_a12);

Line: 246


    ddp_ovdv_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a13);

Line: 247


    ddp_ovdv_rec.last_update_login := rosetta_g_miss_num_map(p7_a14);

Line: 256


    ddp_ovtv_rec.last_updated_by := rosetta_g_miss_num_map(p8_a7);

Line: 257


    ddp_ovtv_rec.last_update_date := rosetta_g_miss_date_in_map(p8_a8);

Line: 258


    ddp_ovtv_rec.last_update_login := rosetta_g_miss_num_map(p8_a9);

Line: 262


    okl_setupovdtemplates_pvt.insert_ovdtemplates(p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      ddp_optv_rec,
      ddp_ovev_rec,
      ddp_ovdv_rec,
      ddp_ovtv_rec,
      ddx_ovtv_rec);

Line: 290


    p9_a7 := rosetta_g_miss_num_map(ddx_ovtv_rec.last_updated_by);

Line: 291


    p9_a8 := ddx_ovtv_rec.last_update_date;

Line: 292


    p9_a9 := rosetta_g_miss_num_map(ddx_ovtv_rec.last_update_login);

Line: 295


  procedure delete_ovdtemplates(p_api_version  NUMBER
    , p_init_msg_list  VARCHAR2
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
    , p8_a0 JTF_NUMBER_TABLE
    , p8_a1 JTF_NUMBER_TABLE
    , p8_a2 JTF_NUMBER_TABLE
    , p8_a3 JTF_NUMBER_TABLE
    , p8_a4 JTF_NUMBER_TABLE
    , p8_a5 JTF_NUMBER_TABLE
    , p8_a6 JTF_DATE_TABLE
    , p8_a7 JTF_NUMBER_TABLE
    , p8_a8 JTF_DATE_TABLE
    , p8_a9 JTF_NUMBER_TABLE
    , p5_a0  NUMBER := 0-1962.0724
    , p5_a1  NUMBER := 0-1962.0724
    , p5_a2  VARCHAR2 := fnd_api.g_miss_char
    , p5_a3  VARCHAR2 := fnd_api.g_miss_char
    , p5_a4  DATE := fnd_api.g_miss_date
    , p5_a5  DATE := fnd_api.g_miss_date
    , p5_a6  VARCHAR2 := fnd_api.g_miss_char
    , p5_a7  VARCHAR2 := fnd_api.g_miss_char
    , p5_a8  VARCHAR2 := fnd_api.g_miss_char
    , p5_a9  VARCHAR2 := fnd_api.g_miss_char
    , p5_a10  VARCHAR2 := fnd_api.g_miss_char
    , p5_a11  VARCHAR2 := fnd_api.g_miss_char
    , p5_a12  VARCHAR2 := fnd_api.g_miss_char
    , p5_a13  VARCHAR2 := fnd_api.g_miss_char
    , p5_a14  VARCHAR2 := fnd_api.g_miss_char
    , p5_a15  VARCHAR2 := fnd_api.g_miss_char
    , p5_a16  VARCHAR2 := fnd_api.g_miss_char
    , p5_a17  VARCHAR2 := fnd_api.g_miss_char
    , p5_a18  VARCHAR2 := fnd_api.g_miss_char
    , p5_a19  VARCHAR2 := fnd_api.g_miss_char
    , p5_a20  VARCHAR2 := fnd_api.g_miss_char
    , p5_a21  VARCHAR2 := fnd_api.g_miss_char
    , p5_a22  NUMBER := 0-1962.0724
    , p5_a23  DATE := fnd_api.g_miss_date
    , p5_a24  NUMBER := 0-1962.0724
    , p5_a25  DATE := fnd_api.g_miss_date
    , p5_a26  NUMBER := 0-1962.0724
    , p6_a0  NUMBER := 0-1962.0724
    , p6_a1  NUMBER := 0-1962.0724
    , p6_a2  NUMBER := 0-1962.0724
    , p6_a3  VARCHAR2 := fnd_api.g_miss_char
    , p6_a4  VARCHAR2 := fnd_api.g_miss_char
    , p6_a5  DATE := fnd_api.g_miss_date
    , p6_a6  DATE := fnd_api.g_miss_date
    , p6_a7  NUMBER := 0-1962.0724
    , p6_a8  DATE := fnd_api.g_miss_date
    , p6_a9  NUMBER := 0-1962.0724
    , p6_a10  DATE := fnd_api.g_miss_date
    , p6_a11  NUMBER := 0-1962.0724
    , p7_a0  NUMBER := 0-1962.0724
    , p7_a1  VARCHAR2 := fnd_api.g_miss_char
    , p7_a2  NUMBER := 0-1962.0724
    , p7_a3  NUMBER := 0-1962.0724
    , p7_a4  NUMBER := 0-1962.0724
    , p7_a5  VARCHAR2 := fnd_api.g_miss_char
    , p7_a6  VARCHAR2 := fnd_api.g_miss_char
    , p7_a7  NUMBER := 0-1962.0724
    , p7_a8  NUMBER := 0-1962.0724
    , p7_a9  VARCHAR2 := fnd_api.g_miss_char
    , p7_a10  NUMBER := 0-1962.0724
    , p7_a11  DATE := fnd_api.g_miss_date
    , p7_a12  NUMBER := 0-1962.0724
    , p7_a13  DATE := fnd_api.g_miss_date
    , p7_a14  NUMBER := 0-1962.0724
  )

  as
    ddp_optv_rec okl_setupovdtemplates_pvt.optv_rec_type;

Line: 404


    ddp_optv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a24);

Line: 405


    ddp_optv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a25);

Line: 406


    ddp_optv_rec.last_update_login := rosetta_g_miss_num_map(p5_a26);

Line: 417


    ddp_ovev_rec.last_updated_by := rosetta_g_miss_num_map(p6_a9);

Line: 418


    ddp_ovev_rec.last_update_date := rosetta_g_miss_date_in_map(p6_a10);

Line: 419


    ddp_ovev_rec.last_update_login := rosetta_g_miss_num_map(p6_a11);

Line: 433


    ddp_ovdv_rec.last_updated_by := rosetta_g_miss_num_map(p7_a12);

Line: 434


    ddp_ovdv_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a13);

Line: 435


    ddp_ovdv_rec.last_update_login := rosetta_g_miss_num_map(p7_a14);

Line: 450


    okl_setupovdtemplates_pvt.delete_ovdtemplates(p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      ddp_optv_rec,
      ddp_ovev_rec,
      ddp_ovdv_rec,
      ddp_ovtv_tbl);