[Home] [Help]
PACKAGE: APPS.FTE_TL_CORE
Source
1 PACKAGE FTE_TL_CORE AUTHID CURRENT_USER 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;