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

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

Line: 24


SELECT suffix
FROM iby_bepinfo
WHERE suffix = ci_bepsuffix AND
   bepid <> ci_bepid;

Line: 62


SELECT name
FROM  iby_bepinfo
WHERE name = ci_bepname AND
   bepid <> ci_bepid;

Line: 129


SELECT to_char(iby_bep_s.nextval) FROM dual;

Line: 166


** It's a new BEP, insert information into iby_bepinfo.
*/
  INSERT INTO iby_bepinfo ( bepid, name, bepusername, beppassword, psusername,
                            pspassword, baseurl, suffix, bep_type,
                            supportedop, adminurl, loginurl, logouturl,
                            leadtime, srvrIdImmed, holidayfile,
                            filesupport, activestatus,
             instrtype, securityscheme, party_id,
             last_update_date, last_updated_by,
             creation_date, created_by,
             last_update_login, object_version_number)
   VALUES ( io_bepid, i_bepname, i_bepusername, i_beppassword, i_psusername,
             i_pspassword, i_bepurl, i_bepsuffix, i_bep_type, i_supportedop,
             i_adminurl,  i_login, i_logout,
             i_leadtime, i_srvrIdImmed, i_holidayfile,
        i_fileSupport, i_activeStatus,
        l_instrtype, i_securityscheme, i_partyid,
        sysdate, fnd_global.user_id,
        sysdate, fnd_global.user_id,
      fnd_global.login_id, 1);

Line: 476


** update the row that matches the bepid;

Line: 478


    UPDATE iby_bepinfo
    SET name = i_bepname,
        bepusername = i_bepusername,
        beppassword = i_beppassword,
        psusername = i_psusername,
        pspassword = i_pspassword,
        baseurl = i_bepurl,
        suffix = i_bepsuffix,
        bep_type = i_bep_type,
        adminurl = i_adminurl,
        loginurl = i_login,
        logouturl = i_logout,
        supportedop = i_supportedop,
        leadtime = i_leadtime,
        srvrIdImmed = i_srvrIdImmed,
        holidayfile = i_holidayfile,
        filesupport = i_fileSupport,
        activeStatus = i_activeStatus,
   instrtype = l_instrtype,
   securityscheme = i_securityscheme,
        party_id = i_partyid,
      last_update_date = sysdate,
   last_updated_by = fnd_global.user_id,
   last_update_login = fnd_global.login_id,
   object_version_number = object_version_number + 1
    WHERE bepid = i_bepid
   AND  object_version_number = i_object_version;

Line: 531


procedure update_BEPInfo(
  i_bepid in iby_bepinfo.bepid%type,
  i_bepname in iby_bepinfo.name%type,
  i_bepurl in iby_bepinfo.baseurl%type,
  i_bepsuffix in iby_bepinfo.suffix%type,
  i_bep_type in iby_bepinfo.bep_type%type,
  i_bepusername in iby_bepinfo.bepusername%type,
  i_beppassword in iby_bepinfo.beppassword%type,
  i_psusername in iby_bepinfo.psusername%type,
  i_pspassword in iby_bepinfo.pspassword%type,
  i_adminurl in iby_bepinfo.adminurl%type,
  i_login in iby_bepinfo.loginurl%type,
  i_logout in iby_bepinfo.logouturl%type,
  i_supportedop in iby_bepinfo.supportedOp%type,
  i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
  i_leadtime in iby_bepinfo.leadtime%type,
  i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type,
  i_holidayfile in iby_bepinfo.holidayfile%type,
  i_fileSupport in iby_bepinfo.fileSupport%type,
  i_activestatus in iby_bepinfo.activestatus%type,
  i_securityscheme in iby_bepinfo.securityscheme%type,
  i_partyid in NUMBER,
  i_preNLSLang in iby_beplangs.beplang%type,
  i_opt1NLSLang in iby_beplangs.beplang%type,
  i_opt2NLSLang in iby_beplangs.beplang%type,
  i_object_version in iby_bepinfo.object_version_number%type)

is
  l_api_name                CONSTANT  VARCHAR2(30) := 'update_BEPInfo';

Line: 641


  UPDATE IBY_BEPINFO  SET
    name              = DECODE(i_bepname, NULL, name, i_bepname),
    suffix            = DECODE(i_bepsuffix, NULL, suffix, i_bepsuffix),
    bepusername       = DECODE(i_bepusername, NULL, bepusername, FND_API.G_MISS_CHAR, NULL, i_bepusername),
    beppassword       = DECODE(i_beppassword, NULL, beppassword, FND_API.G_MISS_CHAR, NULL, i_beppassword),
    psusername        = DECODE(i_psusername, NULL, psusername, FND_API.G_MISS_CHAR, NULL, i_psusername),
    pspassword        = DECODE(i_pspassword, NULL, pspassword, FND_API.G_MISS_CHAR, NULL, i_pspassword),
    baseurl           = DECODE(i_bepurl, NULL, baseurl, FND_API.G_MISS_CHAR, NULL, i_bepurl),
    bep_type          = DECODE(i_bep_type, NULL, bep_type, FND_API.G_MISS_CHAR, NULL, i_bep_type),
    adminurl          = DECODE(i_adminurl, NULL, adminurl, FND_API.G_MISS_CHAR, NULL, i_adminurl),
    loginurl          = DECODE(i_login, NULL, loginurl, FND_API.G_MISS_CHAR, NULL, i_login),
    logouturl         = DECODE(i_logout, NULL, logouturl, FND_API.G_MISS_CHAR, NULL, i_logout),
    supportedop       = DECODE(i_supportedop, NULL, supportedop, FND_API.G_MISS_NUM, NULL, i_supportedop),
    leadtime          = DECODE(i_leadtime, NULL, leadtime, FND_API.G_MISS_NUM, NULL, i_leadtime),
    srvrIdImmed       = DECODE(i_srvrIdImmed, NULL, srvrIdImmed, FND_API.G_MISS_CHAR, NULL, i_srvrIdImmed),
    holidayfile       = DECODE(i_holidayfile, NULL, holidayfile, FND_API.G_MISS_CHAR, NULL, i_holidayfile),
    filesupport       = DECODE(i_fileSupport, NULL, filesupport, FND_API.G_MISS_CHAR, NULL, i_fileSupport),
    activeStatus      = DECODE(i_activeStatus, NULL, activeStatus, FND_API.G_MISS_CHAR, NULL, i_activeStatus),
    -- instrtype         = DECODE(p_instr_type, NULL, instrtype, FND_API.G_MISS_CHAR, NULL, p_instr_type),
    securityscheme    = DECODE(i_securityscheme, NULL, securityscheme, FND_API.G_MISS_NUM, NULL, i_securityscheme),
    party_id          = DECODE(i_partyid, NULL, party_id, FND_API.G_MISS_CHAR, NULL, i_partyid),
    last_update_date  = SYSDATE,
    last_updated_by   = fnd_global.user_id,
    last_update_login = fnd_global.login_id,
    object_version_number = object_version_number + 1
  WHERE bepid = i_bepid
   AND object_version_number = i_object_version;

Line: 687


end update_BEPInfo;

Line: 733


SELECT name, baseurl, suffix, bep_type, bepusername, beppassword,
   supportedop, psusername, pspassword,
       adminurl, loginurl, logouturl, leadtime, holidayfile,
       srvridimmed, filesupport, activestatus,
   securityscheme, party_id, object_version_number
FROM iby_bepinfo
WHERE bepid = ci_bepid;

Line: 742


SELECT beplang
FROM iby_beplangs
WHERE bepid = ci_bepid
AND preferred = 0;

Line: 748


SELECT beplang
FROM iby_beplangs
WHERE bepid = ci_bepid
AND preferred = 1;

Line: 754


SELECT beplang
FROM iby_beplangs
WHERE bepid = ci_bepid
AND preferred = 2;

Line: 827


    UPDATE iby_bepinfo
    SET activestatus = i_status,
    last_update_date = sysdate,
    last_updated_by = fnd_global.user_id,
    last_update_login = fnd_global.login_id,
    object_version_number = object_version_number + 1
    WHERE bepid = i_bepid;

Line: 861


SELECT name
FROM iby_bepinfo
WHERE bepid = ci_id;

Line: 894


select bepid
from iby_bepinfo
where name = ci_name;