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

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

Line: 81


  procedure insert_all_wo_lines(p_api_version  NUMBER
    , p_init_msg_list  VARCHAR2
    , p_commit  VARCHAR2
    , p_estimate_id  NUMBER
    , p4_a0 JTF_NUMBER_TABLE
    , p4_a1 JTF_NUMBER_TABLE
    , p4_a2 JTF_NUMBER_TABLE
    , p4_a3 JTF_NUMBER_TABLE
    , p4_a4 JTF_NUMBER_TABLE
    , p4_a5 JTF_VARCHAR2_TABLE_100
    , p4_a6 JTF_NUMBER_TABLE
    , p4_a7 JTF_NUMBER_TABLE
    , p4_a8 JTF_NUMBER_TABLE
    , p4_a9 JTF_VARCHAR2_TABLE_100
    , p4_a10 JTF_VARCHAR2_TABLE_300
    , p4_a11 JTF_NUMBER_TABLE
    , p4_a12 JTF_NUMBER_TABLE
    , p4_a13 JTF_NUMBER_TABLE
    , p4_a14 JTF_VARCHAR2_TABLE_100
    , p4_a15 JTF_DATE_TABLE
    , p4_a16 JTF_DATE_TABLE
    , p4_a17 JTF_NUMBER_TABLE
    , p4_a18 JTF_NUMBER_TABLE
    , p4_a19 JTF_NUMBER_TABLE
    , p4_a20 JTF_NUMBER_TABLE
    , p4_a21 JTF_NUMBER_TABLE
    , p4_a22 JTF_NUMBER_TABLE
    , p4_a23 JTF_NUMBER_TABLE
    , p4_a24 JTF_NUMBER_TABLE
    , p4_a25 JTF_VARCHAR2_TABLE_300
    , p4_a26 JTF_NUMBER_TABLE
    , p4_a27 JTF_NUMBER_TABLE
    , p4_a28 JTF_VARCHAR2_TABLE_4000
    , p4_a29 JTF_NUMBER_TABLE
    , p4_a30 JTF_NUMBER_TABLE
    , p4_a31 JTF_VARCHAR2_TABLE_100
    , p4_a32 JTF_NUMBER_TABLE
    , p4_a33 JTF_NUMBER_TABLE
    , p4_a34 JTF_NUMBER_TABLE
    , p4_a35 JTF_NUMBER_TABLE
    , p4_a36 JTF_NUMBER_TABLE
    , p4_a37 JTF_NUMBER_TABLE
    , p4_a38 JTF_NUMBER_TABLE
    , p4_a39 JTF_VARCHAR2_TABLE_100
    , p4_a40 JTF_NUMBER_TABLE
    , p4_a41 JTF_VARCHAR2_TABLE_300
    , p4_a42 JTF_NUMBER_TABLE
    , p4_a43 JTF_VARCHAR2_TABLE_100
    , p4_a44 JTF_NUMBER_TABLE
    , p4_a45 JTF_NUMBER_TABLE
    , p4_a46 JTF_NUMBER_TABLE
    , p4_a47 JTF_VARCHAR2_TABLE_100
    , p4_a48 JTF_NUMBER_TABLE
    , p4_a49 JTF_NUMBER_TABLE
    , p4_a50 JTF_VARCHAR2_TABLE_100
    , p4_a51 JTF_VARCHAR2_TABLE_300
    , p4_a52 JTF_NUMBER_TABLE
    , p4_a53 JTF_VARCHAR2_TABLE_100
    , p4_a54 JTF_DATE_TABLE
    , p4_a55 JTF_NUMBER_TABLE
    , p4_a56 JTF_NUMBER_TABLE
    , p4_a57 JTF_NUMBER_TABLE
    , p4_a58 JTF_NUMBER_TABLE
    , p4_a59 JTF_VARCHAR2_TABLE_300
    , p4_a60 JTF_NUMBER_TABLE
    , p4_a61 JTF_NUMBER_TABLE
    , p4_a62 JTF_NUMBER_TABLE
    , p4_a63 JTF_NUMBER_TABLE
    , p4_a64 JTF_NUMBER_TABLE
    , p4_a65 JTF_NUMBER_TABLE
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
  )

  as
    ddp_eam_ce_wo_lines_tbl eam_est_datastructures_pub.eam_ce_work_order_lines_tbl;

Line: 238


    eam_construction_est_pub.insert_all_wo_lines(p_api_version,
      p_init_msg_list,
      p_commit,
      p_estimate_id,
      ddp_eam_ce_wo_lines_tbl,
      x_return_status,
      x_msg_count,
      x_msg_data);

Line: 257


  procedure insert_parent_wo_line(p_api_version  NUMBER
    , p_init_msg_list  VARCHAR2
    , p_commit  VARCHAR2
    , p_estimate_id  NUMBER
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
    , p4_a0  NUMBER := 0-1962.0724
    , p4_a1  VARCHAR2 := fnd_api.g_miss_char
    , p4_a2  NUMBER := 0-1962.0724
    , p4_a3  NUMBER := 0-1962.0724
    , p4_a4  VARCHAR2 := fnd_api.g_miss_char
    , p4_a5  NUMBER := 0-1962.0724
    , p4_a6  NUMBER := 0-1962.0724
    , p4_a7  NUMBER := 0-1962.0724
    , p4_a8  VARCHAR2 := fnd_api.g_miss_char
    , p4_a9  VARCHAR2 := fnd_api.g_miss_char
    , p4_a10  NUMBER := 0-1962.0724
    , p4_a11  NUMBER := 0-1962.0724
    , p4_a12  DATE := fnd_api.g_miss_date
    , p4_a13  DATE := fnd_api.g_miss_date
    , p4_a14  NUMBER := 0-1962.0724
    , p4_a15  VARCHAR2 := fnd_api.g_miss_char
    , p4_a16  NUMBER := 0-1962.0724
  )

  as
    ddp_parent_wo_line_rec eam_est_datastructures_pub.eam_ce_parent_wo_rec;

Line: 315


    eam_construction_est_pub.insert_parent_wo_line(p_api_version,
      p_init_msg_list,
      p_commit,
      p_estimate_id,
      ddp_parent_wo_line_rec,
      x_return_status,
      x_msg_count,
      x_msg_data);

Line: 589


  procedure update_estimate(p_api_version  NUMBER
    , p_commit  VARCHAR2
    , p_init_msg_list  VARCHAR2
    , p_validation_level  NUMBER
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
    , p4_a0  NUMBER := 0-1962.0724
    , p4_a1  NUMBER := 0-1962.0724
    , p4_a2  VARCHAR2 := fnd_api.g_miss_char
    , p4_a3  VARCHAR2 := fnd_api.g_miss_char
    , p4_a4  NUMBER := 0-1962.0724
    , p4_a5  NUMBER := 0-1962.0724
    , p4_a6  VARCHAR2 := fnd_api.g_miss_char
    , p4_a7  VARCHAR2 := fnd_api.g_miss_char
    , p4_a8  VARCHAR2 := fnd_api.g_miss_char
    , p4_a9  VARCHAR2 := fnd_api.g_miss_char
    , p4_a10  VARCHAR2 := fnd_api.g_miss_char
    , p4_a11  VARCHAR2 := fnd_api.g_miss_char
    , p4_a12  VARCHAR2 := fnd_api.g_miss_char
    , p4_a13  VARCHAR2 := fnd_api.g_miss_char
    , p4_a14  VARCHAR2 := fnd_api.g_miss_char
    , p4_a15  VARCHAR2 := fnd_api.g_miss_char
    , p4_a16  VARCHAR2 := fnd_api.g_miss_char
    , p4_a17  VARCHAR2 := fnd_api.g_miss_char
    , p4_a18  VARCHAR2 := fnd_api.g_miss_char
    , p4_a19  VARCHAR2 := fnd_api.g_miss_char
    , p4_a20  VARCHAR2 := fnd_api.g_miss_char
    , p4_a21  VARCHAR2 := fnd_api.g_miss_char
    , p4_a22  VARCHAR2 := fnd_api.g_miss_char
  )

  as
    ddp_estimate_rec eam_est_datastructures_pub.eam_construction_estimate_rec;

Line: 659


    eam_construction_est_pub.update_estimate(p_api_version,
      p_commit,
      p_init_msg_list,
      p_validation_level,
      ddp_estimate_rec,
      x_return_status,
      x_msg_count,
      x_msg_data);

Line: 769


  procedure update_ce_wo_lns_by_group_opt(p_api_version  NUMBER
    , p_commit  VARCHAR2
    , p_init_msg_list  VARCHAR2
    , p_validation_level  NUMBER
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
    , p4_a0  NUMBER := 0-1962.0724
    , p4_a1  VARCHAR2 := fnd_api.g_miss_char
    , p4_a2  NUMBER := 0-1962.0724
    , p4_a3  NUMBER := 0-1962.0724
    , p4_a4  VARCHAR2 := fnd_api.g_miss_char
    , p4_a5  NUMBER := 0-1962.0724
    , p4_a6  NUMBER := 0-1962.0724
    , p4_a7  NUMBER := 0-1962.0724
    , p4_a8  VARCHAR2 := fnd_api.g_miss_char
    , p4_a9  VARCHAR2 := fnd_api.g_miss_char
    , p4_a10  NUMBER := 0-1962.0724
    , p4_a11  NUMBER := 0-1962.0724
    , p4_a12  DATE := fnd_api.g_miss_date
    , p4_a13  DATE := fnd_api.g_miss_date
    , p4_a14  NUMBER := 0-1962.0724
    , p4_a15  NUMBER := 0-1962.0724
  )

  as
    ddp_ce_wo_defaults eam_est_datastructures_pub.eam_ce_wo_defaults_rec;

Line: 825


    eam_construction_est_pub.update_ce_wo_lns_by_group_opt(p_api_version,
      p_commit,
      p_init_msg_list,
      p_validation_level,
      ddp_ce_wo_defaults,
      x_return_status,
      x_msg_count,
      x_msg_data);