eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_ACTMETRICFACT_PVT_W SQL Statements

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

Line: 135


    p0_a1 := ddx_fact_rec.last_update_date;

Line: 136


    p0_a2 := ddx_fact_rec.last_updated_by;

Line: 139


    p0_a5 := ddx_fact_rec.last_update_login;

Line: 370


    ddp_act_metric_fact_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);

Line: 371


    ddp_act_metric_fact_rec.last_updated_by := p7_a2;

Line: 374


    ddp_act_metric_fact_rec.last_update_login := p7_a5;

Line: 498


  procedure update_actmetricfact(p_api_version  NUMBER
    , p_init_msg_list  VARCHAR2
    , p_commit  VARCHAR2
    , p_validation_level  NUMBER
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
    , p7_a0  NUMBER
    , p7_a1  DATE
    , p7_a2  NUMBER
    , p7_a3  DATE
    , p7_a4  NUMBER
    , p7_a5  NUMBER
    , p7_a6  NUMBER
    , p7_a7  NUMBER
    , p7_a8  VARCHAR2
    , p7_a9  VARCHAR2
    , p7_a10  NUMBER
    , p7_a11  NUMBER
    , p7_a12  NUMBER
    , p7_a13  VARCHAR2
    , p7_a14  NUMBER
    , p7_a15  NUMBER
    , p7_a16  VARCHAR2
    , p7_a17  NUMBER
    , p7_a18  NUMBER
    , p7_a19  NUMBER
    , p7_a20  NUMBER
    , p7_a21  VARCHAR2
    , p7_a22  NUMBER
    , p7_a23  NUMBER
    , p7_a24  NUMBER
    , p7_a25  NUMBER
    , p7_a26  NUMBER
    , p7_a27  NUMBER
    , p7_a28  NUMBER
    , p7_a29  NUMBER
    , p7_a30  NUMBER
    , p7_a31  NUMBER
    , p7_a32  NUMBER
    , p7_a33  NUMBER
    , p7_a34  NUMBER
    , p7_a35  NUMBER
    , p7_a36  NUMBER
    , p7_a37  NUMBER
    , p7_a38  NUMBER
    , p7_a39  NUMBER
    , p7_a40  NUMBER
    , p7_a41  NUMBER
    , p7_a42  NUMBER
    , p7_a43  NUMBER
    , p7_a44  NUMBER
    , p7_a45  NUMBER
    , p7_a46  NUMBER
    , p7_a47  NUMBER
    , p7_a48  NUMBER
    , p7_a49  NUMBER
    , p7_a50  NUMBER
    , p7_a51  NUMBER
    , p7_a52  NUMBER
    , p7_a53  NUMBER
    , p7_a54  NUMBER
    , p7_a55  NUMBER
    , p7_a56  NUMBER
    , p7_a57  NUMBER
    , p7_a58  NUMBER
    , p7_a59  NUMBER
    , p7_a60  NUMBER
    , p7_a61  NUMBER
    , p7_a62  NUMBER
    , p7_a63  NUMBER
    , p7_a64  NUMBER
    , p7_a65  NUMBER
    , p7_a66  NUMBER
    , p7_a67  NUMBER
    , p7_a68  NUMBER
    , p7_a69  NUMBER
    , p7_a70  NUMBER
    , p7_a71  NUMBER
    , p7_a72  NUMBER
    , p7_a73  NUMBER
    , p7_a74  NUMBER
    , p7_a75  NUMBER
    , p7_a76  NUMBER
    , p7_a77  NUMBER
    , p7_a78  NUMBER
    , p7_a79  NUMBER
    , p7_a80  NUMBER
    , p7_a81  DATE
    , p7_a82  DATE
    , p7_a83  NUMBER
    , p7_a84  NUMBER
    , p7_a85  NUMBER
    , p7_a86  NUMBER
    , p7_a87  VARCHAR2
    , p7_a88  VARCHAR2
    , p7_a89  NUMBER
    , p7_a90  VARCHAR2
    , p7_a91  VARCHAR2
    , p7_a92  DATE
    , p7_a93  NUMBER
    , p7_a94  NUMBER
    , p7_a95  NUMBER
    , p7_a96  NUMBER
    , p7_a97  NUMBER
    , p7_a98  NUMBER
    , p7_a99  NUMBER
    , p7_a100  NUMBER
    , p7_a101  NUMBER
    , p7_a102  NUMBER
    , p7_a103  NUMBER
    , p7_a104  NUMBER
  )

  as
    ddp_act_metric_fact_rec ozf_actmetricfact_pvt.act_metric_fact_rec_type;

Line: 626


    ddp_act_metric_fact_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);

Line: 627


    ddp_act_metric_fact_rec.last_updated_by := p7_a2;

Line: 630


    ddp_act_metric_fact_rec.last_update_login := p7_a5;

Line: 732


    ozf_actmetricfact_pvt.update_actmetricfact(p_api_version,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      x_return_status,
      x_msg_count,
      x_msg_data,
      ddp_act_metric_fact_rec);

Line: 877


    ddp_act_metric_fact_rec.last_update_date := rosetta_g_miss_date_in_map(p6_a1);

Line: 878


    ddp_act_metric_fact_rec.last_updated_by := p6_a2;

Line: 881


    ddp_act_metric_fact_rec.last_update_login := p6_a5;

Line: 1116


    ddp_act_metric_fact_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);

Line: 1117


    ddp_act_metric_fact_rec.last_updated_by := p0_a2;

Line: 1120


    ddp_act_metric_fact_rec.last_update_login := p0_a5;

Line: 1454


    ddp_act_metric_fact_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);

Line: 1455


    ddp_act_metric_fact_rec.last_updated_by := p0_a2;

Line: 1458


    ddp_act_metric_fact_rec.last_update_login := p0_a5;

Line: 1560


    ddp_complete_fact_rec.last_update_date := rosetta_g_miss_date_in_map(p1_a1);

Line: 1561


    ddp_complete_fact_rec.last_updated_by := p1_a2;

Line: 1564


    ddp_complete_fact_rec.last_update_login := p1_a5;

Line: 1896


    ddp_act_metric_fact_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);

Line: 1897


    ddp_act_metric_fact_rec.last_updated_by := p0_a2;

Line: 1900


    ddp_act_metric_fact_rec.last_update_login := p0_a5;

Line: 2009


    p1_a1 := ddx_complete_fact_rec.last_update_date;

Line: 2010


    p1_a2 := ddx_complete_fact_rec.last_updated_by;

Line: 2013


    p1_a5 := ddx_complete_fact_rec.last_update_login;

Line: 2153


    ddp_formula_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a4);

Line: 2154


    ddp_formula_rec.last_updated_by := p7_a5;

Line: 2157


    ddp_formula_rec.last_update_login := p7_a8;

Line: 2219


    ddp_formula_rec.last_update_date := rosetta_g_miss_date_in_map(p6_a4);

Line: 2220


    ddp_formula_rec.last_updated_by := p6_a5;

Line: 2223


    ddp_formula_rec.last_update_login := p6_a8;

Line: 2270


    ddp_formula_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a4);

Line: 2271


    ddp_formula_rec.last_updated_by := p0_a5;

Line: 2274


    ddp_formula_rec.last_update_login := p0_a8;

Line: 2326


    ddp_formula_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a4);

Line: 2327


    ddp_formula_rec.last_updated_by := p0_a5;

Line: 2330


    ddp_formula_rec.last_update_login := p0_a8;

Line: 2338


    ddp_complete_formula_rec.last_update_date := rosetta_g_miss_date_in_map(p1_a4);

Line: 2339


    ddp_complete_formula_rec.last_updated_by := p1_a5;

Line: 2342


    ddp_complete_formula_rec.last_update_login := p1_a8;

Line: 2400


    ddp_formula_entry_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a7);

Line: 2401


    ddp_formula_entry_rec.last_updated_by := p7_a8;

Line: 2404


    ddp_formula_entry_rec.last_update_login := p7_a11;

Line: 2470


    ddp_formula_entry_rec.last_update_date := rosetta_g_miss_date_in_map(p6_a7);

Line: 2471


    ddp_formula_entry_rec.last_updated_by := p6_a8;

Line: 2474


    ddp_formula_entry_rec.last_update_login := p6_a11;

Line: 2525


    ddp_formula_entry_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a7);

Line: 2526


    ddp_formula_entry_rec.last_updated_by := p0_a8;

Line: 2529


    ddp_formula_entry_rec.last_update_login := p0_a11;

Line: 2587


    ddp_formula_entry_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a7);

Line: 2588


    ddp_formula_entry_rec.last_updated_by := p0_a8;

Line: 2591


    ddp_formula_entry_rec.last_update_login := p0_a11;

Line: 2601


    ddp_complete_formula_entry_rec.last_update_date := rosetta_g_miss_date_in_map(p1_a7);

Line: 2602


    ddp_complete_formula_entry_rec.last_updated_by := p1_a8;

Line: 2605


    ddp_complete_formula_entry_rec.last_update_login := p1_a11;