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

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

Line: 30


SELECT wsh_org_Carrier_Services_s.nextval
FROM sys.dual;

Line: 36


SELECT rowid
FROM WSH_org_Carrier_ServiceS
WHERE org_Carrier_Service_id = p_org_Carrier_Service_id;

Line: 42


SELECT distribution_account
FROM  ORG_FREIGHT_TL
WHERE  freight_code = p_freight_code
and  organization_id = p_organization_id;

Line: 49


SELECT  'Y'
FROM wsh_org_carrier_services wocs,
wsh_carrier_services_v wcs,
wsh_carriers_v wc
WHERE wc.carrier_id = wcs.carrier_id
and wocs.carrier_service_id = wcs.carrier_service_id
and wocs.carrier_service_id <> p_carrier_service_id
and wc.freight_code = p_freight_code
and wocs.organization_id = p_organization_id
and wocs.enabled_flag = 'Y'
and rownum =1;

Line: 63


   select * from org_freight_tl
   where  freight_code = p_freight_code
   and    organization_id = p_organization_id
   and    language = userenv('LANG');

Line: 87


l_orgfgt_update_allowed VARCHAR2(1);

Line: 124


     l_procedure := 'Inserting into Wsh_org_carrier_services';

Line: 128


         WSH_DEBUG_SV.logmsg(l_module_name,'Inserting into WSH_ORG_CARRIER_SERVICES',WSH_DEBUG_SV.C_PROC_LEVEL);

Line: 132


     INSERT INTO wsh_org_Carrier_Services
     (   org_Carrier_Service_id,
         carrier_service_id,
         organization_id,
         enabled_flag,
         attribute_category,
	 attribute1,
	 attribute2,
	 attribute3,
	 attribute4,
	 attribute5,
	 attribute6,
	 attribute7,
	 attribute8,
	 attribute9,
	 attribute10,
	 attribute11,
	 attribute12,
	 attribute13,
	 attribute14,
	 attribute15,
	 creation_date,
	 created_by,
	 last_update_date,
	 last_updated_by,
	 last_update_login
      ) VALUES (
         l_org_Carrier_Service_id,
	 p_org_Carrier_Service_Info.carrier_service_id,
	 p_org_Carrier_Service_Info.organization_id,
	 p_org_Carrier_Service_Info.Enabled_Flag,
	 p_org_Carrier_Service_Info.Attribute_Category,
	 p_org_Carrier_Service_Info.Attribute1,
	 p_org_Carrier_Service_Info.Attribute2,
	 p_org_Carrier_Service_Info.Attribute3,
	 p_org_Carrier_Service_Info.Attribute4,
	 p_org_Carrier_Service_Info.Attribute5,
	 p_org_Carrier_Service_Info.Attribute6,
	 p_org_Carrier_Service_Info.Attribute7,
	 p_org_Carrier_Service_Info.Attribute8,
	 p_org_Carrier_Service_Info.Attribute9,
	 p_org_Carrier_Service_Info.Attribute10,
	 p_org_Carrier_Service_Info.Attribute11,
	 p_org_Carrier_Service_Info.Attribute12,
	 p_org_Carrier_Service_Info.Attribute13,
	 p_org_Carrier_Service_Info.Attribute14,
	 p_org_Carrier_Service_Info.Attribute15,
	 sysdate,
	 fnd_global.user_id,
	 sysdate,
	 fnd_global.user_id,
	 fnd_global.login_id);

Line: 186


            WSH_DEBUG_SV.log(l_module_name,'Rows inserted',SQL%ROWCOUNT);

Line: 196


     l_procedure := 'Inserting into ORG_FREIGHT_TL';

Line: 199


         WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit ORG_FREIGHT_TL_PKG.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);

Line: 202


ORG_FREIGHT_TL_PKG.INSERT_ROW(
    X_ROWID => l_oft_rowid,
    X_FREIGHT_CODE => p_carrier_info.P_FREIGHT_CODE,
    X_FREIGHT_CODE_TL => p_carrier_info.P_FREIGHT_CODE,
    X_ORGANIZATION_ID => p_org_carrier_service_info.ORGANIZATION_ID,
    X_DISABLE_DATE => l_disable_date,
    X_DISTRIBUTION_ACCOUNT => p_org_Carrier_Service_Info.DISTRIBUTION_ACCOUNT, -- BugFix#3296461
   --bug 6126916: While inserting, populate NULL values for DFF attributes
   --(similar to GDF attributes)
    X_ATTRIBUTE_CATEGORY => NULL,
    X_ATTRIBUTE1  => NULL,
    X_ATTRIBUTE2  => NULL,
    X_ATTRIBUTE3  => NULL,
    X_ATTRIBUTE4  => NULL,
    X_ATTRIBUTE5  => NULL,
    X_ATTRIBUTE6  => NULL,
    X_ATTRIBUTE7  => NULL,
    X_ATTRIBUTE8  => NULL,
    X_ATTRIBUTE9  => NULL,
    X_ATTRIBUTE10 => NULL,
    X_ATTRIBUTE11 => NULL,
    X_ATTRIBUTE12 => NULL,
    X_ATTRIBUTE13 => NULL,
    X_ATTRIBUTE14 => NULL,
    X_ATTRIBUTE15 => NULL,
    X_GLOBAL_ATTRIBUTE1  => NULL,
    X_GLOBAL_ATTRIBUTE2  => NULL,
    X_GLOBAL_ATTRIBUTE3  => NULL,
    X_GLOBAL_ATTRIBUTE4  => NULL,
    X_GLOBAL_ATTRIBUTE5  => NULL,
    X_GLOBAL_ATTRIBUTE6  => NULL,
    X_GLOBAL_ATTRIBUTE7  => NULL,
    X_GLOBAL_ATTRIBUTE8  => NULL,
    X_GLOBAL_ATTRIBUTE9  => NULL,
    X_GLOBAL_ATTRIBUTE10 => NULL,
    X_GLOBAL_ATTRIBUTE11 => NULL,
    X_GLOBAL_ATTRIBUTE12 => NULL,
    X_GLOBAL_ATTRIBUTE13 => NULL,
    X_GLOBAL_ATTRIBUTE14 => NULL,
    X_GLOBAL_ATTRIBUTE15 => NULL,
    X_GLOBAL_ATTRIBUTE16 => NULL,
    X_GLOBAL_ATTRIBUTE17 => NULL,
    X_GLOBAL_ATTRIBUTE18 => NULL,
    X_GLOBAL_ATTRIBUTE19 => NULL,
    X_GLOBAL_ATTRIBUTE20 => NULL,
    X_GLOBAL_ATTRIBUTE_CATEGORY => NULL,
    X_DESCRIPTION => SUBSTRB(p_carrier_info.P_CARRIER_NAME,1,80),
    X_CREATION_DATE => SYSDATE, -- Bug 5478419
    X_CREATED_BY => p_carrier_info.CREATED_BY,
    X_LAST_UPDATE_DATE => SYSDATE, -- Bug 5478419
    X_LAST_UPDATED_BY => p_carrier_info.LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN => p_carrier_info.LAST_UPDATE_LOGIN);

Line: 264


     UPDATE ORG_FREIGHT_TL
     SET    party_id = p_csm_info.carrier_id,
            disable_date = l_disable_date
     WHERE  freight_code = p_carrier_info.p_freight_code
     and    organization_id = p_org_carrier_service_info.organization_id;

Line: 270


        WSH_DEBUG_SV.log(l_module_name,'Rows updated',SQL%ROWCOUNT);

Line: 313


   UPDATE wsh_Org_Carrier_Services
   SET
   enabled_flag        = p_org_Carrier_Service_Info.Enabled_Flag,
   attribute_category  = p_org_Carrier_Service_Info.Attribute_Category,
   attribute1	       = p_org_Carrier_Service_Info.Attribute1,
   attribute2	       = p_org_Carrier_Service_Info.Attribute2,
   attribute3	       = p_org_Carrier_Service_Info.Attribute3,
   attribute4	       = p_org_Carrier_Service_Info.Attribute4,
   attribute5	       = p_org_Carrier_Service_Info.Attribute5,
   attribute6	       = p_org_Carrier_Service_Info.Attribute6,
   attribute7	       = p_org_Carrier_Service_Info.Attribute7,
   attribute8	       = p_org_Carrier_Service_Info.Attribute8,
   attribute9	       = p_org_Carrier_Service_Info.Attribute9,
   attribute10	       = p_org_Carrier_Service_Info.Attribute10,
   attribute11	       = p_org_Carrier_Service_Info.Attribute11,
   attribute12	       = p_org_Carrier_Service_Info.Attribute12,
   attribute13	       = p_org_Carrier_Service_Info.Attribute13,
   attribute14	       = p_org_Carrier_Service_Info.Attribute14,
   attribute15	       = p_org_Carrier_Service_Info.Attribute15,
   last_update_date    = p_org_Carrier_Service_Info.Last_Update_Date,
   last_updated_by     = p_org_Carrier_Service_Info.Last_Updated_By,
   last_update_login   = p_org_Carrier_Service_Info.Last_Update_Login
   WHERE rowid = x_rowid;

Line: 345


        UPDATE WSH_CARRIER_SHIP_METHODS
        SET    ENABLED_FLAG = p_org_Carrier_Service_Info.Enabled_Flag,
               WEB_ENABLED  = p_csm_info.web_enabled
        WHERE  ORGANIZATION_ID =  p_csm_info.organization_id
        AND    SHIP_METHOD_CODE = p_csm_info.ship_method_code;

Line: 378


       l_orgfgt_update_allowed := 'N';

Line: 380


       l_orgfgt_update_allowed := 'Y';

Line: 385


    L_PROCEDURE := 'Calling ORG_FREIGHT_TL.Update_Row';

Line: 388


        WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit ORG_FREIGHT_TL_PKG.UPDATE_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);

Line: 392


  IF (l_orgfgt_update_allowed = 'Y') THEN -- Update Allowled
  --
  --Start of fix for bug 6126916: Get Org_Freight_Tl details
  OPEN  c_get_org_freight_tl( p_carrier_info.P_FREIGHT_CODE, p_org_carrier_service_info.ORGANIZATION_ID );

Line: 405


  ORG_FREIGHT_TL_PKG.UPDATE_ROW(
    X_FREIGHT_CODE => p_carrier_info.P_FREIGHT_CODE,
    X_FREIGHT_CODE_TL => p_carrier_info.P_FREIGHT_CODE,
    X_ORGANIZATION_ID => p_org_carrier_service_info.ORGANIZATION_ID,
    X_DISABLE_DATE => l_disable_date,
    X_DISTRIBUTION_ACCOUNT => nvl(p_org_Carrier_Service_Info.DISTRIBUTION_ACCOUNT, l_distribution_account),
    --Bug 6126916: While updating, populate DFF and GDF values from
    --             Org_Freight_Tl table
    X_ATTRIBUTE_CATEGORY => l_org_freight_tl_info.ATTRIBUTE_CATEGORY,
    X_ATTRIBUTE1  => l_org_freight_tl_info.ATTRIBUTE1,
    X_ATTRIBUTE2  => l_org_freight_tl_info.ATTRIBUTE2,
    X_ATTRIBUTE3  => l_org_freight_tl_info.ATTRIBUTE3,
    X_ATTRIBUTE4  => l_org_freight_tl_info.ATTRIBUTE4,
    X_ATTRIBUTE5  => l_org_freight_tl_info.ATTRIBUTE5,
    X_ATTRIBUTE6  => l_org_freight_tl_info.ATTRIBUTE6,
    X_ATTRIBUTE7  => l_org_freight_tl_info.ATTRIBUTE7,
    X_ATTRIBUTE8  => l_org_freight_tl_info.ATTRIBUTE8,
    X_ATTRIBUTE9  => l_org_freight_tl_info.ATTRIBUTE9,
    X_ATTRIBUTE10 => l_org_freight_tl_info.ATTRIBUTE10,
    X_ATTRIBUTE11 => l_org_freight_tl_info.ATTRIBUTE11,
    X_ATTRIBUTE12 => l_org_freight_tl_info.ATTRIBUTE12,
    X_ATTRIBUTE13 => l_org_freight_tl_info.ATTRIBUTE13,
    X_ATTRIBUTE14 => l_org_freight_tl_info.ATTRIBUTE14,
    X_ATTRIBUTE15 => l_org_freight_tl_info.ATTRIBUTE15,
    X_GLOBAL_ATTRIBUTE1  => l_org_freight_tl_info.GLOBAL_ATTRIBUTE1,
    X_GLOBAL_ATTRIBUTE2  => l_org_freight_tl_info.GLOBAL_ATTRIBUTE2,
    X_GLOBAL_ATTRIBUTE3  => l_org_freight_tl_info.GLOBAL_ATTRIBUTE3,
    X_GLOBAL_ATTRIBUTE4  => l_org_freight_tl_info.GLOBAL_ATTRIBUTE4,
    X_GLOBAL_ATTRIBUTE5  => l_org_freight_tl_info.GLOBAL_ATTRIBUTE5,
    X_GLOBAL_ATTRIBUTE6  => l_org_freight_tl_info.GLOBAL_ATTRIBUTE6,
    X_GLOBAL_ATTRIBUTE7  => l_org_freight_tl_info.GLOBAL_ATTRIBUTE7,
    X_GLOBAL_ATTRIBUTE8  => l_org_freight_tl_info.GLOBAL_ATTRIBUTE8,
    X_GLOBAL_ATTRIBUTE9  => l_org_freight_tl_info.GLOBAL_ATTRIBUTE9,
    X_GLOBAL_ATTRIBUTE10 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE10,
    X_GLOBAL_ATTRIBUTE11 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE11,
    X_GLOBAL_ATTRIBUTE12 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE12,
    X_GLOBAL_ATTRIBUTE13 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE13,
    X_GLOBAL_ATTRIBUTE14 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE14,
    X_GLOBAL_ATTRIBUTE15 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE15,
    X_GLOBAL_ATTRIBUTE16 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE16,
    X_GLOBAL_ATTRIBUTE17 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE17,
    X_GLOBAL_ATTRIBUTE18 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE18,
    X_GLOBAL_ATTRIBUTE19 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE19,
    X_GLOBAL_ATTRIBUTE20 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE20,
    X_GLOBAL_ATTRIBUTE_CATEGORY => l_org_freight_tl_info.GLOBAL_ATTRIBUTE_CATEGORY,
    X_DESCRIPTION =>substrb(p_carrier_info.P_CARRIER_NAME,1,80),
    X_LAST_UPDATE_DATE => SYSDATE, -- Bug 5478419
    X_LAST_UPDATED_BY => p_carrier_info.LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN => p_carrier_info.LAST_UPDATE_LOGIN);

Line: 464


     UPDATE ORG_FREIGHT_TL
     SET    party_id = p_csm_info.carrier_id
     WHERE  freight_code = p_carrier_info.p_freight_code
     and    organization_id = p_org_carrier_service_info.organization_id;

Line: 469


        WSH_DEBUG_SV.log(l_module_name,'Update with carrier_id '||p_csm_info.carrier_id,SQL%ROWCOUNT);

Line: 477


  END IF; -- End Update Allowled

Line: 539


SELECT *
FROM   wsh_Org_Carrier_Services
WHERE  rowid = p_rowid
FOR UPDATE of Org_Carrier_Service_id NOWAIT;

Line: 576


      FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');