APPS.WSH_ORG_CARRIER_SITES_PKG SQL Statements

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

Line: 23

SELECT wsh_org_Carrier_sites_s.nextval
FROM sys.dual;

Line: 29

SELECT rowid
FROM   WSH_org_Carrier_sites
WHERE org_Carrier_site_id = p_org_Carrier_site_id;

Line: 95

     l_procedure := 'Inserting into Wsh_org_carrier_sites';

Line: 101

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

Line: 105

     INSERT INTO WSH_ORG_CARRIER_SITES
     (   org_Carrier_site_id,
         carrier_site_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_Site_id,
	 p_org_Carrier_site_Info.carrier_site_id,
	 p_org_Carrier_site_Info.organization_id,
	 p_org_Carrier_site_Info.Enabled_Flag,
	 p_org_Carrier_site_Info.Attribute_Category,
	 p_org_Carrier_site_Info.Attribute1,
	 p_org_Carrier_site_Info.Attribute2,
	 p_org_Carrier_site_Info.Attribute3,
	 p_org_Carrier_site_Info.Attribute4,
	 p_org_Carrier_site_Info.Attribute5,
	 p_org_Carrier_site_Info.Attribute6,
	 p_org_Carrier_site_Info.Attribute7,
	 p_org_Carrier_site_Info.Attribute8,
	 p_org_Carrier_site_Info.Attribute9,
	 p_org_Carrier_site_Info.Attribute10,
	 p_org_Carrier_site_Info.Attribute11,
	 p_org_Carrier_site_Info.Attribute12,
	 p_org_Carrier_site_Info.Attribute13,
	 p_org_Carrier_site_Info.Attribute14,
	 p_org_Carrier_site_Info.Attribute15,
	 sysdate,
	 fnd_global.user_id,
	 sysdate,
	 fnd_global.user_id,
	 fnd_global.login_id);

Line: 180

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

Line: 266

SELECT *
FROM   wsh_Org_Carrier_sites
WHERE  rowid = p_rowid
FOR UPDATE of Org_Carrier_site_id NOWAIT;

Line: 307

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