eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.FTE_PROCESS_REQUESTS

Source


1 PACKAGE FTE_PROCESS_REQUESTS AUTHID CURRENT_USER AS
2 /* $Header: FTEPRRES.pls 120.0.12000000.1 2007/01/18 21:25:36 appldev ship $ */
3 
4 
5 TYPE fte_source_line_rec IS RECORD
6 (source_type		VARCHAR2(10),
7  source_header_id	NUMBER,
8  source_line_id		NUMBER,
9  ship_from_org_id	NUMBER,
10  ship_from_location_id	NUMBER,
11  ship_to_site_id	NUMBER,
12  ship_to_location_id	NUMBER,
13  customer_id		NUMBER,
14  inventory_item_id	NUMBER,
15  source_quantity	NUMBER,
16  source_quantity_uom	VARCHAR2(3),
17  ship_date		DATE,
18  arrival_date		DATE,
19  delivery_lead_time	NUMBER,
20  scheduled_flag		VARCHAR2(1),
21  order_set_type		VARCHAR2(30),
22  order_set_id		NUMBER,
23  intmed_ship_to_site_id	NUMBER,
24  intmed_ship_to_loc_id	NUMBER,
25  carrier_id		NUMBER,
26  ship_method_flag	VARCHAR2(1),
27  ship_method_code	VARCHAR2(30),
28  freight_carrier_code	VARCHAR2(30),
29  service_level		VARCHAR2(30),
30  mode_of_transport	VARCHAR2(30),
31  freight_terms		VARCHAR2(30),
32  fob_code		VARCHAR2(30),
33  weight			NUMBER,
34  weight_uom_code	VARCHAR2(3),
35  volume			NUMBER,
36  volume_uom_code	VARCHAR2(3),
37  freight_rating_flag	VARCHAR2(1),
38  freight_rate		NUMBER,
39  freight_rate_currency	VARCHAR2(3),
40  status			VARCHAR2(1),
41  message_data		VARCHAR2(2000),
42  consolidation_id	NUMBER,
43  override_ship_method   VARCHAR2(1),
44  currency               VARCHAR2(10),
45  currency_conversion_type VARCHAR2(30),
46  origin_country         VARCHAR2(30),        -- FTE J FTE estimate rate
47  origin_state           VARCHAR2(30),        -- FTE J FTE estimate rate
48  origin_city            VARCHAR2(30),        -- FTE J FTE estimate rate
49  origin_zip             VARCHAR2(30),        -- FTE J FTE estimate rate
50  destination_country    VARCHAR2(30),        -- FTE J FTE estimate rate
51  destination_state      VARCHAR2(30),        -- FTE J FTE estimate rate
52  destination_city       VARCHAR2(30),        -- FTE J FTE estimate rate
53  destination_zip        VARCHAR2(30),        -- FTE J FTE estimate rate
54  distance                NUMBER,             -- FTE J FTE estimate rate
55  distance_uom            VARCHAR2(30),        -- FTE J FTE estimate rate
56  vehicle_item_id         NUMBER,        -- FTE J FTE estimate rate
57  commodity_category_id   NUMBER        -- FTE J FTE estimate rate
58 );
59 
60 TYPE fte_source_line_tab IS TABLE OF fte_source_line_rec
61 INDEX BY BINARY_INTEGER;
62 
63 TYPE fte_source_header_rec IS RECORD
64 (consolidation_id	NUMBER,
65  ship_from_org_id	NUMBER,
66  ship_from_location_id	NUMBER,
67  ship_to_location_id	NUMBER,
68  ship_to_site_id	NUMBER,
69  customer_id		NUMBER,
70  ship_date		DATE,
71  arrival_date		DATE,
72  delivery_lead_time	NUMBER,
73  scheduled_flag		VARCHAR2(1),
74  total_weight		NUMBER,
75  weight_uom_code	VARCHAR2(3),
76  total_volume		NUMBER,
77  volume_uom_code	VARCHAR2(3),
78  ship_method_code	VARCHAR2(30),
79  carrier_id		NUMBER,
80  service_level		VARCHAR2(30),
81  mode_of_transport	VARCHAR2(30),
82  freight_terms		VARCHAR2(30),
83  status			VARCHAR2(1),
84  message_data		VARCHAR2(2000),
85  enforce_lead_time	VARCHAR2(1),
86  currency               VARCHAR2(10),
87  currency_conversion_type VARCHAR2(30),
88  origin_country         VARCHAR2(30),        -- FTE J FTE estimate rate
89  origin_state           VARCHAR2(30),        -- FTE J FTE estimate rate
90  origin_city            VARCHAR2(30),        -- FTE J FTE estimate rate
91  origin_zip             VARCHAR2(30),        -- FTE J FTE estimate rate
92  destination_country    VARCHAR2(30),        -- FTE J FTE estimate rate
93  destination_state      VARCHAR2(30),        -- FTE J FTE estimate rate
94  destination_city       VARCHAR2(30),        -- FTE J FTE estimate rate
95  destination_zip        VARCHAR2(30),        -- FTE J FTE estimate rate
96  distance                NUMBER,        -- FTE J FTE estimate rate
97  distance_uom            VARCHAR2(30),        -- FTE J FTE estimate rate
98  vehicle_item_id         NUMBER,        -- FTE J FTE estimate rate
99  commodity_category_id   NUMBER,        -- FTE J FTE estimate rate
100  fob_code                VARCHAR2(30)   -- FTE R12
101  );
102 
103 TYPE fte_source_header_tab IS TABLE OF fte_source_header_rec
104 INDEX BY BINARY_INTEGER;
105 
106 TYPE fte_source_line_rates_rec IS RECORD
107 (source_line_id         NUMBER,
108  cost_type_id		NUMBER,
109  line_type_code		VARCHAR2(30),
110  cost_type              VARCHAR2(30),
111  cost_sub_type          VARCHAR2(30),
112  priced_quantity        NUMBER,
113  priced_uom             VARCHAR2(10),
114  unit_price             NUMBER,
115  base_price             NUMBER,
116  adjusted_unit_price    NUMBER,
117  adjusted_price         NUMBER,
118  currency               VARCHAR2(10),
119  consolidation_id	NUMBER,
120  lane_id		NUMBER,
121  carrier_id		NUMBER,
122  carrier_freight_code 	VARCHAR2(30),
123  service_level		VARCHAR2(30),
124  mode_of_transport	VARCHAR2(30),
125  ship_method_code	VARCHAR2(30),
126  vehicle_type_id 	NUMBER); --Release 12
127 
128 TYPE fte_source_line_rates_tab IS TABLE OF fte_source_line_rates_rec
129 INDEX BY BINARY_INTEGER;
130 
131 TYPE fte_source_header_rates_rec IS RECORD
132 (consolidation_id	NUMBER,
133  lane_id		NUMBER,
134  carrier_id		NUMBER,
135  carrier_freight_code 	VARCHAR2(30),
136  service_level		VARCHAR2(30),
137  mode_of_transport	VARCHAR2(30),
138  ship_method_code	VARCHAR2(30),
139  cost_type_id		NUMBER,
140  cost_type              VARCHAR2(30),
141  price             	NUMBER,
142  currency               VARCHAR2(10),
143  transit_time		NUMBER,
144  transit_time_uom	VARCHAR2(10),
145  first_line_index	NUMBER,
146  vehicle_type_id	NUMBER);--Release 12
147 
148 TYPE fte_source_header_rates_tab IS TABLE OF fte_source_header_rates_rec
149 INDEX BY BINARY_INTEGER;
150 
151 PROCEDURE Process_Lines(p_source_line_tab		IN OUT NOCOPY	FTE_PROCESS_REQUESTS.fte_source_line_tab,
152 			p_source_header_tab		IN OUT NOCOPY	FTE_PROCESS_REQUESTS.fte_source_header_tab,
153 			p_source_type			IN		VARCHAR2,
154 		        p_action			IN		VARCHAR2,
155 			x_source_line_rates_tab		OUT NOCOPY	FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,
156 			x_source_header_rates_tab	OUT NOCOPY	FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,
157 		       	x_return_status			OUT NOCOPY	VARCHAR2,
158 		       	x_msg_count			OUT NOCOPY	NUMBER,
159 			x_msg_data			OUT NOCOPY	VARCHAR2);
160 
161 
162 -- FOR BACKWARD (I) COMPATIBILITY ONLY
163 -- THE FOLLOWING SPEC IS NOT FUNCTIONAL IN THIS BRANCH
164 
165 TYPE fte_rating_parameters_rec IS RECORD
166 (param_name	VARCHAR2(30),
167  param_value	VARCHAR2(240),
168  uom_code	VARCHAR2(10));
169 
170 TYPE fte_rating_parameters_tab IS TABLE OF fte_rating_parameters_rec INDEX BY BINARY_INTEGER;
171 
172 FTE_MISS_RATING_PARAMETERS_TAB fte_rating_parameters_tab;
173 
174 PROCEDURE Process_Lines(p_source_line_tab		IN OUT NOCOPY	FTE_PROCESS_REQUESTS.fte_source_line_tab,
175 			p_source_header_tab		IN OUT NOCOPY	FTE_PROCESS_REQUESTS.fte_source_header_tab,
176 			p_source_type			IN		VARCHAR2,
177 		        p_action			IN		VARCHAR2,
178 			p_rating_parameters_tab		IN		FTE_PROCESS_REQUESTS.fte_rating_parameters_tab DEFAULT FTE_MISS_RATING_PARAMETERS_TAB,
179 			p_source_line_rates_tab		OUT NOCOPY	FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,
180 		       	x_return_status			OUT NOCOPY	VARCHAR2,
181 		       	x_msg_count			OUT NOCOPY	NUMBER,
182 			x_msg_data			OUT NOCOPY	VARCHAR2);
183 
184 
185 END FTE_PROCESS_REQUESTS;