APPS.WSH_ORG_CARRIER_SERVICES_PKG dependencies on ORG_FREIGHT_TL

Line 43: FROM ORG_FREIGHT_TL

39:
40: --- Bug 2796816
41: CURSOR c_distribution_account(p_freight_code varchar2,p_organization_id number) is
42: SELECT distribution_account
43: FROM ORG_FREIGHT_TL
44: WHERE freight_code = p_freight_code
45: and organization_id = p_organization_id;
46:
47: CURSOR c_service_exists

Line 61: --bug 6126916: cursor to fetch org_freight_tl details

57: and wocs.organization_id = p_organization_id
58: and wocs.enabled_flag = 'Y'
59: and rownum =1;
60:
61: --bug 6126916: cursor to fetch org_freight_tl details
62: CURSOR c_get_org_freight_tl( p_freight_code varchar2, p_organization_id number) is
63: select * from org_freight_tl
64: where freight_code = p_freight_code
65: and organization_id = p_organization_id

Line 62: CURSOR c_get_org_freight_tl( p_freight_code varchar2, p_organization_id number) is

58: and wocs.enabled_flag = 'Y'
59: and rownum =1;
60:
61: --bug 6126916: cursor to fetch org_freight_tl details
62: CURSOR c_get_org_freight_tl( p_freight_code varchar2, p_organization_id number) is
63: select * from org_freight_tl
64: where freight_code = p_freight_code
65: and organization_id = p_organization_id
66: and language = userenv('LANG');

Line 63: select * from org_freight_tl

59: and rownum =1;
60:
61: --bug 6126916: cursor to fetch org_freight_tl details
62: CURSOR c_get_org_freight_tl( p_freight_code varchar2, p_organization_id number) is
63: select * from org_freight_tl
64: where freight_code = p_freight_code
65: and organization_id = p_organization_id
66: and language = userenv('LANG');
67:

Line 79: l_org_freight_tl_info c_get_org_freight_tl%rowtype;

75: l_carrier_ship_method_id NUMBER;
76: l_csm_info WSH_CARRIER_SHIP_METHODS_PKG.CSMRecType;
77:
78: --Variable added for bug 6126916
79: l_org_freight_tl_info c_get_org_freight_tl%rowtype;
80:
81: NO_DATA_FOUND EXCEPTION;
82: OTHERS EXCEPTION;
83: Failed_in_CSM EXCEPTION;

Line 86: l_distribution_account ORG_FREIGHT_TL.distribution_account%type;

82: OTHERS EXCEPTION;
83: Failed_in_CSM EXCEPTION;
84: l_return_status VARCHAR2(10);
85: l_service_exists varchar2(2) := 'N'; --- 2796816
86: l_distribution_account ORG_FREIGHT_TL.distribution_account%type;
87: l_orgfgt_update_allowed VARCHAR2(1);
88: --
89: l_debug_on BOOLEAN;
90: --

Line 196: l_procedure := 'Inserting into ORG_FREIGHT_TL';

192: RAISE others;
193: END IF;
194:
195: l_position := 20;
196: l_procedure := 'Inserting into ORG_FREIGHT_TL';
197: --
198: IF l_debug_on THEN
199: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit ORG_FREIGHT_TL_PKG.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
200: END IF;

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

195: l_position := 20;
196: l_procedure := 'Inserting into ORG_FREIGHT_TL';
197: --
198: IF l_debug_on THEN
199: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit ORG_FREIGHT_TL_PKG.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
200: END IF;
201: --
202: ORG_FREIGHT_TL_PKG.INSERT_ROW(
203: X_ROWID => l_oft_rowid,

Line 202: ORG_FREIGHT_TL_PKG.INSERT_ROW(

198: IF l_debug_on THEN
199: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit ORG_FREIGHT_TL_PKG.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
200: END IF;
201: --
202: ORG_FREIGHT_TL_PKG.INSERT_ROW(
203: X_ROWID => l_oft_rowid,
204: X_FREIGHT_CODE => p_carrier_info.P_FREIGHT_CODE,
205: X_FREIGHT_CODE_TL => p_carrier_info.P_FREIGHT_CODE,
206: X_ORGANIZATION_ID => p_org_carrier_service_info.ORGANIZATION_ID,

Line 256: l_procedure := 'Updating Org_Freight_TL';

252: X_LAST_UPDATED_BY => p_carrier_info.LAST_UPDATED_BY,
253: X_LAST_UPDATE_LOGIN => p_carrier_info.LAST_UPDATE_LOGIN);
254:
255: l_position := 30;
256: l_procedure := 'Updating Org_Freight_TL';
257:
258: --
259: IF l_debug_on THEN
260: WSH_DEBUG_SV.logmsg(l_module_name,'Updating ORG_FREIGHT_TL',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 260: WSH_DEBUG_SV.logmsg(l_module_name,'Updating ORG_FREIGHT_TL',WSH_DEBUG_SV.C_PROC_LEVEL);

256: l_procedure := 'Updating Org_Freight_TL';
257:
258: --
259: IF l_debug_on THEN
260: WSH_DEBUG_SV.logmsg(l_module_name,'Updating ORG_FREIGHT_TL',WSH_DEBUG_SV.C_PROC_LEVEL);
261: END IF;
262: --
263:
264: UPDATE ORG_FREIGHT_TL

Line 264: UPDATE ORG_FREIGHT_TL

260: WSH_DEBUG_SV.logmsg(l_module_name,'Updating ORG_FREIGHT_TL',WSH_DEBUG_SV.C_PROC_LEVEL);
261: END IF;
262: --
263:
264: UPDATE ORG_FREIGHT_TL
265: SET party_id = p_csm_info.carrier_id,
266: disable_date = l_disable_date
267: WHERE freight_code = p_carrier_info.p_freight_code
268: and organization_id = p_org_carrier_service_info.organization_id;

Line 374: -- Bug 3537378 : Do not call ORG_FREIGHT_TL.Update_Row if Enabled Flag is N and SERVICE exist is N

370: END IF;
371: -- Bug 2796816 End
372:
373:
374: -- Bug 3537378 : Do not call ORG_FREIGHT_TL.Update_Row if Enabled Flag is N and SERVICE exist is N
375: -- Should not Update the Org. Fgt. Record, Nothing to Update in Org. Freight
376: -- Functionality: Inactivating a Org. Car. Svc. SHOULD NOT Disable/Inactivate an Org.Fgt.tl record
377: IF ( p_org_Carrier_Service_Info.Enabled_Flag = 'N' and l_service_exists = 'N' ) THEN
378: l_orgfgt_update_allowed := 'N';

Line 385: L_PROCEDURE := 'Calling ORG_FREIGHT_TL.Update_Row';

381: END IF;
382:
383:
384: L_POSITION := 40;
385: L_PROCEDURE := 'Calling ORG_FREIGHT_TL.Update_Row';
386: --
387: IF l_debug_on THEN
388: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit ORG_FREIGHT_TL_PKG.UPDATE_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
389: END IF;

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

384: L_POSITION := 40;
385: L_PROCEDURE := 'Calling ORG_FREIGHT_TL.Update_Row';
386: --
387: IF l_debug_on THEN
388: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit ORG_FREIGHT_TL_PKG.UPDATE_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
389: END IF;
390:
391: -- Bug 3537378
392: IF (l_orgfgt_update_allowed = 'Y') THEN -- Update Allowled

Line 394: --Start of fix for bug 6126916: Get Org_Freight_Tl details

390:
391: -- Bug 3537378
392: IF (l_orgfgt_update_allowed = 'Y') THEN -- Update Allowled
393: --
394: --Start of fix for bug 6126916: Get Org_Freight_Tl details
395: OPEN c_get_org_freight_tl( p_carrier_info.P_FREIGHT_CODE, p_org_carrier_service_info.ORGANIZATION_ID );
396: FETCH c_get_org_freight_tl into l_org_freight_tl_info;
397: --
398: IF l_debug_on THEN

Line 395: OPEN c_get_org_freight_tl( p_carrier_info.P_FREIGHT_CODE, p_org_carrier_service_info.ORGANIZATION_ID );

391: -- Bug 3537378
392: IF (l_orgfgt_update_allowed = 'Y') THEN -- Update Allowled
393: --
394: --Start of fix for bug 6126916: Get Org_Freight_Tl details
395: OPEN c_get_org_freight_tl( p_carrier_info.P_FREIGHT_CODE, p_org_carrier_service_info.ORGANIZATION_ID );
396: FETCH c_get_org_freight_tl into l_org_freight_tl_info;
397: --
398: IF l_debug_on THEN
399: WSH_DEBUG_SV.logmsg(l_module_name,'No of rows fetched from cursor c_get_org_freight_tl: ' || c_get_org_freight_tl%ROWCOUNT);

Line 396: FETCH c_get_org_freight_tl into l_org_freight_tl_info;

392: IF (l_orgfgt_update_allowed = 'Y') THEN -- Update Allowled
393: --
394: --Start of fix for bug 6126916: Get Org_Freight_Tl details
395: OPEN c_get_org_freight_tl( p_carrier_info.P_FREIGHT_CODE, p_org_carrier_service_info.ORGANIZATION_ID );
396: FETCH c_get_org_freight_tl into l_org_freight_tl_info;
397: --
398: IF l_debug_on THEN
399: WSH_DEBUG_SV.logmsg(l_module_name,'No of rows fetched from cursor c_get_org_freight_tl: ' || c_get_org_freight_tl%ROWCOUNT);
400: END IF;

Line 399: WSH_DEBUG_SV.logmsg(l_module_name,'No of rows fetched from cursor c_get_org_freight_tl: ' || c_get_org_freight_tl%ROWCOUNT);

395: OPEN c_get_org_freight_tl( p_carrier_info.P_FREIGHT_CODE, p_org_carrier_service_info.ORGANIZATION_ID );
396: FETCH c_get_org_freight_tl into l_org_freight_tl_info;
397: --
398: IF l_debug_on THEN
399: WSH_DEBUG_SV.logmsg(l_module_name,'No of rows fetched from cursor c_get_org_freight_tl: ' || c_get_org_freight_tl%ROWCOUNT);
400: END IF;
401: --
402: CLOSE c_get_org_freight_tl;
403: --End of fix for bug 6126916

Line 402: CLOSE c_get_org_freight_tl;

398: IF l_debug_on THEN
399: WSH_DEBUG_SV.logmsg(l_module_name,'No of rows fetched from cursor c_get_org_freight_tl: ' || c_get_org_freight_tl%ROWCOUNT);
400: END IF;
401: --
402: CLOSE c_get_org_freight_tl;
403: --End of fix for bug 6126916
404:
405: ORG_FREIGHT_TL_PKG.UPDATE_ROW(
406: X_FREIGHT_CODE => p_carrier_info.P_FREIGHT_CODE,

Line 405: ORG_FREIGHT_TL_PKG.UPDATE_ROW(

401: --
402: CLOSE c_get_org_freight_tl;
403: --End of fix for bug 6126916
404:
405: ORG_FREIGHT_TL_PKG.UPDATE_ROW(
406: X_FREIGHT_CODE => p_carrier_info.P_FREIGHT_CODE,
407: X_FREIGHT_CODE_TL => p_carrier_info.P_FREIGHT_CODE,
408: X_ORGANIZATION_ID => p_org_carrier_service_info.ORGANIZATION_ID,
409: X_DISABLE_DATE => l_disable_date,

Line 412: -- Org_Freight_Tl table

408: X_ORGANIZATION_ID => p_org_carrier_service_info.ORGANIZATION_ID,
409: X_DISABLE_DATE => l_disable_date,
410: X_DISTRIBUTION_ACCOUNT => nvl(p_org_Carrier_Service_Info.DISTRIBUTION_ACCOUNT, l_distribution_account),
411: --Bug 6126916: While updating, populate DFF and GDF values from
412: -- Org_Freight_Tl table
413: X_ATTRIBUTE_CATEGORY => l_org_freight_tl_info.ATTRIBUTE_CATEGORY,
414: X_ATTRIBUTE1 => l_org_freight_tl_info.ATTRIBUTE1,
415: X_ATTRIBUTE2 => l_org_freight_tl_info.ATTRIBUTE2,
416: X_ATTRIBUTE3 => l_org_freight_tl_info.ATTRIBUTE3,

Line 413: X_ATTRIBUTE_CATEGORY => l_org_freight_tl_info.ATTRIBUTE_CATEGORY,

409: X_DISABLE_DATE => l_disable_date,
410: X_DISTRIBUTION_ACCOUNT => nvl(p_org_Carrier_Service_Info.DISTRIBUTION_ACCOUNT, l_distribution_account),
411: --Bug 6126916: While updating, populate DFF and GDF values from
412: -- Org_Freight_Tl table
413: X_ATTRIBUTE_CATEGORY => l_org_freight_tl_info.ATTRIBUTE_CATEGORY,
414: X_ATTRIBUTE1 => l_org_freight_tl_info.ATTRIBUTE1,
415: X_ATTRIBUTE2 => l_org_freight_tl_info.ATTRIBUTE2,
416: X_ATTRIBUTE3 => l_org_freight_tl_info.ATTRIBUTE3,
417: X_ATTRIBUTE4 => l_org_freight_tl_info.ATTRIBUTE4,

Line 414: X_ATTRIBUTE1 => l_org_freight_tl_info.ATTRIBUTE1,

410: X_DISTRIBUTION_ACCOUNT => nvl(p_org_Carrier_Service_Info.DISTRIBUTION_ACCOUNT, l_distribution_account),
411: --Bug 6126916: While updating, populate DFF and GDF values from
412: -- Org_Freight_Tl table
413: X_ATTRIBUTE_CATEGORY => l_org_freight_tl_info.ATTRIBUTE_CATEGORY,
414: X_ATTRIBUTE1 => l_org_freight_tl_info.ATTRIBUTE1,
415: X_ATTRIBUTE2 => l_org_freight_tl_info.ATTRIBUTE2,
416: X_ATTRIBUTE3 => l_org_freight_tl_info.ATTRIBUTE3,
417: X_ATTRIBUTE4 => l_org_freight_tl_info.ATTRIBUTE4,
418: X_ATTRIBUTE5 => l_org_freight_tl_info.ATTRIBUTE5,

Line 415: X_ATTRIBUTE2 => l_org_freight_tl_info.ATTRIBUTE2,

411: --Bug 6126916: While updating, populate DFF and GDF values from
412: -- Org_Freight_Tl table
413: X_ATTRIBUTE_CATEGORY => l_org_freight_tl_info.ATTRIBUTE_CATEGORY,
414: X_ATTRIBUTE1 => l_org_freight_tl_info.ATTRIBUTE1,
415: X_ATTRIBUTE2 => l_org_freight_tl_info.ATTRIBUTE2,
416: X_ATTRIBUTE3 => l_org_freight_tl_info.ATTRIBUTE3,
417: X_ATTRIBUTE4 => l_org_freight_tl_info.ATTRIBUTE4,
418: X_ATTRIBUTE5 => l_org_freight_tl_info.ATTRIBUTE5,
419: X_ATTRIBUTE6 => l_org_freight_tl_info.ATTRIBUTE6,

Line 416: X_ATTRIBUTE3 => l_org_freight_tl_info.ATTRIBUTE3,

412: -- Org_Freight_Tl table
413: X_ATTRIBUTE_CATEGORY => l_org_freight_tl_info.ATTRIBUTE_CATEGORY,
414: X_ATTRIBUTE1 => l_org_freight_tl_info.ATTRIBUTE1,
415: X_ATTRIBUTE2 => l_org_freight_tl_info.ATTRIBUTE2,
416: X_ATTRIBUTE3 => l_org_freight_tl_info.ATTRIBUTE3,
417: X_ATTRIBUTE4 => l_org_freight_tl_info.ATTRIBUTE4,
418: X_ATTRIBUTE5 => l_org_freight_tl_info.ATTRIBUTE5,
419: X_ATTRIBUTE6 => l_org_freight_tl_info.ATTRIBUTE6,
420: X_ATTRIBUTE7 => l_org_freight_tl_info.ATTRIBUTE7,

Line 417: X_ATTRIBUTE4 => l_org_freight_tl_info.ATTRIBUTE4,

413: X_ATTRIBUTE_CATEGORY => l_org_freight_tl_info.ATTRIBUTE_CATEGORY,
414: X_ATTRIBUTE1 => l_org_freight_tl_info.ATTRIBUTE1,
415: X_ATTRIBUTE2 => l_org_freight_tl_info.ATTRIBUTE2,
416: X_ATTRIBUTE3 => l_org_freight_tl_info.ATTRIBUTE3,
417: X_ATTRIBUTE4 => l_org_freight_tl_info.ATTRIBUTE4,
418: X_ATTRIBUTE5 => l_org_freight_tl_info.ATTRIBUTE5,
419: X_ATTRIBUTE6 => l_org_freight_tl_info.ATTRIBUTE6,
420: X_ATTRIBUTE7 => l_org_freight_tl_info.ATTRIBUTE7,
421: X_ATTRIBUTE8 => l_org_freight_tl_info.ATTRIBUTE8,

Line 418: X_ATTRIBUTE5 => l_org_freight_tl_info.ATTRIBUTE5,

414: X_ATTRIBUTE1 => l_org_freight_tl_info.ATTRIBUTE1,
415: X_ATTRIBUTE2 => l_org_freight_tl_info.ATTRIBUTE2,
416: X_ATTRIBUTE3 => l_org_freight_tl_info.ATTRIBUTE3,
417: X_ATTRIBUTE4 => l_org_freight_tl_info.ATTRIBUTE4,
418: X_ATTRIBUTE5 => l_org_freight_tl_info.ATTRIBUTE5,
419: X_ATTRIBUTE6 => l_org_freight_tl_info.ATTRIBUTE6,
420: X_ATTRIBUTE7 => l_org_freight_tl_info.ATTRIBUTE7,
421: X_ATTRIBUTE8 => l_org_freight_tl_info.ATTRIBUTE8,
422: X_ATTRIBUTE9 => l_org_freight_tl_info.ATTRIBUTE9,

Line 419: X_ATTRIBUTE6 => l_org_freight_tl_info.ATTRIBUTE6,

415: X_ATTRIBUTE2 => l_org_freight_tl_info.ATTRIBUTE2,
416: X_ATTRIBUTE3 => l_org_freight_tl_info.ATTRIBUTE3,
417: X_ATTRIBUTE4 => l_org_freight_tl_info.ATTRIBUTE4,
418: X_ATTRIBUTE5 => l_org_freight_tl_info.ATTRIBUTE5,
419: X_ATTRIBUTE6 => l_org_freight_tl_info.ATTRIBUTE6,
420: X_ATTRIBUTE7 => l_org_freight_tl_info.ATTRIBUTE7,
421: X_ATTRIBUTE8 => l_org_freight_tl_info.ATTRIBUTE8,
422: X_ATTRIBUTE9 => l_org_freight_tl_info.ATTRIBUTE9,
423: X_ATTRIBUTE10 => l_org_freight_tl_info.ATTRIBUTE10,

Line 420: X_ATTRIBUTE7 => l_org_freight_tl_info.ATTRIBUTE7,

416: X_ATTRIBUTE3 => l_org_freight_tl_info.ATTRIBUTE3,
417: X_ATTRIBUTE4 => l_org_freight_tl_info.ATTRIBUTE4,
418: X_ATTRIBUTE5 => l_org_freight_tl_info.ATTRIBUTE5,
419: X_ATTRIBUTE6 => l_org_freight_tl_info.ATTRIBUTE6,
420: X_ATTRIBUTE7 => l_org_freight_tl_info.ATTRIBUTE7,
421: X_ATTRIBUTE8 => l_org_freight_tl_info.ATTRIBUTE8,
422: X_ATTRIBUTE9 => l_org_freight_tl_info.ATTRIBUTE9,
423: X_ATTRIBUTE10 => l_org_freight_tl_info.ATTRIBUTE10,
424: X_ATTRIBUTE11 => l_org_freight_tl_info.ATTRIBUTE11,

Line 421: X_ATTRIBUTE8 => l_org_freight_tl_info.ATTRIBUTE8,

417: X_ATTRIBUTE4 => l_org_freight_tl_info.ATTRIBUTE4,
418: X_ATTRIBUTE5 => l_org_freight_tl_info.ATTRIBUTE5,
419: X_ATTRIBUTE6 => l_org_freight_tl_info.ATTRIBUTE6,
420: X_ATTRIBUTE7 => l_org_freight_tl_info.ATTRIBUTE7,
421: X_ATTRIBUTE8 => l_org_freight_tl_info.ATTRIBUTE8,
422: X_ATTRIBUTE9 => l_org_freight_tl_info.ATTRIBUTE9,
423: X_ATTRIBUTE10 => l_org_freight_tl_info.ATTRIBUTE10,
424: X_ATTRIBUTE11 => l_org_freight_tl_info.ATTRIBUTE11,
425: X_ATTRIBUTE12 => l_org_freight_tl_info.ATTRIBUTE12,

Line 422: X_ATTRIBUTE9 => l_org_freight_tl_info.ATTRIBUTE9,

418: X_ATTRIBUTE5 => l_org_freight_tl_info.ATTRIBUTE5,
419: X_ATTRIBUTE6 => l_org_freight_tl_info.ATTRIBUTE6,
420: X_ATTRIBUTE7 => l_org_freight_tl_info.ATTRIBUTE7,
421: X_ATTRIBUTE8 => l_org_freight_tl_info.ATTRIBUTE8,
422: X_ATTRIBUTE9 => l_org_freight_tl_info.ATTRIBUTE9,
423: X_ATTRIBUTE10 => l_org_freight_tl_info.ATTRIBUTE10,
424: X_ATTRIBUTE11 => l_org_freight_tl_info.ATTRIBUTE11,
425: X_ATTRIBUTE12 => l_org_freight_tl_info.ATTRIBUTE12,
426: X_ATTRIBUTE13 => l_org_freight_tl_info.ATTRIBUTE13,

Line 423: X_ATTRIBUTE10 => l_org_freight_tl_info.ATTRIBUTE10,

419: X_ATTRIBUTE6 => l_org_freight_tl_info.ATTRIBUTE6,
420: X_ATTRIBUTE7 => l_org_freight_tl_info.ATTRIBUTE7,
421: X_ATTRIBUTE8 => l_org_freight_tl_info.ATTRIBUTE8,
422: X_ATTRIBUTE9 => l_org_freight_tl_info.ATTRIBUTE9,
423: X_ATTRIBUTE10 => l_org_freight_tl_info.ATTRIBUTE10,
424: X_ATTRIBUTE11 => l_org_freight_tl_info.ATTRIBUTE11,
425: X_ATTRIBUTE12 => l_org_freight_tl_info.ATTRIBUTE12,
426: X_ATTRIBUTE13 => l_org_freight_tl_info.ATTRIBUTE13,
427: X_ATTRIBUTE14 => l_org_freight_tl_info.ATTRIBUTE14,

Line 424: X_ATTRIBUTE11 => l_org_freight_tl_info.ATTRIBUTE11,

420: X_ATTRIBUTE7 => l_org_freight_tl_info.ATTRIBUTE7,
421: X_ATTRIBUTE8 => l_org_freight_tl_info.ATTRIBUTE8,
422: X_ATTRIBUTE9 => l_org_freight_tl_info.ATTRIBUTE9,
423: X_ATTRIBUTE10 => l_org_freight_tl_info.ATTRIBUTE10,
424: X_ATTRIBUTE11 => l_org_freight_tl_info.ATTRIBUTE11,
425: X_ATTRIBUTE12 => l_org_freight_tl_info.ATTRIBUTE12,
426: X_ATTRIBUTE13 => l_org_freight_tl_info.ATTRIBUTE13,
427: X_ATTRIBUTE14 => l_org_freight_tl_info.ATTRIBUTE14,
428: X_ATTRIBUTE15 => l_org_freight_tl_info.ATTRIBUTE15,

Line 425: X_ATTRIBUTE12 => l_org_freight_tl_info.ATTRIBUTE12,

421: X_ATTRIBUTE8 => l_org_freight_tl_info.ATTRIBUTE8,
422: X_ATTRIBUTE9 => l_org_freight_tl_info.ATTRIBUTE9,
423: X_ATTRIBUTE10 => l_org_freight_tl_info.ATTRIBUTE10,
424: X_ATTRIBUTE11 => l_org_freight_tl_info.ATTRIBUTE11,
425: X_ATTRIBUTE12 => l_org_freight_tl_info.ATTRIBUTE12,
426: X_ATTRIBUTE13 => l_org_freight_tl_info.ATTRIBUTE13,
427: X_ATTRIBUTE14 => l_org_freight_tl_info.ATTRIBUTE14,
428: X_ATTRIBUTE15 => l_org_freight_tl_info.ATTRIBUTE15,
429: X_GLOBAL_ATTRIBUTE1 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE1,

Line 426: X_ATTRIBUTE13 => l_org_freight_tl_info.ATTRIBUTE13,

422: X_ATTRIBUTE9 => l_org_freight_tl_info.ATTRIBUTE9,
423: X_ATTRIBUTE10 => l_org_freight_tl_info.ATTRIBUTE10,
424: X_ATTRIBUTE11 => l_org_freight_tl_info.ATTRIBUTE11,
425: X_ATTRIBUTE12 => l_org_freight_tl_info.ATTRIBUTE12,
426: X_ATTRIBUTE13 => l_org_freight_tl_info.ATTRIBUTE13,
427: X_ATTRIBUTE14 => l_org_freight_tl_info.ATTRIBUTE14,
428: X_ATTRIBUTE15 => l_org_freight_tl_info.ATTRIBUTE15,
429: X_GLOBAL_ATTRIBUTE1 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE1,
430: X_GLOBAL_ATTRIBUTE2 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE2,

Line 427: X_ATTRIBUTE14 => l_org_freight_tl_info.ATTRIBUTE14,

423: X_ATTRIBUTE10 => l_org_freight_tl_info.ATTRIBUTE10,
424: X_ATTRIBUTE11 => l_org_freight_tl_info.ATTRIBUTE11,
425: X_ATTRIBUTE12 => l_org_freight_tl_info.ATTRIBUTE12,
426: X_ATTRIBUTE13 => l_org_freight_tl_info.ATTRIBUTE13,
427: X_ATTRIBUTE14 => l_org_freight_tl_info.ATTRIBUTE14,
428: X_ATTRIBUTE15 => l_org_freight_tl_info.ATTRIBUTE15,
429: X_GLOBAL_ATTRIBUTE1 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE1,
430: X_GLOBAL_ATTRIBUTE2 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE2,
431: X_GLOBAL_ATTRIBUTE3 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE3,

Line 428: X_ATTRIBUTE15 => l_org_freight_tl_info.ATTRIBUTE15,

424: X_ATTRIBUTE11 => l_org_freight_tl_info.ATTRIBUTE11,
425: X_ATTRIBUTE12 => l_org_freight_tl_info.ATTRIBUTE12,
426: X_ATTRIBUTE13 => l_org_freight_tl_info.ATTRIBUTE13,
427: X_ATTRIBUTE14 => l_org_freight_tl_info.ATTRIBUTE14,
428: X_ATTRIBUTE15 => l_org_freight_tl_info.ATTRIBUTE15,
429: X_GLOBAL_ATTRIBUTE1 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE1,
430: X_GLOBAL_ATTRIBUTE2 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE2,
431: X_GLOBAL_ATTRIBUTE3 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE3,
432: X_GLOBAL_ATTRIBUTE4 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE4,

Line 429: X_GLOBAL_ATTRIBUTE1 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE1,

425: X_ATTRIBUTE12 => l_org_freight_tl_info.ATTRIBUTE12,
426: X_ATTRIBUTE13 => l_org_freight_tl_info.ATTRIBUTE13,
427: X_ATTRIBUTE14 => l_org_freight_tl_info.ATTRIBUTE14,
428: X_ATTRIBUTE15 => l_org_freight_tl_info.ATTRIBUTE15,
429: X_GLOBAL_ATTRIBUTE1 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE1,
430: X_GLOBAL_ATTRIBUTE2 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE2,
431: X_GLOBAL_ATTRIBUTE3 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE3,
432: X_GLOBAL_ATTRIBUTE4 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE4,
433: X_GLOBAL_ATTRIBUTE5 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE5,

Line 430: X_GLOBAL_ATTRIBUTE2 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE2,

426: X_ATTRIBUTE13 => l_org_freight_tl_info.ATTRIBUTE13,
427: X_ATTRIBUTE14 => l_org_freight_tl_info.ATTRIBUTE14,
428: X_ATTRIBUTE15 => l_org_freight_tl_info.ATTRIBUTE15,
429: X_GLOBAL_ATTRIBUTE1 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE1,
430: X_GLOBAL_ATTRIBUTE2 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE2,
431: X_GLOBAL_ATTRIBUTE3 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE3,
432: X_GLOBAL_ATTRIBUTE4 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE4,
433: X_GLOBAL_ATTRIBUTE5 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE5,
434: X_GLOBAL_ATTRIBUTE6 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE6,

Line 431: X_GLOBAL_ATTRIBUTE3 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE3,

427: X_ATTRIBUTE14 => l_org_freight_tl_info.ATTRIBUTE14,
428: X_ATTRIBUTE15 => l_org_freight_tl_info.ATTRIBUTE15,
429: X_GLOBAL_ATTRIBUTE1 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE1,
430: X_GLOBAL_ATTRIBUTE2 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE2,
431: X_GLOBAL_ATTRIBUTE3 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE3,
432: X_GLOBAL_ATTRIBUTE4 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE4,
433: X_GLOBAL_ATTRIBUTE5 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE5,
434: X_GLOBAL_ATTRIBUTE6 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE6,
435: X_GLOBAL_ATTRIBUTE7 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE7,

Line 432: X_GLOBAL_ATTRIBUTE4 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE4,

428: X_ATTRIBUTE15 => l_org_freight_tl_info.ATTRIBUTE15,
429: X_GLOBAL_ATTRIBUTE1 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE1,
430: X_GLOBAL_ATTRIBUTE2 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE2,
431: X_GLOBAL_ATTRIBUTE3 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE3,
432: X_GLOBAL_ATTRIBUTE4 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE4,
433: X_GLOBAL_ATTRIBUTE5 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE5,
434: X_GLOBAL_ATTRIBUTE6 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE6,
435: X_GLOBAL_ATTRIBUTE7 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE7,
436: X_GLOBAL_ATTRIBUTE8 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE8,

Line 433: X_GLOBAL_ATTRIBUTE5 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE5,

429: X_GLOBAL_ATTRIBUTE1 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE1,
430: X_GLOBAL_ATTRIBUTE2 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE2,
431: X_GLOBAL_ATTRIBUTE3 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE3,
432: X_GLOBAL_ATTRIBUTE4 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE4,
433: X_GLOBAL_ATTRIBUTE5 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE5,
434: X_GLOBAL_ATTRIBUTE6 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE6,
435: X_GLOBAL_ATTRIBUTE7 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE7,
436: X_GLOBAL_ATTRIBUTE8 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE8,
437: X_GLOBAL_ATTRIBUTE9 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE9,

Line 434: X_GLOBAL_ATTRIBUTE6 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE6,

430: X_GLOBAL_ATTRIBUTE2 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE2,
431: X_GLOBAL_ATTRIBUTE3 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE3,
432: X_GLOBAL_ATTRIBUTE4 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE4,
433: X_GLOBAL_ATTRIBUTE5 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE5,
434: X_GLOBAL_ATTRIBUTE6 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE6,
435: X_GLOBAL_ATTRIBUTE7 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE7,
436: X_GLOBAL_ATTRIBUTE8 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE8,
437: X_GLOBAL_ATTRIBUTE9 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE9,
438: X_GLOBAL_ATTRIBUTE10 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE10,

Line 435: X_GLOBAL_ATTRIBUTE7 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE7,

431: X_GLOBAL_ATTRIBUTE3 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE3,
432: X_GLOBAL_ATTRIBUTE4 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE4,
433: X_GLOBAL_ATTRIBUTE5 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE5,
434: X_GLOBAL_ATTRIBUTE6 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE6,
435: X_GLOBAL_ATTRIBUTE7 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE7,
436: X_GLOBAL_ATTRIBUTE8 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE8,
437: X_GLOBAL_ATTRIBUTE9 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE9,
438: X_GLOBAL_ATTRIBUTE10 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE10,
439: X_GLOBAL_ATTRIBUTE11 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE11,

Line 436: X_GLOBAL_ATTRIBUTE8 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE8,

432: X_GLOBAL_ATTRIBUTE4 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE4,
433: X_GLOBAL_ATTRIBUTE5 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE5,
434: X_GLOBAL_ATTRIBUTE6 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE6,
435: X_GLOBAL_ATTRIBUTE7 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE7,
436: X_GLOBAL_ATTRIBUTE8 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE8,
437: X_GLOBAL_ATTRIBUTE9 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE9,
438: X_GLOBAL_ATTRIBUTE10 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE10,
439: X_GLOBAL_ATTRIBUTE11 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE11,
440: X_GLOBAL_ATTRIBUTE12 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE12,

Line 437: X_GLOBAL_ATTRIBUTE9 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE9,

433: X_GLOBAL_ATTRIBUTE5 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE5,
434: X_GLOBAL_ATTRIBUTE6 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE6,
435: X_GLOBAL_ATTRIBUTE7 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE7,
436: X_GLOBAL_ATTRIBUTE8 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE8,
437: X_GLOBAL_ATTRIBUTE9 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE9,
438: X_GLOBAL_ATTRIBUTE10 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE10,
439: X_GLOBAL_ATTRIBUTE11 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE11,
440: X_GLOBAL_ATTRIBUTE12 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE12,
441: X_GLOBAL_ATTRIBUTE13 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE13,

Line 438: X_GLOBAL_ATTRIBUTE10 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE10,

434: X_GLOBAL_ATTRIBUTE6 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE6,
435: X_GLOBAL_ATTRIBUTE7 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE7,
436: X_GLOBAL_ATTRIBUTE8 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE8,
437: X_GLOBAL_ATTRIBUTE9 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE9,
438: X_GLOBAL_ATTRIBUTE10 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE10,
439: X_GLOBAL_ATTRIBUTE11 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE11,
440: X_GLOBAL_ATTRIBUTE12 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE12,
441: X_GLOBAL_ATTRIBUTE13 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE13,
442: X_GLOBAL_ATTRIBUTE14 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE14,

Line 439: X_GLOBAL_ATTRIBUTE11 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE11,

435: X_GLOBAL_ATTRIBUTE7 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE7,
436: X_GLOBAL_ATTRIBUTE8 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE8,
437: X_GLOBAL_ATTRIBUTE9 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE9,
438: X_GLOBAL_ATTRIBUTE10 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE10,
439: X_GLOBAL_ATTRIBUTE11 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE11,
440: X_GLOBAL_ATTRIBUTE12 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE12,
441: X_GLOBAL_ATTRIBUTE13 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE13,
442: X_GLOBAL_ATTRIBUTE14 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE14,
443: X_GLOBAL_ATTRIBUTE15 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE15,

Line 440: X_GLOBAL_ATTRIBUTE12 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE12,

436: X_GLOBAL_ATTRIBUTE8 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE8,
437: X_GLOBAL_ATTRIBUTE9 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE9,
438: X_GLOBAL_ATTRIBUTE10 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE10,
439: X_GLOBAL_ATTRIBUTE11 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE11,
440: X_GLOBAL_ATTRIBUTE12 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE12,
441: X_GLOBAL_ATTRIBUTE13 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE13,
442: X_GLOBAL_ATTRIBUTE14 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE14,
443: X_GLOBAL_ATTRIBUTE15 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE15,
444: X_GLOBAL_ATTRIBUTE16 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE16,

Line 441: X_GLOBAL_ATTRIBUTE13 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE13,

437: X_GLOBAL_ATTRIBUTE9 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE9,
438: X_GLOBAL_ATTRIBUTE10 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE10,
439: X_GLOBAL_ATTRIBUTE11 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE11,
440: X_GLOBAL_ATTRIBUTE12 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE12,
441: X_GLOBAL_ATTRIBUTE13 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE13,
442: X_GLOBAL_ATTRIBUTE14 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE14,
443: X_GLOBAL_ATTRIBUTE15 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE15,
444: X_GLOBAL_ATTRIBUTE16 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE16,
445: X_GLOBAL_ATTRIBUTE17 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE17,

Line 442: X_GLOBAL_ATTRIBUTE14 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE14,

438: X_GLOBAL_ATTRIBUTE10 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE10,
439: X_GLOBAL_ATTRIBUTE11 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE11,
440: X_GLOBAL_ATTRIBUTE12 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE12,
441: X_GLOBAL_ATTRIBUTE13 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE13,
442: X_GLOBAL_ATTRIBUTE14 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE14,
443: X_GLOBAL_ATTRIBUTE15 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE15,
444: X_GLOBAL_ATTRIBUTE16 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE16,
445: X_GLOBAL_ATTRIBUTE17 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE17,
446: X_GLOBAL_ATTRIBUTE18 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE18,

Line 443: X_GLOBAL_ATTRIBUTE15 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE15,

439: X_GLOBAL_ATTRIBUTE11 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE11,
440: X_GLOBAL_ATTRIBUTE12 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE12,
441: X_GLOBAL_ATTRIBUTE13 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE13,
442: X_GLOBAL_ATTRIBUTE14 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE14,
443: X_GLOBAL_ATTRIBUTE15 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE15,
444: X_GLOBAL_ATTRIBUTE16 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE16,
445: X_GLOBAL_ATTRIBUTE17 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE17,
446: X_GLOBAL_ATTRIBUTE18 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE18,
447: X_GLOBAL_ATTRIBUTE19 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE19,

Line 444: X_GLOBAL_ATTRIBUTE16 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE16,

440: X_GLOBAL_ATTRIBUTE12 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE12,
441: X_GLOBAL_ATTRIBUTE13 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE13,
442: X_GLOBAL_ATTRIBUTE14 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE14,
443: X_GLOBAL_ATTRIBUTE15 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE15,
444: X_GLOBAL_ATTRIBUTE16 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE16,
445: X_GLOBAL_ATTRIBUTE17 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE17,
446: X_GLOBAL_ATTRIBUTE18 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE18,
447: X_GLOBAL_ATTRIBUTE19 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE19,
448: X_GLOBAL_ATTRIBUTE20 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE20,

Line 445: X_GLOBAL_ATTRIBUTE17 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE17,

441: X_GLOBAL_ATTRIBUTE13 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE13,
442: X_GLOBAL_ATTRIBUTE14 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE14,
443: X_GLOBAL_ATTRIBUTE15 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE15,
444: X_GLOBAL_ATTRIBUTE16 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE16,
445: X_GLOBAL_ATTRIBUTE17 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE17,
446: X_GLOBAL_ATTRIBUTE18 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE18,
447: X_GLOBAL_ATTRIBUTE19 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE19,
448: X_GLOBAL_ATTRIBUTE20 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE20,
449: X_GLOBAL_ATTRIBUTE_CATEGORY => l_org_freight_tl_info.GLOBAL_ATTRIBUTE_CATEGORY,

Line 446: X_GLOBAL_ATTRIBUTE18 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE18,

442: X_GLOBAL_ATTRIBUTE14 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE14,
443: X_GLOBAL_ATTRIBUTE15 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE15,
444: X_GLOBAL_ATTRIBUTE16 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE16,
445: X_GLOBAL_ATTRIBUTE17 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE17,
446: X_GLOBAL_ATTRIBUTE18 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE18,
447: X_GLOBAL_ATTRIBUTE19 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE19,
448: X_GLOBAL_ATTRIBUTE20 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE20,
449: X_GLOBAL_ATTRIBUTE_CATEGORY => l_org_freight_tl_info.GLOBAL_ATTRIBUTE_CATEGORY,
450: X_DESCRIPTION =>substrb(p_carrier_info.P_CARRIER_NAME,1,80),

Line 447: X_GLOBAL_ATTRIBUTE19 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE19,

443: X_GLOBAL_ATTRIBUTE15 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE15,
444: X_GLOBAL_ATTRIBUTE16 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE16,
445: X_GLOBAL_ATTRIBUTE17 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE17,
446: X_GLOBAL_ATTRIBUTE18 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE18,
447: X_GLOBAL_ATTRIBUTE19 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE19,
448: X_GLOBAL_ATTRIBUTE20 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE20,
449: X_GLOBAL_ATTRIBUTE_CATEGORY => l_org_freight_tl_info.GLOBAL_ATTRIBUTE_CATEGORY,
450: X_DESCRIPTION =>substrb(p_carrier_info.P_CARRIER_NAME,1,80),
451: X_LAST_UPDATE_DATE => SYSDATE, -- Bug 5478419

Line 448: X_GLOBAL_ATTRIBUTE20 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE20,

444: X_GLOBAL_ATTRIBUTE16 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE16,
445: X_GLOBAL_ATTRIBUTE17 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE17,
446: X_GLOBAL_ATTRIBUTE18 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE18,
447: X_GLOBAL_ATTRIBUTE19 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE19,
448: X_GLOBAL_ATTRIBUTE20 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE20,
449: X_GLOBAL_ATTRIBUTE_CATEGORY => l_org_freight_tl_info.GLOBAL_ATTRIBUTE_CATEGORY,
450: X_DESCRIPTION =>substrb(p_carrier_info.P_CARRIER_NAME,1,80),
451: X_LAST_UPDATE_DATE => SYSDATE, -- Bug 5478419
452: X_LAST_UPDATED_BY => p_carrier_info.LAST_UPDATED_BY,

Line 449: X_GLOBAL_ATTRIBUTE_CATEGORY => l_org_freight_tl_info.GLOBAL_ATTRIBUTE_CATEGORY,

445: X_GLOBAL_ATTRIBUTE17 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE17,
446: X_GLOBAL_ATTRIBUTE18 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE18,
447: X_GLOBAL_ATTRIBUTE19 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE19,
448: X_GLOBAL_ATTRIBUTE20 => l_org_freight_tl_info.GLOBAL_ATTRIBUTE20,
449: X_GLOBAL_ATTRIBUTE_CATEGORY => l_org_freight_tl_info.GLOBAL_ATTRIBUTE_CATEGORY,
450: X_DESCRIPTION =>substrb(p_carrier_info.P_CARRIER_NAME,1,80),
451: X_LAST_UPDATE_DATE => SYSDATE, -- Bug 5478419
452: X_LAST_UPDATED_BY => p_carrier_info.LAST_UPDATED_BY,
453: X_LAST_UPDATE_LOGIN => p_carrier_info.LAST_UPDATE_LOGIN);

Line 456: L_PROCEDURE := 'Updating ORG_FREIGHT_TL';

452: X_LAST_UPDATED_BY => p_carrier_info.LAST_UPDATED_BY,
453: X_LAST_UPDATE_LOGIN => p_carrier_info.LAST_UPDATE_LOGIN);
454:
455: L_POSITION := 50;
456: L_PROCEDURE := 'Updating ORG_FREIGHT_TL';
457:
458: --
459: IF l_debug_on THEN
460: WSH_DEBUG_SV.logmsg(l_module_name,'Updating ORG_FREIGHT_TL',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 460: WSH_DEBUG_SV.logmsg(l_module_name,'Updating ORG_FREIGHT_TL',WSH_DEBUG_SV.C_PROC_LEVEL);

456: L_PROCEDURE := 'Updating ORG_FREIGHT_TL';
457:
458: --
459: IF l_debug_on THEN
460: WSH_DEBUG_SV.logmsg(l_module_name,'Updating ORG_FREIGHT_TL',WSH_DEBUG_SV.C_PROC_LEVEL);
461: END IF;
462: --
463:
464: UPDATE ORG_FREIGHT_TL

Line 464: UPDATE ORG_FREIGHT_TL

460: WSH_DEBUG_SV.logmsg(l_module_name,'Updating ORG_FREIGHT_TL',WSH_DEBUG_SV.C_PROC_LEVEL);
461: END IF;
462: --
463:
464: UPDATE ORG_FREIGHT_TL
465: SET party_id = p_csm_info.carrier_id
466: WHERE freight_code = p_carrier_info.p_freight_code
467: and organization_id = p_org_carrier_service_info.organization_id;
468: IF l_debug_on THEN