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.AMS_FORMULA_PVT_W SQL Statements

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

Line: 60


    ddp_formula_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a4);

Line: 61


    ddp_formula_rec.last_updated_by := rosetta_g_miss_num_map(p7_a5);

Line: 64


    ddp_formula_rec.last_update_login := rosetta_g_miss_num_map(p7_a8);

Line: 91


  procedure update_formula(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 := 0-1962.0724
    , p7_a1  NUMBER := 0-1962.0724
    , p7_a2  NUMBER := 0-1962.0724
    , p7_a3  NUMBER := 0-1962.0724
    , p7_a4  DATE := fnd_api.g_miss_date
    , p7_a5  NUMBER := 0-1962.0724
    , p7_a6  DATE := fnd_api.g_miss_date
    , p7_a7  NUMBER := 0-1962.0724
    , p7_a8  NUMBER := 0-1962.0724
    , p7_a9  NUMBER := 0-1962.0724
    , p7_a10  VARCHAR2 := fnd_api.g_miss_char
  )

  as
    ddp_formula_rec ams_formula_pvt.ams_formula_rec_type;

Line: 128


    ddp_formula_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a4);

Line: 129


    ddp_formula_rec.last_updated_by := rosetta_g_miss_num_map(p7_a5);

Line: 132


    ddp_formula_rec.last_update_login := rosetta_g_miss_num_map(p7_a8);

Line: 137


    ams_formula_pvt.update_formula(p_api_version,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      x_return_status,
      x_msg_count,
      x_msg_data,
      ddp_formula_rec);

Line: 191


    ddp_formula_rec.last_update_date := rosetta_g_miss_date_in_map(p6_a4);

Line: 192


    ddp_formula_rec.last_updated_by := rosetta_g_miss_num_map(p6_a5);

Line: 195


    ddp_formula_rec.last_update_login := rosetta_g_miss_num_map(p6_a8);

Line: 242


    ddp_formula_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a4);

Line: 243


    ddp_formula_rec.last_updated_by := rosetta_g_miss_num_map(p0_a5);

Line: 246


    ddp_formula_rec.last_update_login := rosetta_g_miss_num_map(p0_a8);

Line: 298


    ddp_formula_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a4);

Line: 299


    ddp_formula_rec.last_updated_by := rosetta_g_miss_num_map(p0_a5);

Line: 302


    ddp_formula_rec.last_update_login := rosetta_g_miss_num_map(p0_a8);

Line: 310


    ddp_complete_formula_rec.last_update_date := rosetta_g_miss_date_in_map(p1_a4);

Line: 311


    ddp_complete_formula_rec.last_updated_by := rosetta_g_miss_num_map(p1_a5);

Line: 314


    ddp_complete_formula_rec.last_update_login := rosetta_g_miss_num_map(p1_a8);

Line: 364


    ddp_formula_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a4);

Line: 365


    ddp_formula_rec.last_updated_by := rosetta_g_miss_num_map(p0_a5);

Line: 368


    ddp_formula_rec.last_update_login := rosetta_g_miss_num_map(p0_a8);

Line: 383


    p1_a4 := ddx_complete_formula_rec.last_update_date;

Line: 384


    p1_a5 := rosetta_g_miss_num_map(ddx_complete_formula_rec.last_updated_by);

Line: 387


    p1_a8 := rosetta_g_miss_num_map(ddx_complete_formula_rec.last_update_login);

Line: 435


    ddp_formula_entry_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a7);

Line: 436


    ddp_formula_entry_rec.last_updated_by := rosetta_g_miss_num_map(p7_a8);

Line: 439


    ddp_formula_entry_rec.last_update_login := rosetta_g_miss_num_map(p7_a11);

Line: 465


  procedure update_formula_entry(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 := 0-1962.0724
    , p7_a1  NUMBER := 0-1962.0724
    , p7_a2  NUMBER := 0-1962.0724
    , p7_a3  VARCHAR2 := fnd_api.g_miss_char
    , p7_a4  VARCHAR2 := fnd_api.g_miss_char
    , p7_a5  VARCHAR2 := fnd_api.g_miss_char
    , p7_a6  VARCHAR2 := fnd_api.g_miss_char
    , p7_a7  DATE := fnd_api.g_miss_date
    , p7_a8  NUMBER := 0-1962.0724
    , p7_a9  DATE := fnd_api.g_miss_date
    , p7_a10  NUMBER := 0-1962.0724
    , p7_a11  NUMBER := 0-1962.0724
    , p7_a12  NUMBER := 0-1962.0724
  )

  as
    ddp_formula_entry_rec ams_formula_pvt.ams_formula_entry_rec_type;

Line: 507


    ddp_formula_entry_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a7);

Line: 508


    ddp_formula_entry_rec.last_updated_by := rosetta_g_miss_num_map(p7_a8);

Line: 511


    ddp_formula_entry_rec.last_update_login := rosetta_g_miss_num_map(p7_a11);

Line: 515


    ams_formula_pvt.update_formula_entry(p_api_version,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      x_return_status,
      x_msg_count,
      x_msg_data,
      ddp_formula_entry_rec);

Line: 574


    ddp_formula_entry_rec.last_update_date := rosetta_g_miss_date_in_map(p6_a7);

Line: 575


    ddp_formula_entry_rec.last_updated_by := rosetta_g_miss_num_map(p6_a8);

Line: 578


    ddp_formula_entry_rec.last_update_login := rosetta_g_miss_num_map(p6_a11);

Line: 629


    ddp_formula_entry_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a7);

Line: 630


    ddp_formula_entry_rec.last_updated_by := rosetta_g_miss_num_map(p0_a8);

Line: 633


    ddp_formula_entry_rec.last_update_login := rosetta_g_miss_num_map(p0_a11);

Line: 691


    ddp_formula_entry_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a7);

Line: 692


    ddp_formula_entry_rec.last_updated_by := rosetta_g_miss_num_map(p0_a8);

Line: 695


    ddp_formula_entry_rec.last_update_login := rosetta_g_miss_num_map(p0_a11);

Line: 705


    ddp_complete_formula_entry_rec.last_update_date := rosetta_g_miss_date_in_map(p1_a7);

Line: 706


    ddp_complete_formula_entry_rec.last_updated_by := rosetta_g_miss_num_map(p1_a8);

Line: 709


    ddp_complete_formula_entry_rec.last_update_login := rosetta_g_miss_num_map(p1_a11);

Line: 765


    ddp_formula_entry_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a7);

Line: 766


    ddp_formula_entry_rec.last_updated_by := rosetta_g_miss_num_map(p0_a8);

Line: 769


    ddp_formula_entry_rec.last_update_login := rosetta_g_miss_num_map(p0_a11);

Line: 786


    p1_a7 := ddx_complete_formula_entry_rec.last_update_date;

Line: 787


    p1_a8 := rosetta_g_miss_num_map(ddx_complete_formula_entry_rec.last_updated_by);

Line: 790


    p1_a11 := rosetta_g_miss_num_map(ddx_complete_formula_entry_rec.last_update_login);