[Home] [Help]
PACKAGE: APPS.FTE_ACS_CACHE_PKG
Source
1 PACKAGE FTE_ACS_CACHE_PKG AUTHID CURRENT_USER AS
2 /* $Header: FTEACSCS.pls 120.0 2005/05/26 17:22:26 appldev noship $ */
3
4 -- ------------------------------------------------------------------------------------------- --
5 -- --
6 -- Tables and records for input --
7 -- ---------------------------- --
8 -- --
9 -- ------------------------------------------------------------------------------------------- --
10 TYPE fte_cs_entity_attr_rec IS RECORD( group_id NUMBER, --cache is built using group id
11 delivery_id NUMBER,
12 trip_id NUMBER,
13 weight NUMBER,
14 weight_uom_code VARCHAR2(30),
15 volume NUMBER,
16 volume_uom_code VARCHAR2(30),
17 transit_time NUMBER,
18 ship_from_location_id NUMBER,
19 ship_to_location_id NUMBER,
20 fob_code VARCHAR2(30));
21
22 TYPE fte_cs_result_attr_rec IS RECORD( result_type VARCHAR2(30), -- Rank / Multileg / Ranked multileg / Ranked itinerary
23 rank NUMBER,
24 leg_destination NUMBER,
25 leg_sequence NUMBER,
26 -- itinerary_id NUMBER, -- Future use for ranked itenerary
27 carrier_id NUMBER,
28 mode_of_transport VARCHAR2(30),
29 service_level VARCHAR2(30),
30 freight_terms_code VARCHAR2(30),
31 consignee_carrier_ac_no VARCHAR2(240),
32 -- track_only_flag VARCHAR2(1),
33 result_level VARCHAR(5));
34
35 TYPE fte_cs_entity_attr_tab IS TABLE OF fte_cs_entity_attr_rec INDEX BY BINARY_INTEGER;
36
37 TYPE fte_cs_result_attr_tab IS TABLE OF fte_cs_result_attr_rec INDEX BY BINARY_INTEGER;
38
39 g_rule_not_found CONSTANT NUMBER := -1;
40
41 -- ------------------------------------------------------------------------------------------- --
42 -- --
43 -- PROCEDURE DEFINITONS --
44 -- -------------------- --
45 -- --
46 -- ------------------------------------------------------------------------------------------- --
47
48 --***************************************************************************--
49 --========================================================================
50 -- PROCEDURE : get_matching_rule PRIVATE
51 --
52 -- PARAMETERS: p_info Attributes of the entity to be searched for
53 -- x_rule_id Matching Rule
54 -- x_return_status Return Status
55 --
56 -- COMMENT : The API returns the rule which matches attribute values passed in p_info.
57 -- If no rule is found matching it returns g_rule_not_found
58 --
59 --***************************************************************************--
60
61 PROCEDURE GET_MATCHING_RULE( p_info IN FTE_ACS_CACHE_PKG.fte_cs_entity_attr_rec,
62 x_rule_id OUT NOCOPY NUMBER,
63 x_return_status OUT NOCOPY VARCHAR2);
64
65
66 --***************************************************************************--
67 --===========================================================================
68 -- PROCEDURE : get_results_for_rule PRIVATE
69 --
70 -- PARAMETERS: p_rule_id Rule Id.
71 -- x_result_tab Results Attributes associated with the rule.
72 -- x_return_status Return Status
73 --
74 -- COMMENT : For a given rule id queries FTE_SEL_RESULT_ASSIGNMENTS and FTE_SEL_RESULT_ATTRIBUTES
75 -- to return the result.Caching is used in this procedure.
76 --
77 --***************************************************************************--
78 PROCEDURE GET_RESULTS_FOR_RULE( p_rule_id IN NUMBER,
79 x_result_tab OUT NOCOPY FTE_ACS_CACHE_PKG.fte_cs_result_attr_tab,
80 x_return_status OUT NOCOPY VARCHAR2);
81
82
83 END FTE_ACS_CACHE_PKG;