APPS.LNS_CUSTOM_PUB_W SQL Statements

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

Line: 504

    , p_update_header  number
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
  )

  as
    ddp_update_header boolean;

Line: 519

    if p_update_header is null
      then ddp_update_header := null;

Line: 521

    elsif p_update_header = 0
      then ddp_update_header := false;

Line: 523

    else ddp_update_header := true;

Line: 533

      ddp_update_header,
      x_return_status,
      x_msg_count,
      x_msg_data);

Line: 723

  procedure updatecustomschedule(p0_a0 JTF_NUMBER_TABLE
    , p0_a1 JTF_NUMBER_TABLE
    , p0_a2 JTF_NUMBER_TABLE
    , p0_a3 JTF_DATE_TABLE
    , p0_a4 JTF_DATE_TABLE
    , p0_a5 JTF_DATE_TABLE
    , p0_a6 JTF_NUMBER_TABLE
    , p0_a7 JTF_NUMBER_TABLE
    , p0_a8 JTF_NUMBER_TABLE
    , p0_a9 JTF_NUMBER_TABLE
    , p0_a10 JTF_NUMBER_TABLE
    , p0_a11 JTF_NUMBER_TABLE
    , p0_a12 JTF_NUMBER_TABLE
    , p0_a13 JTF_NUMBER_TABLE
    , p0_a14 JTF_NUMBER_TABLE
    , p0_a15 JTF_NUMBER_TABLE
    , p0_a16 JTF_VARCHAR2_TABLE_100
    , p0_a17 JTF_VARCHAR2_TABLE_200
    , p0_a18 JTF_VARCHAR2_TABLE_200
    , p0_a19 JTF_VARCHAR2_TABLE_200
    , p0_a20 JTF_VARCHAR2_TABLE_200
    , p0_a21 JTF_VARCHAR2_TABLE_200
    , p0_a22 JTF_VARCHAR2_TABLE_200
    , p0_a23 JTF_VARCHAR2_TABLE_200
    , p0_a24 JTF_VARCHAR2_TABLE_200
    , p0_a25 JTF_VARCHAR2_TABLE_200
    , p0_a26 JTF_VARCHAR2_TABLE_200
    , p0_a27 JTF_VARCHAR2_TABLE_200
    , p0_a28 JTF_VARCHAR2_TABLE_200
    , p0_a29 JTF_VARCHAR2_TABLE_200
    , p0_a30 JTF_VARCHAR2_TABLE_200
    , p0_a31 JTF_VARCHAR2_TABLE_200
    , p0_a32 JTF_VARCHAR2_TABLE_200
    , p0_a33 JTF_VARCHAR2_TABLE_200
    , p0_a34 JTF_VARCHAR2_TABLE_200
    , p0_a35 JTF_VARCHAR2_TABLE_200
    , p0_a36 JTF_VARCHAR2_TABLE_200
    , p0_a37 JTF_NUMBER_TABLE
    , p0_a38 JTF_NUMBER_TABLE
    , p0_a39 JTF_NUMBER_TABLE
    , p0_a40 JTF_NUMBER_TABLE
    , p0_a41 JTF_NUMBER_TABLE
    , p0_a42 JTF_NUMBER_TABLE
    , p0_a43 JTF_NUMBER_TABLE
    , p0_a44 JTF_NUMBER_TABLE
    , p0_a45 JTF_VARCHAR2_TABLE_100
    , p0_a46 JTF_VARCHAR2_TABLE_100
    , p0_a47 JTF_VARCHAR2_TABLE_100
    , p0_a48 JTF_NUMBER_TABLE
    , p0_a49 JTF_VARCHAR2_TABLE_2000
    , p0_a50 JTF_VARCHAR2_TABLE_2000
    , p0_a51 JTF_VARCHAR2_TABLE_2000
    , p0_a52 JTF_VARCHAR2_TABLE_2000
    , p0_a53 JTF_NUMBER_TABLE
    , p0_a54 JTF_VARCHAR2_TABLE_200
    , p0_a55 JTF_NUMBER_TABLE
    , p0_a56 JTF_VARCHAR2_TABLE_300
    , p0_a57 JTF_NUMBER_TABLE
    , p0_a58 JTF_NUMBER_TABLE
    , p0_a59 JTF_VARCHAR2_TABLE_2000
    , p0_a60 JTF_NUMBER_TABLE
    , p0_a61 JTF_NUMBER_TABLE
    , p0_a62 JTF_NUMBER_TABLE
    , p0_a63 JTF_VARCHAR2_TABLE_2000
    , p0_a64 JTF_NUMBER_TABLE
    , p0_a65 JTF_VARCHAR2_TABLE_2000
    , p_loan_id  NUMBER
    , p_init_msg_list  VARCHAR2
    , p_commit  VARCHAR2
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
    , x_invalid_installment_num out nocopy  NUMBER
  )

  as
    ddp_custom_tbl lns_custom_pub.custom_tbl;

Line: 880

    lns_custom_pub.updatecustomschedule(ddp_custom_tbl,
      p_loan_id,
      p_init_msg_list,
      p_commit,
      x_return_status,
      x_msg_count,
      x_msg_data,
      x_invalid_installment_num);

Line: 1062

  procedure updatecustomsched(p0_a0  NUMBER
    , p0_a1  NUMBER
    , p0_a2  NUMBER
    , p0_a3  DATE
    , p0_a4  DATE
    , p0_a5  DATE
    , p0_a6  NUMBER
    , p0_a7  NUMBER
    , p0_a8  NUMBER
    , p0_a9  NUMBER
    , p0_a10  NUMBER
    , p0_a11  NUMBER
    , p0_a12  NUMBER
    , p0_a13  NUMBER
    , p0_a14  NUMBER
    , p0_a15  NUMBER
    , p0_a16  VARCHAR2
    , p0_a17  VARCHAR2
    , p0_a18  VARCHAR2
    , p0_a19  VARCHAR2
    , p0_a20  VARCHAR2
    , p0_a21  VARCHAR2
    , p0_a22  VARCHAR2
    , p0_a23  VARCHAR2
    , p0_a24  VARCHAR2
    , p0_a25  VARCHAR2
    , p0_a26  VARCHAR2
    , p0_a27  VARCHAR2
    , p0_a28  VARCHAR2
    , p0_a29  VARCHAR2
    , p0_a30  VARCHAR2
    , p0_a31  VARCHAR2
    , p0_a32  VARCHAR2
    , p0_a33  VARCHAR2
    , p0_a34  VARCHAR2
    , p0_a35  VARCHAR2
    , p0_a36  VARCHAR2
    , p0_a37  NUMBER
    , p0_a38  NUMBER
    , p0_a39  NUMBER
    , p0_a40  NUMBER
    , p0_a41  NUMBER
    , p0_a42  NUMBER
    , p0_a43  NUMBER
    , p0_a44  NUMBER
    , p0_a45  VARCHAR2
    , p0_a46  VARCHAR2
    , p0_a47  VARCHAR2
    , p0_a48  NUMBER
    , p0_a49  VARCHAR2
    , p0_a50  VARCHAR2
    , p0_a51  VARCHAR2
    , p0_a52  VARCHAR2
    , p0_a53  NUMBER
    , p0_a54  VARCHAR2
    , p0_a55  NUMBER
    , p0_a56  VARCHAR2
    , p0_a57  NUMBER
    , p0_a58  NUMBER
    , p0_a59  VARCHAR2
    , p0_a60  NUMBER
    , p0_a61  NUMBER
    , p0_a62  NUMBER
    , p0_a63  VARCHAR2
    , p0_a64  NUMBER
    , p0_a65  VARCHAR2
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
  )

  as
    ddp_custom_rec lns_custom_pub.custom_sched_type;

Line: 1210

    lns_custom_pub.updatecustomsched(ddp_custom_rec,
      x_return_status,
      x_msg_count,
      x_msg_data);