PACKAGE: APPS.FTE_TL_CORE

Source

1 PACKAGE FTE_TL_CORE AS
2 /* $Header: FTEVTLOS.pls 120.0 2005/05/26 17:04:22 appldev noship $ */
3 
4 -- Global constants
5 
6    TL_WEIGHT_BASIS NUMBER := 1;
7 
8 
9 TYPE tl_exceptions_type IS RECORD(
10 	trip_index 		NUMBER,
11 	implicit_non_dummy_cnt 	NUMBER,
12 	check_tlqp_ouputfail  	VARCHAR2(1),
13 	check_qp_ipl_fail 	VARCHAR2(1),
14 	not_on_pl_flag		VARCHAR2(1),
15 	price_req_failed	VARCHAR2(1),
16 	allocation_failed	VARCHAR2(1)
17 	);
18 
19 TYPE tl_exceptions_tab_type IS TABLE OF  tl_exceptions_type INDEX BY BINARY_INTEGER;
20 
21 
22 -- +======================================================================+
23 --   Procedure :
24 --           tl_core
25 --
26 --   Description:
27 --           Build the call structure for the pricing engine, invoke the
28 --           rating engine, analyze results, return results.
29 --   Inputs:
30 --           p_trip_rec    IN TL_trip_data_input_rec_type
31 --           p_stop_tab          IN TL_trip_stop_data_tab_type,
32 --           p_carrier_pref      IN TL_trip_carrier_preferences_rec_type,
33 --   Output:
34 --           x_trip_charges_rec  OUT NOCOPY  TL_trip_data_output_rec_type,
35 --           x_stop_charges_tab  OUT NOCOPY TL_trip_stop_output_tab_type,
36 --           x_return_status     OUT NOCOPY VARCHAR2
37 --
38 --   Global dependencies:
39 --           No direct
40 --
41 --   DB:
42 --           No direct
43 -- +======================================================================+
44 
45   PROCEDURE tl_core (
46                    p_trip_rec          IN  FTE_TL_CACHE.TL_trip_data_input_rec_type,
47                    p_stop_tab          IN  FTE_TL_CACHE.TL_trip_stop_input_tab_type,
48                    p_carrier_pref      IN  FTE_TL_CACHE.TL_carrier_pref_rec_type,
49                    x_trip_charges_rec  OUT NOCOPY FTE_TL_CACHE.TL_trip_output_rec_type,
50                    x_stop_charges_tab  OUT NOCOPY FTE_TL_CACHE.TL_trip_stop_output_tab_type,
51                    x_return_status     OUT NOCOPY VARCHAR2);
52 
53 
54 
55 
56 
57 
58 PROCEDURE TL_Core_Multiple (
59 		    p_start_trip_index IN NUMBER,
60 		    p_end_trip_index IN NUMBER,
61 	            p_trip_tab    IN FTE_TL_CACHE.TL_trip_data_input_tab_type,
62 	            p_stop_tab          IN  FTE_TL_CACHE.TL_trip_stop_input_tab_type,
63 	            p_carrier_pref_tab      IN  FTE_TL_CACHE.TL_CARRIER_PREF_TAB_TYPE,
64 	            x_trip_charges_tab  OUT NOCOPY FTE_TL_CACHE.TL_TRIP_OUTPUT_TAB_TYPE,
65 	            x_stop_charges_tab  OUT NOCOPY	FTE_TL_CACHE.TL_trip_stop_output_tab_type,
66 		    x_exceptions_tab OUT NOCOPY FTE_TL_CORE.tl_exceptions_tab_type,
67 	            x_return_status     OUT NOCOPY VARCHAR2);
68 
69 END FTE_TL_CORE;