APPS.FTE_LANE_SEARCH dependencies on FTE_SCHEDULE_TAB

Line 499: x_schedule_results OUT NOCOPY fte_schedule_tab,

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:
503:

Line 514: l_schedule_results fte_schedule_tab;

510: j NUMBER;
511: l_result_ids t_result_ids;
512:
513: x_count NUMBER := 1;
514: l_schedule_results fte_schedule_tab;
515:
516: --
517: l_debug_on BOOLEAN;
518: --

Line 543: x_schedule_results := fte_schedule_tab();

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();
547: l_schedule_results := fte_schedule_tab();

Line 547: l_schedule_results := fte_schedule_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',
551: p_num_results => (p_num_results-x_count),

Line 638: x_schedule_results OUT NOCOPY fte_schedule_tab,

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:
642: l_search_criteria FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_criteria_rec;

Line 753: l_schedules_tab fte_schedule_tab;

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
756: type t_result_ids is table of NUMBER index by binary_integer;
757: l_result_lane_ids t_result_ids;

Line 846: x_schedule_results := fte_schedule_tab();

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:
850: IF l_debug_on THEN

Line 859: x_schedule_results := fte_schedule_tab();

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
863: x_return_message := x_return_message || l_origins(i).CITY||','||

Line 872: x_schedule_results := fte_schedule_tab();

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
876: x_return_message := x_return_message || l_destinations(i).CITY||','||

Line 1687: l_schedules_tab := fte_schedule_tab();

1683: -- call constraints API
1684:
1685: ELSE -- p_search_type = 'S'
1686:
1687: l_schedules_tab := fte_schedule_tab();
1688:
1689: --
1690: -- Debug Statements
1691: --