[Home] [Help]
PACKAGE: APPS.FTE_ACS_PKG
Source
1 PACKAGE FTE_ACS_PKG AS
2 /* $Header: FTEACSMS.pls 120.2 2005/06/23 14:16:56 appldev ship $ */
3
4 -- ------------------------------------------------------------------------------------------- --
5 -- --
6 -- Tables and records for input --
7 -- ---------------------------- --
8 -- --
9 -- ------------------------------------------------------------------------------------------- --
10 TYPE fte_cs_output_message_rec IS RECORD (sequence_number NUMBER,
11 message_type VARCHAR2(1),
12 message_code VARCHAR2(30),
13 message_text VARCHAR2(2000),
14 level NUMBER,
15 query_id NUMBER,
16 group_id NUMBER,
17 rule_id NUMBER,
18 result_id NUMBER);
19
20 TYPE fte_cs_output_message_tab IS TABLE OF fte_cs_output_message_rec INDEX BY BINARY_INTEGER;
21
22 -- ----------------------------------------------------------------------------------------- --
23
24 TYPE fte_car_sel_tmp_num_table IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
25 TYPE fte_flag_tab_type IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
26 TYPE fte_car_sel_tmp_uom_table IS TABLE OF VARCHAR2(3) INDEX BY BINARY_INTEGER;
27 TYPE fte_car_sel_char4_table IS TABLE OF VARCHAR2(4) INDEX BY BINARY_INTEGER;
28 TYPE fte_car_sel_tmp_code_table IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
29 TYPE fte_car_sel_tmp_char_table IS TABLE OF VARCHAR2(240) INDEX BY BINARY_INTEGER;
30 TYPE fte_car_sel_msg_table IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
31 TYPE fte_car_sel_date_table IS TABLE OF DATE INDEX BY BINARY_INTEGER;
32
33
34 --
35 -- R12 Definations;
36 --
37 TYPE fte_cs_entity_rec_type IS RECORD(
38 delivery_id NUMBER,
39 delivery_name VARCHAR2(30),
40 trip_id NUMBER,
41 trip_name VARCHAR2(30),
42 organization_id NUMBER,
43 triporigin_internalorg_id NUMBER,
44 gross_weight NUMBER,
45 weight_uom_code VARCHAR2(3),
46 volume NUMBER,
47 volume_uom_code VARCHAR2(3),
48 initial_pickup_loc_id NUMBER,
49 ultimate_dropoff_loc_id NUMBER,
50 customer_id NUMBER,
51 customer_site_id NUMBER,
52 freight_terms_code VARCHAR2(30),
53 initial_pickup_date DATE,
54 ultimate_dropoff_date DATE,
55 fob_code VARCHAR2(30),
56 start_search_level VARCHAR2(10),
57 transit_time NUMBER,
58 rule_id NUMBER,
59 result_found_flag VARCHAR2(1));
60
61 TYPE fte_cs_entity_tab_type IS TABLE OF FTE_CS_ENTITY_REC_TYPE INDEX BY BINARY_INTEGER;
62
63 TYPE fte_cs_result_rec_type IS RECORD(
64 rule_id NUMBER,
65 rule_name VARCHAR2(30),
66 delivery_id NUMBER,
67 organization_id NUMBER,
68 initial_pickup_location_id NUMBER,
69 ultimate_dropoff_location_id NUMBER,
70 trip_id NUMBER,
71 result_type VARCHAR2(30), -- Rank / Multileg / Ranked multileg / Ranked itinerary
72 rank NUMBER,
73 leg_destination NUMBER,
74 leg_sequence NUMBER,
75 -- itinerary_id NUMBER, -- Future use for ranked itenerary
76 carrier_id NUMBER,
77 mode_of_transport VARCHAR2(30),
78 service_level VARCHAR2(30),
79 ship_method_code VARCHAR2(30),
80 freight_terms_code VARCHAR2(30),
81 consignee_carrier_ac_no VARCHAR2(240), --WSH_TRIPS
82 -- track_only_flag VARCHAR2(1),
83 result_level VARCHAR(5),
84 pickup_date DATE,
85 dropoff_date DATE,
86 min_transit_time NUMBER,
87 max_transit_time NUMBER,
88 append_flag VARCHAR2(1)
89 --,routing_rule_id NUMBER
90 );
91
92 TYPE fte_cs_result_tab_type IS TABLE OF fte_cs_result_rec_type INDEX BY BINARY_INTEGER;
93
94 -- ------------------------------------------------------------------------------------------- --
95 -- --
96 -- PROCEDURE DEFINITONS --
97 -- -------------------- --
98 -- --
99 -- ------------------------------------------------------------------------------------------- --
100 /*
101 PROCEDURE START_ACS(p_cs_input_header_rec IN OUT NOCOPY FTE_ACS_PKG.fte_cs_input_header_rec,
102 p_cs_input_attribute_tab IN OUT NOCOPY FTE_ACS_PKG.fte_cs_input_attribute_tab,
103 p_object_name IN VARCHAR2,
104 p_object_id IN NUMBER,
105 p_messaging_yn IN VARCHAR2,
106 x_cs_output_result_tab OUT NOCOPY FTE_ACS_PKG.fte_cs_output_result_tab,
107 x_cs_output_message_tab OUT NOCOPY FTE_ACS_PKG.fte_cs_output_message_tab,
108 x_return_message OUT NOCOPY VARCHAR2,
109 x_return_status OUT NOCOPY VARCHAR2);
110 */
111
112 PROCEDURE LOG_CS_MESSAGES(p_message_type_tab IN OUT NOCOPY FTE_ACS_PKG.fte_flag_tab_type,
113 p_message_code_tab IN OUT NOCOPY FTE_ACS_PKG.fte_car_sel_tmp_code_table,
114 p_message_text_tab IN OUT NOCOPY FTE_ACS_PKG.fte_car_sel_msg_table,
115 p_level_tab IN OUT NOCOPY FTE_ACS_PKG.fte_car_sel_tmp_num_table,
116 p_query_id IN NUMBER,
117 p_group_id_tab IN OUT NOCOPY FTE_ACS_PKG.fte_car_sel_tmp_num_table,
118 p_rule_id_tab IN OUT NOCOPY FTE_ACS_PKG.fte_car_sel_tmp_num_table,
119 p_result_id_tab IN OUT NOCOPY FTE_ACS_PKG.fte_car_sel_tmp_num_table,
120 x_return_status OUT NOCOPY VARCHAR2,
121 x_return_message OUT NOCOPY VARCHAR2);
122
123
124 --
125 -- R12 Routing Enhancement
126 --
127 PROCEDURE GET_ROUTING_RESULTS( p_format_cs_tab IN OUT NOCOPY FTE_ACS_PKG.fte_cs_entity_tab_type,
128 p_entity IN VARCHAR2,--trip/dlvy/pseudo_dlvy
129 p_messaging_yn IN VARCHAR2,
130 p_caller IN VARCHAR2,
131 x_cs_output_tab OUT NOCOPY FTE_ACS_PKG.fte_cs_result_tab_type,
132 x_cs_output_message_tab OUT NOCOPY FTE_ACS_PKG.fte_cs_output_message_tab,
133 x_return_message OUT NOCOPY VARCHAR2,
134 x_return_status OUT NOCOPY VARCHAR2);
135
136 --
137 -- R12 Routing Enhancement
138 --
139
140 END FTE_ACS_PKG;