APPS.AHL_WF_MAPPING_PVT_W SQL Statements

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

Line: 43

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

Line: 44

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

Line: 45

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

Line: 136

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

Line: 137

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

Line: 138

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

Line: 286

    ddp_wf_mapping_rec.last_update_date := rosetta_g_miss_date_in_map(p4_a4);

Line: 287

    ddp_wf_mapping_rec.last_updated_by := p4_a5;

Line: 288

    ddp_wf_mapping_rec.last_update_login := p4_a6;

Line: 324

  procedure update_wf_mapping(p_api_version  NUMBER
    , p_init_msg_list  VARCHAR2
    , p_commit  VARCHAR2
    , p_validation_level  NUMBER
    , p4_a0  NUMBER
    , p4_a1  NUMBER
    , p4_a2  DATE
    , p4_a3  NUMBER
    , p4_a4  DATE
    , p4_a5  NUMBER
    , p4_a6  NUMBER
    , p4_a7  VARCHAR2
    , p4_a8  VARCHAR2
    , p4_a9  VARCHAR2
    , p4_a10  VARCHAR2
    , p4_a11  VARCHAR2
    , p4_a12  VARCHAR2
    , p4_a13  VARCHAR2
    , p4_a14  VARCHAR2
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
  )

  as
    ddp_wf_mapping_rec ahl_wf_mapping_pvt.wf_mapping_rec_type;

Line: 362

    ddp_wf_mapping_rec.last_update_date := rosetta_g_miss_date_in_map(p4_a4);

Line: 363

    ddp_wf_mapping_rec.last_updated_by := p4_a5;

Line: 364

    ddp_wf_mapping_rec.last_update_login := p4_a6;

Line: 378

    ahl_wf_mapping_pvt.update_wf_mapping(p_api_version,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      ddp_wf_mapping_rec,
      x_return_status,
      x_msg_count,
      x_msg_data);

Line: 438

    ddp_wf_mapping_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a4);

Line: 439

    ddp_wf_mapping_rec.last_updated_by := p7_a5;

Line: 440

    ddp_wf_mapping_rec.last_update_login := p7_a6;

Line: 499

    ddp_wf_mapping_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a4);

Line: 500

    ddp_wf_mapping_rec.last_updated_by := p0_a5;

Line: 501

    ddp_wf_mapping_rec.last_update_login := p0_a6;

Line: 566

    ddp_wf_mapping_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a4);

Line: 567

    ddp_wf_mapping_rec.last_updated_by := p0_a5;

Line: 568

    ddp_wf_mapping_rec.last_update_login := p0_a6;

Line: 589

    p1_a4 := ddx_complete_rec.last_update_date;

Line: 590

    p1_a5 := ddx_complete_rec.last_updated_by;

Line: 591

    p1_a6 := ddx_complete_rec.last_update_login;