DBA Data[Home] [Help]

APPS.OKL_LEASE_QUOTE_PVT_W SQL Statements

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

Line: 334

  procedure update_lease_qte(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  VARCHAR2
    , p3_a21  NUMBER
    , p3_a22  DATE
    , p3_a23  DATE
    , p3_a24  VARCHAR2
    , p3_a25  VARCHAR2
    , p3_a26  DATE
    , p3_a27  DATE
    , p3_a28  DATE
    , p3_a29  VARCHAR2
    , p3_a30  NUMBER
    , p3_a31  NUMBER
    , p3_a32  NUMBER
    , p3_a33  VARCHAR2
    , p3_a34  VARCHAR2
    , p3_a35  NUMBER
    , p3_a36  NUMBER
    , p3_a37  NUMBER
    , p3_a38  VARCHAR2
    , p3_a39  NUMBER
    , p3_a40  NUMBER
    , p3_a41  VARCHAR2
    , p3_a42  VARCHAR2
    , p3_a43  NUMBER
    , p3_a44  NUMBER
    , p3_a45  NUMBER
    , p3_a46  NUMBER
    , p3_a47  NUMBER
    , p3_a48  NUMBER
    , p3_a49  NUMBER
    , p3_a50  NUMBER
    , p3_a51  NUMBER
    , p3_a52  VARCHAR2
    , p3_a53  VARCHAR2
    , p3_a54  VARCHAR2
    , p3_a55  NUMBER
    , p3_a56  NUMBER
    , p3_a57  VARCHAR2
    , p3_a58  VARCHAR2
    , p3_a59  VARCHAR2
    , p3_a60  NUMBER
    , p3_a61  VARCHAR2
    , p3_a62  NUMBER
    , p3_a63  VARCHAR2
    , p3_a64  VARCHAR2
    , p3_a65  VARCHAR2
    , p3_a66  VARCHAR2
    , p3_a67  NUMBER
    , p3_a68  VARCHAR2
    , p3_a69  VARCHAR2
    , p3_a70  VARCHAR2
    , p3_a71  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  VARCHAR2
    , p4_a21 out nocopy  NUMBER
    , p4_a22 out nocopy  DATE
    , p4_a23 out nocopy  DATE
    , p4_a24 out nocopy  VARCHAR2
    , p4_a25 out nocopy  VARCHAR2
    , p4_a26 out nocopy  DATE
    , p4_a27 out nocopy  DATE
    , p4_a28 out nocopy  DATE
    , p4_a29 out nocopy  VARCHAR2
    , p4_a30 out nocopy  NUMBER
    , p4_a31 out nocopy  NUMBER
    , p4_a32 out nocopy  NUMBER
    , p4_a33 out nocopy  VARCHAR2
    , p4_a34 out nocopy  VARCHAR2
    , p4_a35 out nocopy  NUMBER
    , p4_a36 out nocopy  NUMBER
    , p4_a37 out nocopy  NUMBER
    , p4_a38 out nocopy  VARCHAR2
    , p4_a39 out nocopy  NUMBER
    , p4_a40 out nocopy  NUMBER
    , p4_a41 out nocopy  VARCHAR2
    , p4_a42 out nocopy  VARCHAR2
    , p4_a43 out nocopy  NUMBER
    , p4_a44 out nocopy  NUMBER
    , p4_a45 out nocopy  NUMBER
    , p4_a46 out nocopy  NUMBER
    , p4_a47 out nocopy  NUMBER
    , p4_a48 out nocopy  NUMBER
    , p4_a49 out nocopy  NUMBER
    , p4_a50 out nocopy  NUMBER
    , p4_a51 out nocopy  NUMBER
    , p4_a52 out nocopy  VARCHAR2
    , p4_a53 out nocopy  VARCHAR2
    , p4_a54 out nocopy  VARCHAR2
    , p4_a55 out nocopy  NUMBER
    , p4_a56 out nocopy  NUMBER
    , p4_a57 out nocopy  VARCHAR2
    , p4_a58 out nocopy  VARCHAR2
    , p4_a59 out nocopy  VARCHAR2
    , p4_a60 out nocopy  NUMBER
    , p4_a61 out nocopy  VARCHAR2
    , p4_a62 out nocopy  NUMBER
    , p4_a63 out nocopy  VARCHAR2
    , p4_a64 out nocopy  VARCHAR2
    , p4_a65 out nocopy  VARCHAR2
    , p4_a66 out nocopy  VARCHAR2
    , p4_a67 out nocopy  NUMBER
    , p4_a68 out nocopy  VARCHAR2
    , p4_a69 out nocopy  VARCHAR2
    , p4_a70 out nocopy  VARCHAR2
    , p4_a71 out nocopy  VARCHAR2
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
  )

  as
    ddp_lease_qte_rec okl_lease_quote_pvt.lease_qte_rec_type;
Line: 574

    okl_lease_quote_pvt.update_lease_qte(p_api_version,
      p_init_msg_list,
      p_transaction_control,
      ddp_lease_qte_rec,
      ddx_lease_qte_rec,
      x_return_status,
      x_msg_count,
      x_msg_data);