DBA Data[Home] [Help]

APPS.IEX_SCORE_PUB_W SQL Statements

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

Line: 112

          t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a2(indx));
Line: 113

          t(ddindx).last_updated_by := a3(indx);
Line: 116

          t(ddindx).last_update_login := a6(indx);
Line: 129

          t(ddindx).program_update_date := rosetta_g_miss_date_in_map(a19(indx));
Line: 255

          a2(indx) := t(ddindx).last_update_date;
Line: 256

          a3(indx) := t(ddindx).last_updated_by;
Line: 259

          a6(indx) := t(ddindx).last_update_login;
Line: 272

          a19(indx) := t(ddindx).program_update_date;
Line: 311

          t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a5(indx));
Line: 312

          t(ddindx).last_updated_by := a6(indx);
Line: 315

          t(ddindx).last_update_login := a9(indx);
Line: 379

          a5(indx) := t(ddindx).last_update_date;
Line: 380

          a6(indx) := t(ddindx).last_updated_by;
Line: 383

          a9(indx) := t(ddindx).last_update_login;
Line: 423

          t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a8(indx));
Line: 424

          t(ddindx).last_updated_by := a9(indx);
Line: 427

          t(ddindx).last_update_login := a12(indx);
Line: 506

          a8(indx) := t(ddindx).last_update_date;
Line: 507

          a9(indx) := t(ddindx).last_updated_by;
Line: 510

          a12(indx) := t(ddindx).last_update_login;
Line: 551

          t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a4(indx));
Line: 552

          t(ddindx).last_updated_by := a5(indx);
Line: 553

          t(ddindx).last_update_login := a6(indx);
Line: 659

          a4(indx) := t(ddindx).last_update_date;
Line: 660

          a5(indx) := t(ddindx).last_updated_by;
Line: 661

          a6(indx) := t(ddindx).last_update_login;
Line: 852

    ddp_score_rec.last_update_date := rosetta_g_miss_date_in_map(p3_a2);
Line: 853

    ddp_score_rec.last_updated_by := p3_a3;
Line: 856

    ddp_score_rec.last_update_login := p3_a6;
Line: 869

    ddp_score_rec.program_update_date := rosetta_g_miss_date_in_map(p3_a19);
Line: 903

  procedure update_score(p_api_version  NUMBER
    , p_init_msg_list  VARCHAR2
    , p_commit  VARCHAR2
    , p3_a0 JTF_NUMBER_TABLE
    , p3_a1 JTF_VARCHAR2_TABLE_300
    , p3_a2 JTF_DATE_TABLE
    , p3_a3 JTF_NUMBER_TABLE
    , p3_a4 JTF_DATE_TABLE
    , p3_a5 JTF_NUMBER_TABLE
    , p3_a6 JTF_NUMBER_TABLE
    , p3_a7 JTF_VARCHAR2_TABLE_200
    , p3_a8 JTF_VARCHAR2_TABLE_100
    , p3_a9 JTF_DATE_TABLE
    , p3_a10 JTF_DATE_TABLE
    , p3_a11 JTF_NUMBER_TABLE
    , p3_a12 JTF_VARCHAR2_TABLE_100
    , p3_a13 JTF_NUMBER_TABLE
    , p3_a14 JTF_VARCHAR2_TABLE_100
    , p3_a15 JTF_NUMBER_TABLE
    , p3_a16 JTF_NUMBER_TABLE
    , p3_a17 JTF_NUMBER_TABLE
    , p3_a18 JTF_NUMBER_TABLE
    , p3_a19 JTF_DATE_TABLE
    , p3_a20 JTF_VARCHAR2_TABLE_100
    , p3_a21 JTF_VARCHAR2_TABLE_100
    , p3_a22 JTF_VARCHAR2_TABLE_1000
    , p3_a23 JTF_VARCHAR2_TABLE_1000
    , p3_a24 JTF_VARCHAR2_TABLE_100
    , x_dup_status out nocopy  VARCHAR2
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
  )

  as
    ddp_score_tbl iex_score_pub.score_tbl_type;
Line: 978

    iex_score_pub.update_score(p_api_version,
      p_init_msg_list,
      p_commit,
      ddp_score_tbl,
      x_dup_status,
      x_return_status,
      x_msg_count,
      x_msg_data);
Line: 997

  procedure delete_score(p_api_version  NUMBER
    , p_init_msg_list  VARCHAR2
    , p_commit  VARCHAR2
    , p_score_id_tbl JTF_NUMBER_TABLE
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
  )

  as
    ddp_score_id_tbl iex_score_pub.score_id_tbl;
Line: 1021

    iex_score_pub.delete_score(p_api_version,
      p_init_msg_list,
      p_commit,
      ddp_score_id_tbl,
      x_return_status,
      x_msg_count,
      x_msg_data);
Line: 1071

    ddp_score_comp_rec.last_update_date := rosetta_g_miss_date_in_map(p3_a5);
Line: 1072

    ddp_score_comp_rec.last_updated_by := p3_a6;
Line: 1075

    ddp_score_comp_rec.last_update_login := p3_a9;
Line: 1101

  procedure update_score_comp(p_api_version  NUMBER
    , p_init_msg_list  VARCHAR2
    , p_commit  VARCHAR2
    , p3_a0 JTF_NUMBER_TABLE
    , p3_a1 JTF_NUMBER_TABLE
    , p3_a2 JTF_NUMBER_TABLE
    , p3_a3 JTF_VARCHAR2_TABLE_100
    , p3_a4 JTF_NUMBER_TABLE
    , p3_a5 JTF_DATE_TABLE
    , p3_a6 JTF_NUMBER_TABLE
    , p3_a7 JTF_DATE_TABLE
    , p3_a8 JTF_NUMBER_TABLE
    , p3_a9 JTF_NUMBER_TABLE
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
  )

  as
    ddp_score_comp_tbl iex_score_pub.score_comp_tbl_type;
Line: 1144

    iex_score_pub.update_score_comp(p_api_version,
      p_init_msg_list,
      p_commit,
      ddp_score_comp_tbl,
      x_return_status,
      x_msg_count,
      x_msg_data);
Line: 1161

  procedure delete_score_comp(p_api_version  NUMBER
    , p_init_msg_list  VARCHAR2
    , p_commit  VARCHAR2
    , p_score_id  NUMBER
    , p_score_comp_id_tbl JTF_NUMBER_TABLE
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
  )

  as
    ddp_score_comp_id_tbl iex_score_pub.score_comp_id_tbl;
Line: 1187

    iex_score_pub.delete_score_comp(p_api_version,
      p_init_msg_list,
      p_commit,
      p_score_id,
      ddp_score_comp_id_tbl,
      x_return_status,
      x_msg_count,
      x_msg_data);
Line: 1247

    ddp_score_comp_type_rec.last_update_date := rosetta_g_miss_date_in_map(p3_a4);
Line: 1248

    ddp_score_comp_type_rec.last_updated_by := p3_a5;
Line: 1249

    ddp_score_comp_type_rec.last_update_login := p3_a6;
Line: 1289

  procedure update_score_comp_type(p_api_version  NUMBER
    , p_init_msg_list  VARCHAR2
    , p_commit  VARCHAR2
    , p3_a0 JTF_NUMBER_TABLE
    , p3_a1 JTF_NUMBER_TABLE
    , p3_a2 JTF_NUMBER_TABLE
    , p3_a3 JTF_NUMBER_TABLE
    , p3_a4 JTF_DATE_TABLE
    , p3_a5 JTF_NUMBER_TABLE
    , p3_a6 JTF_NUMBER_TABLE
    , p3_a7 JTF_DATE_TABLE
    , p3_a8 JTF_NUMBER_TABLE
    , p3_a9 JTF_VARCHAR2_TABLE_2000
    , p3_a10 JTF_VARCHAR2_TABLE_100
    , p3_a11 JTF_VARCHAR2_TABLE_100
    , p3_a12 JTF_VARCHAR2_TABLE_100
    , p3_a13 JTF_VARCHAR2_TABLE_100
    , p3_a14 JTF_VARCHAR2_TABLE_100
    , p3_a15 JTF_VARCHAR2_TABLE_100
    , p3_a16 JTF_VARCHAR2_TABLE_100
    , p3_a17 JTF_NUMBER_TABLE
    , x_dup_status out nocopy  VARCHAR2
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
  )

  as
    ddp_score_comp_type_tbl iex_score_pub.score_comp_type_tbl_type;
Line: 1350

    iex_score_pub.update_score_comp_type(p_api_version,
      p_init_msg_list,
      p_commit,
      ddp_score_comp_type_tbl,
      x_dup_status,
      x_return_status,
      x_msg_count,
      x_msg_data);
Line: 1369

  procedure delete_score_comp_type(p_api_version  NUMBER
    , p_init_msg_list  VARCHAR2
    , p_commit  VARCHAR2
    , p3_a0 JTF_NUMBER_TABLE
    , p3_a1 JTF_NUMBER_TABLE
    , p3_a2 JTF_NUMBER_TABLE
    , p3_a3 JTF_NUMBER_TABLE
    , p3_a4 JTF_DATE_TABLE
    , p3_a5 JTF_NUMBER_TABLE
    , p3_a6 JTF_NUMBER_TABLE
    , p3_a7 JTF_DATE_TABLE
    , p3_a8 JTF_NUMBER_TABLE
    , p3_a9 JTF_VARCHAR2_TABLE_2000
    , p3_a10 JTF_VARCHAR2_TABLE_100
    , p3_a11 JTF_VARCHAR2_TABLE_100
    , p3_a12 JTF_VARCHAR2_TABLE_100
    , p3_a13 JTF_VARCHAR2_TABLE_100
    , p3_a14 JTF_VARCHAR2_TABLE_100
    , p3_a15 JTF_VARCHAR2_TABLE_100
    , p3_a16 JTF_VARCHAR2_TABLE_100
    , p3_a17 JTF_NUMBER_TABLE
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
  )

  as
    ddp_score_comp_type_tbl iex_score_pub.score_comp_type_tbl_type;
Line: 1428

    iex_score_pub.delete_score_comp_type(p_api_version,
      p_init_msg_list,
      p_commit,
      ddp_score_comp_type_tbl,
      x_return_status,
      x_msg_count,
      x_msg_data);
Line: 1525

  procedure update_score_comp_det(p_api_version  NUMBER
    , p_init_msg_list  VARCHAR2
    , p_commit  VARCHAR2
    , p3_a0 JTF_NUMBER_TABLE
    , p3_a1 JTF_NUMBER_TABLE
    , p3_a2 JTF_NUMBER_TABLE
    , p3_a3 JTF_NUMBER_TABLE
    , p3_a4 JTF_VARCHAR2_TABLE_2000
    , p3_a5 JTF_NUMBER_TABLE
    , p3_a6 JTF_NUMBER_TABLE
    , p3_a7 JTF_NUMBER_TABLE
    , p3_a8 JTF_DATE_TABLE
    , p3_a9 JTF_NUMBER_TABLE
    , p3_a10 JTF_DATE_TABLE
    , p3_a11 JTF_NUMBER_TABLE
    , p3_a12 JTF_NUMBER_TABLE
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
  )

  as
    ddp_score_comp_det_tbl iex_score_pub.score_comp_det_tbl_type;
Line: 1574

    iex_score_pub.update_score_comp_det(p_api_version,
      p_init_msg_list,
      p_commit,
      ddp_score_comp_det_tbl,
      x_return_status,
      x_msg_count,
      x_msg_data);
Line: 1591

  procedure delete_score_comp_det(p_api_version  NUMBER
    , p_init_msg_list  VARCHAR2
    , p_commit  VARCHAR2
    , p_score_comp_id  NUMBER
    , p_score_comp_det_id_tbl JTF_NUMBER_TABLE
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
  )

  as
    ddp_score_comp_det_id_tbl iex_score_pub.score_comp_det_id_tbl;
Line: 1617

    iex_score_pub.delete_score_comp_det(p_api_version,
      p_init_msg_list,
      p_commit,
      p_score_comp_id,
      ddp_score_comp_det_id_tbl,
      x_return_status,
      x_msg_count,
      x_msg_data);