DBA Data[Home] [Help]

APPS.LNS_LOAN_HEADER_PUB_W SQL Statements

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

Line: 242

  procedure update_loan(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  DATE
    , p1_a8  NUMBER
    , p1_a9  NUMBER
    , p1_a10  VARCHAR2
    , p1_a11  NUMBER
    , p1_a12  VARCHAR2
    , p1_a13  VARCHAR2
    , p1_a14  NUMBER
    , p1_a15  VARCHAR2
    , p1_a16  VARCHAR2
    , p1_a17  VARCHAR2
    , p1_a18  VARCHAR2
    , p1_a19  VARCHAR2
    , p1_a20  NUMBER
    , p1_a21  NUMBER
    , p1_a22  DATE
    , p1_a23  DATE
    , p1_a24  DATE
    , p1_a25  NUMBER
    , p1_a26  VARCHAR2
    , p1_a27  VARCHAR2
    , p1_a28  NUMBER
    , p1_a29  VARCHAR2
    , p1_a30  NUMBER
    , p1_a31  NUMBER
    , p1_a32  NUMBER
    , p1_a33  NUMBER
    , p1_a34  DATE
    , p1_a35  NUMBER
    , p1_a36  VARCHAR2
    , p1_a37  VARCHAR2
    , p1_a38  VARCHAR2
    , p1_a39  VARCHAR2
    , p1_a40  VARCHAR2
    , p1_a41  VARCHAR2
    , p1_a42  VARCHAR2
    , p1_a43  VARCHAR2
    , p1_a44  VARCHAR2
    , p1_a45  VARCHAR2
    , p1_a46  VARCHAR2
    , p1_a47  VARCHAR2
    , p1_a48  VARCHAR2
    , p1_a49  VARCHAR2
    , p1_a50  VARCHAR2
    , p1_a51  VARCHAR2
    , p1_a52  VARCHAR2
    , p1_a53  VARCHAR2
    , p1_a54  VARCHAR2
    , p1_a55  VARCHAR2
    , p1_a56  VARCHAR2
    , p1_a57  DATE
    , p1_a58  VARCHAR2
    , p1_a59  VARCHAR2
    , p1_a60  VARCHAR2
    , p1_a61  VARCHAR2
    , p1_a62  NUMBER
    , p1_a63  VARCHAR2
    , p1_a64  DATE
    , p1_a65  VARCHAR2
    , p1_a66  NUMBER
    , p1_a67  NUMBER
    , p1_a68  VARCHAR2
    , p1_a69  VARCHAR2
    , p1_a70  DATE
    , p1_a71  NUMBER
    , p1_a72  NUMBER
    , p1_a73  NUMBER
    , p1_a74  NUMBER
    , p1_a75  NUMBER
    , p1_a76  VARCHAR2
    , p1_a77  VARCHAR2
    , p1_a78  NUMBER
    , p1_a79  VARCHAR2
    , p1_a80  VARCHAR2
    , p1_a81  VARCHAR2
    , p1_a82  NUMBER
    , p1_a83  VARCHAR2
    , p1_a84  DATE
    , p1_a85  NUMBER
    , p1_a86  VARCHAR2
    , p1_a87  DATE
    , p1_a88  VARCHAR2
    , p1_a89  DATE
    , p1_a90  NUMBER
    , p1_a91  NUMBER
    , p1_a92  VARCHAR2
    , p1_a93  VARCHAR2
    , p1_a94  VARCHAR2
    , p1_a95  NUMBER
    , p1_a96  VARCHAR2
    , p1_a97  NUMBER
    , p1_a98  VARCHAR2
    , p1_a99  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_header_rec lns_loan_header_pub.loan_header_rec_type;
Line: 462

    lns_loan_header_pub.update_loan(p_init_msg_list,
      ddp_loan_header_rec,
      p_object_version_number,
      x_return_status,
      x_msg_count,
      x_msg_data);