DBA Data[Home] [Help]

APPS.WSH_FTE_INTEGRATION dependencies on FTE_CARRIER_RANK_LIST_PVT

Line 1354: l_ranked_list FTE_CARRIER_RANK_LIST_PVT.CARRIER_RANK_LIST_TBL_TYPE;

1350: --x_ranklist OUT NOCOPY CARRIER_RANK_LIST_TBL_TYPE
1351: )
1352: IS
1353:
1354: l_ranked_list FTE_CARRIER_RANK_LIST_PVT.CARRIER_RANK_LIST_TBL_TYPE;
1355: l_rank_id NUMBER := NULL;
1356: list_cnt NUMBER := 0;
1357:
1358: l_error_code NUMBER; -- Oracle SQL Error Number

Line 1389: -- Copy p_ranked_list to FTE_CARRIER_RANK_LIST_PVT.CARRIER_RANK_LIST_TBL_TYPE

1385: x_return_status := FND_API.G_RET_STS_SUCCESS;
1386:
1387: IF (WSH_UTIL_CORE.FTE_Is_Installed = 'Y') THEN
1388:
1389: -- Copy p_ranked_list to FTE_CARRIER_RANK_LIST_PVT.CARRIER_RANK_LIST_TBL_TYPE
1390:
1391: list_cnt := p_ranklist.FIRST;
1392: IF list_cnt IS NOT NULL THEN
1393: LOOP

Line 1412: FTE_CARRIER_RANK_LIST_PVT.RANK_LIST_ACTION(

1408:
1409: END LOOP;
1410: END IF;
1411:
1412: FTE_CARRIER_RANK_LIST_PVT.RANK_LIST_ACTION(
1413: p_api_version_number => 1.0,
1414: p_init_msg_list => p_init_msg_list,
1415: x_return_status => l_return_status,
1416: x_msg_count => x_msg_count,

Line 1773: -- FTE_CARRIER_RANK_LIST_PVT.CREATE_RANK_LIST_BULK

1769: -- COMMENT : This procedure calls FTE to perform a bulk operation
1770: -- on ranking carriers in trips.
1771: --
1772: -- This procedure is a wrapper for
1773: -- FTE_CARRIER_RANK_LIST_PVT.CREATE_RANK_LIST_BULK
1774: --
1775: -- It will pull the required values from WSH_TRIPS to
1776: -- build the rank list for the FTE API.
1777: --

Line 1795: l_ranklist FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_bulk_rec;

1791: 'wsh.plsql.' || G_PKG_NAME || '.' || 'CREATE_RANK_LIST_BULK';
1792: --
1793: l_index NUMBER;
1794: i NUMBER;
1795: l_ranklist FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_bulk_rec;
1796: BEGIN
1797: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1798: --
1799: IF l_debug_on IS NULL THEN

Line 1908: 'Calling FTE_CARRIER_RANK_LIST_PVT.CREATE_RANK_LIST_BULK',

1904: IF l_debug_on THEN
1905: WSH_DEBUG_SV.log(l_module_name, 'l_ranklist.trip_id.COUNT',
1906: l_ranklist.trip_id.COUNT);
1907: WSH_DEBUG_SV.logmsg(l_module_name,
1908: 'Calling FTE_CARRIER_RANK_LIST_PVT.CREATE_RANK_LIST_BULK',
1909: WSH_DEBUG_SV.C_PROC_LEVEL);
1910: END IF;
1911:
1912: FTE_CARRIER_RANK_LIST_PVT.CREATE_RANK_LIST_BULK(

Line 1912: FTE_CARRIER_RANK_LIST_PVT.CREATE_RANK_LIST_BULK(

1908: 'Calling FTE_CARRIER_RANK_LIST_PVT.CREATE_RANK_LIST_BULK',
1909: WSH_DEBUG_SV.C_PROC_LEVEL);
1910: END IF;
1911:
1912: FTE_CARRIER_RANK_LIST_PVT.CREATE_RANK_LIST_BULK(
1913: p_api_version_number => p_api_version_number,
1914: p_init_msg_list => p_init_msg_list,
1915: x_return_status => x_return_status,
1916: x_msg_count => x_msg_count,