The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT wsh_org_Carrier_Services_s.nextval
FROM sys.dual;
SELECT rowid
FROM WSH_org_Carrier_ServiceS
WHERE org_Carrier_Service_id = p_org_Carrier_Service_id;
SELECT distribution_account
FROM ORG_FREIGHT_TL
WHERE freight_code = p_freight_code
and organization_id = p_organization_id;
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;
select * from org_freight_tl
where freight_code = p_freight_code
and organization_id = p_organization_id
and language = userenv('LANG');
l_orgfgt_update_allowed VARCHAR2(1);
l_procedure := 'Inserting into Wsh_org_carrier_services';
WSH_DEBUG_SV.logmsg(l_module_name,'Inserting into WSH_ORG_CARRIER_SERVICES',WSH_DEBUG_SV.C_PROC_LEVEL);
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);
WSH_DEBUG_SV.log(l_module_name,'Rows inserted',SQL%ROWCOUNT);
l_procedure := 'Inserting into ORG_FREIGHT_TL';
WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit ORG_FREIGHT_TL_PKG.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
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);
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;
WSH_DEBUG_SV.log(l_module_name,'Rows updated',SQL%ROWCOUNT);
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;
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;
l_orgfgt_update_allowed := 'N';
l_orgfgt_update_allowed := 'Y';
L_PROCEDURE := 'Calling ORG_FREIGHT_TL.Update_Row';
WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit ORG_FREIGHT_TL_PKG.UPDATE_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
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 );
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);
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;
WSH_DEBUG_SV.log(l_module_name,'Update with carrier_id '||p_csm_info.carrier_id,SQL%ROWCOUNT);
END IF; -- End Update Allowled
SELECT *
FROM wsh_Org_Carrier_Services
WHERE rowid = p_rowid
FOR UPDATE of Org_Carrier_Service_id NOWAIT;
FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');