eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FTE_SS_INTERFACE dependencies on FTE_CARRIER_RANK_LIST_PVT

Line 11: PROCEDURE RATE_SORT_WRAPPER(p_ss_rate_sort_tbl IN FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,

7:
8: -- For Rel 12 HBHAGAVA
9:
10: --{
11: PROCEDURE RATE_SORT_WRAPPER(p_ss_rate_sort_tbl IN FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,
12: x_ss_rate_sort_tbl OUT NOCOPY FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type)
13: IS
14:
15: l_ss_rate_sort_rec FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec;

Line 12: x_ss_rate_sort_tbl OUT NOCOPY FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type)

8: -- For Rel 12 HBHAGAVA
9:
10: --{
11: PROCEDURE RATE_SORT_WRAPPER(p_ss_rate_sort_tbl IN FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,
12: x_ss_rate_sort_tbl OUT NOCOPY FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type)
13: IS
14:
15: l_ss_rate_sort_rec FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec;
16:

Line 15: l_ss_rate_sort_rec FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec;

11: PROCEDURE RATE_SORT_WRAPPER(p_ss_rate_sort_tbl IN FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,
12: x_ss_rate_sort_tbl OUT NOCOPY FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type)
13: IS
14:
15: l_ss_rate_sort_rec FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec;
16:
17:
18: BEGIN
19:

Line 36: x_routing_results OUT NOCOPY FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,

32:
33:
34: --{
35: PROCEDURE GET_RANKED_RESULTS( p_rule_id IN NUMBER,
36: x_routing_results OUT NOCOPY FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,
37: x_return_status OUT NOCOPY VARCHAR2)
38: IS
39:
40:

Line 65: PROCEDURE ROUTING_GUIDE_MAIN(x_routing_results OUT NOCOPY FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,

61: --}
62:
63:
64: --{
65: PROCEDURE ROUTING_GUIDE_MAIN(x_routing_results OUT NOCOPY FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,
66: x_return_status OUT NOCOPY VARCHAR2)
67: IS
68:
69:

Line 102: p_rank_list_rec IN FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec,

98: END LOG;
99:
100:
101: PROCEDURE DERIVE_INITIAL_SHIPMETHOD(
102: p_rank_list_rec IN FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec,
103: x_carrier_id OUT NOCOPY NUMBER,
104: x_service_level OUT NOCOPY VARCHAR2,
105: x_mode_of_transport OUT NOCOPY VARCHAR2)
106: IS

Line 251: X_SS_RATE_SORT_TAB OUT NOCOPY FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,

247: P_INIT_MSG_LIST IN VARCHAR2,
248: P_COMMIT IN VARCHAR2,
249: P_CALLER IN VARCHAR2,
250: P_FTE_SS_ATTR_REC IN FTE_SS_ATTR_REC,
251: X_SS_RATE_SORT_TAB OUT NOCOPY FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,
252: X_SAVE_RANK_LIST OUT NOCOPY VARCHAR2,
253: X_RANK_EXIST_TAB OUT NOCOPY FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,
254: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
255: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 253: X_RANK_EXIST_TAB OUT NOCOPY FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,

249: P_CALLER IN VARCHAR2,
250: P_FTE_SS_ATTR_REC IN FTE_SS_ATTR_REC,
251: X_SS_RATE_SORT_TAB OUT NOCOPY FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,
252: X_SAVE_RANK_LIST OUT NOCOPY VARCHAR2,
253: X_RANK_EXIST_TAB OUT NOCOPY FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,
254: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
255: X_MSG_COUNT OUT NOCOPY NUMBER,
256: X_MSG_DATA OUT NOCOPY VARCHAR2)
257: IS

Line 275: l_rank_list_tbl FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;

271: l_msg_data VARCHAR2(32767);
272: l_number_of_warnings NUMBER;
273: l_number_of_errors NUMBER;
274:
275: l_rank_list_tbl FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
276: l_routing_results FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
277: l_rank_list_rec FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec;
278: l_routing_results_rec FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec;
279:

Line 276: l_routing_results FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;

272: l_number_of_warnings NUMBER;
273: l_number_of_errors NUMBER;
274:
275: l_rank_list_tbl FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
276: l_routing_results FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
277: l_rank_list_rec FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec;
278: l_routing_results_rec FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec;
279:
280: l_rank_exist_rec FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec;

Line 277: l_rank_list_rec FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec;

273: l_number_of_errors NUMBER;
274:
275: l_rank_list_tbl FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
276: l_routing_results FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
277: l_rank_list_rec FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec;
278: l_routing_results_rec FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec;
279:
280: l_rank_exist_rec FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec;
281: l_new_rank_list_rec FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec;

Line 278: l_routing_results_rec FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec;

274:
275: l_rank_list_tbl FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
276: l_routing_results FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
277: l_rank_list_rec FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec;
278: l_routing_results_rec FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec;
279:
280: l_rank_exist_rec FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec;
281: l_new_rank_list_rec FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec;
282:

Line 280: l_rank_exist_rec FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec;

276: l_routing_results FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
277: l_rank_list_rec FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec;
278: l_routing_results_rec FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec;
279:
280: l_rank_exist_rec FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec;
281: l_new_rank_list_rec FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec;
282:
283: l_tbl_count NUMBER;
284: l_initsmconfig VARCHAR2(3);

Line 281: l_new_rank_list_rec FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec;

277: l_rank_list_rec FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec;
278: l_routing_results_rec FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec;
279:
280: l_rank_exist_rec FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec;
281: l_new_rank_list_rec FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec;
282:
283: l_tbl_count NUMBER;
284: l_initsmconfig VARCHAR2(3);
285: l_uismconfig VARCHAR2(3);

Line 316: FTE_CARRIER_RANK_LIST_PVT.GET_RANK_LIST(

312: l_number_of_errors := 0;
313:
314:
315: -- Get the rank list
316: FTE_CARRIER_RANK_LIST_PVT.GET_RANK_LIST(
317: p_init_msg_list => 1.0,
318: x_return_status => l_return_status,
319: x_msg_count => l_msg_count,
320: x_msg_data => l_msg_data,

Line 374: IF (l_rank_list_rec.source = FTE_CARRIER_RANK_LIST_PVT.S_SOURCE_RG)

370:
371:
372: X_RANK_EXIST_TAB(1) := l_rank_list_rec;
373:
374: IF (l_rank_list_rec.source = FTE_CARRIER_RANK_LIST_PVT.S_SOURCE_RG)
375: THEN
376: --{
377: -- First copy the existing service to out tab so that it can be send back
378:

Line 506: ELSIF (l_rank_list_rec.source = FTE_CARRIER_RANK_LIST_PVT.S_SOURCE_LCSS)

502:
503: --}
504: END IF;
505: --}
506: ELSIF (l_rank_list_rec.source = FTE_CARRIER_RANK_LIST_PVT.S_SOURCE_LCSS)
507: THEN
508: --{
509: IF l_debug_on
510: THEN

Line 524: ELSIF (l_rank_list_rec.source = FTE_CARRIER_RANK_LIST_PVT.S_SOURCE_TP)

520: X_SS_RATE_SORT_TAB(X_SS_RATE_SORT_TAB.COUNT+1) :=
521: l_new_rank_list_rec;
522:
523: --}
524: ELSIF (l_rank_list_rec.source = FTE_CARRIER_RANK_LIST_PVT.S_SOURCE_TP)
525: THEN
526: --{
527:
528: IF l_debug_on

Line 643: X_SS_RATE_SORT_TAB OUT NOCOPY FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,

639: P_COMMIT IN VARCHAR2,
640: P_CALLER IN VARCHAR2,
641: P_FTE_SS_ATTR_REC IN FTE_SS_ATTR_REC,
642: X_LIST_CREATE_TYPE OUT NOCOPY VARCHAR2,
643: X_SS_RATE_SORT_TAB OUT NOCOPY FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,
644: X_SAVE_RANK_LIST OUT NOCOPY VARCHAR2,
645: X_RANK_EXIST_TAB OUT NOCOPY FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,
646: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
647: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 645: X_RANK_EXIST_TAB OUT NOCOPY FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,

641: P_FTE_SS_ATTR_REC IN FTE_SS_ATTR_REC,
642: X_LIST_CREATE_TYPE OUT NOCOPY VARCHAR2,
643: X_SS_RATE_SORT_TAB OUT NOCOPY FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,
644: X_SAVE_RANK_LIST OUT NOCOPY VARCHAR2,
645: X_RANK_EXIST_TAB OUT NOCOPY FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,
646: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
647: X_MSG_COUNT OUT NOCOPY NUMBER,
648: X_MSG_DATA OUT NOCOPY VARCHAR2)
649: IS

Line 668: l_rank_list_tbl FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;

664: l_number_of_warnings NUMBER;
665: l_number_of_errors NUMBER;
666:
667: -- values existing in rank list table
668: l_rank_list_tbl FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
669: l_rank_list_rec FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec;
670:
671:
672: -- routing guide result table

Line 669: l_rank_list_rec FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec;

665: l_number_of_errors NUMBER;
666:
667: -- values existing in rank list table
668: l_rank_list_tbl FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
669: l_rank_list_rec FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec;
670:
671:
672: -- routing guide result table
673: l_routing_results FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;

Line 673: l_routing_results FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;

669: l_rank_list_rec FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec;
670:
671:
672: -- routing guide result table
673: l_routing_results FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
674:
675: l_new_rank_list_rec FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec;
676: l_temp_rank_tbl FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
677:

Line 675: l_new_rank_list_rec FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec;

671:
672: -- routing guide result table
673: l_routing_results FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
674:
675: l_new_rank_list_rec FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec;
676: l_temp_rank_tbl FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
677:
678: l_tbl_count NUMBER;
679: l_initsmconfig VARCHAR2(3);

Line 676: l_temp_rank_tbl FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;

672: -- routing guide result table
673: l_routing_results FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
674:
675: l_new_rank_list_rec FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec;
676: l_temp_rank_tbl FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
677:
678: l_tbl_count NUMBER;
679: l_initsmconfig VARCHAR2(3);
680: l_uismconfig VARCHAR2(3);

Line 723: FTE_CARRIER_RANK_LIST_PVT.GET_RANK_LIST(

719: l_number_of_errors := 0;
720:
721:
722: -- Get the rank list
723: FTE_CARRIER_RANK_LIST_PVT.GET_RANK_LIST(
724: p_init_msg_list => 1.0,
725: x_return_status => l_return_status,
726: x_msg_count => l_msg_count,
727: x_msg_data => l_msg_data,

Line 768: l_new_rank_list_rec.SOURCE := FTE_CARRIER_RANK_LIST_PVT.S_SOURCE_UI;

764:
765: l_new_rank_list_rec.CARRIER_ID := P_FTE_SS_ATTR_REC.CARRIER_ID;
766: l_new_rank_list_rec.SERVICE_LEVEL := P_FTE_SS_ATTR_REC.SERVICE_LEVEL;
767: l_new_rank_list_rec.MODE_OF_TRANSPORT := P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT;
768: l_new_rank_list_rec.SOURCE := FTE_CARRIER_RANK_LIST_PVT.S_SOURCE_UI;
769: l_new_rank_list_rec.SORT := 'UI';
770:
771: X_SS_RATE_SORT_TAB(X_SS_RATE_SORT_TAB.COUNT+1) := l_new_rank_list_rec;
772:

Line 803: IF (l_rank_list_rec.source = FTE_CARRIER_RANK_LIST_PVT.S_SOURCE_RG)

799:
800: END IF;
801:
802:
803: IF (l_rank_list_rec.source = FTE_CARRIER_RANK_LIST_PVT.S_SOURCE_RG)
804: THEN
805: --{
806:
807: -- there is a service on the rank entry but it is possible to have

Line 934: FTE_CARRIER_RANK_LIST_PVT.RANK_LIST_ACTION(

930: -- but user clicks save that means he picked up some service so we do not
931: -- need this partial shipmethod info anyway. We have INITSMCONFIG to find out
932: -- what was the initial config anyway
933:
934: FTE_CARRIER_RANK_LIST_PVT.RANK_LIST_ACTION(
935: p_api_version_number => 1.0,
936: p_init_msg_list => FND_API.G_FALSE,
937: x_return_status => l_return_status,
938: x_msg_count => l_msg_count,

Line 940: p_action_code => FTE_CARRIER_RANK_LIST_PVT.S_DELETE,

936: p_init_msg_list => FND_API.G_FALSE,
937: x_return_status => l_return_status,
938: x_msg_count => l_msg_count,
939: x_msg_data => l_msg_data,
940: p_action_code => FTE_CARRIER_RANK_LIST_PVT.S_DELETE,
941: p_ranklist => l_temp_rank_tbl,
942: p_trip_id => P_FTE_SS_ATTR_REC.trip_id,
943: p_rank_id => null);
944:

Line 1017: ELSIF (l_rank_list_rec.source = FTE_CARRIER_RANK_LIST_PVT.S_SOURCE_TP)

1013:
1014: --}
1015: END IF;
1016: --}
1017: ELSIF (l_rank_list_rec.source = FTE_CARRIER_RANK_LIST_PVT.S_SOURCE_TP)
1018: THEN
1019: --{
1020:
1021: -- Call routing guide if Append flag is set to Y.

Line 1092: ELSIF (l_rank_list_rec.source = FTE_CARRIER_RANK_LIST_PVT.S_SOURCE_UI)

1088: X_SAVE_RANK_LIST := FND_API.G_FALSE;
1089: --}
1090: END IF;
1091: --}
1092: ELSIF (l_rank_list_rec.source = FTE_CARRIER_RANK_LIST_PVT.S_SOURCE_UI)
1093: THEN
1094: --{
1095:
1096: IF l_debug_on

Line 1117: ELSIF (l_rank_list_rec.source = FTE_CARRIER_RANK_LIST_PVT.S_SOURCE_LCSS)

1113: l_rank_list_rec;
1114:
1115:
1116: --}
1117: ELSIF (l_rank_list_rec.source = FTE_CARRIER_RANK_LIST_PVT.S_SOURCE_LCSS)
1118: THEN
1119: --{
1120: IF l_debug_on
1121: THEN

Line 1193: l_new_rank_list_rec.SOURCE := FTE_CARRIER_RANK_LIST_PVT.S_SOURCE_UI;

1189:
1190: l_new_rank_list_rec.CARRIER_ID := P_FTE_SS_ATTR_REC.CARRIER_ID;
1191: l_new_rank_list_rec.SERVICE_LEVEL := P_FTE_SS_ATTR_REC.SERVICE_LEVEL;
1192: l_new_rank_list_rec.MODE_OF_TRANSPORT := P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT;
1193: l_new_rank_list_rec.SOURCE := FTE_CARRIER_RANK_LIST_PVT.S_SOURCE_UI;
1194: l_new_rank_list_rec.SORT := 'UI';
1195:
1196: X_SS_RATE_SORT_TAB(X_SS_RATE_SORT_TAB.COUNT+1) := l_new_rank_list_rec;
1197:

Line 1348: l_new_rank_list_rec.SOURCE := FTE_CARRIER_RANK_LIST_PVT.S_SOURCE_UI;

1344: l_new_rank_list_rec.CARRIER_ID := P_FTE_SS_ATTR_REC.CARRIER_ID;
1345: l_new_rank_list_rec.SERVICE_LEVEL := P_FTE_SS_ATTR_REC.SERVICE_LEVEL;
1346: l_new_rank_list_rec.MODE_OF_TRANSPORT := P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT;
1347:
1348: l_new_rank_list_rec.SOURCE := FTE_CARRIER_RANK_LIST_PVT.S_SOURCE_UI;
1349:
1350: IF (P_FTE_SS_ATTR_REC.CARRIER_ID IS NULL
1351: AND P_FTE_SS_ATTR_REC.SERVICE_LEVEL IS NULL
1352: AND P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT IS NULL)

Line 1354: l_new_rank_list_rec.SOURCE := FTE_CARRIER_RANK_LIST_PVT.S_SOURCE_LCSS;

1350: IF (P_FTE_SS_ATTR_REC.CARRIER_ID IS NULL
1351: AND P_FTE_SS_ATTR_REC.SERVICE_LEVEL IS NULL
1352: AND P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT IS NULL)
1353: THEN
1354: l_new_rank_list_rec.SOURCE := FTE_CARRIER_RANK_LIST_PVT.S_SOURCE_LCSS;
1355: END IF;
1356:
1357: l_new_rank_list_rec.SORT := 'UI';
1358:

Line 1453: X_SS_RATE_SORT_TAB OUT NOCOPY FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,

1449: P_CALLER IN VARCHAR2,
1450: P_FTE_SS_ATTR_REC IN FTE_SS_ATTR_REC,
1451: X_RATING_REQUEST_ID OUT NOCOPY NUMBER,
1452: X_LIST_CREATE_TYPE OUT NOCOPY VARCHAR2,
1453: X_SS_RATE_SORT_TAB OUT NOCOPY FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,
1454: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1455: X_MSG_COUNT OUT NOCOPY NUMBER,
1456: X_MSG_DATA OUT NOCOPY VARCHAR2)
1457: IS

Line 1478: l_search_criteria_tbl FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;

1474: l_number_of_errors NUMBER;
1475:
1476: l_list_create_type VARCHAR2(32767);
1477:
1478: l_search_criteria_tbl FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
1479: l_search_results_tbl FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
1480: l_existing_service_tbl FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
1481: l_existing_sm_tbl FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
1482:

Line 1479: l_search_results_tbl FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;

1475:
1476: l_list_create_type VARCHAR2(32767);
1477:
1478: l_search_criteria_tbl FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
1479: l_search_results_tbl FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
1480: l_existing_service_tbl FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
1481: l_existing_sm_tbl FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
1482:
1483: l_manual_services_tbl FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;

Line 1480: l_existing_service_tbl FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;

1476: l_list_create_type VARCHAR2(32767);
1477:
1478: l_search_criteria_tbl FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
1479: l_search_results_tbl FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
1480: l_existing_service_tbl FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
1481: l_existing_sm_tbl FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
1482:
1483: l_manual_services_tbl FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
1484:

Line 1481: l_existing_sm_tbl FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;

1477:
1478: l_search_criteria_tbl FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
1479: l_search_results_tbl FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
1480: l_existing_service_tbl FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
1481: l_existing_sm_tbl FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
1482:
1483: l_manual_services_tbl FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
1484:
1485: l_rank_list_in_param_tbl FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;

Line 1483: l_manual_services_tbl FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;

1479: l_search_results_tbl FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
1480: l_existing_service_tbl FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
1481: l_existing_sm_tbl FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
1482:
1483: l_manual_services_tbl FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
1484:
1485: l_rank_list_in_param_tbl FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
1486:
1487: l_save_rank_list VARCHAR2(1); -- Search Services

Line 1485: l_rank_list_in_param_tbl FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;

1481: l_existing_sm_tbl FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
1482:
1483: l_manual_services_tbl FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
1484:
1485: l_rank_list_in_param_tbl FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
1486:
1487: l_save_rank_list VARCHAR2(1); -- Search Services
1488:
1489: l_rank_list_action VARCHAR2(30);

Line 1837: l_rank_list_action := FTE_CARRIER_RANK_LIST_PVT.S_APPEND;

1833:
1834: -- Set action to APPEND since we are going to append to the list instead
1835: -- of creating scratch.
1836:
1837: l_rank_list_action := FTE_CARRIER_RANK_LIST_PVT.S_APPEND;
1838: --}
1839: ELSE
1840: --{
1841: -- no existing service

Line 1851: l_rank_list_action := FTE_CARRIER_RANK_LIST_PVT.S_CREATE;

1847: WSH_DEBUG_SV.C_PROC_LEVEL);
1848: END IF;
1849:
1850:
1851: l_rank_list_action := FTE_CARRIER_RANK_LIST_PVT.S_CREATE;
1852:
1853: --}
1854: END IF;
1855:

Line 1955: FTE_CARRIER_RANK_LIST_PVT.RANK_LIST_ACTION(

1951: --}
1952: END IF;
1953:
1954: -- Now call RANK_ACTION API to save information
1955: FTE_CARRIER_RANK_LIST_PVT.RANK_LIST_ACTION(
1956: p_api_version_number => 1.0,
1957: p_init_msg_list => FND_API.G_FALSE,
1958: x_return_status => l_return_status,
1959: x_msg_count => l_msg_count,

Line 2294: l_SS_RATE_SORT_TAB FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;

2290: l_number_of_errors NUMBER;
2291:
2292: l_list_create_type VARCHAR2(32767);
2293:
2294: l_SS_RATE_SORT_TAB FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
2295:
2296: l_ss_rate_sort_rec FTE_SS_RATE_SORT_REC;
2297:
2298: --}

Line 2522: l_routing_results FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;

2518: l_msg_data VARCHAR2(32767);
2519: l_number_of_warnings NUMBER;
2520: l_number_of_errors NUMBER;
2521:
2522: l_routing_results FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
2523:
2524: l_mode VARCHAR2(80);
2525: l_service VARCHAR2(80);
2526: l_carrierName VARCHAR2(360);

Line 2867: FTE_CARRIER_RANK_LIST_PVT.RANK_LIST_ACTION_UIWRAPPER(

2863: -- OUT param is the new rankId to be stored on the trip
2864:
2865: IF ( l_list_action IS NOT NULL AND l_trip_id IS NOT NULL) THEN
2866: IF ( p_list_action = 'SET_CURRENT' ) THEN
2867: FTE_CARRIER_RANK_LIST_PVT.RANK_LIST_ACTION_UIWRAPPER(
2868: p_API_VERSION_NUMBER => 1.0,
2869: p_INIT_MSG_LIST => FND_API.G_TRUE,
2870: p_ACTION_CODE => l_list_action,
2871: p_RANKLIST => p_ss_rate_sort_tab,

Line 2878: FTE_CARRIER_RANK_LIST_PVT.RANK_LIST_ACTION_UIWRAPPER(

2874: x_RETURN_STATUS => l_return_status,
2875: x_MSG_COUNT => l_msg_count,
2876: x_MSG_DATA => l_msg_data);
2877: ELSE
2878: FTE_CARRIER_RANK_LIST_PVT.RANK_LIST_ACTION_UIWRAPPER(
2879: p_API_VERSION_NUMBER => 1.0,
2880: p_INIT_MSG_LIST => FND_API.G_TRUE,
2881: p_ACTION_CODE => l_list_action,
2882: p_RANKLIST => p_ss_rate_sort_tab,