DBA Data[Home] [Help]

APPS.FTE_TL_CACHE dependencies on FTE_DIST_INT_PKG

Line 3068: l_location_tab FTE_DIST_INT_PKG.fte_dist_input_tab;

3064: l_time NUMBER;
3065: l_quantity NUMBER;
3066: l_carrier_distance_uom VARCHAR2(30);
3067: l_carrier_time_uom VARCHAR2(30);
3068: l_location_tab FTE_DIST_INT_PKG.fte_dist_input_tab;
3069: l_location_rec FTE_DIST_INT_PKG.fte_dist_input_rec;
3070: l_location_log_tab FTE_DIST_INT_PKG.fte_dist_output_message_tab;
3071:
3072: l_location_out_tab FTE_DIST_INT_PKG.fte_dist_output_tab;

Line 3069: l_location_rec FTE_DIST_INT_PKG.fte_dist_input_rec;

3065: l_quantity NUMBER;
3066: l_carrier_distance_uom VARCHAR2(30);
3067: l_carrier_time_uom VARCHAR2(30);
3068: l_location_tab FTE_DIST_INT_PKG.fte_dist_input_tab;
3069: l_location_rec FTE_DIST_INT_PKG.fte_dist_input_rec;
3070: l_location_log_tab FTE_DIST_INT_PKG.fte_dist_output_message_tab;
3071:
3072: l_location_out_tab FTE_DIST_INT_PKG.fte_dist_output_tab;
3073: l_mileage_api_fail VARCHAR2(1);

Line 3070: l_location_log_tab FTE_DIST_INT_PKG.fte_dist_output_message_tab;

3066: l_carrier_distance_uom VARCHAR2(30);
3067: l_carrier_time_uom VARCHAR2(30);
3068: l_location_tab FTE_DIST_INT_PKG.fte_dist_input_tab;
3069: l_location_rec FTE_DIST_INT_PKG.fte_dist_input_rec;
3070: l_location_log_tab FTE_DIST_INT_PKG.fte_dist_output_message_tab;
3071:
3072: l_location_out_tab FTE_DIST_INT_PKG.fte_dist_output_tab;
3073: l_mileage_api_fail VARCHAR2(1);
3074:

Line 3072: l_location_out_tab FTE_DIST_INT_PKG.fte_dist_output_tab;

3068: l_location_tab FTE_DIST_INT_PKG.fte_dist_input_tab;
3069: l_location_rec FTE_DIST_INT_PKG.fte_dist_input_rec;
3070: l_location_log_tab FTE_DIST_INT_PKG.fte_dist_output_message_tab;
3071:
3072: l_location_out_tab FTE_DIST_INT_PKG.fte_dist_output_tab;
3073: l_mileage_api_fail VARCHAR2(1);
3074:
3075: l_return_message VARCHAR2(32767);
3076:

Line 3148: FTE_DIST_INT_PKG.GET_DISTANCE_TIME(

3144:
3145: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_DBG,' DBG 4');
3146:
3147: --Call Mileage api
3148: FTE_DIST_INT_PKG.GET_DISTANCE_TIME(
3149: p_distance_input_tab=> l_location_tab,
3150: p_location_region_flag=> 'L',
3151: p_messaging_yn => 'Y',
3152: p_api_version => '1',

Line 3159: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_DBG,'FTE_DIST_INT_PKG.GET_DISTANCE_TIME, status:'||l_return_status||' msg:'||l_return_message);

3155: x_distance_message_tab => l_location_log_tab,
3156: x_return_message =>l_return_message,
3157: x_return_status => l_return_status);
3158:
3159: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_DBG,'FTE_DIST_INT_PKG.GET_DISTANCE_TIME, status:'||l_return_status||' msg:'||l_return_message);
3160: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3161: THEN
3162: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3163: THEN

Line 11330: l_location_tab FTE_DIST_INT_PKG.fte_dist_input_tab;

11326: END TL_BUILD_CACHE_FOR_LCS;
11327:
11328: PROCEDURE Test_Mileage IS
11329:
11330: l_location_tab FTE_DIST_INT_PKG.fte_dist_input_tab;
11331: l_location_rec FTE_DIST_INT_PKG.fte_dist_input_rec;
11332: l_location_log_tab FTE_DIST_INT_PKG.fte_dist_output_message_tab;
11333:
11334: l_location_out_tab FTE_DIST_INT_PKG.fte_dist_output_tab;

Line 11331: l_location_rec FTE_DIST_INT_PKG.fte_dist_input_rec;

11327:
11328: PROCEDURE Test_Mileage IS
11329:
11330: l_location_tab FTE_DIST_INT_PKG.fte_dist_input_tab;
11331: l_location_rec FTE_DIST_INT_PKG.fte_dist_input_rec;
11332: l_location_log_tab FTE_DIST_INT_PKG.fte_dist_output_message_tab;
11333:
11334: l_location_out_tab FTE_DIST_INT_PKG.fte_dist_output_tab;
11335:

Line 11332: l_location_log_tab FTE_DIST_INT_PKG.fte_dist_output_message_tab;

11328: PROCEDURE Test_Mileage IS
11329:
11330: l_location_tab FTE_DIST_INT_PKG.fte_dist_input_tab;
11331: l_location_rec FTE_DIST_INT_PKG.fte_dist_input_rec;
11332: l_location_log_tab FTE_DIST_INT_PKG.fte_dist_output_message_tab;
11333:
11334: l_location_out_tab FTE_DIST_INT_PKG.fte_dist_output_tab;
11335:
11336: l_return_message VARCHAR2(32767);

Line 11334: l_location_out_tab FTE_DIST_INT_PKG.fte_dist_output_tab;

11330: l_location_tab FTE_DIST_INT_PKG.fte_dist_input_tab;
11331: l_location_rec FTE_DIST_INT_PKG.fte_dist_input_rec;
11332: l_location_log_tab FTE_DIST_INT_PKG.fte_dist_output_message_tab;
11333:
11334: l_location_out_tab FTE_DIST_INT_PKG.fte_dist_output_tab;
11335:
11336: l_return_message VARCHAR2(32767);
11337:
11338: l_return_status VARCHAR2(1);

Line 11405: FTE_DIST_INT_PKG.GET_DISTANCE_TIME(

11401: l_location_tab(11).destination_id:=2881;
11402:
11403:
11404:
11405: FTE_DIST_INT_PKG.GET_DISTANCE_TIME(
11406: p_distance_input_tab=> l_location_tab,
11407: p_location_region_flag=> 'L',
11408: p_messaging_yn => 'Y',
11409: p_api_version => '1',