DBA Data[Home] [Help]

APPS.FTE_TRIP_RATING_GRP dependencies on FTE_CARRIER_RANK_LIST_PVT

Line 2463: x_rank_rec IN OUT NOCOPY FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec,

2459:
2460: PROCEDURE Copy_LaneSched_To_Rank(
2461: p_lane_rec IN fte_lane_rec,
2462: p_sched_rec IN fte_schedule_rec,
2463: x_rank_rec IN OUT NOCOPY FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec,
2464: x_return_status OUT NOCOPY VARCHAR2)
2465: IS
2466:
2467: l_log_level NUMBER := FTE_FREIGHT_PRICING_UTIL.G_DBG;

Line 2522: p_rank_rec IN FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec,

2518:
2519: PROCEDURE LaneSched_Matches_Rank(
2520: p_lane_rec IN fte_lane_rec,
2521: p_schedule_rec IN fte_schedule_rec,
2522: p_rank_rec IN FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec,
2523: x_match_result OUT NOCOPY VARCHAR2,--'Y' or 'N'
2524: x_return_status OUT NOCOPY VARCHAR2)
2525: IS
2526:

Line 2639: p_ss_rate_sort_tab IN FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,

2635: END LaneSched_Matches_Rank;
2636:
2637: PROCEDURE Search_Multi_ShipMethods(
2638: p_ss_attr_rec IN FTE_SS_ATTR_REC,
2639: p_ss_rate_sort_tab IN FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,
2640: x_ss_rate_sort_tab OUT NOCOPY FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,
2641: x_ref OUT NOCOPY dbms_utility.number_array,
2642: x_return_status OUT NOCOPY VARCHAR2)
2643: IS

Line 2640: x_ss_rate_sort_tab OUT NOCOPY FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,

2636:
2637: PROCEDURE Search_Multi_ShipMethods(
2638: p_ss_attr_rec IN FTE_SS_ATTR_REC,
2639: p_ss_rate_sort_tab IN FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,
2640: x_ss_rate_sort_tab OUT NOCOPY FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,
2641: x_ref OUT NOCOPY dbms_utility.number_array,
2642: x_return_status OUT NOCOPY VARCHAR2)
2643: IS
2644: l_match_result VARCHAR2(1);

Line 3074: PROCEDURE Display_Rank_Rec(p_rank_rec IN FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec)

3070: END Display_Attr_Rec;
3071:
3072:
3073:
3074: PROCEDURE Display_Rank_Rec(p_rank_rec IN FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec)
3075: IS
3076: l_log_level NUMBER := FTE_FREIGHT_PRICING_UTIL.G_DBG;
3077:
3078: BEGIN

Line 3159: p_rank_tab IN FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,

3155:
3156: END Display_Rank_Rec;
3157:
3158: PROCEDURE Display_Rank_Tab(
3159: p_rank_tab IN FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,
3160: p_input_ref IN dbms_utility.number_array)
3161: IS
3162: l_log_level NUMBER := FTE_FREIGHT_PRICING_UTIL.G_DBG;
3163: i NUMBER;

Line 3242: p_ss_rate_sort_tab IN FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,

3238: END Get_Vehicle_Item_Org;
3239:
3240:
3241: PROCEDURE Seq_Tender_Sort(
3242: p_ss_rate_sort_tab IN FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,
3243: p_input_ref IN dbms_utility.number_array ,-- Reference of p_ss_rate_sort_tab to input ranks
3244: x_ss_rate_sort_tab OUT NOCOPY FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,
3245: x_input_ref OUT NOCOPY dbms_utility.number_array ,-- Reference of p_ss_rate_sort_tab to input ranks
3246: x_return_status OUT NOCOPY VARCHAR2)

Line 3244: x_ss_rate_sort_tab OUT NOCOPY FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,

3240:
3241: PROCEDURE Seq_Tender_Sort(
3242: p_ss_rate_sort_tab IN FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,
3243: p_input_ref IN dbms_utility.number_array ,-- Reference of p_ss_rate_sort_tab to input ranks
3244: x_ss_rate_sort_tab OUT NOCOPY FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,
3245: x_input_ref OUT NOCOPY dbms_utility.number_array ,-- Reference of p_ss_rate_sort_tab to input ranks
3246: x_return_status OUT NOCOPY VARCHAR2)
3247: IS
3248: i NUMBER;

Line 3390: p_ss_rate_sort_tab IN FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,

3386:
3387: END Seq_Tender_Sort;
3388:
3389: PROCEDURE Remove_Duplicate_Lanes(
3390: p_ss_rate_sort_tab IN FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,
3391: p_input_ref IN dbms_utility.number_array ,-- Reference of p_ss_rate_sort_tab to input ranks
3392: x_ss_rate_sort_tab OUT NOCOPY FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,
3393: x_input_ref OUT NOCOPY dbms_utility.number_array ,-- Reference of p_ss_rate_sort_tab to input ranks
3394: x_return_status OUT NOCOPY VARCHAR2)

Line 3392: x_ss_rate_sort_tab OUT NOCOPY FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,

3388:
3389: PROCEDURE Remove_Duplicate_Lanes(
3390: p_ss_rate_sort_tab IN FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,
3391: p_input_ref IN dbms_utility.number_array ,-- Reference of p_ss_rate_sort_tab to input ranks
3392: x_ss_rate_sort_tab OUT NOCOPY FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,
3393: x_input_ref OUT NOCOPY dbms_utility.number_array ,-- Reference of p_ss_rate_sort_tab to input ranks
3394: x_return_status OUT NOCOPY VARCHAR2)
3395: IS
3396: i NUMBER;

Line 3650: p_ss_rate_sort_tab IN FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,

3646: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3647: p_event IN VARCHAR2 DEFAULT 'FTE_TRIP_COMP',
3648: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3649: p_init_prc_log IN VARCHAR2 DEFAULT 'Y',
3650: p_ss_rate_sort_tab IN FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,
3651: p_ss_rate_sort_atr_rec IN FTE_SS_ATTR_REC,
3652: x_ss_rate_sort_tab OUT NOCOPY FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,
3653: x_rating_request_id OUT NOCOPY NUMBER,
3654: x_return_status OUT NOCOPY VARCHAR2,

Line 3652: x_ss_rate_sort_tab OUT NOCOPY FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,

3648: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3649: p_init_prc_log IN VARCHAR2 DEFAULT 'Y',
3650: p_ss_rate_sort_tab IN FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,
3651: p_ss_rate_sort_atr_rec IN FTE_SS_ATTR_REC,
3652: x_ss_rate_sort_tab OUT NOCOPY FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,
3653: x_rating_request_id OUT NOCOPY NUMBER,
3654: x_return_status OUT NOCOPY VARCHAR2,
3655: x_msg_count OUT NOCOPY NUMBER,
3656: x_msg_data OUT NOCOPY VARCHAR2)

Line 3663: l_sort_rank_tab FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;

3659: i NUMBER;
3660: j NUMBER;
3661: k NUMBER;
3662:
3663: l_sort_rank_tab FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
3664: l_rate_rank_tab FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
3665: l_lane_rank_tab FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
3666: l_elim_rank_tab FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
3667: l_lane_rank_ref DBMS_UTILITY.NUMBER_ARRAY;

Line 3664: l_rate_rank_tab FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;

3660: j NUMBER;
3661: k NUMBER;
3662:
3663: l_sort_rank_tab FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
3664: l_rate_rank_tab FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
3665: l_lane_rank_tab FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
3666: l_elim_rank_tab FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
3667: l_lane_rank_ref DBMS_UTILITY.NUMBER_ARRAY;
3668: l_rate_rank_ref DBMS_UTILITY.NUMBER_ARRAY;

Line 3665: l_lane_rank_tab FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;

3661: k NUMBER;
3662:
3663: l_sort_rank_tab FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
3664: l_rate_rank_tab FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
3665: l_lane_rank_tab FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
3666: l_elim_rank_tab FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
3667: l_lane_rank_ref DBMS_UTILITY.NUMBER_ARRAY;
3668: l_rate_rank_ref DBMS_UTILITY.NUMBER_ARRAY;
3669: l_sort_rank_ref DBMS_UTILITY.NUMBER_ARRAY;

Line 3666: l_elim_rank_tab FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;

3662:
3663: l_sort_rank_tab FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
3664: l_rate_rank_tab FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
3665: l_lane_rank_tab FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
3666: l_elim_rank_tab FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
3667: l_lane_rank_ref DBMS_UTILITY.NUMBER_ARRAY;
3668: l_rate_rank_ref DBMS_UTILITY.NUMBER_ARRAY;
3669: l_sort_rank_ref DBMS_UTILITY.NUMBER_ARRAY;
3670: