DBA Data[Home] [Help]

APPS.AHL_RA_SETUPS_PVT_W SQL Statements

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

Line: 64

    ddp_x_setup_data_rec.last_update_date := p8_a9;
Line: 65

    ddp_x_setup_data_rec.last_updated_by := p8_a10;
Line: 66

    ddp_x_setup_data_rec.last_update_login := p8_a11;
Line: 113

    p8_a9 := ddp_x_setup_data_rec.last_update_date;
Line: 114

    p8_a10 := ddp_x_setup_data_rec.last_updated_by;
Line: 115

    p8_a11 := ddp_x_setup_data_rec.last_update_login;
Line: 134

  procedure delete_setup_data(p_api_version  NUMBER
    , p_init_msg_list  VARCHAR2
    , p_commit  VARCHAR2
    , p_validation_level  NUMBER
    , p_module_type  VARCHAR2
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
    , p8_a0  NUMBER
    , p8_a1  VARCHAR2
    , p8_a2  NUMBER
    , p8_a3  VARCHAR2
    , p8_a4  VARCHAR2
    , p8_a5  NUMBER
    , p8_a6  NUMBER
    , p8_a7  DATE
    , p8_a8  NUMBER
    , p8_a9  DATE
    , p8_a10  NUMBER
    , p8_a11  NUMBER
    , p8_a12  VARCHAR2
    , p8_a13  VARCHAR2
    , p8_a14  VARCHAR2
    , p8_a15  VARCHAR2
    , p8_a16  VARCHAR2
    , p8_a17  VARCHAR2
    , p8_a18  VARCHAR2
    , p8_a19  VARCHAR2
    , p8_a20  VARCHAR2
    , p8_a21  VARCHAR2
    , p8_a22  VARCHAR2
    , p8_a23  VARCHAR2
    , p8_a24  VARCHAR2
    , p8_a25  VARCHAR2
    , p8_a26  VARCHAR2
    , p8_a27  VARCHAR2
  )

  as
    ddp_setup_data_rec ahl_ra_setups_pvt.ra_setup_data_rec_type;
Line: 195

    ddp_setup_data_rec.last_update_date := p8_a9;
Line: 196

    ddp_setup_data_rec.last_updated_by := p8_a10;
Line: 197

    ddp_setup_data_rec.last_update_login := p8_a11;
Line: 216

    ahl_ra_setups_pvt.delete_setup_data(p_api_version,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      p_module_type,
      x_return_status,
      x_msg_count,
      x_msg_data,
      ddp_setup_data_rec);
Line: 302

    ddp_x_reliability_data_rec.last_update_date := p8_a11;
Line: 303

    ddp_x_reliability_data_rec.last_updated_by := p8_a12;
Line: 304

    ddp_x_reliability_data_rec.last_update_login := p8_a13;
Line: 353

    p8_a11 := ddp_x_reliability_data_rec.last_update_date;
Line: 354

    p8_a12 := ddp_x_reliability_data_rec.last_updated_by;
Line: 355

    p8_a13 := ddp_x_reliability_data_rec.last_update_login;
Line: 374

  procedure delete_reliability_data(p_api_version  NUMBER
    , p_init_msg_list  VARCHAR2
    , p_commit  VARCHAR2
    , p_validation_level  NUMBER
    , p_module_type  VARCHAR2
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
    , p8_a0  NUMBER
    , p8_a1  NUMBER
    , p8_a2  NUMBER
    , p8_a3  NUMBER
    , p8_a4  VARCHAR2
    , p8_a5  NUMBER
    , p8_a6  VARCHAR2
    , p8_a7  NUMBER
    , p8_a8  NUMBER
    , p8_a9  DATE
    , p8_a10  NUMBER
    , p8_a11  DATE
    , p8_a12  NUMBER
    , p8_a13  NUMBER
    , p8_a14  VARCHAR2
    , p8_a15  VARCHAR2
    , p8_a16  VARCHAR2
    , p8_a17  VARCHAR2
    , p8_a18  VARCHAR2
    , p8_a19  VARCHAR2
    , p8_a20  VARCHAR2
    , p8_a21  VARCHAR2
    , p8_a22  VARCHAR2
    , p8_a23  VARCHAR2
    , p8_a24  VARCHAR2
    , p8_a25  VARCHAR2
    , p8_a26  VARCHAR2
    , p8_a27  VARCHAR2
    , p8_a28  VARCHAR2
    , p8_a29  VARCHAR2
  )

  as
    ddp_reliability_data_rec ahl_ra_setups_pvt.ra_definition_hdr_rec_type;
Line: 439

    ddp_reliability_data_rec.last_update_date := p8_a11;
Line: 440

    ddp_reliability_data_rec.last_updated_by := p8_a12;
Line: 441

    ddp_reliability_data_rec.last_update_login := p8_a13;
Line: 460

    ahl_ra_setups_pvt.delete_reliability_data(p_api_version,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      p_module_type,
      x_return_status,
      x_msg_count,
      x_msg_data,
      ddp_reliability_data_rec);
Line: 575

    ddp_x_reliability_data_rec.last_update_date := p8_a11;
Line: 576

    ddp_x_reliability_data_rec.last_updated_by := p8_a12;
Line: 577

    ddp_x_reliability_data_rec.last_update_login := p8_a13;
Line: 604

    ddp_x_mtbf_data_rec.last_update_date := p9_a9;
Line: 605

    ddp_x_mtbf_data_rec.last_updated_by := p9_a10;
Line: 606

    ddp_x_mtbf_data_rec.last_update_login := p9_a11;
Line: 656

    p8_a11 := ddp_x_reliability_data_rec.last_update_date;
Line: 657

    p8_a12 := ddp_x_reliability_data_rec.last_updated_by;
Line: 658

    p8_a13 := ddp_x_reliability_data_rec.last_update_login;
Line: 685

    p9_a9 := ddp_x_mtbf_data_rec.last_update_date;
Line: 686

    p9_a10 := ddp_x_mtbf_data_rec.last_updated_by;
Line: 687

    p9_a11 := ddp_x_mtbf_data_rec.last_update_login;
Line: 706

  procedure update_mtbf_data(p_api_version  NUMBER
    , p_init_msg_list  VARCHAR2
    , p_commit  VARCHAR2
    , p_validation_level  NUMBER
    , p_module_type  VARCHAR2
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
    , p8_a0 in out nocopy  NUMBER
    , p8_a1 in out nocopy  NUMBER
    , p8_a2 in out nocopy  NUMBER
    , p8_a3 in out nocopy  NUMBER
    , p8_a4 in out nocopy  VARCHAR2
    , p8_a5 in out nocopy  NUMBER
    , p8_a6 in out nocopy  VARCHAR2
    , p8_a7 in out nocopy  NUMBER
    , p8_a8 in out nocopy  NUMBER
    , p8_a9 in out nocopy  DATE
    , p8_a10 in out nocopy  NUMBER
    , p8_a11 in out nocopy  DATE
    , p8_a12 in out nocopy  NUMBER
    , p8_a13 in out nocopy  NUMBER
    , p8_a14 in out nocopy  VARCHAR2
    , p8_a15 in out nocopy  VARCHAR2
    , p8_a16 in out nocopy  VARCHAR2
    , p8_a17 in out nocopy  VARCHAR2
    , p8_a18 in out nocopy  VARCHAR2
    , p8_a19 in out nocopy  VARCHAR2
    , p8_a20 in out nocopy  VARCHAR2
    , p8_a21 in out nocopy  VARCHAR2
    , p8_a22 in out nocopy  VARCHAR2
    , p8_a23 in out nocopy  VARCHAR2
    , p8_a24 in out nocopy  VARCHAR2
    , p8_a25 in out nocopy  VARCHAR2
    , p8_a26 in out nocopy  VARCHAR2
    , p8_a27 in out nocopy  VARCHAR2
    , p8_a28 in out nocopy  VARCHAR2
    , p8_a29 in out nocopy  VARCHAR2
    , p9_a0 in out nocopy  NUMBER
    , p9_a1 in out nocopy  NUMBER
    , p9_a2 in out nocopy  NUMBER
    , p9_a3 in out nocopy  NUMBER
    , p9_a4 in out nocopy  VARCHAR2
    , p9_a5 in out nocopy  NUMBER
    , p9_a6 in out nocopy  NUMBER
    , p9_a7 in out nocopy  DATE
    , p9_a8 in out nocopy  NUMBER
    , p9_a9 in out nocopy  DATE
    , p9_a10 in out nocopy  NUMBER
    , p9_a11 in out nocopy  NUMBER
    , p9_a12 in out nocopy  VARCHAR2
    , p9_a13 in out nocopy  VARCHAR2
    , p9_a14 in out nocopy  VARCHAR2
    , p9_a15 in out nocopy  VARCHAR2
    , p9_a16 in out nocopy  VARCHAR2
    , p9_a17 in out nocopy  VARCHAR2
    , p9_a18 in out nocopy  VARCHAR2
    , p9_a19 in out nocopy  VARCHAR2
    , p9_a20 in out nocopy  VARCHAR2
    , p9_a21 in out nocopy  VARCHAR2
    , p9_a22 in out nocopy  VARCHAR2
    , p9_a23 in out nocopy  VARCHAR2
    , p9_a24 in out nocopy  VARCHAR2
    , p9_a25 in out nocopy  VARCHAR2
    , p9_a26 in out nocopy  VARCHAR2
    , p9_a27 in out nocopy  VARCHAR2
  )

  as
    ddp_x_reliability_data_rec ahl_ra_setups_pvt.ra_definition_hdr_rec_type;
Line: 800

    ddp_x_reliability_data_rec.last_update_date := p8_a11;
Line: 801

    ddp_x_reliability_data_rec.last_updated_by := p8_a12;
Line: 802

    ddp_x_reliability_data_rec.last_update_login := p8_a13;
Line: 829

    ddp_x_mtbf_data_rec.last_update_date := p9_a9;
Line: 830

    ddp_x_mtbf_data_rec.last_updated_by := p9_a10;
Line: 831

    ddp_x_mtbf_data_rec.last_update_login := p9_a11;
Line: 850

    ahl_ra_setups_pvt.update_mtbf_data(p_api_version,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      p_module_type,
      x_return_status,
      x_msg_count,
      x_msg_data,
      ddp_x_reliability_data_rec,
      ddp_x_mtbf_data_rec);
Line: 881

    p8_a11 := ddp_x_reliability_data_rec.last_update_date;
Line: 882

    p8_a12 := ddp_x_reliability_data_rec.last_updated_by;
Line: 883

    p8_a13 := ddp_x_reliability_data_rec.last_update_login;
Line: 910

    p9_a9 := ddp_x_mtbf_data_rec.last_update_date;
Line: 911

    p9_a10 := ddp_x_mtbf_data_rec.last_updated_by;
Line: 912

    p9_a11 := ddp_x_mtbf_data_rec.last_update_login;
Line: 931

  procedure delete_mtbf_data(p_api_version  NUMBER
    , p_init_msg_list  VARCHAR2
    , p_commit  VARCHAR2
    , p_validation_level  NUMBER
    , p_module_type  VARCHAR2
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
    , p8_a0 in out nocopy  NUMBER
    , p8_a1 in out nocopy  NUMBER
    , p8_a2 in out nocopy  NUMBER
    , p8_a3 in out nocopy  NUMBER
    , p8_a4 in out nocopy  VARCHAR2
    , p8_a5 in out nocopy  NUMBER
    , p8_a6 in out nocopy  VARCHAR2
    , p8_a7 in out nocopy  NUMBER
    , p8_a8 in out nocopy  NUMBER
    , p8_a9 in out nocopy  DATE
    , p8_a10 in out nocopy  NUMBER
    , p8_a11 in out nocopy  DATE
    , p8_a12 in out nocopy  NUMBER
    , p8_a13 in out nocopy  NUMBER
    , p8_a14 in out nocopy  VARCHAR2
    , p8_a15 in out nocopy  VARCHAR2
    , p8_a16 in out nocopy  VARCHAR2
    , p8_a17 in out nocopy  VARCHAR2
    , p8_a18 in out nocopy  VARCHAR2
    , p8_a19 in out nocopy  VARCHAR2
    , p8_a20 in out nocopy  VARCHAR2
    , p8_a21 in out nocopy  VARCHAR2
    , p8_a22 in out nocopy  VARCHAR2
    , p8_a23 in out nocopy  VARCHAR2
    , p8_a24 in out nocopy  VARCHAR2
    , p8_a25 in out nocopy  VARCHAR2
    , p8_a26 in out nocopy  VARCHAR2
    , p8_a27 in out nocopy  VARCHAR2
    , p8_a28 in out nocopy  VARCHAR2
    , p8_a29 in out nocopy  VARCHAR2
    , p9_a0  NUMBER
    , p9_a1  NUMBER
    , p9_a2  NUMBER
    , p9_a3  NUMBER
    , p9_a4  VARCHAR2
    , p9_a5  NUMBER
    , p9_a6  NUMBER
    , p9_a7  DATE
    , p9_a8  NUMBER
    , p9_a9  DATE
    , p9_a10  NUMBER
    , p9_a11  NUMBER
    , p9_a12  VARCHAR2
    , p9_a13  VARCHAR2
    , p9_a14  VARCHAR2
    , p9_a15  VARCHAR2
    , p9_a16  VARCHAR2
    , p9_a17  VARCHAR2
    , p9_a18  VARCHAR2
    , p9_a19  VARCHAR2
    , p9_a20  VARCHAR2
    , p9_a21  VARCHAR2
    , p9_a22  VARCHAR2
    , p9_a23  VARCHAR2
    , p9_a24  VARCHAR2
    , p9_a25  VARCHAR2
    , p9_a26  VARCHAR2
    , p9_a27  VARCHAR2
  )

  as
    ddp_x_reliability_data_rec ahl_ra_setups_pvt.ra_definition_hdr_rec_type;
Line: 1025

    ddp_x_reliability_data_rec.last_update_date := p8_a11;
Line: 1026

    ddp_x_reliability_data_rec.last_updated_by := p8_a12;
Line: 1027

    ddp_x_reliability_data_rec.last_update_login := p8_a13;
Line: 1054

    ddp_mtbf_data_rec.last_update_date := p9_a9;
Line: 1055

    ddp_mtbf_data_rec.last_updated_by := p9_a10;
Line: 1056

    ddp_mtbf_data_rec.last_update_login := p9_a11;
Line: 1075

    ahl_ra_setups_pvt.delete_mtbf_data(p_api_version,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      p_module_type,
      x_return_status,
      x_msg_count,
      x_msg_data,
      ddp_x_reliability_data_rec,
      ddp_mtbf_data_rec);
Line: 1106

    p8_a11 := ddp_x_reliability_data_rec.last_update_date;
Line: 1107

    p8_a12 := ddp_x_reliability_data_rec.last_updated_by;
Line: 1108

    p8_a13 := ddp_x_reliability_data_rec.last_update_login;
Line: 1189

    ddp_x_counter_assoc_rec.last_update_date := p8_a9;
Line: 1190

    ddp_x_counter_assoc_rec.last_updated_by := p8_a10;
Line: 1191

    ddp_x_counter_assoc_rec.last_update_login := p8_a11;
Line: 1238

    p8_a9 := ddp_x_counter_assoc_rec.last_update_date;
Line: 1239

    p8_a10 := ddp_x_counter_assoc_rec.last_updated_by;
Line: 1240

    p8_a11 := ddp_x_counter_assoc_rec.last_update_login;
Line: 1259

  procedure delete_counter_assoc(p_api_version  NUMBER
    , p_init_msg_list  VARCHAR2
    , p_commit  VARCHAR2
    , p_validation_level  NUMBER
    , p_module_type  VARCHAR2
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
    , p8_a0  NUMBER
    , p8_a1  NUMBER
    , p8_a2  NUMBER
    , p8_a3  VARCHAR2
    , p8_a4  VARCHAR2
    , p8_a5  NUMBER
    , p8_a6  NUMBER
    , p8_a7  DATE
    , p8_a8  NUMBER
    , p8_a9  DATE
    , p8_a10  NUMBER
    , p8_a11  NUMBER
    , p8_a12  VARCHAR2
    , p8_a13  VARCHAR2
    , p8_a14  VARCHAR2
    , p8_a15  VARCHAR2
    , p8_a16  VARCHAR2
    , p8_a17  VARCHAR2
    , p8_a18  VARCHAR2
    , p8_a19  VARCHAR2
    , p8_a20  VARCHAR2
    , p8_a21  VARCHAR2
    , p8_a22  VARCHAR2
    , p8_a23  VARCHAR2
    , p8_a24  VARCHAR2
    , p8_a25  VARCHAR2
    , p8_a26  VARCHAR2
    , p8_a27  VARCHAR2
  )

  as
    ddp_counter_assoc_rec ahl_ra_setups_pvt.ra_counter_assoc_rec_type;
Line: 1320

    ddp_counter_assoc_rec.last_update_date := p8_a9;
Line: 1321

    ddp_counter_assoc_rec.last_updated_by := p8_a10;
Line: 1322

    ddp_counter_assoc_rec.last_update_login := p8_a11;
Line: 1341

    ahl_ra_setups_pvt.delete_counter_assoc(p_api_version,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      p_module_type,
      x_return_status,
      x_msg_count,
      x_msg_data,
      ddp_counter_assoc_rec);
Line: 1427

    ddp_x_fct_assoc_rec.last_update_date := p8_a11;
Line: 1428

    ddp_x_fct_assoc_rec.last_updated_by := p8_a12;
Line: 1429

    ddp_x_fct_assoc_rec.last_update_login := p8_a13;
Line: 1478

    p8_a11 := ddp_x_fct_assoc_rec.last_update_date;
Line: 1479

    p8_a12 := ddp_x_fct_assoc_rec.last_updated_by;
Line: 1480

    p8_a13 := ddp_x_fct_assoc_rec.last_update_login;
Line: 1499

  procedure update_fct_assoc_data(p_api_version  NUMBER
    , p_init_msg_list  VARCHAR2
    , p_commit  VARCHAR2
    , p_validation_level  NUMBER
    , p_module_type  VARCHAR2
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
    , p8_a0 in out nocopy  NUMBER
    , p8_a1 in out nocopy  VARCHAR2
    , p8_a2 in out nocopy  VARCHAR2
    , p8_a3 in out nocopy  NUMBER
    , p8_a4 in out nocopy  NUMBER
    , p8_a5 in out nocopy  NUMBER
    , p8_a6 in out nocopy  VARCHAR2
    , p8_a7 in out nocopy  NUMBER
    , p8_a8 in out nocopy  NUMBER
    , p8_a9 in out nocopy  DATE
    , p8_a10 in out nocopy  NUMBER
    , p8_a11 in out nocopy  DATE
    , p8_a12 in out nocopy  NUMBER
    , p8_a13 in out nocopy  NUMBER
    , p8_a14 in out nocopy  VARCHAR2
    , p8_a15 in out nocopy  VARCHAR2
    , p8_a16 in out nocopy  VARCHAR2
    , p8_a17 in out nocopy  VARCHAR2
    , p8_a18 in out nocopy  VARCHAR2
    , p8_a19 in out nocopy  VARCHAR2
    , p8_a20 in out nocopy  VARCHAR2
    , p8_a21 in out nocopy  VARCHAR2
    , p8_a22 in out nocopy  VARCHAR2
    , p8_a23 in out nocopy  VARCHAR2
    , p8_a24 in out nocopy  VARCHAR2
    , p8_a25 in out nocopy  VARCHAR2
    , p8_a26 in out nocopy  VARCHAR2
    , p8_a27 in out nocopy  VARCHAR2
    , p8_a28 in out nocopy  VARCHAR2
    , p8_a29 in out nocopy  VARCHAR2
  )

  as
    ddp_x_fct_assoc_rec ahl_ra_setups_pvt.ra_fct_assoc_rec_type;
Line: 1564

    ddp_x_fct_assoc_rec.last_update_date := p8_a11;
Line: 1565

    ddp_x_fct_assoc_rec.last_updated_by := p8_a12;
Line: 1566

    ddp_x_fct_assoc_rec.last_update_login := p8_a13;
Line: 1585

    ahl_ra_setups_pvt.update_fct_assoc_data(p_api_version,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      p_module_type,
      x_return_status,
      x_msg_count,
      x_msg_data,
      ddp_x_fct_assoc_rec);
Line: 1615

    p8_a11 := ddp_x_fct_assoc_rec.last_update_date;
Line: 1616

    p8_a12 := ddp_x_fct_assoc_rec.last_updated_by;
Line: 1617

    p8_a13 := ddp_x_fct_assoc_rec.last_update_login;
Line: 1636

  procedure delete_fct_assoc_data(p_api_version  NUMBER
    , p_init_msg_list  VARCHAR2
    , p_commit  VARCHAR2
    , p_validation_level  NUMBER
    , p_module_type  VARCHAR2
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
    , p8_a0  NUMBER
    , p8_a1  VARCHAR2
    , p8_a2  VARCHAR2
    , p8_a3  NUMBER
    , p8_a4  NUMBER
    , p8_a5  NUMBER
    , p8_a6  VARCHAR2
    , p8_a7  NUMBER
    , p8_a8  NUMBER
    , p8_a9  DATE
    , p8_a10  NUMBER
    , p8_a11  DATE
    , p8_a12  NUMBER
    , p8_a13  NUMBER
    , p8_a14  VARCHAR2
    , p8_a15  VARCHAR2
    , p8_a16  VARCHAR2
    , p8_a17  VARCHAR2
    , p8_a18  VARCHAR2
    , p8_a19  VARCHAR2
    , p8_a20  VARCHAR2
    , p8_a21  VARCHAR2
    , p8_a22  VARCHAR2
    , p8_a23  VARCHAR2
    , p8_a24  VARCHAR2
    , p8_a25  VARCHAR2
    , p8_a26  VARCHAR2
    , p8_a27  VARCHAR2
    , p8_a28  VARCHAR2
    , p8_a29  VARCHAR2
  )

  as
    ddp_fct_assoc_rec ahl_ra_setups_pvt.ra_fct_assoc_rec_type;
Line: 1701

    ddp_fct_assoc_rec.last_update_date := p8_a11;
Line: 1702

    ddp_fct_assoc_rec.last_updated_by := p8_a12;
Line: 1703

    ddp_fct_assoc_rec.last_update_login := p8_a13;
Line: 1722

    ahl_ra_setups_pvt.delete_fct_assoc_data(p_api_version,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      p_module_type,
      x_return_status,
      x_msg_count,
      x_msg_data,
      ddp_fct_assoc_rec);