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

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

Line: 992


  procedure update_channel_team(p_api_version_number  NUMBER
    , p_init_msg_list  VARCHAR2
    , p_commit  VARCHAR2
    , p_validation_level  NUMBER
    , p_partner_id  NUMBER
    , p_vad_partner_id  NUMBER
    , p_mode  VARCHAR2
    , p_login_user  NUMBER
    , p8_a0  VARCHAR2
    , p8_a1  VARCHAR2
    , p8_a2  VARCHAR2
    , p8_a3  VARCHAR2
    , p8_a4  VARCHAR2
    , p8_a5  VARCHAR2
    , p8_a6  VARCHAR2
    , p8_a7  VARCHAR2
    , p8_a8  VARCHAR2
    , p8_a9  VARCHAR2
    , p8_a10  VARCHAR2
    , p8_a11  VARCHAR2
    , p8_a12  VARCHAR2
    , p8_a13  VARCHAR2
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
    , p12_a0 out nocopy JTF_NUMBER_TABLE
  )

  as
    ddp_upd_prtnr_qflr_flg_rec pv_terr_assign_pub.prtnr_qflr_flg_rec_type;

Line: 1055


    pv_terr_assign_pub.update_channel_team(p_api_version_number,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      p_partner_id,
      p_vad_partner_id,
      p_mode,
      p_login_user,
      ddp_upd_prtnr_qflr_flg_rec,
      x_return_status,
      x_msg_count,
      x_msg_data,
      ddx_prtnr_access_id_tbl);