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_LEASE_OPPORTUNITY_PVT_W SQL Statements

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

Line: 262


  procedure update_lease_opp(p_api_version  NUMBER
    , p_init_msg_list  VARCHAR2
    , p_transaction_control  VARCHAR2
    , p3_a0  NUMBER
    , p3_a1  NUMBER
    , p3_a2  VARCHAR2
    , p3_a3  VARCHAR2
    , p3_a4  VARCHAR2
    , p3_a5  VARCHAR2
    , p3_a6  VARCHAR2
    , p3_a7  VARCHAR2
    , p3_a8  VARCHAR2
    , p3_a9  VARCHAR2
    , p3_a10  VARCHAR2
    , p3_a11  VARCHAR2
    , p3_a12  VARCHAR2
    , p3_a13  VARCHAR2
    , p3_a14  VARCHAR2
    , p3_a15  VARCHAR2
    , p3_a16  VARCHAR2
    , p3_a17  VARCHAR2
    , p3_a18  VARCHAR2
    , p3_a19  VARCHAR2
    , p3_a20  DATE
    , p3_a21  DATE
    , p3_a22  NUMBER
    , p3_a23  NUMBER
    , p3_a24  NUMBER
    , p3_a25  NUMBER
    , p3_a26  NUMBER
    , p3_a27  VARCHAR2
    , p3_a28  VARCHAR2
    , p3_a29  NUMBER
    , p3_a30  DATE
    , p3_a31  NUMBER
    , p3_a32  NUMBER
    , p3_a33  NUMBER
    , p3_a34  NUMBER
    , p3_a35  NUMBER
    , p3_a36  DATE
    , p3_a37  DATE
    , p3_a38  VARCHAR2
    , p3_a39  VARCHAR2
    , p3_a40  VARCHAR2
    , p3_a41  NUMBER
    , p3_a42  VARCHAR2
    , p3_a43  VARCHAR2
    , p3_a44  VARCHAR2
    , p3_a45  NUMBER
    , p3_a46  NUMBER
    , p3_a47  NUMBER
    , p3_a48  NUMBER
    , p3_a49  VARCHAR2
    , p3_a50  VARCHAR2
    , p3_a51  VARCHAR2
    , p3_a52  VARCHAR2
    , p4_a0 out nocopy  NUMBER
    , p4_a1 out nocopy  NUMBER
    , p4_a2 out nocopy  VARCHAR2
    , p4_a3 out nocopy  VARCHAR2
    , p4_a4 out nocopy  VARCHAR2
    , p4_a5 out nocopy  VARCHAR2
    , p4_a6 out nocopy  VARCHAR2
    , p4_a7 out nocopy  VARCHAR2
    , p4_a8 out nocopy  VARCHAR2
    , p4_a9 out nocopy  VARCHAR2
    , p4_a10 out nocopy  VARCHAR2
    , p4_a11 out nocopy  VARCHAR2
    , p4_a12 out nocopy  VARCHAR2
    , p4_a13 out nocopy  VARCHAR2
    , p4_a14 out nocopy  VARCHAR2
    , p4_a15 out nocopy  VARCHAR2
    , p4_a16 out nocopy  VARCHAR2
    , p4_a17 out nocopy  VARCHAR2
    , p4_a18 out nocopy  VARCHAR2
    , p4_a19 out nocopy  VARCHAR2
    , p4_a20 out nocopy  DATE
    , p4_a21 out nocopy  DATE
    , p4_a22 out nocopy  NUMBER
    , p4_a23 out nocopy  NUMBER
    , p4_a24 out nocopy  NUMBER
    , p4_a25 out nocopy  NUMBER
    , p4_a26 out nocopy  NUMBER
    , p4_a27 out nocopy  VARCHAR2
    , p4_a28 out nocopy  VARCHAR2
    , p4_a29 out nocopy  NUMBER
    , p4_a30 out nocopy  DATE
    , p4_a31 out nocopy  NUMBER
    , p4_a32 out nocopy  NUMBER
    , p4_a33 out nocopy  NUMBER
    , p4_a34 out nocopy  NUMBER
    , p4_a35 out nocopy  NUMBER
    , p4_a36 out nocopy  DATE
    , p4_a37 out nocopy  DATE
    , p4_a38 out nocopy  VARCHAR2
    , p4_a39 out nocopy  VARCHAR2
    , p4_a40 out nocopy  VARCHAR2
    , p4_a41 out nocopy  NUMBER
    , p4_a42 out nocopy  VARCHAR2
    , p4_a43 out nocopy  VARCHAR2
    , p4_a44 out nocopy  VARCHAR2
    , p4_a45 out nocopy  NUMBER
    , p4_a46 out nocopy  NUMBER
    , p4_a47 out nocopy  NUMBER
    , p4_a48 out nocopy  NUMBER
    , p4_a49 out nocopy  VARCHAR2
    , p4_a50 out nocopy  VARCHAR2
    , p4_a51 out nocopy  VARCHAR2
    , p4_a52 out nocopy  VARCHAR2
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
  )

  as
    ddp_lease_opp_rec okl_lease_opportunity_pvt.lease_opp_rec_type;

Line: 445


    okl_lease_opportunity_pvt.update_lease_opp(p_api_version,
      p_init_msg_list,
      p_transaction_control,
      ddp_lease_opp_rec,
      ddx_lease_opp_rec,
      x_return_status,
      x_msg_count,
      x_msg_data);