[Home] [Help]
PACKAGE: APPS.OE_FREIGHT_CHOICES_PVT
Source
1 PACKAGE OE_FREIGHT_CHOICES_PVT AUTHID CURRENT_USER AS
2 /* $Header: OEXVFCHS.pls 120.3.12010000.1 2008/07/25 07:59:51 appldev ship $ */
3
4 TYPE shipment_summary_rec_type IS RECORD
5 (consolidation_id NUMBER,
6 shipping_method VARCHAR2(80),
7 shipping_method_code VARCHAR2(30),
8 ship_from VARCHAR2(40),
9 ship_to VARCHAR2(40),
10 transit_time NUMBER,
11 charge_amount NUMBER,
12 cost NUMBER,
13 total_weight NUMBER,
14 weight_uom VARCHAR2(3),
15 total_Volume NUMBER,
16 volume_uom Varchar2(3),
17 Freight_Terms Varchar2(30),
18 scheduled_ship_date DATE);
19
20 TYPE shipment_summary_tbl_type IS TABLE OF shipment_summary_rec_type
21 INDEX BY BINARY_INTEGER;
22
23 TYPE freight_choices_rec_type IS RECORD
24 (consolidation_id NUMBER,
25 shipping_method VARCHAR2(80),
26 shipping_method_code VARCHAR2(30),
27 transit_time NUMBER,
28 transit_time_uom VARCHAR2(10),
29 charge_amount NUMBER,
30 cost NUMBER,
31 lane_id NUMBER); --bug 4408958
32
33 TYPE freight_choices_tbl_type IS TABLE OF freight_choices_rec_type
34 INDEX BY BINARY_INTEGER;
35
36 TYPE Ship_date_rec_type IS Record
37 (schedule_ship_date DATE,
38 line_id NUMBER);
39
40 TYPE Ship_Date_Tbl IS Table of Ship_date_rec_type
41 INDEX BY BINARY_INTEGER;
42
43 TYPE line_shipment_details_rec_type IS RECORD
44 (source_line_id NUMBER,
45 inventory_item_id NUMBER,
46 source_quantity NUMBER,
47 source_quantity_uom VARCHAR2(3),
48 ship_date DATE,
49 arrival_date DATE);
50
51 TYPE line_shipment_details_tbl_type IS TABLE OF line_shipment_details_rec_type
52 INDEX BY BINARY_INTEGER;
53
54 g_fte_source_line_tab FTE_PROCESS_REQUESTS.Fte_Source_Line_Tab;
55 G_shipment_summary_tbl shipment_summary_tbl_type;
56 G_shipment_summary_count NUMBER;
57 G_shipment_summary_index NUMBER;
58 G_Ship_Date_tbl Ship_Date_Tbl;
59
60 G_FTE_SOURCE_LINE_RATE_TAB FTE_PROCESS_REQUESTS.fte_source_line_rates_Tab;
61 G_FTE_LINE_RATE_TAB FTE_PROCESS_REQUESTS.fte_source_line_rates_Tab;
62 G_FTE_header_RATE_TAB FTE_PROCESS_REQUESTS.fte_source_header_rates_Tab;
63 G_freight_choices_tbl freight_choices_tbl_type;
64 G_freight_choices_count NUMBER;
65 G_freight_choices_index NUMBER;
66 G_line_tbl OE_Order_PUB.Line_Tbl_Type;
67
68 G_FTE_SOURCE_HEADER_TAB FTE_PROCESS_REQUESTS.Fte_Source_Header_Tab;
69 g_line_shipment_details_tbl FTE_PROCESS_REQUESTS.fte_source_line_Tab ;
70
71 PROCEDURE Get_Shipment_Summary
72 (p_header_id IN NUMBER,
73 x_shipment_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
74 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
75 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
76 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
77
78 PROCEDURE Get_Shipment_Summary_Tbl(
79 x_shipment_summary_tbl IN OUT NOCOPY /* file.sql.39 change */ shipment_summary_tbl_type);
80
81 PROCEDURE Get_Freight_Choices
82 ( p_consolidation_id IN NUMBER,
83 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
84 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
85 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
86 ;
87
88 PROCEDURE Get_Freight_Choices_Tbl
89 (x_freight_choices_tbl IN OUT NOCOPY /* file.sql.39 change */ freight_choices_tbl_type);
90
91 PROCEDURE Get_Shipment_Details_Tbl
92 (x_Line_Shipment_Details_tbl IN OUT NOCOPY /* file.sql.39 change */ line_Shipment_Details_tbl_type);
93
94 PROCEDURE Process_Freight_Choices
95 ( p_header_id IN NUMBER
96 ,p_consolidation_id IN NUMBER
97 ,p_ship_method_code IN VARCHAR2
98 ,p_lane_id IN NUMBER --bug 4408958
99 ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
100 ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
101 ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
102
103 -- FUNCTION get_method RETURN VARCHAR2;
104
105 PROCEDURE Cancel_all;
106
107 -- Bug 6186084
108 PROCEDURE Repopulate_Freight_Choices
109 ( x_volume OUT NOCOPY NUMBER
110 ,x_weight OUT NOCOPY NUMBER
111 ,x_consolidation_id IN NUMBER);
112
113 END OE_FREIGHT_CHOICES_PVT;