DBA Data[Home] [Help]

APPS.LNS_TERMS_PUB_W SQL Statements

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

Line: 168

  procedure update_term(p_init_msg_list  VARCHAR2
    , p1_a0  NUMBER
    , p1_a1  NUMBER
    , p1_a2  VARCHAR2
    , p1_a3  VARCHAR2
    , p1_a4  DATE
    , p1_a5  DATE
    , p1_a6  NUMBER
    , p1_a7  VARCHAR2
    , p1_a8  VARCHAR2
    , p1_a9  VARCHAR2
    , p1_a10  DATE
    , p1_a11  NUMBER
    , p1_a12  NUMBER
    , p1_a13  NUMBER
    , p1_a14  NUMBER
    , p1_a15  VARCHAR2
    , p1_a16  VARCHAR2
    , p1_a17  VARCHAR2
    , p1_a18  VARCHAR2
    , p1_a19  VARCHAR2
    , p1_a20  VARCHAR2
    , p1_a21  VARCHAR2
    , p1_a22  NUMBER
    , p1_a23  VARCHAR2
    , p1_a24  VARCHAR2
    , p1_a25  NUMBER
    , p1_a26  VARCHAR2
    , p1_a27  NUMBER
    , p1_a28  VARCHAR2
    , p1_a29  DATE
    , p1_a30  DATE
    , p1_a31  DATE
    , p1_a32  VARCHAR2
    , p1_a33  DATE
    , p1_a34  DATE
    , p1_a35  DATE
    , p1_a36  VARCHAR2
    , p1_a37  NUMBER
    , p1_a38  NUMBER
    , p1_a39  NUMBER
    , p1_a40  NUMBER
    , p1_a41  NUMBER
    , p1_a42  NUMBER
    , p1_a43  VARCHAR2
    , p1_a44  NUMBER
    , p1_a45  NUMBER
    , p1_a46  DATE
    , p1_a47  DATE
    , p1_a48  NUMBER
    , p1_a49  NUMBER
    , p1_a50  VARCHAR2
    , p1_a51  VARCHAR2
    , p1_a52  VARCHAR2
    , p1_a53  DATE
    , p1_a54  VARCHAR2
    , p1_a55  NUMBER
    , p1_a56  NUMBER
    , p1_a57  VARCHAR2
    , p1_a58  VARCHAR2
    , p1_a59  VARCHAR2
    , p1_a60  NUMBER
    , p1_a61  VARCHAR2
    , p1_a62  VARCHAR2
    , p1_a63  VARCHAR2
    , p1_a64  VARCHAR2
    , p_object_version_number in out nocopy  NUMBER
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
  )

  as
    ddp_loan_term_rec lns_terms_pub.loan_term_rec_type;
Line: 318

    lns_terms_pub.update_term(p_init_msg_list,
      ddp_loan_term_rec,
      p_object_version_number,
      x_return_status,
      x_msg_count,
      x_msg_data);