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

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

Line: 336


          t(ddindx).can_delete_flag := a10(indx);

Line: 337


          t(ddindx).can_update_flag := a11(indx);

Line: 451


          a10(indx) := t(ddindx).can_delete_flag;

Line: 452


          a11(indx) := t(ddindx).can_update_flag;

Line: 1156


  procedure update_group(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
    , p_check_login_user  VARCHAR2
    , p_group_id  NUMBER
    , p_new_group_name  VARCHAR2
    , p_new_group_desc  VARCHAR2
    , p_group_usage  VARCHAR2
    , p_email_address  VARCHAR2
    , p_new_start_date  date
    , p_new_end_date  date
  )

  as
    ddp_new_start_date date;

Line: 1198


    amv_user_pvt.update_group(p_api_version,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_check_login_user,
      p_group_id,
      p_new_group_name,
      p_new_group_desc,
      p_group_usage,
      p_email_address,
      ddp_new_start_date,
      ddp_new_end_date);

Line: 1592


  procedure update_access(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
    , p_check_login_user  VARCHAR2
    , p8_a0  NUMBER := 0-1962.0724
    , p8_a1  NUMBER := 0-1962.0724
    , p8_a2  VARCHAR2 := fnd_api.g_miss_char
    , p8_a3  NUMBER := 0-1962.0724
    , p8_a4  NUMBER := 0-1962.0724
    , p8_a5  VARCHAR2 := fnd_api.g_miss_char
    , p8_a6  DATE := fnd_api.g_miss_date
    , p8_a7  DATE := fnd_api.g_miss_date
    , p8_a8  VARCHAR2 := fnd_api.g_miss_char
    , p8_a9  VARCHAR2 := fnd_api.g_miss_char
    , p8_a10  VARCHAR2 := fnd_api.g_miss_char
    , p8_a11  VARCHAR2 := fnd_api.g_miss_char
    , p8_a12  VARCHAR2 := fnd_api.g_miss_char
    , p8_a13  VARCHAR2 := fnd_api.g_miss_char
    , p8_a14  VARCHAR2 := fnd_api.g_miss_char
    , p8_a15  VARCHAR2 := fnd_api.g_miss_char
  )

  as
    ddp_access_obj amv_user_pvt.amv_access_obj_type;

Line: 1642


    ddp_access_obj.can_delete_flag := p8_a10;

Line: 1643


    ddp_access_obj.can_update_flag := p8_a11;

Line: 1650


    amv_user_pvt.update_access(p_api_version,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_check_login_user,
      ddp_access_obj);

Line: 1671


  procedure update_access(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
    , p_check_login_user  VARCHAR2
    , p8_a0 JTF_NUMBER_TABLE
    , p8_a1 JTF_NUMBER_TABLE
    , p8_a2 JTF_VARCHAR2_TABLE_100
    , p8_a3 JTF_NUMBER_TABLE
    , p8_a4 JTF_NUMBER_TABLE
    , p8_a5 JTF_VARCHAR2_TABLE_100
    , p8_a6 JTF_DATE_TABLE
    , p8_a7 JTF_DATE_TABLE
    , p8_a8 JTF_VARCHAR2_TABLE_100
    , p8_a9 JTF_VARCHAR2_TABLE_100
    , p8_a10 JTF_VARCHAR2_TABLE_100
    , p8_a11 JTF_VARCHAR2_TABLE_100
    , p8_a12 JTF_VARCHAR2_TABLE_100
    , p8_a13 JTF_VARCHAR2_TABLE_100
    , p8_a14 JTF_VARCHAR2_TABLE_100
    , p8_a15 JTF_VARCHAR2_TABLE_100
  )

  as
    ddp_access_obj_array amv_user_pvt.amv_access_obj_varray;

Line: 1730


    amv_user_pvt.update_access(p_api_version,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_check_login_user,
      ddp_access_obj_array);

Line: 1751


  procedure update_resourceapplaccess(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
    , p_check_login_user  VARCHAR2
    , p_resource_id  NUMBER
    , p_application_id  NUMBER
    , p10_a0  VARCHAR2 := fnd_api.g_miss_char
    , p10_a1  VARCHAR2 := fnd_api.g_miss_char
    , p10_a2  VARCHAR2 := fnd_api.g_miss_char
    , p10_a3  VARCHAR2 := fnd_api.g_miss_char
    , p10_a4  VARCHAR2 := fnd_api.g_miss_char
    , p10_a5  VARCHAR2 := fnd_api.g_miss_char
    , p10_a6  VARCHAR2 := fnd_api.g_miss_char
    , p10_a7  VARCHAR2 := fnd_api.g_miss_char
  )

  as
    ddp_access_flag_obj amv_user_pvt.amv_access_flag_obj_type;

Line: 1789


    ddp_access_flag_obj.can_delete_flag := p10_a2;

Line: 1790


    ddp_access_flag_obj.can_update_flag := p10_a3;

Line: 1797


    amv_user_pvt.update_resourceapplaccess(p_api_version,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_check_login_user,
      p_resource_id,
      p_application_id,
      ddp_access_flag_obj);

Line: 1822


  procedure update_resourcechanaccess(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
    , p_check_login_user  VARCHAR2
    , p_resource_id  NUMBER
    , p_channel_id  NUMBER
    , p10_a0  VARCHAR2 := fnd_api.g_miss_char
    , p10_a1  VARCHAR2 := fnd_api.g_miss_char
    , p10_a2  VARCHAR2 := fnd_api.g_miss_char
    , p10_a3  VARCHAR2 := fnd_api.g_miss_char
    , p10_a4  VARCHAR2 := fnd_api.g_miss_char
    , p10_a5  VARCHAR2 := fnd_api.g_miss_char
    , p10_a6  VARCHAR2 := fnd_api.g_miss_char
    , p10_a7  VARCHAR2 := fnd_api.g_miss_char
  )

  as
    ddp_access_flag_obj amv_user_pvt.amv_access_flag_obj_type;

Line: 1860


    ddp_access_flag_obj.can_delete_flag := p10_a2;

Line: 1861


    ddp_access_flag_obj.can_update_flag := p10_a3;

Line: 1868


    amv_user_pvt.update_resourcechanaccess(p_api_version,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_check_login_user,
      p_resource_id,
      p_channel_id,
      ddp_access_flag_obj);

Line: 1893


  procedure update_resourcecateaccess(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
    , p_check_login_user  VARCHAR2
    , p_resource_id  NUMBER
    , p_category_id  NUMBER
    , p10_a0  VARCHAR2 := fnd_api.g_miss_char
    , p10_a1  VARCHAR2 := fnd_api.g_miss_char
    , p10_a2  VARCHAR2 := fnd_api.g_miss_char
    , p10_a3  VARCHAR2 := fnd_api.g_miss_char
    , p10_a4  VARCHAR2 := fnd_api.g_miss_char
    , p10_a5  VARCHAR2 := fnd_api.g_miss_char
    , p10_a6  VARCHAR2 := fnd_api.g_miss_char
    , p10_a7  VARCHAR2 := fnd_api.g_miss_char
  )

  as
    ddp_access_flag_obj amv_user_pvt.amv_access_flag_obj_type;

Line: 1931


    ddp_access_flag_obj.can_delete_flag := p10_a2;

Line: 1932


    ddp_access_flag_obj.can_update_flag := p10_a3;

Line: 1939


    amv_user_pvt.update_resourcecateaccess(p_api_version,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_check_login_user,
      p_resource_id,
      p_category_id,
      ddp_access_flag_obj);

Line: 1964


  procedure update_resourceitemaccess(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
    , p_check_login_user  VARCHAR2
    , p_resource_id  NUMBER
    , p_item_id  NUMBER
    , p10_a0  VARCHAR2 := fnd_api.g_miss_char
    , p10_a1  VARCHAR2 := fnd_api.g_miss_char
    , p10_a2  VARCHAR2 := fnd_api.g_miss_char
    , p10_a3  VARCHAR2 := fnd_api.g_miss_char
    , p10_a4  VARCHAR2 := fnd_api.g_miss_char
    , p10_a5  VARCHAR2 := fnd_api.g_miss_char
    , p10_a6  VARCHAR2 := fnd_api.g_miss_char
    , p10_a7  VARCHAR2 := fnd_api.g_miss_char
  )

  as
    ddp_access_flag_obj amv_user_pvt.amv_access_flag_obj_type;

Line: 2002


    ddp_access_flag_obj.can_delete_flag := p10_a2;

Line: 2003


    ddp_access_flag_obj.can_update_flag := p10_a3;

Line: 2010


    amv_user_pvt.update_resourceitemaccess(p_api_version,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_check_login_user,
      p_resource_id,
      p_item_id,
      ddp_access_flag_obj);

Line: 2035


  procedure update_groupapplaccess(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
    , p_check_login_user  VARCHAR2
    , p_resource_id  NUMBER
    , p_group_id  NUMBER
    , p_application_id  NUMBER
    , p11_a0  VARCHAR2 := fnd_api.g_miss_char
    , p11_a1  VARCHAR2 := fnd_api.g_miss_char
    , p11_a2  VARCHAR2 := fnd_api.g_miss_char
    , p11_a3  VARCHAR2 := fnd_api.g_miss_char
    , p11_a4  VARCHAR2 := fnd_api.g_miss_char
    , p11_a5  VARCHAR2 := fnd_api.g_miss_char
    , p11_a6  VARCHAR2 := fnd_api.g_miss_char
    , p11_a7  VARCHAR2 := fnd_api.g_miss_char
  )

  as
    ddp_access_flag_obj amv_user_pvt.amv_access_flag_obj_type;

Line: 2075


    ddp_access_flag_obj.can_delete_flag := p11_a2;

Line: 2076


    ddp_access_flag_obj.can_update_flag := p11_a3;

Line: 2083


    amv_user_pvt.update_groupapplaccess(p_api_version,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_check_login_user,
      p_resource_id,
      p_group_id,
      p_application_id,
      ddp_access_flag_obj);

Line: 2110


  procedure update_groupchanaccess(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
    , p_check_login_user  VARCHAR2
    , p_group_id  NUMBER
    , p_channel_id  NUMBER
    , p10_a0  VARCHAR2 := fnd_api.g_miss_char
    , p10_a1  VARCHAR2 := fnd_api.g_miss_char
    , p10_a2  VARCHAR2 := fnd_api.g_miss_char
    , p10_a3  VARCHAR2 := fnd_api.g_miss_char
    , p10_a4  VARCHAR2 := fnd_api.g_miss_char
    , p10_a5  VARCHAR2 := fnd_api.g_miss_char
    , p10_a6  VARCHAR2 := fnd_api.g_miss_char
    , p10_a7  VARCHAR2 := fnd_api.g_miss_char
  )

  as
    ddp_access_flag_obj amv_user_pvt.amv_access_flag_obj_type;

Line: 2148


    ddp_access_flag_obj.can_delete_flag := p10_a2;

Line: 2149


    ddp_access_flag_obj.can_update_flag := p10_a3;

Line: 2156


    amv_user_pvt.update_groupchanaccess(p_api_version,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_check_login_user,
      p_group_id,
      p_channel_id,
      ddp_access_flag_obj);

Line: 2181


  procedure update_groupcateaccess(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
    , p_check_login_user  VARCHAR2
    , p_group_id  NUMBER
    , p_category_id  NUMBER
    , p10_a0  VARCHAR2 := fnd_api.g_miss_char
    , p10_a1  VARCHAR2 := fnd_api.g_miss_char
    , p10_a2  VARCHAR2 := fnd_api.g_miss_char
    , p10_a3  VARCHAR2 := fnd_api.g_miss_char
    , p10_a4  VARCHAR2 := fnd_api.g_miss_char
    , p10_a5  VARCHAR2 := fnd_api.g_miss_char
    , p10_a6  VARCHAR2 := fnd_api.g_miss_char
    , p10_a7  VARCHAR2 := fnd_api.g_miss_char
  )

  as
    ddp_access_flag_obj amv_user_pvt.amv_access_flag_obj_type;

Line: 2219


    ddp_access_flag_obj.can_delete_flag := p10_a2;

Line: 2220


    ddp_access_flag_obj.can_update_flag := p10_a3;

Line: 2227


    amv_user_pvt.update_groupcateaccess(p_api_version,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_check_login_user,
      p_group_id,
      p_category_id,
      ddp_access_flag_obj);

Line: 2252


  procedure update_groupitemaccess(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
    , p_check_login_user  VARCHAR2
    , p_group_id  NUMBER
    , p_item_id  NUMBER
    , p10_a0  VARCHAR2 := fnd_api.g_miss_char
    , p10_a1  VARCHAR2 := fnd_api.g_miss_char
    , p10_a2  VARCHAR2 := fnd_api.g_miss_char
    , p10_a3  VARCHAR2 := fnd_api.g_miss_char
    , p10_a4  VARCHAR2 := fnd_api.g_miss_char
    , p10_a5  VARCHAR2 := fnd_api.g_miss_char
    , p10_a6  VARCHAR2 := fnd_api.g_miss_char
    , p10_a7  VARCHAR2 := fnd_api.g_miss_char
  )

  as
    ddp_access_flag_obj amv_user_pvt.amv_access_flag_obj_type;

Line: 2290


    ddp_access_flag_obj.can_delete_flag := p10_a2;

Line: 2291


    ddp_access_flag_obj.can_update_flag := p10_a3;

Line: 2298


    amv_user_pvt.update_groupitemaccess(p_api_version,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_check_login_user,
      p_group_id,
      p_item_id,
      ddp_access_flag_obj);

Line: 2406


    p11_a10 := ddx_access_obj.can_delete_flag;

Line: 2407


    p11_a11 := ddx_access_obj.can_update_flag;

Line: 2669


    p13_a2 := ddx_access_flag_obj.can_delete_flag;

Line: 2670


    p13_a3 := ddx_access_flag_obj.can_update_flag;

Line: 2740


    p10_a2 := ddx_access_flag_obj.can_delete_flag;

Line: 2741


    p10_a3 := ddx_access_flag_obj.can_update_flag;

Line: 2811


    p10_a2 := ddx_access_flag_obj.can_delete_flag;

Line: 2812


    p10_a3 := ddx_access_flag_obj.can_update_flag;

Line: 2882


    p10_a2 := ddx_access_flag_obj.can_delete_flag;

Line: 2883


    p10_a3 := ddx_access_flag_obj.can_update_flag;

Line: 2953


    p10_a2 := ddx_access_flag_obj.can_delete_flag;

Line: 2954


    p10_a3 := ddx_access_flag_obj.can_update_flag;

Line: 3020


    p9_a2 := ddx_access_flag_obj.can_delete_flag;

Line: 3021


    p9_a3 := ddx_access_flag_obj.can_update_flag;

Line: 3087


    p9_a2 := ddx_access_flag_obj.can_delete_flag;

Line: 3088


    p9_a3 := ddx_access_flag_obj.can_update_flag;

Line: 3154


    p9_a2 := ddx_access_flag_obj.can_delete_flag;

Line: 3155


    p9_a3 := ddx_access_flag_obj.can_update_flag;

Line: 3221


    p9_a2 := ddx_access_flag_obj.can_delete_flag;

Line: 3222


    p9_a3 := ddx_access_flag_obj.can_update_flag;