237: X_ATTRIBUTE15 => NULL,
238: X_MEANING => p_Carrier_Service_Info.ship_method_meaning,
239: X_DESCRIPTION => p_Carrier_Service_Info.ship_method_meaning,
240: X_CREATION_DATE => sysdate,
241: X_CREATED_BY => FND_GLOBAL.USER_ID,
242: X_LAST_UPDATE_DATE => SYSDATE,
243: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
244: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID);
245:
239: X_DESCRIPTION => p_Carrier_Service_Info.ship_method_meaning,
240: X_CREATION_DATE => sysdate,
241: X_CREATED_BY => FND_GLOBAL.USER_ID,
242: X_LAST_UPDATE_DATE => SYSDATE,
243: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
244: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID);
245:
246: END IF;
247:
240: X_CREATION_DATE => sysdate,
241: X_CREATED_BY => FND_GLOBAL.USER_ID,
242: X_LAST_UPDATE_DATE => SYSDATE,
243: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
244: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID);
245:
246: END IF;
247:
248: l_position := 20;
1283: X_ATTRIBUTE15 => lookupinfo.ATTRIBUTE15,
1284: X_MEANING => p_Carrier_Service_Info.SHIP_METHOD_MEANING,
1285: X_DESCRIPTION => p_Carrier_Service_Info.SHIP_METHOD_MEANING,
1286: X_LAST_UPDATE_DATE => sysdate,
1287: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1288: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID
1289: );
1290:
1291: l_position := 40;
1284: X_MEANING => p_Carrier_Service_Info.SHIP_METHOD_MEANING,
1285: X_DESCRIPTION => p_Carrier_Service_Info.SHIP_METHOD_MEANING,
1286: X_LAST_UPDATE_DATE => sysdate,
1287: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1288: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID
1289: );
1290:
1291: l_position := 40;
1292: l_procedure := 'Updating WSH_CARRIER_SHIP_METHODS';
1295: IF C_freight_code%found THEN
1296: UPDATE WSH_CARRIER_SHIP_METHODS
1297: SET WEB_ENABLED = p_Carrier_Service_Info.Web_Enabled,
1298: LAST_UPDATE_DATE =sysdate,
1299: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1300: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
1301: ATTRIBUTE1 = p_Carrier_Service_Info.Attribute1,
1302: ATTRIBUTE2 = p_Carrier_Service_Info.Attribute2,
1303: ATTRIBUTE3 = p_Carrier_Service_Info.Attribute3,
1296: UPDATE WSH_CARRIER_SHIP_METHODS
1297: SET WEB_ENABLED = p_Carrier_Service_Info.Web_Enabled,
1298: LAST_UPDATE_DATE =sysdate,
1299: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1300: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
1301: ATTRIBUTE1 = p_Carrier_Service_Info.Attribute1,
1302: ATTRIBUTE2 = p_Carrier_Service_Info.Attribute2,
1303: ATTRIBUTE3 = p_Carrier_Service_Info.Attribute3,
1304: ATTRIBUTE4 = p_Carrier_Service_Info.Attribute4,