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

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

Line: 56


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

Line: 57


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

Line: 60


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

Line: 174


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

Line: 175


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

Line: 178


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

Line: 295


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

Line: 296


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

Line: 299


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

Line: 598


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

Line: 599


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

Line: 602


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

Line: 682


    ddp_offadj_line_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a6);

Line: 683


    ddp_offadj_line_rec.last_updated_by := rosetta_g_miss_num_map(p7_a7);

Line: 686


    ddp_offadj_line_rec.last_update_login := rosetta_g_miss_num_map(p7_a10);

Line: 832


    ddp_list_line_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a32);

Line: 833


    ddp_list_line_rec.last_updated_by := rosetta_g_miss_num_map(p7_a33);

Line: 836


    ddp_list_line_rec.last_update_login := rosetta_g_miss_num_map(p7_a36);

Line: 881


  procedure update_offer_adj_line(p_api_version_number  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
    , x_object_version_number out nocopy  NUMBER
    , p7_a0  NUMBER := 0-1962.0724
    , p7_a1  NUMBER := 0-1962.0724
    , p7_a2  NUMBER := 0-1962.0724
    , p7_a3  VARCHAR2 := fnd_api.g_miss_char
    , p7_a4  NUMBER := 0-1962.0724
    , p7_a5  NUMBER := 0-1962.0724
    , p7_a6  DATE := fnd_api.g_miss_date
    , p7_a7  NUMBER := 0-1962.0724
    , p7_a8  DATE := fnd_api.g_miss_date
    , p7_a9  NUMBER := 0-1962.0724
    , p7_a10  NUMBER := 0-1962.0724
    , p7_a11  NUMBER := 0-1962.0724
    , p7_a12  NUMBER := 0-1962.0724
    , p7_a13  VARCHAR2 := fnd_api.g_miss_char
    , p7_a14  NUMBER := 0-1962.0724
    , p7_a15  NUMBER := 0-1962.0724
    , p7_a16  NUMBER := 0-1962.0724
    , p7_a17  NUMBER := 0-1962.0724
    , p7_a18  VARCHAR2 := fnd_api.g_miss_char
    , p7_a19  DATE := fnd_api.g_miss_date
  )

  as
    ddp_offadj_line_rec ozf_offer_adj_line_pvt.offadj_line_rec_type;

Line: 930


    ddp_offadj_line_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a6);

Line: 931


    ddp_offadj_line_rec.last_updated_by := rosetta_g_miss_num_map(p7_a7);

Line: 934


    ddp_offadj_line_rec.last_update_login := rosetta_g_miss_num_map(p7_a10);

Line: 947


    ozf_offer_adj_line_pvt.update_offer_adj_line(p_api_version_number,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      x_return_status,
      x_msg_count,
      x_msg_data,
      ddp_offadj_line_rec,
      x_object_version_number);

Line: 968


  procedure update_new_offer_adj_line(p_api_version_number  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
    , x_object_version_number out nocopy  NUMBER
    , p7_a0  NUMBER := 0-1962.0724
    , p7_a1  NUMBER := 0-1962.0724
    , p7_a2  NUMBER := 0-1962.0724
    , p7_a3  NUMBER := 0-1962.0724
    , p7_a4  VARCHAR2 := fnd_api.g_miss_char
    , p7_a5  NUMBER := 0-1962.0724
    , p7_a6  VARCHAR2 := fnd_api.g_miss_char
    , p7_a7  VARCHAR2 := fnd_api.g_miss_char
    , p7_a8  VARCHAR2 := fnd_api.g_miss_char
    , p7_a9  VARCHAR2 := fnd_api.g_miss_char
    , p7_a10  VARCHAR2 := fnd_api.g_miss_char
    , p7_a11  VARCHAR2 := fnd_api.g_miss_char
    , p7_a12  VARCHAR2 := fnd_api.g_miss_char
    , p7_a13  NUMBER := 0-1962.0724
    , p7_a14  NUMBER := 0-1962.0724
    , p7_a15  NUMBER := 0-1962.0724
    , p7_a16  NUMBER := 0-1962.0724
    , p7_a17  VARCHAR2 := fnd_api.g_miss_char
    , p7_a18  NUMBER := 0-1962.0724
    , p7_a19  NUMBER := 0-1962.0724
    , p7_a20  NUMBER := 0-1962.0724
    , p7_a21  NUMBER := 0-1962.0724
    , p7_a22  NUMBER := 0-1962.0724
    , p7_a23  VARCHAR2 := fnd_api.g_miss_char
    , p7_a24  NUMBER := 0-1962.0724
    , p7_a25  VARCHAR2 := fnd_api.g_miss_char
    , p7_a26  VARCHAR2 := fnd_api.g_miss_char
    , p7_a27  NUMBER := 0-1962.0724
    , p7_a28  VARCHAR2 := fnd_api.g_miss_char
    , p7_a29  NUMBER := 0-1962.0724
    , p7_a30  VARCHAR2 := fnd_api.g_miss_char
    , p7_a31  NUMBER := 0-1962.0724
    , p7_a32  DATE := fnd_api.g_miss_date
    , p7_a33  NUMBER := 0-1962.0724
    , p7_a34  DATE := fnd_api.g_miss_date
    , p7_a35  NUMBER := 0-1962.0724
    , p7_a36  NUMBER := 0-1962.0724
    , p7_a37  NUMBER := 0-1962.0724
    , p7_a38  DATE := fnd_api.g_miss_date
    , p7_a39  DATE := fnd_api.g_miss_date
    , p7_a40  VARCHAR2 := fnd_api.g_miss_char
    , p7_a41  VARCHAR2 := fnd_api.g_miss_char
    , p7_a42  VARCHAR2 := fnd_api.g_miss_char
    , p7_a43  VARCHAR2 := fnd_api.g_miss_char
    , p7_a44  VARCHAR2 := fnd_api.g_miss_char
    , p7_a45  VARCHAR2 := fnd_api.g_miss_char
    , p7_a46  VARCHAR2 := fnd_api.g_miss_char
    , p7_a47  VARCHAR2 := fnd_api.g_miss_char
    , p7_a48  VARCHAR2 := fnd_api.g_miss_char
    , p7_a49  VARCHAR2 := fnd_api.g_miss_char
    , p7_a50  VARCHAR2 := fnd_api.g_miss_char
    , p7_a51  VARCHAR2 := fnd_api.g_miss_char
    , p7_a52  VARCHAR2 := fnd_api.g_miss_char
    , p7_a53  VARCHAR2 := fnd_api.g_miss_char
    , p7_a54  VARCHAR2 := fnd_api.g_miss_char
    , p7_a55  VARCHAR2 := fnd_api.g_miss_char
    , p7_a56  DATE := fnd_api.g_miss_date
  )

  as
    ddp_list_line_rec ozf_offer_adj_line_pvt.offadj_new_line_rec_type;

Line: 1080


    ddp_list_line_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a32);

Line: 1081


    ddp_list_line_rec.last_updated_by := rosetta_g_miss_num_map(p7_a33);

Line: 1084


    ddp_list_line_rec.last_update_login := rosetta_g_miss_num_map(p7_a36);

Line: 1108


    ozf_offer_adj_line_pvt.update_new_offer_adj_line(p_api_version_number,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      x_return_status,
      x_msg_count,
      x_msg_data,
      ddp_list_line_rec,
      x_object_version_number);

Line: 1173


    ddp_offadj_line_rec.last_update_date := rosetta_g_miss_date_in_map(p3_a6);

Line: 1174


    ddp_offadj_line_rec.last_updated_by := rosetta_g_miss_num_map(p3_a7);

Line: 1177


    ddp_offadj_line_rec.last_update_login := rosetta_g_miss_num_map(p3_a10);

Line: 1248


    ddp_offadj_line_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a6);

Line: 1249


    ddp_offadj_line_rec.last_updated_by := rosetta_g_miss_num_map(p0_a7);

Line: 1252


    ddp_offadj_line_rec.last_update_login := rosetta_g_miss_num_map(p0_a10);

Line: 1319


    ddp_offadj_line_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a6);

Line: 1320


    ddp_offadj_line_rec.last_updated_by := rosetta_g_miss_num_map(p5_a7);

Line: 1323


    ddp_offadj_line_rec.last_update_login := rosetta_g_miss_num_map(p5_a10);