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: 117

    ddp_x_cost_price_rec.is_cst_struc_updated := p5_a15;
Line: 148

    ddp_x_cost_price_rec.last_updated_by := p5_a46;
Line: 149

    ddp_x_cost_price_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a47);
Line: 150

    ddp_x_cost_price_rec.last_update_login := p5_a48;
Line: 203

    p5_a15 := ddp_x_cost_price_rec.is_cst_struc_updated;
Line: 234

    p5_a46 := ddp_x_cost_price_rec.last_updated_by;
Line: 235

    p5_a47 := ddp_x_cost_price_rec.last_update_date;
Line: 236

    p5_a48 := ddp_x_cost_price_rec.last_update_login;
Line: 359

    ddp_x_cost_price_rec.is_cst_struc_updated := p5_a15;
Line: 390

    ddp_x_cost_price_rec.last_updated_by := p5_a46;
Line: 391

    ddp_x_cost_price_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a47);
Line: 392

    ddp_x_cost_price_rec.last_update_login := p5_a48;
Line: 445

    p5_a15 := ddp_x_cost_price_rec.is_cst_struc_updated;
Line: 476

    p5_a46 := ddp_x_cost_price_rec.last_updated_by;
Line: 477

    p5_a47 := ddp_x_cost_price_rec.last_update_date;
Line: 478

    p5_a48 := ddp_x_cost_price_rec.last_update_login;
Line: 601

    ddp_x_cost_price_rec.is_cst_struc_updated := p5_a15;
Line: 632

    ddp_x_cost_price_rec.last_updated_by := p5_a46;
Line: 633

    ddp_x_cost_price_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a47);
Line: 634

    ddp_x_cost_price_rec.last_update_login := p5_a48;
Line: 687

    p5_a15 := ddp_x_cost_price_rec.is_cst_struc_updated;
Line: 718

    p5_a46 := ddp_x_cost_price_rec.last_updated_by;
Line: 719

    p5_a47 := ddp_x_cost_price_rec.last_update_date;
Line: 720

    p5_a48 := ddp_x_cost_price_rec.last_update_login;
Line: 742

  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  VARCHAR2
    , p5_a41  VARCHAR2
    , p5_a42  VARCHAR2
    , p5_a43  DATE
    , 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
    , 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: 843

    ddp_cost_price_rec.is_cst_struc_updated := p5_a15;
Line: 874

    ddp_cost_price_rec.last_updated_by := p5_a46;
Line: 875

    ddp_cost_price_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a47);
Line: 876

    ddp_cost_price_rec.last_update_login := p5_a48;
Line: 898

    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: 1023

    ddp_x_cost_price_rec.is_cst_struc_updated := p8_a15;
Line: 1054

    ddp_x_cost_price_rec.last_updated_by := p8_a46;
Line: 1055

    ddp_x_cost_price_rec.last_update_date := rosetta_g_miss_date_in_map(p8_a47);
Line: 1056

    ddp_x_cost_price_rec.last_update_login := p8_a48;
Line: 1109

    p8_a15 := ddp_x_cost_price_rec.is_cst_struc_updated;
Line: 1140

    p8_a46 := ddp_x_cost_price_rec.last_updated_by;
Line: 1141

    p8_a47 := ddp_x_cost_price_rec.last_update_date;
Line: 1142

    p8_a48 := ddp_x_cost_price_rec.last_update_login;
Line: 1331

    ddp_cost_price_rec.is_cst_struc_updated := p8_a15;
Line: 1362

    ddp_cost_price_rec.last_updated_by := p8_a46;
Line: 1363

    ddp_cost_price_rec.last_update_date := rosetta_g_miss_date_in_map(p8_a47);
Line: 1364

    ddp_cost_price_rec.last_update_login := p8_a48;