DBA Data[Home] [Help]

APPS.OKL_LEASE_RATE_SETS_PVT_W SQL Statements

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

Line: 233

    ddp_lrtv_rec.last_updated_by := p5_a14;
Line: 234

    ddp_lrtv_rec.last_update_date := p5_a15;
Line: 235

    ddp_lrtv_rec.last_update_login := p5_a16;
Line: 278

    ddp_lrvv_rec.last_updated_by := p7_a18;
Line: 279

    ddp_lrvv_rec.last_update_date := p7_a19;
Line: 280

    ddp_lrvv_rec.last_update_login := p7_a20;
Line: 332

    p6_a14 := ddx_lrtv_rec.last_updated_by;
Line: 333

    p6_a15 := ddx_lrtv_rec.last_update_date;
Line: 334

    p6_a16 := ddx_lrtv_rec.last_update_login;
Line: 377

    p8_a18 := ddx_lrvv_rec.last_updated_by;
Line: 378

    p8_a19 := ddx_lrvv_rec.last_update_date;
Line: 379

    p8_a20 := ddx_lrvv_rec.last_update_login;
Line: 399

  procedure update_lease_rate_set(p_api_version  NUMBER
    , p_init_msg_list  VARCHAR2
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
    , p5_a0  NUMBER
    , p5_a1  NUMBER
    , p5_a2  VARCHAR2
    , p5_a3  NUMBER
    , p5_a4  NUMBER
    , p5_a5  NUMBER
    , p5_a6  VARCHAR2
    , p5_a7  VARCHAR2
    , p5_a8  DATE
    , p5_a9  DATE
    , p5_a10  VARCHAR2
    , p5_a11  VARCHAR2
    , p5_a12  NUMBER
    , p5_a13  DATE
    , p5_a14  NUMBER
    , p5_a15  DATE
    , p5_a16  NUMBER
    , p5_a17  VARCHAR2
    , p5_a18  VARCHAR2
    , p5_a19  VARCHAR2
    , p5_a20  VARCHAR2
    , p5_a21  VARCHAR2
    , p5_a22  VARCHAR2
    , p5_a23  VARCHAR2
    , p5_a24  VARCHAR2
    , p5_a25  VARCHAR2
    , p5_a26  VARCHAR2
    , p5_a27  VARCHAR2
    , p5_a28  VARCHAR2
    , p5_a29  VARCHAR2
    , p5_a30  VARCHAR2
    , p5_a31  VARCHAR2
    , p5_a32  VARCHAR2
    , p5_a33  VARCHAR2
    , p5_a34  NUMBER
    , p5_a35  VARCHAR2
    , p5_a36  VARCHAR2
    , p5_a37  NUMBER
    , p5_a38  NUMBER
    , p6_a0 out nocopy  NUMBER
    , p6_a1 out nocopy  NUMBER
    , p6_a2 out nocopy  VARCHAR2
    , p6_a3 out nocopy  NUMBER
    , p6_a4 out nocopy  NUMBER
    , p6_a5 out nocopy  NUMBER
    , p6_a6 out nocopy  VARCHAR2
    , p6_a7 out nocopy  VARCHAR2
    , p6_a8 out nocopy  DATE
    , p6_a9 out nocopy  DATE
    , p6_a10 out nocopy  VARCHAR2
    , p6_a11 out nocopy  VARCHAR2
    , p6_a12 out nocopy  NUMBER
    , p6_a13 out nocopy  DATE
    , p6_a14 out nocopy  NUMBER
    , p6_a15 out nocopy  DATE
    , p6_a16 out nocopy  NUMBER
    , p6_a17 out nocopy  VARCHAR2
    , p6_a18 out nocopy  VARCHAR2
    , p6_a19 out nocopy  VARCHAR2
    , p6_a20 out nocopy  VARCHAR2
    , p6_a21 out nocopy  VARCHAR2
    , p6_a22 out nocopy  VARCHAR2
    , p6_a23 out nocopy  VARCHAR2
    , p6_a24 out nocopy  VARCHAR2
    , p6_a25 out nocopy  VARCHAR2
    , p6_a26 out nocopy  VARCHAR2
    , p6_a27 out nocopy  VARCHAR2
    , p6_a28 out nocopy  VARCHAR2
    , p6_a29 out nocopy  VARCHAR2
    , p6_a30 out nocopy  VARCHAR2
    , p6_a31 out nocopy  VARCHAR2
    , p6_a32 out nocopy  VARCHAR2
    , p6_a33 out nocopy  VARCHAR2
    , p6_a34 out nocopy  NUMBER
    , p6_a35 out nocopy  VARCHAR2
    , p6_a36 out nocopy  VARCHAR2
    , p6_a37 out nocopy  NUMBER
    , p6_a38 out nocopy  NUMBER
    , p7_a0  NUMBER
    , p7_a1  NUMBER
    , p7_a2  VARCHAR2
    , p7_a3  DATE
    , p7_a4  DATE
    , p7_a5  NUMBER
    , p7_a6  NUMBER
    , p7_a7  NUMBER
    , p7_a8  NUMBER
    , p7_a9  VARCHAR2
    , p7_a10  NUMBER
    , p7_a11  NUMBER
    , p7_a12  NUMBER
    , p7_a13  NUMBER
    , p7_a14  NUMBER
    , p7_a15  VARCHAR2
    , p7_a16  NUMBER
    , p7_a17  DATE
    , p7_a18  NUMBER
    , p7_a19  DATE
    , p7_a20  NUMBER
    , p7_a21  VARCHAR2
    , p7_a22  VARCHAR2
    , p7_a23  VARCHAR2
    , p7_a24  VARCHAR2
    , p7_a25  VARCHAR2
    , p7_a26  VARCHAR2
    , p7_a27  VARCHAR2
    , p7_a28  VARCHAR2
    , p7_a29  VARCHAR2
    , p7_a30  VARCHAR2
    , p7_a31  VARCHAR2
    , p7_a32  VARCHAR2
    , p7_a33  VARCHAR2
    , p7_a34  VARCHAR2
    , p7_a35  VARCHAR2
    , p7_a36  VARCHAR2
    , p7_a37  NUMBER
    , p8_a0 out nocopy  NUMBER
    , p8_a1 out nocopy  NUMBER
    , p8_a2 out nocopy  VARCHAR2
    , p8_a3 out nocopy  DATE
    , p8_a4 out nocopy  DATE
    , p8_a5 out nocopy  NUMBER
    , p8_a6 out nocopy  NUMBER
    , p8_a7 out nocopy  NUMBER
    , p8_a8 out nocopy  NUMBER
    , p8_a9 out nocopy  VARCHAR2
    , p8_a10 out nocopy  NUMBER
    , p8_a11 out nocopy  NUMBER
    , p8_a12 out nocopy  NUMBER
    , p8_a13 out nocopy  NUMBER
    , p8_a14 out nocopy  NUMBER
    , p8_a15 out nocopy  VARCHAR2
    , p8_a16 out nocopy  NUMBER
    , p8_a17 out nocopy  DATE
    , p8_a18 out nocopy  NUMBER
    , p8_a19 out nocopy  DATE
    , p8_a20 out nocopy  NUMBER
    , p8_a21 out nocopy  VARCHAR2
    , p8_a22 out nocopy  VARCHAR2
    , p8_a23 out nocopy  VARCHAR2
    , p8_a24 out nocopy  VARCHAR2
    , p8_a25 out nocopy  VARCHAR2
    , p8_a26 out nocopy  VARCHAR2
    , p8_a27 out nocopy  VARCHAR2
    , p8_a28 out nocopy  VARCHAR2
    , p8_a29 out nocopy  VARCHAR2
    , p8_a30 out nocopy  VARCHAR2
    , p8_a31 out nocopy  VARCHAR2
    , p8_a32 out nocopy  VARCHAR2
    , p8_a33 out nocopy  VARCHAR2
    , p8_a34 out nocopy  VARCHAR2
    , p8_a35 out nocopy  VARCHAR2
    , p8_a36 out nocopy  VARCHAR2
    , p8_a37 out nocopy  NUMBER
  )

  as
    ddp_lrtv_rec okl_lease_rate_sets_pvt.lrtv_rec_type;
Line: 588

    ddp_lrtv_rec.last_updated_by := p5_a14;
Line: 589

    ddp_lrtv_rec.last_update_date := p5_a15;
Line: 590

    ddp_lrtv_rec.last_update_login := p5_a16;
Line: 633

    ddp_lrvv_rec.last_updated_by := p7_a18;
Line: 634

    ddp_lrvv_rec.last_update_date := p7_a19;
Line: 635

    ddp_lrvv_rec.last_update_login := p7_a20;
Line: 656

    okl_lease_rate_sets_pvt.update_lease_rate_set(p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      ddp_lrtv_rec,
      ddx_lrtv_rec,
      ddp_lrvv_rec,
      ddx_lrvv_rec);
Line: 687

    p6_a14 := ddx_lrtv_rec.last_updated_by;
Line: 688

    p6_a15 := ddx_lrtv_rec.last_update_date;
Line: 689

    p6_a16 := ddx_lrtv_rec.last_update_login;
Line: 732

    p8_a18 := ddx_lrvv_rec.last_updated_by;
Line: 733

    p8_a19 := ddx_lrvv_rec.last_update_date;
Line: 734

    p8_a20 := ddx_lrvv_rec.last_update_login;
Line: 943

    ddp_lrtv_rec.last_updated_by := p5_a14;
Line: 944

    ddp_lrtv_rec.last_update_date := p5_a15;
Line: 945

    ddp_lrtv_rec.last_update_login := p5_a16;
Line: 988

    ddp_lrvv_rec.last_updated_by := p7_a18;
Line: 989

    ddp_lrvv_rec.last_update_date := p7_a19;
Line: 990

    ddp_lrvv_rec.last_update_login := p7_a20;
Line: 1042

    p6_a14 := ddx_lrtv_rec.last_updated_by;
Line: 1043

    p6_a15 := ddx_lrtv_rec.last_update_date;
Line: 1044

    p6_a16 := ddx_lrtv_rec.last_update_login;
Line: 1087

    p8_a18 := ddx_lrvv_rec.last_updated_by;
Line: 1088

    p8_a19 := ddx_lrvv_rec.last_update_date;
Line: 1089

    p8_a20 := ddx_lrvv_rec.last_update_login;
Line: 1298

    ddp_lrtv_rec.last_updated_by := p5_a14;
Line: 1299

    ddp_lrtv_rec.last_update_date := p5_a15;
Line: 1300

    ddp_lrtv_rec.last_update_login := p5_a16;
Line: 1343

    ddp_lrvv_rec.last_updated_by := p7_a18;
Line: 1344

    ddp_lrvv_rec.last_update_date := p7_a19;
Line: 1345

    ddp_lrvv_rec.last_update_login := p7_a20;
Line: 1397

    p6_a14 := ddx_lrtv_rec.last_updated_by;
Line: 1398

    p6_a15 := ddx_lrtv_rec.last_update_date;
Line: 1399

    p6_a16 := ddx_lrtv_rec.last_update_login;
Line: 1442

    p8_a18 := ddx_lrvv_rec.last_updated_by;
Line: 1443

    p8_a19 := ddx_lrvv_rec.last_update_date;
Line: 1444

    p8_a20 := ddx_lrvv_rec.last_update_login;
Line: 1464

  procedure update_lrs_gen_lrf(p_api_version  NUMBER
    , p_init_msg_list  VARCHAR2
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
    , p5_a0  NUMBER
    , p5_a1  NUMBER
    , p5_a2  VARCHAR2
    , p5_a3  NUMBER
    , p5_a4  NUMBER
    , p5_a5  NUMBER
    , p5_a6  VARCHAR2
    , p5_a7  VARCHAR2
    , p5_a8  DATE
    , p5_a9  DATE
    , p5_a10  VARCHAR2
    , p5_a11  VARCHAR2
    , p5_a12  NUMBER
    , p5_a13  DATE
    , p5_a14  NUMBER
    , p5_a15  DATE
    , p5_a16  NUMBER
    , p5_a17  VARCHAR2
    , p5_a18  VARCHAR2
    , p5_a19  VARCHAR2
    , p5_a20  VARCHAR2
    , p5_a21  VARCHAR2
    , p5_a22  VARCHAR2
    , p5_a23  VARCHAR2
    , p5_a24  VARCHAR2
    , p5_a25  VARCHAR2
    , p5_a26  VARCHAR2
    , p5_a27  VARCHAR2
    , p5_a28  VARCHAR2
    , p5_a29  VARCHAR2
    , p5_a30  VARCHAR2
    , p5_a31  VARCHAR2
    , p5_a32  VARCHAR2
    , p5_a33  VARCHAR2
    , p5_a34  NUMBER
    , p5_a35  VARCHAR2
    , p5_a36  VARCHAR2
    , p5_a37  NUMBER
    , p5_a38  NUMBER
    , p6_a0 out nocopy  NUMBER
    , p6_a1 out nocopy  NUMBER
    , p6_a2 out nocopy  VARCHAR2
    , p6_a3 out nocopy  NUMBER
    , p6_a4 out nocopy  NUMBER
    , p6_a5 out nocopy  NUMBER
    , p6_a6 out nocopy  VARCHAR2
    , p6_a7 out nocopy  VARCHAR2
    , p6_a8 out nocopy  DATE
    , p6_a9 out nocopy  DATE
    , p6_a10 out nocopy  VARCHAR2
    , p6_a11 out nocopy  VARCHAR2
    , p6_a12 out nocopy  NUMBER
    , p6_a13 out nocopy  DATE
    , p6_a14 out nocopy  NUMBER
    , p6_a15 out nocopy  DATE
    , p6_a16 out nocopy  NUMBER
    , p6_a17 out nocopy  VARCHAR2
    , p6_a18 out nocopy  VARCHAR2
    , p6_a19 out nocopy  VARCHAR2
    , p6_a20 out nocopy  VARCHAR2
    , p6_a21 out nocopy  VARCHAR2
    , p6_a22 out nocopy  VARCHAR2
    , p6_a23 out nocopy  VARCHAR2
    , p6_a24 out nocopy  VARCHAR2
    , p6_a25 out nocopy  VARCHAR2
    , p6_a26 out nocopy  VARCHAR2
    , p6_a27 out nocopy  VARCHAR2
    , p6_a28 out nocopy  VARCHAR2
    , p6_a29 out nocopy  VARCHAR2
    , p6_a30 out nocopy  VARCHAR2
    , p6_a31 out nocopy  VARCHAR2
    , p6_a32 out nocopy  VARCHAR2
    , p6_a33 out nocopy  VARCHAR2
    , p6_a34 out nocopy  NUMBER
    , p6_a35 out nocopy  VARCHAR2
    , p6_a36 out nocopy  VARCHAR2
    , p6_a37 out nocopy  NUMBER
    , p6_a38 out nocopy  NUMBER
    , p7_a0  NUMBER
    , p7_a1  NUMBER
    , p7_a2  VARCHAR2
    , p7_a3  DATE
    , p7_a4  DATE
    , p7_a5  NUMBER
    , p7_a6  NUMBER
    , p7_a7  NUMBER
    , p7_a8  NUMBER
    , p7_a9  VARCHAR2
    , p7_a10  NUMBER
    , p7_a11  NUMBER
    , p7_a12  NUMBER
    , p7_a13  NUMBER
    , p7_a14  NUMBER
    , p7_a15  VARCHAR2
    , p7_a16  NUMBER
    , p7_a17  DATE
    , p7_a18  NUMBER
    , p7_a19  DATE
    , p7_a20  NUMBER
    , p7_a21  VARCHAR2
    , p7_a22  VARCHAR2
    , p7_a23  VARCHAR2
    , p7_a24  VARCHAR2
    , p7_a25  VARCHAR2
    , p7_a26  VARCHAR2
    , p7_a27  VARCHAR2
    , p7_a28  VARCHAR2
    , p7_a29  VARCHAR2
    , p7_a30  VARCHAR2
    , p7_a31  VARCHAR2
    , p7_a32  VARCHAR2
    , p7_a33  VARCHAR2
    , p7_a34  VARCHAR2
    , p7_a35  VARCHAR2
    , p7_a36  VARCHAR2
    , p7_a37  NUMBER
    , p8_a0 out nocopy  NUMBER
    , p8_a1 out nocopy  NUMBER
    , p8_a2 out nocopy  VARCHAR2
    , p8_a3 out nocopy  DATE
    , p8_a4 out nocopy  DATE
    , p8_a5 out nocopy  NUMBER
    , p8_a6 out nocopy  NUMBER
    , p8_a7 out nocopy  NUMBER
    , p8_a8 out nocopy  NUMBER
    , p8_a9 out nocopy  VARCHAR2
    , p8_a10 out nocopy  NUMBER
    , p8_a11 out nocopy  NUMBER
    , p8_a12 out nocopy  NUMBER
    , p8_a13 out nocopy  NUMBER
    , p8_a14 out nocopy  NUMBER
    , p8_a15 out nocopy  VARCHAR2
    , p8_a16 out nocopy  NUMBER
    , p8_a17 out nocopy  DATE
    , p8_a18 out nocopy  NUMBER
    , p8_a19 out nocopy  DATE
    , p8_a20 out nocopy  NUMBER
    , p8_a21 out nocopy  VARCHAR2
    , p8_a22 out nocopy  VARCHAR2
    , p8_a23 out nocopy  VARCHAR2
    , p8_a24 out nocopy  VARCHAR2
    , p8_a25 out nocopy  VARCHAR2
    , p8_a26 out nocopy  VARCHAR2
    , p8_a27 out nocopy  VARCHAR2
    , p8_a28 out nocopy  VARCHAR2
    , p8_a29 out nocopy  VARCHAR2
    , p8_a30 out nocopy  VARCHAR2
    , p8_a31 out nocopy  VARCHAR2
    , p8_a32 out nocopy  VARCHAR2
    , p8_a33 out nocopy  VARCHAR2
    , p8_a34 out nocopy  VARCHAR2
    , p8_a35 out nocopy  VARCHAR2
    , p8_a36 out nocopy  VARCHAR2
    , p8_a37 out nocopy  NUMBER
  )

  as
    ddp_lrtv_rec okl_lease_rate_sets_pvt.lrtv_rec_type;
Line: 1653

    ddp_lrtv_rec.last_updated_by := p5_a14;
Line: 1654

    ddp_lrtv_rec.last_update_date := p5_a15;
Line: 1655

    ddp_lrtv_rec.last_update_login := p5_a16;
Line: 1698

    ddp_lrvv_rec.last_updated_by := p7_a18;
Line: 1699

    ddp_lrvv_rec.last_update_date := p7_a19;
Line: 1700

    ddp_lrvv_rec.last_update_login := p7_a20;
Line: 1721

    okl_lease_rate_sets_pvt.update_lrs_gen_lrf(p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      ddp_lrtv_rec,
      ddx_lrtv_rec,
      ddp_lrvv_rec,
      ddx_lrvv_rec);
Line: 1752

    p6_a14 := ddx_lrtv_rec.last_updated_by;
Line: 1753

    p6_a15 := ddx_lrtv_rec.last_update_date;
Line: 1754

    p6_a16 := ddx_lrtv_rec.last_update_login;
Line: 1797

    p8_a18 := ddx_lrvv_rec.last_updated_by;
Line: 1798

    p8_a19 := ddx_lrvv_rec.last_update_date;
Line: 1799

    p8_a20 := ddx_lrvv_rec.last_update_login;
Line: 2008

    ddp_lrtv_rec.last_updated_by := p5_a14;
Line: 2009

    ddp_lrtv_rec.last_update_date := p5_a15;
Line: 2010

    ddp_lrtv_rec.last_update_login := p5_a16;
Line: 2053

    ddp_lrvv_rec.last_updated_by := p7_a18;
Line: 2054

    ddp_lrvv_rec.last_update_date := p7_a19;
Line: 2055

    ddp_lrvv_rec.last_update_login := p7_a20;
Line: 2107

    p6_a14 := ddx_lrtv_rec.last_updated_by;
Line: 2108

    p6_a15 := ddx_lrtv_rec.last_update_date;
Line: 2109

    p6_a16 := ddx_lrtv_rec.last_update_login;
Line: 2152

    p8_a18 := ddx_lrvv_rec.last_updated_by;
Line: 2153

    p8_a19 := ddx_lrvv_rec.last_update_date;
Line: 2154

    p8_a20 := ddx_lrvv_rec.last_update_login;
Line: 2363

    ddp_lrtv_rec.last_updated_by := p5_a14;
Line: 2364

    ddp_lrtv_rec.last_update_date := p5_a15;
Line: 2365

    ddp_lrtv_rec.last_update_login := p5_a16;
Line: 2408

    ddp_lrvv_rec.last_updated_by := p7_a18;
Line: 2409

    ddp_lrvv_rec.last_update_date := p7_a19;
Line: 2410

    ddp_lrvv_rec.last_update_login := p7_a20;
Line: 2462

    p6_a14 := ddx_lrtv_rec.last_updated_by;
Line: 2463

    p6_a15 := ddx_lrtv_rec.last_update_date;
Line: 2464

    p6_a16 := ddx_lrtv_rec.last_update_login;
Line: 2507

    p8_a18 := ddx_lrvv_rec.last_updated_by;
Line: 2508

    p8_a19 := ddx_lrvv_rec.last_update_date;
Line: 2509

    p8_a20 := ddx_lrvv_rec.last_update_login;
Line: 2529

  procedure update_lrs_gen_lrf_submit(p_api_version  NUMBER
    , p_init_msg_list  VARCHAR2
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
    , p5_a0  NUMBER
    , p5_a1  NUMBER
    , p5_a2  VARCHAR2
    , p5_a3  NUMBER
    , p5_a4  NUMBER
    , p5_a5  NUMBER
    , p5_a6  VARCHAR2
    , p5_a7  VARCHAR2
    , p5_a8  DATE
    , p5_a9  DATE
    , p5_a10  VARCHAR2
    , p5_a11  VARCHAR2
    , p5_a12  NUMBER
    , p5_a13  DATE
    , p5_a14  NUMBER
    , p5_a15  DATE
    , p5_a16  NUMBER
    , p5_a17  VARCHAR2
    , p5_a18  VARCHAR2
    , p5_a19  VARCHAR2
    , p5_a20  VARCHAR2
    , p5_a21  VARCHAR2
    , p5_a22  VARCHAR2
    , p5_a23  VARCHAR2
    , p5_a24  VARCHAR2
    , p5_a25  VARCHAR2
    , p5_a26  VARCHAR2
    , p5_a27  VARCHAR2
    , p5_a28  VARCHAR2
    , p5_a29  VARCHAR2
    , p5_a30  VARCHAR2
    , p5_a31  VARCHAR2
    , p5_a32  VARCHAR2
    , p5_a33  VARCHAR2
    , p5_a34  NUMBER
    , p5_a35  VARCHAR2
    , p5_a36  VARCHAR2
    , p5_a37  NUMBER
    , p5_a38  NUMBER
    , p6_a0 out nocopy  NUMBER
    , p6_a1 out nocopy  NUMBER
    , p6_a2 out nocopy  VARCHAR2
    , p6_a3 out nocopy  NUMBER
    , p6_a4 out nocopy  NUMBER
    , p6_a5 out nocopy  NUMBER
    , p6_a6 out nocopy  VARCHAR2
    , p6_a7 out nocopy  VARCHAR2
    , p6_a8 out nocopy  DATE
    , p6_a9 out nocopy  DATE
    , p6_a10 out nocopy  VARCHAR2
    , p6_a11 out nocopy  VARCHAR2
    , p6_a12 out nocopy  NUMBER
    , p6_a13 out nocopy  DATE
    , p6_a14 out nocopy  NUMBER
    , p6_a15 out nocopy  DATE
    , p6_a16 out nocopy  NUMBER
    , p6_a17 out nocopy  VARCHAR2
    , p6_a18 out nocopy  VARCHAR2
    , p6_a19 out nocopy  VARCHAR2
    , p6_a20 out nocopy  VARCHAR2
    , p6_a21 out nocopy  VARCHAR2
    , p6_a22 out nocopy  VARCHAR2
    , p6_a23 out nocopy  VARCHAR2
    , p6_a24 out nocopy  VARCHAR2
    , p6_a25 out nocopy  VARCHAR2
    , p6_a26 out nocopy  VARCHAR2
    , p6_a27 out nocopy  VARCHAR2
    , p6_a28 out nocopy  VARCHAR2
    , p6_a29 out nocopy  VARCHAR2
    , p6_a30 out nocopy  VARCHAR2
    , p6_a31 out nocopy  VARCHAR2
    , p6_a32 out nocopy  VARCHAR2
    , p6_a33 out nocopy  VARCHAR2
    , p6_a34 out nocopy  NUMBER
    , p6_a35 out nocopy  VARCHAR2
    , p6_a36 out nocopy  VARCHAR2
    , p6_a37 out nocopy  NUMBER
    , p6_a38 out nocopy  NUMBER
    , p7_a0  NUMBER
    , p7_a1  NUMBER
    , p7_a2  VARCHAR2
    , p7_a3  DATE
    , p7_a4  DATE
    , p7_a5  NUMBER
    , p7_a6  NUMBER
    , p7_a7  NUMBER
    , p7_a8  NUMBER
    , p7_a9  VARCHAR2
    , p7_a10  NUMBER
    , p7_a11  NUMBER
    , p7_a12  NUMBER
    , p7_a13  NUMBER
    , p7_a14  NUMBER
    , p7_a15  VARCHAR2
    , p7_a16  NUMBER
    , p7_a17  DATE
    , p7_a18  NUMBER
    , p7_a19  DATE
    , p7_a20  NUMBER
    , p7_a21  VARCHAR2
    , p7_a22  VARCHAR2
    , p7_a23  VARCHAR2
    , p7_a24  VARCHAR2
    , p7_a25  VARCHAR2
    , p7_a26  VARCHAR2
    , p7_a27  VARCHAR2
    , p7_a28  VARCHAR2
    , p7_a29  VARCHAR2
    , p7_a30  VARCHAR2
    , p7_a31  VARCHAR2
    , p7_a32  VARCHAR2
    , p7_a33  VARCHAR2
    , p7_a34  VARCHAR2
    , p7_a35  VARCHAR2
    , p7_a36  VARCHAR2
    , p7_a37  NUMBER
    , p8_a0 out nocopy  NUMBER
    , p8_a1 out nocopy  NUMBER
    , p8_a2 out nocopy  VARCHAR2
    , p8_a3 out nocopy  DATE
    , p8_a4 out nocopy  DATE
    , p8_a5 out nocopy  NUMBER
    , p8_a6 out nocopy  NUMBER
    , p8_a7 out nocopy  NUMBER
    , p8_a8 out nocopy  NUMBER
    , p8_a9 out nocopy  VARCHAR2
    , p8_a10 out nocopy  NUMBER
    , p8_a11 out nocopy  NUMBER
    , p8_a12 out nocopy  NUMBER
    , p8_a13 out nocopy  NUMBER
    , p8_a14 out nocopy  NUMBER
    , p8_a15 out nocopy  VARCHAR2
    , p8_a16 out nocopy  NUMBER
    , p8_a17 out nocopy  DATE
    , p8_a18 out nocopy  NUMBER
    , p8_a19 out nocopy  DATE
    , p8_a20 out nocopy  NUMBER
    , p8_a21 out nocopy  VARCHAR2
    , p8_a22 out nocopy  VARCHAR2
    , p8_a23 out nocopy  VARCHAR2
    , p8_a24 out nocopy  VARCHAR2
    , p8_a25 out nocopy  VARCHAR2
    , p8_a26 out nocopy  VARCHAR2
    , p8_a27 out nocopy  VARCHAR2
    , p8_a28 out nocopy  VARCHAR2
    , p8_a29 out nocopy  VARCHAR2
    , p8_a30 out nocopy  VARCHAR2
    , p8_a31 out nocopy  VARCHAR2
    , p8_a32 out nocopy  VARCHAR2
    , p8_a33 out nocopy  VARCHAR2
    , p8_a34 out nocopy  VARCHAR2
    , p8_a35 out nocopy  VARCHAR2
    , p8_a36 out nocopy  VARCHAR2
    , p8_a37 out nocopy  NUMBER
  )

  as
    ddp_lrtv_rec okl_lease_rate_sets_pvt.lrtv_rec_type;
Line: 2718

    ddp_lrtv_rec.last_updated_by := p5_a14;
Line: 2719

    ddp_lrtv_rec.last_update_date := p5_a15;
Line: 2720

    ddp_lrtv_rec.last_update_login := p5_a16;
Line: 2763

    ddp_lrvv_rec.last_updated_by := p7_a18;
Line: 2764

    ddp_lrvv_rec.last_update_date := p7_a19;
Line: 2765

    ddp_lrvv_rec.last_update_login := p7_a20;
Line: 2786

    okl_lease_rate_sets_pvt.update_lrs_gen_lrf_submit(p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      ddp_lrtv_rec,
      ddx_lrtv_rec,
      ddp_lrvv_rec,
      ddx_lrvv_rec);
Line: 2817

    p6_a14 := ddx_lrtv_rec.last_updated_by;
Line: 2818

    p6_a15 := ddx_lrtv_rec.last_update_date;
Line: 2819

    p6_a16 := ddx_lrtv_rec.last_update_login;
Line: 2862

    p8_a18 := ddx_lrvv_rec.last_updated_by;
Line: 2863

    p8_a19 := ddx_lrvv_rec.last_update_date;
Line: 2864

    p8_a20 := ddx_lrvv_rec.last_update_login;
Line: 3073

    ddp_lrtv_rec.last_updated_by := p5_a14;
Line: 3074

    ddp_lrtv_rec.last_update_date := p5_a15;
Line: 3075

    ddp_lrtv_rec.last_update_login := p5_a16;
Line: 3118

    ddp_lrvv_rec.last_updated_by := p7_a18;
Line: 3119

    ddp_lrvv_rec.last_update_date := p7_a19;
Line: 3120

    ddp_lrvv_rec.last_update_login := p7_a20;
Line: 3172

    p6_a14 := ddx_lrtv_rec.last_updated_by;
Line: 3173

    p6_a15 := ddx_lrtv_rec.last_update_date;
Line: 3174

    p6_a16 := ddx_lrtv_rec.last_update_login;
Line: 3217

    p8_a18 := ddx_lrvv_rec.last_updated_by;
Line: 3218

    p8_a19 := ddx_lrvv_rec.last_update_date;
Line: 3219

    p8_a20 := ddx_lrvv_rec.last_update_login;