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_PS_RULE_PVT_W SQL Statements

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

Line: 110


          t(ddindx).last_updated_by := rosetta_g_miss_num_map(a2(indx));

Line: 111


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

Line: 112


          t(ddindx).last_update_login := rosetta_g_miss_num_map(a4(indx));

Line: 268


          a2(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);

Line: 269


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

Line: 270


          a4(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);

Line: 360


    ddp_ps_rules_rec.last_updated_by := rosetta_g_miss_num_map(p7_a2);

Line: 361


    ddp_ps_rules_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a3);

Line: 362


    ddp_ps_rules_rec.last_update_login := rosetta_g_miss_num_map(p7_a4);

Line: 431


  procedure update_ps_rule(p_api_version_number  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
    , p8_a0  NUMBER
    , p8_a1  NUMBER
    , p8_a2  NUMBER
    , p9_a0 JTF_VARCHAR2_TABLE_100
    , p9_a1 JTF_VARCHAR2_TABLE_100
    , p10_a0 JTF_VARCHAR2_TABLE_100
    , p10_a1 JTF_VARCHAR2_TABLE_100
    , x_object_version_number OUT NOCOPY  NUMBER
    , p7_a0  NUMBER := 0-1962.0724
    , p7_a1  DATE := fnd_api.g_miss_date
    , p7_a2  NUMBER := 0-1962.0724
    , p7_a3  DATE := fnd_api.g_miss_date
    , p7_a4  NUMBER := 0-1962.0724
    , p7_a5  NUMBER := 0-1962.0724
    , p7_a6  NUMBER := 0-1962.0724
    , p7_a7  NUMBER := 0-1962.0724
    , p7_a8  NUMBER := 0-1962.0724
    , p7_a9  NUMBER := 0-1962.0724
    , p7_a10  NUMBER := 0-1962.0724
    , p7_a11  VARCHAR2 := fnd_api.g_miss_char
    , p7_a12  VARCHAR2 := fnd_api.g_miss_char
    , p7_a13  VARCHAR2 := fnd_api.g_miss_char
    , p7_a14  NUMBER := 0-1962.0724
    , p7_a15  VARCHAR2 := fnd_api.g_miss_char
    , p7_a16  VARCHAR2 := fnd_api.g_miss_char
    , p7_a17  NUMBER := 0-1962.0724
    , p7_a18  VARCHAR2 := fnd_api.g_miss_char
    , p7_a19  VARCHAR2 := fnd_api.g_miss_char
    , p7_a20  VARCHAR2 := fnd_api.g_miss_char
    , p7_a21  VARCHAR2 := fnd_api.g_miss_char
    , p7_a22  VARCHAR2 := fnd_api.g_miss_char
    , p7_a23  VARCHAR2 := fnd_api.g_miss_char
    , p7_a24  VARCHAR2 := fnd_api.g_miss_char
    , p7_a25  VARCHAR2 := fnd_api.g_miss_char
    , p7_a26  VARCHAR2 := fnd_api.g_miss_char
    , p7_a27  VARCHAR2 := fnd_api.g_miss_char
  )
  as
    ddp_ps_rules_rec ams_ps_rule_pvt.ps_rules_rec_type;

Line: 493


    ddp_ps_rules_rec.last_updated_by := rosetta_g_miss_num_map(p7_a2);

Line: 494


    ddp_ps_rules_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a3);

Line: 495


    ddp_ps_rules_rec.last_update_login := rosetta_g_miss_num_map(p7_a4);

Line: 549


    ams_ps_rule_pvt.update_ps_rule(p_api_version_number,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      x_return_status,
      x_msg_count,
      x_msg_data,
      ddp_ps_rules_rec,
      ddp_visitor_rec,
      ddp_ps_filter_tbl,
      ddp_ps_strategy_tbl,
      x_object_version_number);

Line: 576


  procedure update_ps_rule_alt(p_api_version_number  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
    , p8_a0  NUMBER
    , p8_a1  NUMBER
    , p8_a2  NUMBER
    , p9_a0 JTF_VARCHAR2_TABLE_100
    , p9_a1 JTF_VARCHAR2_TABLE_100
    , p10_a0 JTF_VARCHAR2_TABLE_100
    , p10_a1 JTF_VARCHAR2_TABLE_100
    , p_vistype_change  number
    , p_rem_change  number
    , x_object_version_number OUT NOCOPY  NUMBER
    , p7_a0  NUMBER := 0-1962.0724
    , p7_a1  DATE := fnd_api.g_miss_date
    , p7_a2  NUMBER := 0-1962.0724
    , p7_a3  DATE := fnd_api.g_miss_date
    , p7_a4  NUMBER := 0-1962.0724
    , p7_a5  NUMBER := 0-1962.0724
    , p7_a6  NUMBER := 0-1962.0724
    , p7_a7  NUMBER := 0-1962.0724
    , p7_a8  NUMBER := 0-1962.0724
    , p7_a9  NUMBER := 0-1962.0724
    , p7_a10  NUMBER := 0-1962.0724
    , p7_a11  VARCHAR2 := fnd_api.g_miss_char
    , p7_a12  VARCHAR2 := fnd_api.g_miss_char
    , p7_a13  VARCHAR2 := fnd_api.g_miss_char
    , p7_a14  NUMBER := 0-1962.0724
    , p7_a15  VARCHAR2 := fnd_api.g_miss_char
    , p7_a16  VARCHAR2 := fnd_api.g_miss_char
    , p7_a17  NUMBER := 0-1962.0724
    , p7_a18  VARCHAR2 := fnd_api.g_miss_char
    , p7_a19  VARCHAR2 := fnd_api.g_miss_char
    , p7_a20  VARCHAR2 := fnd_api.g_miss_char
    , p7_a21  VARCHAR2 := fnd_api.g_miss_char
    , p7_a22  VARCHAR2 := fnd_api.g_miss_char
    , p7_a23  VARCHAR2 := fnd_api.g_miss_char
    , p7_a24  VARCHAR2 := fnd_api.g_miss_char
    , p7_a25  VARCHAR2 := fnd_api.g_miss_char
    , p7_a26  VARCHAR2 := fnd_api.g_miss_char
    , p7_a27  VARCHAR2 := fnd_api.g_miss_char
  )
  as
    ddp_ps_rules_rec ams_ps_rule_pvt.ps_rules_rec_type;

Line: 642


    ddp_ps_rules_rec.last_updated_by := rosetta_g_miss_num_map(p7_a2);

Line: 643


    ddp_ps_rules_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a3);

Line: 644


    ddp_ps_rules_rec.last_update_login := rosetta_g_miss_num_map(p7_a4);

Line: 712


    ams_ps_rule_pvt.update_ps_rule_alt(p_api_version_number,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      x_return_status,
      x_msg_count,
      x_msg_data,
      ddp_ps_rules_rec,
      ddp_visitor_rec,
      ddp_ps_filter_tbl,
      ddp_ps_strategy_tbl,
      ddp_vistype_change,
      ddp_rem_change,
      x_object_version_number);

Line: 743


  procedure delete_ps_rule_alt(p_api_version_number  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
    , p_object_version_number  NUMBER
    , p7_a0  NUMBER := 0-1962.0724
    , p7_a1  DATE := fnd_api.g_miss_date
    , p7_a2  NUMBER := 0-1962.0724
    , p7_a3  DATE := fnd_api.g_miss_date
    , p7_a4  NUMBER := 0-1962.0724
    , p7_a5  NUMBER := 0-1962.0724
    , p7_a6  NUMBER := 0-1962.0724
    , p7_a7  NUMBER := 0-1962.0724
    , p7_a8  NUMBER := 0-1962.0724
    , p7_a9  NUMBER := 0-1962.0724
    , p7_a10  NUMBER := 0-1962.0724
    , p7_a11  VARCHAR2 := fnd_api.g_miss_char
    , p7_a12  VARCHAR2 := fnd_api.g_miss_char
    , p7_a13  VARCHAR2 := fnd_api.g_miss_char
    , p7_a14  NUMBER := 0-1962.0724
    , p7_a15  VARCHAR2 := fnd_api.g_miss_char
    , p7_a16  VARCHAR2 := fnd_api.g_miss_char
    , p7_a17  NUMBER := 0-1962.0724
    , p7_a18  VARCHAR2 := fnd_api.g_miss_char
    , p7_a19  VARCHAR2 := fnd_api.g_miss_char
    , p7_a20  VARCHAR2 := fnd_api.g_miss_char
    , p7_a21  VARCHAR2 := fnd_api.g_miss_char
    , p7_a22  VARCHAR2 := fnd_api.g_miss_char
    , p7_a23  VARCHAR2 := fnd_api.g_miss_char
    , p7_a24  VARCHAR2 := fnd_api.g_miss_char
    , p7_a25  VARCHAR2 := fnd_api.g_miss_char
    , p7_a26  VARCHAR2 := fnd_api.g_miss_char
    , p7_a27  VARCHAR2 := fnd_api.g_miss_char
  )
  as
    ddp_ps_rules_rec ams_ps_rule_pvt.ps_rules_rec_type;

Line: 795


    ddp_ps_rules_rec.last_updated_by := rosetta_g_miss_num_map(p7_a2);

Line: 796


    ddp_ps_rules_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a3);

Line: 797


    ddp_ps_rules_rec.last_update_login := rosetta_g_miss_num_map(p7_a4);

Line: 824


    ams_ps_rule_pvt.delete_ps_rule_alt(p_api_version_number,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      x_return_status,
      x_msg_count,
      x_msg_data,
      ddp_ps_rules_rec,
      p_object_version_number);

Line: 891


    ddp_ps_rules_rec.last_updated_by := rosetta_g_miss_num_map(p3_a2);

Line: 892


    ddp_ps_rules_rec.last_update_date := rosetta_g_miss_date_in_map(p3_a3);

Line: 893


    ddp_ps_rules_rec.last_update_login := rosetta_g_miss_num_map(p3_a4);

Line: 978


    ddp_ps_rules_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);

Line: 979


    ddp_ps_rules_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a3);

Line: 980


    ddp_ps_rules_rec.last_update_login := rosetta_g_miss_num_map(p0_a4);

Line: 1017


  procedure update_filters(p_rulegroup_id  NUMBER
    , p1_a0 JTF_VARCHAR2_TABLE_100
    , p1_a1 JTF_VARCHAR2_TABLE_100
    , x_return_status OUT NOCOPY  VARCHAR2
  )
  as
    ddp_ps_filter_tbl ams_ps_rule_pvt.ps_rules_tuple_tbl_type;

Line: 1035


    ams_ps_rule_pvt.update_filters(p_rulegroup_id,
      ddp_ps_filter_tbl,
      x_return_status);

Line: 1044


  procedure update_strategy_params(p_rulegroup_id  NUMBER
    , p1_a0 JTF_VARCHAR2_TABLE_100
    , p1_a1 JTF_VARCHAR2_TABLE_100
    , x_return_status OUT NOCOPY  VARCHAR2
  )
  as
    ddp_ps_strategy_tbl ams_ps_rule_pvt.ps_rules_tuple_tbl_type;

Line: 1062


    ams_ps_rule_pvt.update_strategy_params(p_rulegroup_id,
      ddp_ps_strategy_tbl,
      x_return_status);

Line: 1118


    ddp_ps_rules_rec.last_updated_by := rosetta_g_miss_num_map(p5_a2);

Line: 1119


    ddp_ps_rules_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a3);

Line: 1120


    ddp_ps_rules_rec.last_update_login := rosetta_g_miss_num_map(p5_a4);