DBA Data[Home] [Help]

APPS.CSF_DEBRIEF_PUB_W SQL Statements

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

Line: 44

          t(ddindx).last_updated_by := a7(indx);
Line: 45

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

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

          a7(indx) := t(ddindx).last_updated_by;
Line: 193

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

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

          t(ddindx).ib_update_status := a38(indx);
Line: 336

          t(ddindx).ib_update_msg_code := a39(indx);
Line: 337

          t(ddindx).ib_update_message := a40(indx);
Line: 338

          t(ddindx).spare_update_status := a41(indx);
Line: 339

          t(ddindx).spare_update_msg_code := a42(indx);
Line: 340

          t(ddindx).spare_update_message := a43(indx);
Line: 343

          t(ddindx).last_updated_by := a46(indx);
Line: 344

          t(ddindx).last_update_date := a47(indx);
Line: 345

          t(ddindx).last_update_login := a48(indx);
Line: 693

          a38(indx) := t(ddindx).ib_update_status;
Line: 694

          a39(indx) := t(ddindx).ib_update_msg_code;
Line: 695

          a40(indx) := t(ddindx).ib_update_message;
Line: 696

          a41(indx) := t(ddindx).spare_update_status;
Line: 697

          a42(indx) := t(ddindx).spare_update_msg_code;
Line: 698

          a43(indx) := t(ddindx).spare_update_message;
Line: 701

          a46(indx) := t(ddindx).last_updated_by;
Line: 702

          a47(indx) := t(ddindx).last_update_date;
Line: 703

          a48(indx) := t(ddindx).last_update_login;
Line: 853

    ddp_debrief_rec.last_updated_by := p3_a7;
Line: 854

    ddp_debrief_rec.last_update_date := p3_a8;
Line: 855

    ddp_debrief_rec.last_update_login := p3_a9;
Line: 969

  procedure update_debrief(p_api_version_number  NUMBER
    , p_init_msg_list  VARCHAR2
    , p_commit  VARCHAR2
    , p3_a0  NUMBER
    , p3_a1  VARCHAR2
    , p3_a2  DATE
    , p3_a3  NUMBER
    , p3_a4  NUMBER
    , p3_a5  NUMBER
    , p3_a6  DATE
    , p3_a7  NUMBER
    , p3_a8  DATE
    , p3_a9  NUMBER
    , p3_a10  VARCHAR2
    , p3_a11  VARCHAR2
    , p3_a12  VARCHAR2
    , p3_a13  VARCHAR2
    , p3_a14  VARCHAR2
    , p3_a15  VARCHAR2
    , p3_a16  VARCHAR2
    , p3_a17  VARCHAR2
    , p3_a18  VARCHAR2
    , p3_a19  VARCHAR2
    , p3_a20  VARCHAR2
    , p3_a21  VARCHAR2
    , p3_a22  VARCHAR2
    , p3_a23  VARCHAR2
    , p3_a24  VARCHAR2
    , p3_a25  VARCHAR2
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
  )

  as
    ddp_debrief_rec csf_debrief_pub.debrief_rec_type;
Line: 1019

    ddp_debrief_rec.last_updated_by := p3_a7;
Line: 1020

    ddp_debrief_rec.last_update_date := p3_a8;
Line: 1021

    ddp_debrief_rec.last_update_login := p3_a9;
Line: 1043

    csf_debrief_pub.update_debrief(p_api_version_number,
      p_init_msg_list,
      p_commit,
      ddp_debrief_rec,
      x_return_status,
      x_msg_count,
      x_msg_data);
Line: 1252

  procedure update_debrief_line(p_api_version_number  NUMBER
    , p_init_msg_list  VARCHAR2
    , p_commit  VARCHAR2
    , p_upd_tskassgnstatus  VARCHAR2
    , p_task_assignment_status  VARCHAR2
    , p5_a0  NUMBER
    , p5_a1  NUMBER
    , p5_a2  NUMBER
    , p5_a3  DATE
    , p5_a4  NUMBER
    , p5_a5  NUMBER
    , p5_a6  NUMBER
    , p5_a7  NUMBER
    , p5_a8  NUMBER
    , p5_a9  NUMBER
    , p5_a10  VARCHAR2
    , p5_a11  VARCHAR2
    , p5_a12  NUMBER
    , p5_a13  NUMBER
    , p5_a14  NUMBER
    , p5_a15  NUMBER
    , p5_a16  VARCHAR2
    , p5_a17  VARCHAR2
    , p5_a18  VARCHAR2
    , p5_a19  VARCHAR2
    , p5_a20  VARCHAR2
    , p5_a21  NUMBER
    , p5_a22  NUMBER
    , p5_a23  VARCHAR2
    , p5_a24  VARCHAR2
    , p5_a25  VARCHAR2
    , p5_a26  VARCHAR2
    , p5_a27  DATE
    , p5_a28  DATE
    , p5_a29  NUMBER
    , p5_a30  NUMBER
    , p5_a31  NUMBER
    , p5_a32  VARCHAR2
    , p5_a33  NUMBER
    , p5_a34  VARCHAR2
    , p5_a35  VARCHAR2
    , p5_a36  VARCHAR2
    , p5_a37  VARCHAR2
    , p5_a38  VARCHAR2
    , p5_a39  VARCHAR2
    , p5_a40  VARCHAR2
    , p5_a41  VARCHAR2
    , p5_a42  VARCHAR2
    , p5_a43  VARCHAR2
    , p5_a44  NUMBER
    , p5_a45  DATE
    , p5_a46  NUMBER
    , p5_a47  DATE
    , p5_a48  NUMBER
    , p5_a49  VARCHAR2
    , p5_a50  VARCHAR2
    , p5_a51  VARCHAR2
    , p5_a52  VARCHAR2
    , p5_a53  VARCHAR2
    , p5_a54  VARCHAR2
    , p5_a55  VARCHAR2
    , p5_a56  VARCHAR2
    , p5_a57  VARCHAR2
    , p5_a58  VARCHAR2
    , p5_a59  VARCHAR2
    , p5_a60  VARCHAR2
    , p5_a61  VARCHAR2
    , p5_a62  VARCHAR2
    , p5_a63  VARCHAR2
    , p5_a64  VARCHAR2
    , p5_a65  VARCHAR2
    , p5_a66  NUMBER
    , p5_a67  DATE
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
  )

  as
    ddp_debrief_line_rec csf_debrief_pub.debrief_line_rec_type;
Line: 1379

    ddp_debrief_line_rec.ib_update_status := p5_a38;
Line: 1380

    ddp_debrief_line_rec.ib_update_msg_code := p5_a39;
Line: 1381

    ddp_debrief_line_rec.ib_update_message := p5_a40;
Line: 1382

    ddp_debrief_line_rec.spare_update_status := p5_a41;
Line: 1383

    ddp_debrief_line_rec.spare_update_msg_code := p5_a42;
Line: 1384

    ddp_debrief_line_rec.spare_update_message := p5_a43;
Line: 1387

    ddp_debrief_line_rec.last_updated_by := p5_a46;
Line: 1388

    ddp_debrief_line_rec.last_update_date := p5_a47;
Line: 1389

    ddp_debrief_line_rec.last_update_login := p5_a48;
Line: 1414

    csf_debrief_pub.update_debrief_line(p_api_version_number,
      p_init_msg_list,
      p_commit,
      p_upd_tskassgnstatus,
      p_task_assignment_status,
      ddp_debrief_line_rec,
      x_return_status,
      x_msg_count,
      x_msg_data);