324: P_Carrier_info.Attribute13,
325: P_Carrier_info.Attribute14,
326: P_Carrier_info.Attribute15,
327: sysdate,
328: FND_GLOBAL.USER_ID,
329: sysdate,
330: FND_GLOBAL.USER_ID,
331: FND_GLOBAL.LOGIN_ID,
332: -- Pack J
326: P_Carrier_info.Attribute15,
327: sysdate,
328: FND_GLOBAL.USER_ID,
329: sysdate,
330: FND_GLOBAL.USER_ID,
331: FND_GLOBAL.LOGIN_ID,
332: -- Pack J
333: P_Carrier_info.MAX_NUM_STOPS_PERMITTED,
334: P_Carrier_info.MAX_TOTAL_DISTANCE,
327: sysdate,
328: FND_GLOBAL.USER_ID,
329: sysdate,
330: FND_GLOBAL.USER_ID,
331: FND_GLOBAL.LOGIN_ID,
332: -- Pack J
333: P_Carrier_info.MAX_NUM_STOPS_PERMITTED,
334: P_Carrier_info.MAX_TOTAL_DISTANCE,
335: P_Carrier_info.MAX_TOTAL_TIME,
702: attribute13 = P_Carrier_info.Attribute13,
703: attribute14 = P_Carrier_info.Attribute14,
704: attribute15 = P_Carrier_info.Attribute15,
705: last_update_date = sysdate,
706: last_updated_by = FND_GLOBAL.USER_ID,
707: last_update_login = FND_GLOBAL.login_id,
708: -- Pack J
709: MAX_NUM_STOPS_PERMITTED = P_Carrier_info.MAX_NUM_STOPS_PERMITTED,
710: MAX_TOTAL_DISTANCE = P_Carrier_info.MAX_TOTAL_DISTANCE,
703: attribute14 = P_Carrier_info.Attribute14,
704: attribute15 = P_Carrier_info.Attribute15,
705: last_update_date = sysdate,
706: last_updated_by = FND_GLOBAL.USER_ID,
707: last_update_login = FND_GLOBAL.login_id,
708: -- Pack J
709: MAX_NUM_STOPS_PERMITTED = P_Carrier_info.MAX_NUM_STOPS_PERMITTED,
710: MAX_TOTAL_DISTANCE = P_Carrier_info.MAX_TOTAL_DISTANCE,
711: MAX_TOTAL_TIME = P_Carrier_info.MAX_TOTAL_TIME,
772: attribute13 = P_Carrier_info.Attribute13,
773: attribute14 = P_Carrier_info.Attribute14,
774: attribute15 = P_Carrier_info.Attribute15,
775: last_update_date = sysdate,
776: last_updated_by = FND_GLOBAL.USER_ID,
777: last_update_login = FND_GLOBAL.login_id
778: WHERE freight_code = P_Carrier_info.FREIGHT_CODE;
779:
780: IF FND_API.To_Boolean(p_commit) THEN
773: attribute14 = P_Carrier_info.Attribute14,
774: attribute15 = P_Carrier_info.Attribute15,
775: last_update_date = sysdate,
776: last_updated_by = FND_GLOBAL.USER_ID,
777: last_update_login = FND_GLOBAL.login_id
778: WHERE freight_code = P_Carrier_info.FREIGHT_CODE;
779:
780: IF FND_API.To_Boolean(p_commit) THEN
781: COMMIT;
1669: X_ATTRIBUTE15 => lookupinfo.ATTRIBUTE15,
1670: X_MEANING => lookupinfo.MEANING,
1671: X_DESCRIPTION => lookupinfo.DESCRIPTION,
1672: X_LAST_UPDATE_DATE => sysdate,
1673: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1674: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID
1675: );
1676: END IF;
1677: FETCH C_get_carrier_services INTO l_carrier_service_id;
1670: X_MEANING => lookupinfo.MEANING,
1671: X_DESCRIPTION => lookupinfo.DESCRIPTION,
1672: X_LAST_UPDATE_DATE => sysdate,
1673: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1674: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID
1675: );
1676: END IF;
1677: FETCH C_get_carrier_services INTO l_carrier_service_id;
1678: END LOOP;