DBA Data[Home] [Help]

APPS.FTE_TL_RATING dependencies on FTE_PROCESS_REQUESTS

Line 4337: p_source_header_rec IN FTE_PROCESS_REQUESTS.fte_source_header_rec,

4333: p_start_trip_index IN NUMBER,
4334: p_end_trip_index IN NUMBER,
4335: p_lane_info_tab IN FTE_FREIGHT_RATING_PUB.lane_info_tab_type,
4336: p_output_cost_tab IN FTE_FREIGHT_PRICING.Freight_Cost_Temp_Tab_Type,
4337: p_source_header_rec IN FTE_PROCESS_REQUESTS.fte_source_header_rec,
4338: p_source_lines_tab IN FTE_PROCESS_REQUESTS.fte_source_line_tab,
4339: p_LCSS_flag IN VARCHAR2,
4340: p_lane_sched_sum_rows IN dbms_utility.number_array,
4341: p_lane_sched_curr_rows IN dbms_utility.name_array,

Line 4338: p_source_lines_tab IN FTE_PROCESS_REQUESTS.fte_source_line_tab,

4334: p_end_trip_index IN NUMBER,
4335: p_lane_info_tab IN FTE_FREIGHT_RATING_PUB.lane_info_tab_type,
4336: p_output_cost_tab IN FTE_FREIGHT_PRICING.Freight_Cost_Temp_Tab_Type,
4337: p_source_header_rec IN FTE_PROCESS_REQUESTS.fte_source_header_rec,
4338: p_source_lines_tab IN FTE_PROCESS_REQUESTS.fte_source_line_tab,
4339: p_LCSS_flag IN VARCHAR2,
4340: p_lane_sched_sum_rows IN dbms_utility.number_array,
4341: p_lane_sched_curr_rows IN dbms_utility.name_array,
4342: p_filtered_rows IN dbms_utility.number_array,

Line 4345: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,

4341: p_lane_sched_curr_rows IN dbms_utility.name_array,
4342: p_filtered_rows IN dbms_utility.number_array,
4343: p_ref_rows IN dbms_utility.number_array,
4344: p_summary_cache_ref IN dbms_utility.number_array,
4345: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,
4346: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,
4347: x_return_status OUT NOCOPY VARCHAR2)
4348: IS
4349:

Line 4346: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,

4342: p_filtered_rows IN dbms_utility.number_array,
4343: p_ref_rows IN dbms_utility.number_array,
4344: p_summary_cache_ref IN dbms_utility.number_array,
4345: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,
4346: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,
4347: x_return_status OUT NOCOPY VARCHAR2)
4348: IS
4349:
4350: l_source_header_rate_rec FTE_PROCESS_REQUESTS.fte_source_header_rates_rec;

Line 4350: l_source_header_rate_rec FTE_PROCESS_REQUESTS.fte_source_header_rates_rec;

4346: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,
4347: x_return_status OUT NOCOPY VARCHAR2)
4348: IS
4349:
4350: l_source_header_rate_rec FTE_PROCESS_REQUESTS.fte_source_header_rates_rec;
4351: l_source_line_rate_rec FTE_PROCESS_REQUESTS.fte_source_line_rates_rec;
4352: l_detail_records FTE_PROCESS_REQUESTS.fte_source_line_rates_tab;
4353: l_detail_price dbms_utility.number_array;
4354: l_detail_charge dbms_utility.number_array;

Line 4351: l_source_line_rate_rec FTE_PROCESS_REQUESTS.fte_source_line_rates_rec;

4347: x_return_status OUT NOCOPY VARCHAR2)
4348: IS
4349:
4350: l_source_header_rate_rec FTE_PROCESS_REQUESTS.fte_source_header_rates_rec;
4351: l_source_line_rate_rec FTE_PROCESS_REQUESTS.fte_source_line_rates_rec;
4352: l_detail_records FTE_PROCESS_REQUESTS.fte_source_line_rates_tab;
4353: l_detail_price dbms_utility.number_array;
4354: l_detail_charge dbms_utility.number_array;
4355: l_price NUMBER;

Line 4352: l_detail_records FTE_PROCESS_REQUESTS.fte_source_line_rates_tab;

4348: IS
4349:
4350: l_source_header_rate_rec FTE_PROCESS_REQUESTS.fte_source_header_rates_rec;
4351: l_source_line_rate_rec FTE_PROCESS_REQUESTS.fte_source_line_rates_rec;
4352: l_detail_records FTE_PROCESS_REQUESTS.fte_source_line_rates_tab;
4353: l_detail_price dbms_utility.number_array;
4354: l_detail_charge dbms_utility.number_array;
4355: l_price NUMBER;
4356: l_charge NUMBER;

Line 5004: p_source_header_rec IN FTE_PROCESS_REQUESTS.fte_source_header_rec,

5000: PROCEDURE TL_OM_RATING(
5001: p_lane_rows IN dbms_utility.number_array ,
5002: p_schedule_rows IN dbms_utility.number_array,
5003: p_lane_info_tab IN FTE_FREIGHT_RATING_PUB.lane_info_tab_type,
5004: p_source_header_rec IN FTE_PROCESS_REQUESTS.fte_source_header_rec,
5005: p_source_lines_tab IN FTE_PROCESS_REQUESTS.fte_source_line_tab,
5006: p_LCSS_flag IN VARCHAR2,
5007: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,
5008: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,

Line 5005: p_source_lines_tab IN FTE_PROCESS_REQUESTS.fte_source_line_tab,

5001: p_lane_rows IN dbms_utility.number_array ,
5002: p_schedule_rows IN dbms_utility.number_array,
5003: p_lane_info_tab IN FTE_FREIGHT_RATING_PUB.lane_info_tab_type,
5004: p_source_header_rec IN FTE_PROCESS_REQUESTS.fte_source_header_rec,
5005: p_source_lines_tab IN FTE_PROCESS_REQUESTS.fte_source_line_tab,
5006: p_LCSS_flag IN VARCHAR2,
5007: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,
5008: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,
5009: x_return_status OUT NOCOPY Varchar2)

Line 5007: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,

5003: p_lane_info_tab IN FTE_FREIGHT_RATING_PUB.lane_info_tab_type,
5004: p_source_header_rec IN FTE_PROCESS_REQUESTS.fte_source_header_rec,
5005: p_source_lines_tab IN FTE_PROCESS_REQUESTS.fte_source_line_tab,
5006: p_LCSS_flag IN VARCHAR2,
5007: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,
5008: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,
5009: x_return_status OUT NOCOPY Varchar2)
5010: IS
5011:

Line 5008: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,

5004: p_source_header_rec IN FTE_PROCESS_REQUESTS.fte_source_header_rec,
5005: p_source_lines_tab IN FTE_PROCESS_REQUESTS.fte_source_line_tab,
5006: p_LCSS_flag IN VARCHAR2,
5007: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,
5008: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,
5009: x_return_status OUT NOCOPY Varchar2)
5010: IS
5011:
5012: l_exploded_lane_rows dbms_utility.number_array;