DBA Data[Home] [Help]

APPS.FTE_TL_CACHE dependencies on DBMS_UTILITY

Line 540: p_lane_rows IN DBMS_UTILITY.NUMBER_ARRAY,

536:
537: PROCEDURE TL_Build_Cache_For_Delivery(
538: p_wsh_new_delivery_id IN NUMBER,
539: p_wsh_delivery_leg_id IN NUMBER ,
540: p_lane_rows IN DBMS_UTILITY.NUMBER_ARRAY,
541: p_schedule_rows IN DBMS_UTILITY.NUMBER_ARRAY,
542: x_return_status OUT NOCOPY VARCHAR2) IS
543:
544:

Line 541: p_schedule_rows IN DBMS_UTILITY.NUMBER_ARRAY,

537: PROCEDURE TL_Build_Cache_For_Delivery(
538: p_wsh_new_delivery_id IN NUMBER,
539: p_wsh_delivery_leg_id IN NUMBER ,
540: p_lane_rows IN DBMS_UTILITY.NUMBER_ARRAY,
541: p_schedule_rows IN DBMS_UTILITY.NUMBER_ARRAY,
542: x_return_status OUT NOCOPY VARCHAR2) IS
543:
544:
545: l_return_status VARCHAR2(1);

Line 4886: l_parent_dleg_hash DBMS_UTILITY.NUMBER_ARRAY;

4882: IS
4883:
4884: l_parent_dleg_id NUMBER;
4885: l_parent_dleg_index NUMBER;
4886: l_parent_dleg_hash DBMS_UTILITY.NUMBER_ARRAY;
4887: l_child_dleg_hash DBMS_UTILITY.NUMBER_ARRAY;
4888:
4889: l_curr_dleg_list DBMS_UTILITY.NUMBER_ARRAY;
4890: l_next_dleg_list DBMS_UTILITY.NUMBER_ARRAY;

Line 4887: l_child_dleg_hash DBMS_UTILITY.NUMBER_ARRAY;

4883:
4884: l_parent_dleg_id NUMBER;
4885: l_parent_dleg_index NUMBER;
4886: l_parent_dleg_hash DBMS_UTILITY.NUMBER_ARRAY;
4887: l_child_dleg_hash DBMS_UTILITY.NUMBER_ARRAY;
4888:
4889: l_curr_dleg_list DBMS_UTILITY.NUMBER_ARRAY;
4890: l_next_dleg_list DBMS_UTILITY.NUMBER_ARRAY;
4891:

Line 4889: l_curr_dleg_list DBMS_UTILITY.NUMBER_ARRAY;

4885: l_parent_dleg_index NUMBER;
4886: l_parent_dleg_hash DBMS_UTILITY.NUMBER_ARRAY;
4887: l_child_dleg_hash DBMS_UTILITY.NUMBER_ARRAY;
4888:
4889: l_curr_dleg_list DBMS_UTILITY.NUMBER_ARRAY;
4890: l_next_dleg_list DBMS_UTILITY.NUMBER_ARRAY;
4891:
4892: l_parent_dleg_rec TL_delivery_leg_rec_type;
4893: l_child_dleg_rec TL_delivery_leg_rec_type;

Line 4890: l_next_dleg_list DBMS_UTILITY.NUMBER_ARRAY;

4886: l_parent_dleg_hash DBMS_UTILITY.NUMBER_ARRAY;
4887: l_child_dleg_hash DBMS_UTILITY.NUMBER_ARRAY;
4888:
4889: l_curr_dleg_list DBMS_UTILITY.NUMBER_ARRAY;
4890: l_next_dleg_list DBMS_UTILITY.NUMBER_ARRAY;
4891:
4892: l_parent_dleg_rec TL_delivery_leg_rec_type;
4893: l_child_dleg_rec TL_delivery_leg_rec_type;
4894: l_dleg_id NUMBER;

Line 4896: l_dlegs_with_no_consol_chld DBMS_UTILITY.NUMBER_ARRAY;

4892: l_parent_dleg_rec TL_delivery_leg_rec_type;
4893: l_child_dleg_rec TL_delivery_leg_rec_type;
4894: l_dleg_id NUMBER;
4895: i NUMBER;
4896: l_dlegs_with_no_consol_chld DBMS_UTILITY.NUMBER_ARRAY;
4897: l_dlegs_with_no_consol DBMS_UTILITY.NUMBER_ARRAY;
4898:
4899: l_return_status VARCHAR2(1);
4900:

Line 4897: l_dlegs_with_no_consol DBMS_UTILITY.NUMBER_ARRAY;

4893: l_child_dleg_rec TL_delivery_leg_rec_type;
4894: l_dleg_id NUMBER;
4895: i NUMBER;
4896: l_dlegs_with_no_consol_chld DBMS_UTILITY.NUMBER_ARRAY;
4897: l_dlegs_with_no_consol DBMS_UTILITY.NUMBER_ARRAY;
4898:
4899: l_return_status VARCHAR2(1);
4900:
4901: l_log_level NUMBER := FTE_FREIGHT_PRICING_UTIL.G_DBG;

Line 7584: p_lane_rows IN DBMS_UTILITY.number_array ,

7580: p_pickup_location IN NUMBER,
7581: p_dropoff_location IN NUMBER,
7582: p_departure_date IN DATE,
7583: p_arrival_date IN DATE,
7584: p_lane_rows IN DBMS_UTILITY.number_array ,
7585: p_schedule_rows IN DBMS_UTILITY.number_array,
7586: x_return_status OUT NOCOPY Varchar2) IS
7587:
7588:

Line 7585: p_schedule_rows IN DBMS_UTILITY.number_array,

7581: p_dropoff_location IN NUMBER,
7582: p_departure_date IN DATE,
7583: p_arrival_date IN DATE,
7584: p_lane_rows IN DBMS_UTILITY.number_array ,
7585: p_schedule_rows IN DBMS_UTILITY.number_array,
7586: x_return_status OUT NOCOPY Varchar2) IS
7587:
7588:
7589: CURSOR get_dleg_from_dlv(c_delivery_id IN NUMBER) RETURN

Line 9912: p_lane_rows IN dbms_utility.number_array ,

9908: --stops,dlegs, carr will remain the same
9909:
9910: PROCEDURE TL_BUILD_CACHE_FOR_TRP_COMPARE(
9911: p_wsh_trip_id IN Number ,
9912: p_lane_rows IN dbms_utility.number_array ,
9913: p_schedule_rows IN dbms_utility.number_array,
9914: p_vehicle_rows IN dbms_utility.number_array,
9915: x_return_status OUT NOCOPY Varchar2) IS
9916:

Line 9913: p_schedule_rows IN dbms_utility.number_array,

9909:
9910: PROCEDURE TL_BUILD_CACHE_FOR_TRP_COMPARE(
9911: p_wsh_trip_id IN Number ,
9912: p_lane_rows IN dbms_utility.number_array ,
9913: p_schedule_rows IN dbms_utility.number_array,
9914: p_vehicle_rows IN dbms_utility.number_array,
9915: x_return_status OUT NOCOPY Varchar2) IS
9916:
9917:

Line 9914: p_vehicle_rows IN dbms_utility.number_array,

9910: PROCEDURE TL_BUILD_CACHE_FOR_TRP_COMPARE(
9911: p_wsh_trip_id IN Number ,
9912: p_lane_rows IN dbms_utility.number_array ,
9913: p_schedule_rows IN dbms_utility.number_array,
9914: p_vehicle_rows IN dbms_utility.number_array,
9915: x_return_status OUT NOCOPY Varchar2) IS
9916:
9917:
9918:

Line 10962: p_lane_rows IN dbms_utility.number_array ,

10958:
10959:
10960: PROCEDURE TL_BUILD_CACHE_FOR_DLV_COMPARE(
10961: p_wsh_delivery_id IN Number ,
10962: p_lane_rows IN dbms_utility.number_array ,
10963: p_schedule_rows IN dbms_utility.number_array,
10964: p_vehicle_rows IN dbms_utility.number_array,
10965: p_dep_date IN DATE DEFAULT sysdate,
10966: p_arr_date IN DATE DEFAULT sysdate,

Line 10963: p_schedule_rows IN dbms_utility.number_array,

10959:
10960: PROCEDURE TL_BUILD_CACHE_FOR_DLV_COMPARE(
10961: p_wsh_delivery_id IN Number ,
10962: p_lane_rows IN dbms_utility.number_array ,
10963: p_schedule_rows IN dbms_utility.number_array,
10964: p_vehicle_rows IN dbms_utility.number_array,
10965: p_dep_date IN DATE DEFAULT sysdate,
10966: p_arr_date IN DATE DEFAULT sysdate,
10967: p_pickup_location_id IN NUMBER,

Line 10964: p_vehicle_rows IN dbms_utility.number_array,

10960: PROCEDURE TL_BUILD_CACHE_FOR_DLV_COMPARE(
10961: p_wsh_delivery_id IN Number ,
10962: p_lane_rows IN dbms_utility.number_array ,
10963: p_schedule_rows IN dbms_utility.number_array,
10964: p_vehicle_rows IN dbms_utility.number_array,
10965: p_dep_date IN DATE DEFAULT sysdate,
10966: p_arr_date IN DATE DEFAULT sysdate,
10967: p_pickup_location_id IN NUMBER,
10968: p_dropoff_location_id IN NUMBER,

Line 11252: p_lane_rows IN dbms_utility.number_array ,

11248:
11249:
11250: PROCEDURE TL_BUILD_CACHE_FOR_LCS(
11251: p_wsh_trip_id IN Number ,
11252: p_lane_rows IN dbms_utility.number_array ,
11253: p_schedule_rows IN dbms_utility.number_array ,
11254: p_vehicle_rows IN dbms_utility.number_array,
11255: x_return_status OUT NOCOPY Varchar2) IS
11256:

Line 11253: p_schedule_rows IN dbms_utility.number_array ,

11249:
11250: PROCEDURE TL_BUILD_CACHE_FOR_LCS(
11251: p_wsh_trip_id IN Number ,
11252: p_lane_rows IN dbms_utility.number_array ,
11253: p_schedule_rows IN dbms_utility.number_array ,
11254: p_vehicle_rows IN dbms_utility.number_array,
11255: x_return_status OUT NOCOPY Varchar2) IS
11256:
11257:

Line 11254: p_vehicle_rows IN dbms_utility.number_array,

11250: PROCEDURE TL_BUILD_CACHE_FOR_LCS(
11251: p_wsh_trip_id IN Number ,
11252: p_lane_rows IN dbms_utility.number_array ,
11253: p_schedule_rows IN dbms_utility.number_array ,
11254: p_vehicle_rows IN dbms_utility.number_array,
11255: x_return_status OUT NOCOPY Varchar2) IS
11256:
11257:
11258:

Line 11260: l_vehicle_rows dbms_utility.number_array;

11256:
11257:
11258:
11259: l_vehicle_type_id NUMBER;
11260: l_vehicle_rows dbms_utility.number_array;
11261: l_schedule_rows dbms_utility.number_array;
11262: l_return_status VARCHAR2(1);
11263:
11264: l_log_level NUMBER := FTE_FREIGHT_PRICING_UTIL.G_DBG;

Line 11261: l_schedule_rows dbms_utility.number_array;

11257:
11258:
11259: l_vehicle_type_id NUMBER;
11260: l_vehicle_rows dbms_utility.number_array;
11261: l_schedule_rows dbms_utility.number_array;
11262: l_return_status VARCHAR2(1);
11263:
11264: l_log_level NUMBER := FTE_FREIGHT_PRICING_UTIL.G_DBG;
11265: i NUMBER;

Line 13059: p_lane_rows IN dbms_utility.number_array ,

13055:
13056:
13057:
13058: PROCEDURE TL_BUILD_CACHE_FOR_ESTIMATE(
13059: p_lane_rows IN dbms_utility.number_array ,
13060: p_schedule_rows IN dbms_utility.number_array,
13061: p_vehicle_rows IN dbms_utility.number_array,
13062: p_pickup_location_id IN NUMBER,
13063: p_dropoff_location_id IN NUMBER,

Line 13060: p_schedule_rows IN dbms_utility.number_array,

13056:
13057:
13058: PROCEDURE TL_BUILD_CACHE_FOR_ESTIMATE(
13059: p_lane_rows IN dbms_utility.number_array ,
13060: p_schedule_rows IN dbms_utility.number_array,
13061: p_vehicle_rows IN dbms_utility.number_array,
13062: p_pickup_location_id IN NUMBER,
13063: p_dropoff_location_id IN NUMBER,
13064: p_ship_date IN DATE,

Line 13061: p_vehicle_rows IN dbms_utility.number_array,

13057:
13058: PROCEDURE TL_BUILD_CACHE_FOR_ESTIMATE(
13059: p_lane_rows IN dbms_utility.number_array ,
13060: p_schedule_rows IN dbms_utility.number_array,
13061: p_vehicle_rows IN dbms_utility.number_array,
13062: p_pickup_location_id IN NUMBER,
13063: p_dropoff_location_id IN NUMBER,
13064: p_ship_date IN DATE,
13065: p_delivery_date IN DATE,

Line 14306: p_lane_rows IN dbms_utility.number_array ,

14302:
14303: PROCEDURE TL_BUILD_CACHE_FOR_OM(
14304: p_source_header_rec IN FTE_PROCESS_REQUESTS.fte_source_header_rec,
14305: p_source_lines_tab IN FTE_PROCESS_REQUESTS.fte_source_line_tab,
14306: p_lane_rows IN dbms_utility.number_array ,
14307: p_schedule_rows IN dbms_utility.number_array,
14308: p_vehicle_rows IN dbms_utility.number_array,
14309: x_return_status OUT NOCOPY Varchar2)
14310: IS

Line 14307: p_schedule_rows IN dbms_utility.number_array,

14303: PROCEDURE TL_BUILD_CACHE_FOR_OM(
14304: p_source_header_rec IN FTE_PROCESS_REQUESTS.fte_source_header_rec,
14305: p_source_lines_tab IN FTE_PROCESS_REQUESTS.fte_source_line_tab,
14306: p_lane_rows IN dbms_utility.number_array ,
14307: p_schedule_rows IN dbms_utility.number_array,
14308: p_vehicle_rows IN dbms_utility.number_array,
14309: x_return_status OUT NOCOPY Varchar2)
14310: IS
14311:

Line 14308: p_vehicle_rows IN dbms_utility.number_array,

14304: p_source_header_rec IN FTE_PROCESS_REQUESTS.fte_source_header_rec,
14305: p_source_lines_tab IN FTE_PROCESS_REQUESTS.fte_source_line_tab,
14306: p_lane_rows IN dbms_utility.number_array ,
14307: p_schedule_rows IN dbms_utility.number_array,
14308: p_vehicle_rows IN dbms_utility.number_array,
14309: x_return_status OUT NOCOPY Varchar2)
14310: IS
14311:
14312: l_trip_index NUMBER;