DBA Data[Home] [Help]

APPS.AHL_VWP_TASK_CST_PR_PVT_W SQL Statements

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

Line: 112

    ddp_x_cost_price_rec.is_cst_struc_updated := p5_a15;
Line: 138

    ddp_x_cost_price_rec.last_updated_by := p5_a41;
Line: 139

    ddp_x_cost_price_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a42);
Line: 140

    ddp_x_cost_price_rec.last_update_login := p5_a43;
Line: 193

    p5_a15 := ddp_x_cost_price_rec.is_cst_struc_updated;
Line: 219

    p5_a41 := ddp_x_cost_price_rec.last_updated_by;
Line: 220

    p5_a42 := ddp_x_cost_price_rec.last_update_date;
Line: 221

    p5_a43 := ddp_x_cost_price_rec.last_update_login;
Line: 339

    ddp_x_cost_price_rec.is_cst_struc_updated := p5_a15;
Line: 365

    ddp_x_cost_price_rec.last_updated_by := p5_a41;
Line: 366

    ddp_x_cost_price_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a42);
Line: 367

    ddp_x_cost_price_rec.last_update_login := p5_a43;
Line: 420

    p5_a15 := ddp_x_cost_price_rec.is_cst_struc_updated;
Line: 446

    p5_a41 := ddp_x_cost_price_rec.last_updated_by;
Line: 447

    p5_a42 := ddp_x_cost_price_rec.last_update_date;
Line: 448

    p5_a43 := ddp_x_cost_price_rec.last_update_login;
Line: 566

    ddp_x_cost_price_rec.is_cst_struc_updated := p5_a15;
Line: 592

    ddp_x_cost_price_rec.last_updated_by := p5_a41;
Line: 593

    ddp_x_cost_price_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a42);
Line: 594

    ddp_x_cost_price_rec.last_update_login := p5_a43;
Line: 647

    p5_a15 := ddp_x_cost_price_rec.is_cst_struc_updated;
Line: 673

    p5_a41 := ddp_x_cost_price_rec.last_updated_by;
Line: 674

    p5_a42 := ddp_x_cost_price_rec.last_update_date;
Line: 675

    p5_a43 := ddp_x_cost_price_rec.last_update_login;
Line: 697

  procedure update_task_cost_details(p_api_version  NUMBER
    , p_init_msg_list  VARCHAR2
    , p_commit  VARCHAR2
    , p_validation_level  NUMBER
    , p_module_type  VARCHAR2
    , p5_a0  NUMBER
    , p5_a1  NUMBER
    , p5_a2  NUMBER
    , p5_a3  NUMBER
    , p5_a4  NUMBER
    , p5_a5  NUMBER
    , p5_a6  NUMBER
    , p5_a7  VARCHAR2
    , p5_a8  NUMBER
    , p5_a9  NUMBER
    , p5_a10  NUMBER
    , p5_a11  NUMBER
    , p5_a12  VARCHAR2
    , p5_a13  VARCHAR2
    , p5_a14  VARCHAR2
    , p5_a15  VARCHAR2
    , p5_a16  NUMBER
    , p5_a17  VARCHAR2
    , p5_a18  NUMBER
    , p5_a19  NUMBER
    , p5_a20  NUMBER
    , p5_a21  DATE
    , p5_a22  DATE
    , p5_a23  DATE
    , p5_a24  DATE
    , p5_a25  DATE
    , p5_a26  DATE
    , p5_a27  VARCHAR2
    , p5_a28  NUMBER
    , p5_a29  VARCHAR2
    , p5_a30  VARCHAR2
    , p5_a31  NUMBER
    , p5_a32  VARCHAR2
    , p5_a33  VARCHAR2
    , p5_a34  VARCHAR2
    , p5_a35  NUMBER
    , p5_a36  VARCHAR2
    , p5_a37  NUMBER
    , p5_a38  NUMBER
    , p5_a39  NUMBER
    , p5_a40  DATE
    , p5_a41  NUMBER
    , p5_a42  DATE
    , p5_a43  NUMBER
    , p5_a44  VARCHAR2
    , p5_a45  VARCHAR2
    , p5_a46  VARCHAR2
    , p5_a47  VARCHAR2
    , p5_a48  VARCHAR2
    , 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
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
  )

  as
    ddp_cost_price_rec ahl_vwp_visit_cst_pr_pvt.cost_price_rec_type;
Line: 793

    ddp_cost_price_rec.is_cst_struc_updated := p5_a15;
Line: 819

    ddp_cost_price_rec.last_updated_by := p5_a41;
Line: 820

    ddp_cost_price_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a42);
Line: 821

    ddp_cost_price_rec.last_update_login := p5_a43;
Line: 843

    ahl_vwp_task_cst_pr_pvt.update_task_cost_details(p_api_version,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      p_module_type,
      ddp_cost_price_rec,
      x_return_status,
      x_msg_count,
      x_msg_data);
Line: 963

    ddp_x_cost_price_rec.is_cst_struc_updated := p8_a15;
Line: 989

    ddp_x_cost_price_rec.last_updated_by := p8_a41;
Line: 990

    ddp_x_cost_price_rec.last_update_date := rosetta_g_miss_date_in_map(p8_a42);
Line: 991

    ddp_x_cost_price_rec.last_update_login := p8_a43;
Line: 1044

    p8_a15 := ddp_x_cost_price_rec.is_cst_struc_updated;
Line: 1070

    p8_a41 := ddp_x_cost_price_rec.last_updated_by;
Line: 1071

    p8_a42 := ddp_x_cost_price_rec.last_update_date;
Line: 1072

    p8_a43 := ddp_x_cost_price_rec.last_update_login;
Line: 1251

    ddp_cost_price_rec.is_cst_struc_updated := p8_a15;
Line: 1277

    ddp_cost_price_rec.last_updated_by := p8_a41;
Line: 1278

    ddp_cost_price_rec.last_update_date := rosetta_g_miss_date_in_map(p8_a42);
Line: 1279

    ddp_cost_price_rec.last_update_login := p8_a43;