APPS.FTE_MLS_TEST_NT dependencies on FTE_SS_RATE_SORT_REC

Line 54: l_ss_rate_sort_rec FTE_SS_RATE_SORT_REC;

50: l_ret_trip_name VARCHAR2(30);
51: l_ret_trip_id NUMBER;
52: l_list_action VARCHAR2(30);
53:
54: l_ss_rate_sort_rec FTE_SS_RATE_SORT_REC;
55: l_action_out_rec FTE_ACTION_OUT_REC;
56: l_trip_action_param FTE_TRIP_ACTION_PARAM_REC;
57:
58: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

Line 388: l_ss_rate_sort_rec FTE_SS_RATE_SORT_REC;

384: x_MSG_COUNT OUT NOCOPY NUMBER,
385: x_MSG_DATA OUT NOCOPY VARCHAR2
386: )
387: IS
388: l_ss_rate_sort_rec FTE_SS_RATE_SORT_REC;
389: l_ss_rate_sort_rec2 FTE_SS_RATE_SORT_REC;
390: l_ss_rate_sort_rec3 FTE_SS_RATE_SORT_REC;
391: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
392: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.'|| G_PKG_NAME ||'.'||'SEARCH_SERVICES';

Line 389: l_ss_rate_sort_rec2 FTE_SS_RATE_SORT_REC;

385: x_MSG_DATA OUT NOCOPY VARCHAR2
386: )
387: IS
388: l_ss_rate_sort_rec FTE_SS_RATE_SORT_REC;
389: l_ss_rate_sort_rec2 FTE_SS_RATE_SORT_REC;
390: l_ss_rate_sort_rec3 FTE_SS_RATE_SORT_REC;
391: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
392: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.'|| G_PKG_NAME ||'.'||'SEARCH_SERVICES';
393:

Line 390: l_ss_rate_sort_rec3 FTE_SS_RATE_SORT_REC;

386: )
387: IS
388: l_ss_rate_sort_rec FTE_SS_RATE_SORT_REC;
389: l_ss_rate_sort_rec2 FTE_SS_RATE_SORT_REC;
390: l_ss_rate_sort_rec3 FTE_SS_RATE_SORT_REC;
391: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
392: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.'|| G_PKG_NAME ||'.'||'SEARCH_SERVICES';
393:
394: BEGIN

Line 419: l_ss_rate_sort_rec3 := FTE_SS_RATE_SORT_REC(

415: --x_LIST_CREATE_TYPE := 'MAN';
416: x_LIST_CREATE_TYPE := 'RG';
417: --
418:
419: l_ss_rate_sort_rec3 := FTE_SS_RATE_SORT_REC(
420: 3, 3,
421: 14003, null, 67278, 'LTL', 'LTL', null, null,
422: null, 'MAN', 650, 'USD',
423: 0, 'DAY', null, null,

Line 429: l_ss_rate_sort_rec := FTE_SS_RATE_SORT_REC(

425:
426: x_SS_RATE_SORT_TAB.EXTEND;
427: x_SS_RATE_SORT_TAB(1) := l_ss_rate_sort_rec3;
428:
429: l_ss_rate_sort_rec := FTE_SS_RATE_SORT_REC(
430: 1, 1,
431: 1408, null, 14012, 'LTL', 'LTL', null, null,
432: null, 'RG', 900, 'KRW',
433: 5, 'DAY', null, null,

Line 439: l_ss_rate_sort_rec2 := FTE_SS_RATE_SORT_REC(

435:
436: x_SS_RATE_SORT_TAB.EXTEND;
437: x_SS_RATE_SORT_TAB(2) := l_ss_rate_sort_rec;
438:
439: l_ss_rate_sort_rec2 := FTE_SS_RATE_SORT_REC(
440: 2, 2,
441: 1490, null, 49275, 'TRUCK', 'STANDARD', 16817, 204,
442: null, 'MAN', 643, 'USD',
443: '2', 'DAY', null, null,