APPS.FTE_LANE_SEARCH dependencies on FTE_LANE_TAB

Line 498: x_lane_results OUT NOCOPY fte_lane_tab,

494: -- -----------------------------------------------------------------
495: PROCEDURE Search_Lanes( p_search_criteria IN fte_search_criteria_tab,
496: p_num_results IN NUMBER,
497: p_search_type IN VARCHAR2,
498: x_lane_results OUT NOCOPY fte_lane_tab,
499: x_schedule_results OUT NOCOPY fte_schedule_tab,
500: x_return_message OUT NOCOPY VARCHAR2,
501: x_return_status OUT NOCOPY VARCHAR2) IS
502:

Line 506: l_lane_results fte_lane_tab;

502:
503:
504: type t_result_ids is table of NUMBER index by binary_integer;
505:
506: l_lane_results fte_lane_tab;
507: l_lane_id NUMBER;
508: l_schedule_id NUMBER;
509: i NUMBER;
510: j NUMBER;

Line 542: x_lane_results:= fte_lane_tab();

538: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.COUNT',p_search_criteria.COUNT);
539: WSH_DEBUG_SV.log(l_module_name,'P_NUM_RESULTS',P_NUM_RESULTS);
540: END IF;
541: --
542: x_lane_results:= fte_lane_tab();
543: x_schedule_results := fte_schedule_tab();
544: i := p_search_criteria.FIRST;
545: WHILE i is not null LOOP
546: l_lane_results := fte_lane_tab();

Line 546: l_lane_results := fte_lane_tab();

542: x_lane_results:= fte_lane_tab();
543: x_schedule_results := fte_schedule_tab();
544: i := p_search_criteria.FIRST;
545: WHILE i is not null LOOP
546: l_lane_results := fte_lane_tab();
547: l_schedule_results := fte_schedule_tab();
548: Search_Lanes( p_search_criteria => p_search_criteria(i),
549: p_search_type => p_search_type,
550: p_source_type => 'R',

Line 637: x_lane_results OUT NOCOPY fte_lane_tab,

633: PROCEDURE Search_Lanes(p_search_criteria IN fte_search_criteria_rec,
634: p_search_type IN VARCHAR2, -- 'L' for lanes, 'S' for schedules
635: p_source_type IN VARCHAR2,
636: p_num_results IN NUMBER,
637: x_lane_results OUT NOCOPY fte_lane_tab,
638: x_schedule_results OUT NOCOPY fte_schedule_tab,
639: x_return_message OUT NOCOPY VARCHAR2,
640: x_return_status OUT NOCOPY VARCHAR2) IS
641:

Line 751: l_lanes_tab fte_lane_tab;

747: s_active_flag dbms_sql.VARCHAR2_TABLE;
748:
749: l_num_rows NUMBER := 0;
750: l_lanes_rec fte_lane_rec;
751: l_lanes_tab fte_lane_tab;
752: l_schedules_rec fte_schedule_rec;
753: l_schedules_tab fte_schedule_tab;
754:
755: -- similar to hash table to keep track of unique lane ids

Line 845: x_lane_results := fte_lane_tab();

841: --If no regions are found, return.
842: IF (l_parent_dests IS NULL OR l_parent_dests.COUNT <= 0 OR
843: l_parent_origins IS NULL OR l_parent_origins.COUNT <= 0) THEN
844:
845: x_lane_results := fte_lane_tab();
846: x_schedule_results := fte_schedule_tab();
847:
848: x_return_message := x_return_message || 'No regions found for search criteria';
849:

Line 858: x_lane_results := fte_lane_tab();

854: RETURN;
855: END IF;
856:
857: IF (l_origins.COUNT > 1) THEN
858: x_lane_results := fte_lane_tab();
859: x_schedule_results := fte_schedule_tab();
860: x_return_message := x_return_message || 'Ambiguous origin input -- ' || Fnd_Global.NewLine;
861:
862: FOR i IN l_origins.FIRST .. l_origins.LAST LOOP

Line 871: x_lane_results := fte_lane_tab();

867: RETURN;
868: END IF;
869:
870: IF (l_destinations.COUNT > 1) THEN
871: x_lane_results := fte_lane_tab();
872: x_schedule_results := fte_schedule_tab();
873: x_return_message := x_return_message || 'Ambiguous destination input -- ' || Fnd_Global.NewLine;
874:
875: FOR i IN l_destinations.FIRST .. l_destinations.LAST LOOP

Line 973: l_lanes_tab := fte_lane_tab();

969: -- [11/11] Add query type for Lane Group and Commitment -> 'T'
970: l_source_type := p_source_type;
971:
972: IF (p_search_type = 'L') THEN
973: l_lanes_tab := fte_lane_tab();
974:
975: --
976: -- Debug Statements
977: --