DBA Data[Home] [Help]

APPS.OKL_REPORT_PVT_W SQL Statements

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

Line: 76

    ddp_repv_rec.last_updated_by := p5_a14;
Line: 77

    ddp_repv_rec.last_update_date := p5_a15;
Line: 78

    ddp_repv_rec.last_update_login := p5_a16;
Line: 114

    p6_a14 := ddx_repv_rec.last_updated_by;
Line: 115

    p6_a15 := ddx_repv_rec.last_update_date;
Line: 116

    p6_a16 := ddx_repv_rec.last_update_login;
Line: 122

  procedure update_report(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  VARCHAR2
    , p5_a2  NUMBER
    , p5_a3  VARCHAR2
    , p5_a4  NUMBER
    , p5_a5  VARCHAR2
    , p5_a6  VARCHAR2
    , p5_a7  VARCHAR2
    , p5_a8  VARCHAR2
    , p5_a9  VARCHAR2
    , p5_a10  DATE
    , p5_a11  DATE
    , p5_a12  NUMBER
    , p5_a13  DATE
    , p5_a14  NUMBER
    , p5_a15  DATE
    , p5_a16  NUMBER
    , p5_a17  VARCHAR2
    , p5_a18  VARCHAR2
    , p5_a19  VARCHAR2
    , p6_a0 out nocopy  NUMBER
    , p6_a1 out nocopy  VARCHAR2
    , p6_a2 out nocopy  NUMBER
    , p6_a3 out nocopy  VARCHAR2
    , p6_a4 out nocopy  NUMBER
    , p6_a5 out nocopy  VARCHAR2
    , p6_a6 out nocopy  VARCHAR2
    , p6_a7 out nocopy  VARCHAR2
    , p6_a8 out nocopy  VARCHAR2
    , p6_a9 out nocopy  VARCHAR2
    , p6_a10 out nocopy  DATE
    , p6_a11 out nocopy  DATE
    , 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
  )

  as
    ddp_repv_rec okl_report_pvt.repv_rec_type;
Line: 195

    ddp_repv_rec.last_updated_by := p5_a14;
Line: 196

    ddp_repv_rec.last_update_date := p5_a15;
Line: 197

    ddp_repv_rec.last_update_login := p5_a16;
Line: 204

    okl_report_pvt.update_report(p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      ddp_repv_rec,
      ddx_repv_rec);
Line: 233

    p6_a14 := ddx_repv_rec.last_updated_by;
Line: 234

    p6_a15 := ddx_repv_rec.last_update_date;
Line: 235

    p6_a16 := ddx_repv_rec.last_update_login;
Line: 241

  procedure delete_report(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  VARCHAR2
    , p5_a2  NUMBER
    , p5_a3  VARCHAR2
    , p5_a4  NUMBER
    , p5_a5  VARCHAR2
    , p5_a6  VARCHAR2
    , p5_a7  VARCHAR2
    , p5_a8  VARCHAR2
    , p5_a9  VARCHAR2
    , p5_a10  DATE
    , p5_a11  DATE
    , p5_a12  NUMBER
    , p5_a13  DATE
    , p5_a14  NUMBER
    , p5_a15  DATE
    , p5_a16  NUMBER
    , p5_a17  VARCHAR2
    , p5_a18  VARCHAR2
    , p5_a19  VARCHAR2
  )

  as
    ddp_repv_rec okl_report_pvt.repv_rec_type;
Line: 293

    ddp_repv_rec.last_updated_by := p5_a14;
Line: 294

    ddp_repv_rec.last_update_date := p5_a15;
Line: 295

    ddp_repv_rec.last_update_login := p5_a16;
Line: 301

    okl_report_pvt.delete_report(p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      ddp_repv_rec);
Line: 368

    ddp_repv_rec.last_updated_by := p5_a14;
Line: 369

    ddp_repv_rec.last_update_date := p5_a15;
Line: 370

    ddp_repv_rec.last_update_login := p5_a16;
Line: 512

  procedure update_report(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 JTF_NUMBER_TABLE
    , p5_a1 JTF_VARCHAR2_TABLE_300
    , p5_a2 JTF_NUMBER_TABLE
    , p5_a3 JTF_VARCHAR2_TABLE_100
    , p5_a4 JTF_NUMBER_TABLE
    , p5_a5 JTF_VARCHAR2_TABLE_100
    , p5_a6 JTF_VARCHAR2_TABLE_100
    , p5_a7 JTF_VARCHAR2_TABLE_100
    , p5_a8 JTF_VARCHAR2_TABLE_100
    , p5_a9 JTF_VARCHAR2_TABLE_2000
    , p5_a10 JTF_DATE_TABLE
    , p5_a11 JTF_DATE_TABLE
    , p5_a12 JTF_NUMBER_TABLE
    , p5_a13 JTF_DATE_TABLE
    , p5_a14 JTF_NUMBER_TABLE
    , p5_a15 JTF_DATE_TABLE
    , p5_a16 JTF_NUMBER_TABLE
    , p5_a17 JTF_VARCHAR2_TABLE_100
    , p5_a18 JTF_VARCHAR2_TABLE_100
    , p5_a19 JTF_VARCHAR2_TABLE_100
    , p6_a0 out nocopy JTF_NUMBER_TABLE
    , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
    , p6_a2 out nocopy JTF_NUMBER_TABLE
    , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
    , p6_a4 out nocopy JTF_NUMBER_TABLE
    , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
    , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
    , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
    , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
    , p6_a9 out nocopy JTF_VARCHAR2_TABLE_2000
    , p6_a10 out nocopy JTF_DATE_TABLE
    , p6_a11 out nocopy JTF_DATE_TABLE
    , p6_a12 out nocopy JTF_NUMBER_TABLE
    , p6_a13 out nocopy JTF_DATE_TABLE
    , p6_a14 out nocopy JTF_NUMBER_TABLE
    , p6_a15 out nocopy JTF_DATE_TABLE
    , p6_a16 out nocopy JTF_NUMBER_TABLE
    , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
    , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
    , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
  )

  as
    ddp_repv_tbl okl_report_pvt.repv_tbl_type;
Line: 595

    okl_report_pvt.update_report(p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      ddp_repv_tbl,
      ddx_repv_tbl);
Line: 633

  procedure delete_report(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 JTF_NUMBER_TABLE
    , p5_a1 JTF_VARCHAR2_TABLE_300
    , p5_a2 JTF_NUMBER_TABLE
    , p5_a3 JTF_VARCHAR2_TABLE_100
    , p5_a4 JTF_NUMBER_TABLE
    , p5_a5 JTF_VARCHAR2_TABLE_100
    , p5_a6 JTF_VARCHAR2_TABLE_100
    , p5_a7 JTF_VARCHAR2_TABLE_100
    , p5_a8 JTF_VARCHAR2_TABLE_100
    , p5_a9 JTF_VARCHAR2_TABLE_2000
    , p5_a10 JTF_DATE_TABLE
    , p5_a11 JTF_DATE_TABLE
    , p5_a12 JTF_NUMBER_TABLE
    , p5_a13 JTF_DATE_TABLE
    , p5_a14 JTF_NUMBER_TABLE
    , p5_a15 JTF_DATE_TABLE
    , p5_a16 JTF_NUMBER_TABLE
    , p5_a17 JTF_VARCHAR2_TABLE_100
    , p5_a18 JTF_VARCHAR2_TABLE_100
    , p5_a19 JTF_VARCHAR2_TABLE_100
  )

  as
    ddp_repv_tbl okl_report_pvt.repv_tbl_type;
Line: 694

    okl_report_pvt.delete_report(p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      ddp_repv_tbl);
Line: 837

    ddp_rpp_rec.last_updated_by := p5_a9;
Line: 838

    ddp_rpp_rec.last_update_date := p5_a10;
Line: 839

    ddp_rpp_rec.last_update_login := p5_a11;
Line: 867

    p6_a9 := ddx_rpp_rec.last_updated_by;
Line: 868

    p6_a10 := ddx_rpp_rec.last_update_date;
Line: 869

    p6_a11 := ddx_rpp_rec.last_update_login;
Line: 872

  procedure update_report_parameters(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  VARCHAR2
    , p5_a5  DATE
    , p5_a6  NUMBER
    , p5_a7  VARCHAR2
    , p5_a8  DATE
    , p5_a9  NUMBER
    , p5_a10  DATE
    , p5_a11  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  VARCHAR2
    , p6_a5 out nocopy  DATE
    , p6_a6 out nocopy  NUMBER
    , p6_a7 out nocopy  VARCHAR2
    , p6_a8 out nocopy  DATE
    , p6_a9 out nocopy  NUMBER
    , p6_a10 out nocopy  DATE
    , p6_a11 out nocopy  NUMBER
  )

  as
    ddp_rpp_rec okl_report_pvt.rpp_rec_type;
Line: 924

    ddp_rpp_rec.last_updated_by := p5_a9;
Line: 925

    ddp_rpp_rec.last_update_date := p5_a10;
Line: 926

    ddp_rpp_rec.last_update_login := p5_a11;
Line: 930

    okl_report_pvt.update_report_parameters(p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      ddp_rpp_rec,
      ddx_rpp_rec);
Line: 954

    p6_a9 := ddx_rpp_rec.last_updated_by;
Line: 955

    p6_a10 := ddx_rpp_rec.last_update_date;
Line: 956

    p6_a11 := ddx_rpp_rec.last_update_login;
Line: 959

  procedure delete_report_parameters(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  VARCHAR2
    , p5_a5  DATE
    , p5_a6  NUMBER
    , p5_a7  VARCHAR2
    , p5_a8  DATE
    , p5_a9  NUMBER
    , p5_a10  DATE
    , p5_a11  NUMBER
  )

  as
    ddp_rpp_rec okl_report_pvt.rpp_rec_type;
Line: 998

    ddp_rpp_rec.last_updated_by := p5_a9;
Line: 999

    ddp_rpp_rec.last_update_date := p5_a10;
Line: 1000

    ddp_rpp_rec.last_update_login := p5_a11;
Line: 1003

    okl_report_pvt.delete_report_parameters(p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      ddp_rpp_rec);
Line: 1057

    ddp_rpp_rec.last_updated_by := p5_a9;
Line: 1058

    ddp_rpp_rec.last_update_date := p5_a10;
Line: 1059

    ddp_rpp_rec.last_update_login := p5_a11;
Line: 1166

  procedure update_report_parameters(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 JTF_NUMBER_TABLE
    , p5_a1 JTF_NUMBER_TABLE
    , p5_a2 JTF_VARCHAR2_TABLE_100
    , p5_a3 JTF_NUMBER_TABLE
    , p5_a4 JTF_VARCHAR2_TABLE_300
    , p5_a5 JTF_DATE_TABLE
    , p5_a6 JTF_NUMBER_TABLE
    , p5_a7 JTF_VARCHAR2_TABLE_100
    , p5_a8 JTF_DATE_TABLE
    , p5_a9 JTF_NUMBER_TABLE
    , p5_a10 JTF_DATE_TABLE
    , p5_a11 JTF_NUMBER_TABLE
    , p6_a0 out nocopy JTF_NUMBER_TABLE
    , p6_a1 out nocopy JTF_NUMBER_TABLE
    , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
    , p6_a3 out nocopy JTF_NUMBER_TABLE
    , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
    , p6_a5 out nocopy JTF_DATE_TABLE
    , p6_a6 out nocopy JTF_NUMBER_TABLE
    , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
    , p6_a8 out nocopy JTF_DATE_TABLE
    , p6_a9 out nocopy JTF_NUMBER_TABLE
    , p6_a10 out nocopy JTF_DATE_TABLE
    , p6_a11 out nocopy JTF_NUMBER_TABLE
  )

  as
    ddp_rpp_tbl okl_report_pvt.rpp_tbl_type;
Line: 1225

    okl_report_pvt.update_report_parameters(p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      ddp_rpp_tbl,
      ddx_rpp_tbl);
Line: 1255

  procedure delete_report_parameters(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 JTF_NUMBER_TABLE
    , p5_a1 JTF_NUMBER_TABLE
    , p5_a2 JTF_VARCHAR2_TABLE_100
    , p5_a3 JTF_NUMBER_TABLE
    , p5_a4 JTF_VARCHAR2_TABLE_300
    , p5_a5 JTF_DATE_TABLE
    , p5_a6 JTF_NUMBER_TABLE
    , p5_a7 JTF_VARCHAR2_TABLE_100
    , p5_a8 JTF_DATE_TABLE
    , p5_a9 JTF_NUMBER_TABLE
    , p5_a10 JTF_DATE_TABLE
    , p5_a11 JTF_NUMBER_TABLE
  )

  as
    ddp_rpp_tbl okl_report_pvt.rpp_tbl_type;
Line: 1300

    okl_report_pvt.delete_report_parameters(p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      ddp_rpp_tbl);
Line: 1421

    ddp_rap_rec.last_updated_by := p5_a7;
Line: 1422

    ddp_rap_rec.last_update_date := p5_a8;
Line: 1423

    ddp_rap_rec.last_update_login := p5_a9;
Line: 1449

    p6_a7 := ddx_rap_rec.last_updated_by;
Line: 1450

    p6_a8 := ddx_rap_rec.last_update_date;
Line: 1451

    p6_a9 := ddx_rap_rec.last_update_login;
Line: 1454

  procedure update_report_acc_parameters(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  DATE
    , p5_a7  NUMBER
    , p5_a8  DATE
    , p5_a9  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  DATE
    , p6_a7 out nocopy  NUMBER
    , p6_a8 out nocopy  DATE
    , p6_a9 out nocopy  NUMBER
  )

  as
    ddp_rap_rec okl_report_pvt.rap_rec_type;
Line: 1500

    ddp_rap_rec.last_updated_by := p5_a7;
Line: 1501

    ddp_rap_rec.last_update_date := p5_a8;
Line: 1502

    ddp_rap_rec.last_update_login := p5_a9;
Line: 1506

    okl_report_pvt.update_report_acc_parameters(p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      ddp_rap_rec,
      ddx_rap_rec);
Line: 1528

    p6_a7 := ddx_rap_rec.last_updated_by;
Line: 1529

    p6_a8 := ddx_rap_rec.last_update_date;
Line: 1530

    p6_a9 := ddx_rap_rec.last_update_login;
Line: 1533

  procedure delete_report_acc_parameters(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  DATE
    , p5_a7  NUMBER
    , p5_a8  DATE
    , p5_a9  NUMBER
  )

  as
    ddp_rap_rec okl_report_pvt.rap_rec_type;
Line: 1568

    ddp_rap_rec.last_updated_by := p5_a7;
Line: 1569

    ddp_rap_rec.last_update_date := p5_a8;
Line: 1570

    ddp_rap_rec.last_update_login := p5_a9;
Line: 1573

    okl_report_pvt.delete_report_acc_parameters(p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      ddp_rap_rec);
Line: 1623

    ddp_rap_rec.last_updated_by := p5_a7;
Line: 1624

    ddp_rap_rec.last_update_date := p5_a8;
Line: 1625

    ddp_rap_rec.last_update_login := p5_a9;
Line: 1724

  procedure update_report_acc_parameters(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 JTF_NUMBER_TABLE
    , p5_a1 JTF_NUMBER_TABLE
    , p5_a2 JTF_VARCHAR2_TABLE_100
    , p5_a3 JTF_NUMBER_TABLE
    , p5_a4 JTF_NUMBER_TABLE
    , p5_a5 JTF_NUMBER_TABLE
    , p5_a6 JTF_DATE_TABLE
    , p5_a7 JTF_NUMBER_TABLE
    , p5_a8 JTF_DATE_TABLE
    , p5_a9 JTF_NUMBER_TABLE
    , p6_a0 out nocopy JTF_NUMBER_TABLE
    , p6_a1 out nocopy JTF_NUMBER_TABLE
    , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
    , p6_a3 out nocopy JTF_NUMBER_TABLE
    , p6_a4 out nocopy JTF_NUMBER_TABLE
    , p6_a5 out nocopy JTF_NUMBER_TABLE
    , p6_a6 out nocopy JTF_DATE_TABLE
    , p6_a7 out nocopy JTF_NUMBER_TABLE
    , p6_a8 out nocopy JTF_DATE_TABLE
    , p6_a9 out nocopy JTF_NUMBER_TABLE
  )

  as
    ddp_rap_tbl okl_report_pvt.rap_tbl_type;
Line: 1777

    okl_report_pvt.update_report_acc_parameters(p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      ddp_rap_tbl,
      ddx_rap_tbl);
Line: 1805

  procedure delete_report_acc_parameters(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 JTF_NUMBER_TABLE
    , p5_a1 JTF_NUMBER_TABLE
    , p5_a2 JTF_VARCHAR2_TABLE_100
    , p5_a3 JTF_NUMBER_TABLE
    , p5_a4 JTF_NUMBER_TABLE
    , p5_a5 JTF_NUMBER_TABLE
    , p5_a6 JTF_DATE_TABLE
    , p5_a7 JTF_NUMBER_TABLE
    , p5_a8 JTF_DATE_TABLE
    , p5_a9 JTF_NUMBER_TABLE
  )

  as
    ddp_rap_tbl okl_report_pvt.rap_tbl_type;
Line: 1846

    okl_report_pvt.delete_report_acc_parameters(p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      ddp_rap_tbl);
Line: 1960

    ddp_rps_rec.last_updated_by := p5_a6;
Line: 1961

    ddp_rps_rec.last_update_date := p5_a7;
Line: 1962

    ddp_rps_rec.last_update_login := p5_a8;
Line: 1987

    p6_a6 := ddx_rps_rec.last_updated_by;
Line: 1988

    p6_a7 := ddx_rps_rec.last_update_date;
Line: 1989

    p6_a8 := ddx_rps_rec.last_update_login;
Line: 1992

  procedure update_report_strm_parameters(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  NUMBER
    , p5_a3  VARCHAR2
    , p5_a4  NUMBER
    , p5_a5  DATE
    , p5_a6  NUMBER
    , p5_a7  DATE
    , p5_a8  NUMBER
    , p6_a0 out nocopy  NUMBER
    , p6_a1 out nocopy  NUMBER
    , p6_a2 out nocopy  NUMBER
    , p6_a3 out nocopy  VARCHAR2
    , p6_a4 out nocopy  NUMBER
    , p6_a5 out nocopy  DATE
    , p6_a6 out nocopy  NUMBER
    , p6_a7 out nocopy  DATE
    , p6_a8 out nocopy  NUMBER
  )

  as
    ddp_rps_rec okl_report_pvt.rps_rec_type;
Line: 2035

    ddp_rps_rec.last_updated_by := p5_a6;
Line: 2036

    ddp_rps_rec.last_update_date := p5_a7;
Line: 2037

    ddp_rps_rec.last_update_login := p5_a8;
Line: 2041

    okl_report_pvt.update_report_strm_parameters(p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      ddp_rps_rec,
      ddx_rps_rec);
Line: 2062

    p6_a6 := ddx_rps_rec.last_updated_by;
Line: 2063

    p6_a7 := ddx_rps_rec.last_update_date;
Line: 2064

    p6_a8 := ddx_rps_rec.last_update_login;
Line: 2067

  procedure delete_report_strm_parameters(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  NUMBER
    , p5_a3  VARCHAR2
    , p5_a4  NUMBER
    , p5_a5  DATE
    , p5_a6  NUMBER
    , p5_a7  DATE
    , p5_a8  NUMBER
  )

  as
    ddp_rps_rec okl_report_pvt.rps_rec_type;
Line: 2100

    ddp_rps_rec.last_updated_by := p5_a6;
Line: 2101

    ddp_rps_rec.last_update_date := p5_a7;
Line: 2102

    ddp_rps_rec.last_update_login := p5_a8;
Line: 2105

    okl_report_pvt.delete_report_strm_parameters(p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      ddp_rps_rec);
Line: 2153

    ddp_rps_rec.last_updated_by := p5_a6;
Line: 2154

    ddp_rps_rec.last_update_date := p5_a7;
Line: 2155

    ddp_rps_rec.last_update_login := p5_a8;
Line: 2250

  procedure update_report_strm_parameters(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 JTF_NUMBER_TABLE
    , p5_a1 JTF_NUMBER_TABLE
    , p5_a2 JTF_NUMBER_TABLE
    , p5_a3 JTF_VARCHAR2_TABLE_100
    , p5_a4 JTF_NUMBER_TABLE
    , p5_a5 JTF_DATE_TABLE
    , p5_a6 JTF_NUMBER_TABLE
    , p5_a7 JTF_DATE_TABLE
    , p5_a8 JTF_NUMBER_TABLE
    , p6_a0 out nocopy JTF_NUMBER_TABLE
    , p6_a1 out nocopy JTF_NUMBER_TABLE
    , p6_a2 out nocopy JTF_NUMBER_TABLE
    , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
    , p6_a4 out nocopy JTF_NUMBER_TABLE
    , p6_a5 out nocopy JTF_DATE_TABLE
    , p6_a6 out nocopy JTF_NUMBER_TABLE
    , p6_a7 out nocopy JTF_DATE_TABLE
    , p6_a8 out nocopy JTF_NUMBER_TABLE
  )

  as
    ddp_rps_tbl okl_report_pvt.rps_tbl_type;
Line: 2300

    okl_report_pvt.update_report_strm_parameters(p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      ddp_rps_tbl,
      ddx_rps_tbl);
Line: 2327

  procedure delete_report_strm_parameters(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 JTF_NUMBER_TABLE
    , p5_a1 JTF_NUMBER_TABLE
    , p5_a2 JTF_NUMBER_TABLE
    , p5_a3 JTF_VARCHAR2_TABLE_100
    , p5_a4 JTF_NUMBER_TABLE
    , p5_a5 JTF_DATE_TABLE
    , p5_a6 JTF_NUMBER_TABLE
    , p5_a7 JTF_DATE_TABLE
    , p5_a8 JTF_NUMBER_TABLE
  )

  as
    ddp_rps_tbl okl_report_pvt.rps_tbl_type;
Line: 2366

    okl_report_pvt.delete_report_strm_parameters(p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      ddp_rps_tbl);
Line: 2481

    ddp_rtp_rec.last_updated_by := p5_a7;
Line: 2482

    ddp_rtp_rec.last_update_date := p5_a8;
Line: 2483

    ddp_rtp_rec.last_update_login := p5_a9;
Line: 2509

    p6_a7 := ddx_rtp_rec.last_updated_by;
Line: 2510

    p6_a8 := ddx_rtp_rec.last_update_date;
Line: 2511

    p6_a9 := ddx_rtp_rec.last_update_login;
Line: 2514

  procedure update_report_trx_parameters(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  NUMBER
    , p5_a3  NUMBER
    , p5_a4  VARCHAR2
    , p5_a5  NUMBER
    , p5_a6  DATE
    , p5_a7  NUMBER
    , p5_a8  DATE
    , p5_a9  NUMBER
    , p6_a0 out nocopy  NUMBER
    , p6_a1 out nocopy  NUMBER
    , p6_a2 out nocopy  NUMBER
    , p6_a3 out nocopy  NUMBER
    , p6_a4 out nocopy  VARCHAR2
    , p6_a5 out nocopy  NUMBER
    , p6_a6 out nocopy  DATE
    , p6_a7 out nocopy  NUMBER
    , p6_a8 out nocopy  DATE
    , p6_a9 out nocopy  NUMBER
  )

  as
    ddp_rtp_rec okl_report_pvt.rtp_rec_type;
Line: 2560

    ddp_rtp_rec.last_updated_by := p5_a7;
Line: 2561

    ddp_rtp_rec.last_update_date := p5_a8;
Line: 2562

    ddp_rtp_rec.last_update_login := p5_a9;
Line: 2566

    okl_report_pvt.update_report_trx_parameters(p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      ddp_rtp_rec,
      ddx_rtp_rec);
Line: 2588

    p6_a7 := ddx_rtp_rec.last_updated_by;
Line: 2589

    p6_a8 := ddx_rtp_rec.last_update_date;
Line: 2590

    p6_a9 := ddx_rtp_rec.last_update_login;
Line: 2593

  procedure delete_report_trx_parameters(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  NUMBER
    , p5_a3  NUMBER
    , p5_a4  VARCHAR2
    , p5_a5  NUMBER
    , p5_a6  DATE
    , p5_a7  NUMBER
    , p5_a8  DATE
    , p5_a9  NUMBER
  )

  as
    ddp_rtp_rec okl_report_pvt.rtp_rec_type;
Line: 2628

    ddp_rtp_rec.last_updated_by := p5_a7;
Line: 2629

    ddp_rtp_rec.last_update_date := p5_a8;
Line: 2630

    ddp_rtp_rec.last_update_login := p5_a9;
Line: 2633

    okl_report_pvt.delete_report_trx_parameters(p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      ddp_rtp_rec);
Line: 2683

    ddp_rtp_rec.last_updated_by := p5_a7;
Line: 2684

    ddp_rtp_rec.last_update_date := p5_a8;
Line: 2685

    ddp_rtp_rec.last_update_login := p5_a9;
Line: 2784

  procedure update_report_trx_parameters(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 JTF_NUMBER_TABLE
    , p5_a1 JTF_NUMBER_TABLE
    , p5_a2 JTF_NUMBER_TABLE
    , p5_a3 JTF_NUMBER_TABLE
    , p5_a4 JTF_VARCHAR2_TABLE_100
    , p5_a5 JTF_NUMBER_TABLE
    , p5_a6 JTF_DATE_TABLE
    , p5_a7 JTF_NUMBER_TABLE
    , p5_a8 JTF_DATE_TABLE
    , p5_a9 JTF_NUMBER_TABLE
    , p6_a0 out nocopy JTF_NUMBER_TABLE
    , p6_a1 out nocopy JTF_NUMBER_TABLE
    , p6_a2 out nocopy JTF_NUMBER_TABLE
    , p6_a3 out nocopy JTF_NUMBER_TABLE
    , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
    , p6_a5 out nocopy JTF_NUMBER_TABLE
    , p6_a6 out nocopy JTF_DATE_TABLE
    , p6_a7 out nocopy JTF_NUMBER_TABLE
    , p6_a8 out nocopy JTF_DATE_TABLE
    , p6_a9 out nocopy JTF_NUMBER_TABLE
  )

  as
    ddp_rtp_tbl okl_report_pvt.rtp_tbl_type;
Line: 2837

    okl_report_pvt.update_report_trx_parameters(p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      ddp_rtp_tbl,
      ddx_rtp_tbl);
Line: 2865

  procedure delete_report_trx_parameters(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 JTF_NUMBER_TABLE
    , p5_a1 JTF_NUMBER_TABLE
    , p5_a2 JTF_NUMBER_TABLE
    , p5_a3 JTF_NUMBER_TABLE
    , p5_a4 JTF_VARCHAR2_TABLE_100
    , p5_a5 JTF_NUMBER_TABLE
    , p5_a6 JTF_DATE_TABLE
    , p5_a7 JTF_NUMBER_TABLE
    , p5_a8 JTF_DATE_TABLE
    , p5_a9 JTF_NUMBER_TABLE
  )

  as
    ddp_rtp_tbl okl_report_pvt.rtp_tbl_type;
Line: 2906

    okl_report_pvt.delete_report_trx_parameters(p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      ddp_rtp_tbl);
Line: 3140

    ddp_repv_rec.last_updated_by := p5_a14;
Line: 3141

    ddp_repv_rec.last_update_date := p5_a15;
Line: 3142

    ddp_repv_rec.last_update_login := p5_a16;
Line: 3239

    p6_a14 := ddx_repv_rec.last_updated_by;
Line: 3240

    p6_a15 := ddx_repv_rec.last_update_date;
Line: 3241

    p6_a16 := ddx_repv_rec.last_update_login;
Line: 3300

  procedure update_report(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  VARCHAR2
    , p5_a2  NUMBER
    , p5_a3  VARCHAR2
    , p5_a4  NUMBER
    , p5_a5  VARCHAR2
    , p5_a6  VARCHAR2
    , p5_a7  VARCHAR2
    , p5_a8  VARCHAR2
    , p5_a9  VARCHAR2
    , p5_a10  DATE
    , p5_a11  DATE
    , p5_a12  NUMBER
    , p5_a13  DATE
    , p5_a14  NUMBER
    , p5_a15  DATE
    , p5_a16  NUMBER
    , p5_a17  VARCHAR2
    , p5_a18  VARCHAR2
    , p5_a19  VARCHAR2
    , p6_a0 out nocopy  NUMBER
    , p6_a1 out nocopy  VARCHAR2
    , p6_a2 out nocopy  NUMBER
    , p6_a3 out nocopy  VARCHAR2
    , p6_a4 out nocopy  NUMBER
    , p6_a5 out nocopy  VARCHAR2
    , p6_a6 out nocopy  VARCHAR2
    , p6_a7 out nocopy  VARCHAR2
    , p6_a8 out nocopy  VARCHAR2
    , p6_a9 out nocopy  VARCHAR2
    , p6_a10 out nocopy  DATE
    , p6_a11 out nocopy  DATE
    , 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
    , p7_a0 JTF_NUMBER_TABLE
    , p7_a1 JTF_NUMBER_TABLE
    , p7_a2 JTF_VARCHAR2_TABLE_100
    , p7_a3 JTF_NUMBER_TABLE
    , p7_a4 JTF_VARCHAR2_TABLE_300
    , p7_a5 JTF_DATE_TABLE
    , p7_a6 JTF_NUMBER_TABLE
    , p7_a7 JTF_VARCHAR2_TABLE_100
    , p7_a8 JTF_DATE_TABLE
    , p7_a9 JTF_NUMBER_TABLE
    , p7_a10 JTF_DATE_TABLE
    , p7_a11 JTF_NUMBER_TABLE
    , p8_a0 out nocopy JTF_NUMBER_TABLE
    , p8_a1 out nocopy JTF_NUMBER_TABLE
    , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
    , p8_a3 out nocopy JTF_NUMBER_TABLE
    , p8_a4 out nocopy JTF_VARCHAR2_TABLE_300
    , p8_a5 out nocopy JTF_DATE_TABLE
    , p8_a6 out nocopy JTF_NUMBER_TABLE
    , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
    , p8_a8 out nocopy JTF_DATE_TABLE
    , p8_a9 out nocopy JTF_NUMBER_TABLE
    , p8_a10 out nocopy JTF_DATE_TABLE
    , p8_a11 out nocopy JTF_NUMBER_TABLE
    , p9_a0 JTF_NUMBER_TABLE
    , p9_a1 JTF_NUMBER_TABLE
    , p9_a2 JTF_VARCHAR2_TABLE_100
    , p9_a3 JTF_NUMBER_TABLE
    , p9_a4 JTF_NUMBER_TABLE
    , p9_a5 JTF_NUMBER_TABLE
    , p9_a6 JTF_DATE_TABLE
    , p9_a7 JTF_NUMBER_TABLE
    , p9_a8 JTF_DATE_TABLE
    , p9_a9 JTF_NUMBER_TABLE
    , p10_a0 out nocopy JTF_NUMBER_TABLE
    , p10_a1 out nocopy JTF_NUMBER_TABLE
    , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
    , p10_a3 out nocopy JTF_NUMBER_TABLE
    , p10_a4 out nocopy JTF_NUMBER_TABLE
    , p10_a5 out nocopy JTF_NUMBER_TABLE
    , p10_a6 out nocopy JTF_DATE_TABLE
    , p10_a7 out nocopy JTF_NUMBER_TABLE
    , p10_a8 out nocopy JTF_DATE_TABLE
    , p10_a9 out nocopy JTF_NUMBER_TABLE
    , p11_a0 JTF_NUMBER_TABLE
    , p11_a1 JTF_NUMBER_TABLE
    , p11_a2 JTF_NUMBER_TABLE
    , p11_a3 JTF_VARCHAR2_TABLE_100
    , p11_a4 JTF_NUMBER_TABLE
    , p11_a5 JTF_DATE_TABLE
    , p11_a6 JTF_NUMBER_TABLE
    , p11_a7 JTF_DATE_TABLE
    , p11_a8 JTF_NUMBER_TABLE
    , p12_a0 out nocopy JTF_NUMBER_TABLE
    , p12_a1 out nocopy JTF_NUMBER_TABLE
    , p12_a2 out nocopy JTF_NUMBER_TABLE
    , p12_a3 out nocopy JTF_VARCHAR2_TABLE_100
    , p12_a4 out nocopy JTF_NUMBER_TABLE
    , p12_a5 out nocopy JTF_DATE_TABLE
    , p12_a6 out nocopy JTF_NUMBER_TABLE
    , p12_a7 out nocopy JTF_DATE_TABLE
    , p12_a8 out nocopy JTF_NUMBER_TABLE
    , p13_a0 JTF_NUMBER_TABLE
    , p13_a1 JTF_NUMBER_TABLE
    , p13_a2 JTF_NUMBER_TABLE
    , p13_a3 JTF_NUMBER_TABLE
    , p13_a4 JTF_VARCHAR2_TABLE_100
    , p13_a5 JTF_NUMBER_TABLE
    , p13_a6 JTF_DATE_TABLE
    , p13_a7 JTF_NUMBER_TABLE
    , p13_a8 JTF_DATE_TABLE
    , p13_a9 JTF_NUMBER_TABLE
    , p14_a0 out nocopy JTF_NUMBER_TABLE
    , p14_a1 out nocopy JTF_NUMBER_TABLE
    , p14_a2 out nocopy JTF_NUMBER_TABLE
    , p14_a3 out nocopy JTF_NUMBER_TABLE
    , p14_a4 out nocopy JTF_VARCHAR2_TABLE_100
    , p14_a5 out nocopy JTF_NUMBER_TABLE
    , p14_a6 out nocopy JTF_DATE_TABLE
    , p14_a7 out nocopy JTF_NUMBER_TABLE
    , p14_a8 out nocopy JTF_DATE_TABLE
    , p14_a9 out nocopy JTF_NUMBER_TABLE
  )

  as
    ddp_repv_rec okl_report_pvt.repv_rec_type;
Line: 3463

    ddp_repv_rec.last_updated_by := p5_a14;
Line: 3464

    ddp_repv_rec.last_update_date := p5_a15;
Line: 3465

    ddp_repv_rec.last_update_login := p5_a16;
Line: 3525

    okl_report_pvt.update_report(p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      ddp_repv_rec,
      ddx_repv_rec,
      ddp_rpp_tbl,
      ddx_rpp_tbl,
      ddp_rap_tbl,
      ddx_rap_tbl,
      ddp_rps_tbl,
      ddx_rps_tbl,
      ddp_rtp_tbl,
      ddx_rtp_tbl);
Line: 3562

    p6_a14 := ddx_repv_rec.last_updated_by;
Line: 3563

    p6_a15 := ddx_repv_rec.last_update_date;
Line: 3564

    p6_a16 := ddx_repv_rec.last_update_login;