1 PACKAGE OE_Shipping_Integration_PUB AS
2 /* $Header: OEXPSHPS.pls 120.0 2005/06/01 01:07:38 appldev noship $ */
3
4 TYPE Cal_Tolerance_Rec_Type IS RECORD
5 ( line_id NUMBER := FND_API.G_MISS_NUM
6 , shipping_uom VARCHAR2(3) := FND_API.G_MISS_CHAR
7 , quantity_to_be_shipped NUMBER := FND_API.G_MISS_NUM
8 , planned_quantity NUMBER := FND_API.G_MISS_NUM
9 );
10
11 TYPE Cal_Tolerance_Tbl_Type IS TABLE OF Cal_Tolerance_Rec_Type
12 INDEX BY BINARY_INTEGER;
13
14
15 -- Setsmc_Input_Rec_Type was included for bug 3623149
16 TYPE Setsmc_Input_Rec_Type IS RECORD
17 ( header_id NUMBER,
18 top_model_line_id NUMBER,
19 ship_set_id NUMBER
20 );
21
22 TYPE Setsmc_Output_Rec_Type IS RECORD
23 ( x_interface_status VARCHAR2(1));
24
25
26 PROCEDURE Get_SetSMC_Interface_Status
27 (p_setsmc_input_rec IN Setsmc_Input_Rec_Type
28 ,p_setsmc_output_rec OUT NOCOPY /* file.sql.39 change */ Setsmc_Output_Rec_Type
29 ,x_return_status OUT NOCOPY VARCHAR2);
30
31
32 -- Start of Comments
33 -- API name : Is_Activity_Shipping
34 -- Type : Public
35 -- Pre-reqs : None.
36 -- Function : Checks if the current activity for a line is SHIP_LINE in
37 -- work flow. Returns FND_API.G_TRUE if line is at SHIP_LINE
38 -- work flow activity else return FND_API.G_FALSE.
39 -- Parameters : p_api_version_number IN NUMBER Required
40 -- p_line_id IN NUMBER Required
41 -- The line_id of the line for which the check is required.
42 -- Version : Current version = 1.0
43 -- Initial version = 1.0
44 -- End of Comments
45 --
46
47 FUNCTION Is_Activity_Shipping
48 (
49 p_api_version_number IN NUMBER
50 , p_line_id IN NUMBER
51 ) return VARCHAR2;
52
53 -- Start of Comments
54 -- API name : Complete_Ship_Line_Activity
55 -- Type : Public
56 -- Pre-reqs : The line for which the SHIP_LINE work flow activity is to
57 -- be completed should be at SHIP_LINE work flow activity.
58 -- Function : Checks if the current activity for a line is SHIP_LINE in
59 -- work flow. Returns FND_API.G_TRUE if line is at SHIP_LINE
60 -- work flow activity else return FND_API.G_FALSE.
61 -- Parameters : p_api_version_number IN NUMBER Required
62 -- p_line_id IN NUMBER Required
63 -- The line_id of the line for which the SHIP_LINE work
64 -- flow activity will be completed.
65 -- p_result_code IN VARCHAR2 Required
66 -- The result code with which the SHIP_LINE work flow
67 -- activity will be completed. It could be 'SHIP_CONFIRM'
68 -- or 'NON_SHIPPABLE'.
69 -- Version : Current version = 1.0
70 -- Initial version = 1.0
71 -- End of Comments
72 --
73 PROCEDURE Complete_Ship_Line_Activity
74 ( p_api_version_number IN NUMBER
75 , p_line_id IN NUMBER
76 , p_result_code IN VARCHAR2
77 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
78 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
79 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
80 );
81
82 -- Start of Comments
83 -- API name : Credit_Check
84 -- Type : Public
85 -- Pre-reqs : None.
86 -- Function : This function performs the credit check for the passed
87 -- header and line id and returns the result of credit check.
88 -- Parameters : p_api_version_number IN NUMBER Required
89 -- p_header_id IN NUMBER Required
90 -- The header_id of the order for which the check is
91 -- required.
92 -- p_line_id IN NUMBER
93 -- The line_id of the line for which the check is required.
94 -- Version : Current version = 1.0
95 -- Initial version = 1.0
96 -- End of Comments
97 --
98 FUNCTION Credit_Check
99 (
100 p_api_version_number IN NUMBER
101 , p_header_id IN NUMBER
102 , p_line_id IN NUMBER DEFAULT NULL
103 ) return VARCHAR2;
104
105 FUNCTION Check_Holds_For_SC
106 (
107 p_api_version_number IN NUMBER
108 , p_header_id IN NUMBER DEFAULT NULL
109 , p_line_id IN NUMBER
110 ) return VARCHAR2;
111
112 -- Start of Comments
113 -- API name : Get_Tolerance
114 -- Type : Public
115 -- Pre-reqs : None.
116 -- Function : This procedure will be called by shipping to find out NOCOPY /* file.sql.39 change */ if
117 -- the value of tolerance needs to be updated if a partial
118 -- shipment is being done and there are some planned shipments
119 -- or if the shipment is beyond over shipment tolerance.
120 -- tolerances for the passed line_id.
121 -- Parameters : p_api_version_number IN NUMBER Required
122 -- p_cal_tolerance_tbl IN Table of records Required
123 -- It is a table of records with each records having the
124 -- line_id, quantity being shipepd and planned quantity.
125 -- Version : Current version = 1.0
126 -- Initial version = 1.0
127 -- End of Comments
128 --
129 PROCEDURE Get_Tolerance
130 (
131 p_api_version_number IN NUMBER
132 , p_cal_tolerance_tbl IN Cal_Tolerance_Tbl_Type
133 , x_update_tolerance_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
134 , x_ship_tolerance OUT NOCOPY /* file.sql.39 change */ NUMBER
135 , x_ship_beyond_tolerance OUT NOCOPY /* file.sql.39 change */ VARCHAR2
136 , x_shipped_within_tolerance OUT NOCOPY /* file.sql.39 change */ VARCHAR2
137 , x_config_broken OUT NOCOPY /* file.sql.39 change */ VARCHAR2
138 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
139 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
140 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
141 );
142
143 -- Start of Comments
144 -- API name : Get_Quantity
145 -- Type : Public
146 -- Pre-reqs : None.
147 -- Function : This procedure gets the ordered and shipped quantities for
148 -- the passed line_id. It will cumulate the ordered and shipped
149 -- quantities across the split lines for the passed line_id.
150 -- Parameters : p_api_version_number IN NUMBER Required
151 -- p_line_id IN NUMBER Required
152 -- The line_id of the line for which the ordered and
153 -- shipped quantities are required.
154 -- p_line_set_id IN NUMBER Required
155 -- The line_set_id of the line for which the ordered and
156 -- shipped quantities are required.
157 -- Version : Current version = 1.0
158 -- Initial version = 1.0
159 -- End of Comments
160 --
161 PROCEDURE Get_Quantity
162 (
163 p_api_version_number IN NUMBER
164 , p_line_id IN NUMBER
165 , p_line_set_id IN NUMBER
166 , x_ordered_quantity OUT NOCOPY /* file.sql.39 change */ NUMBER
167 , x_shipped_quantity OUT NOCOPY /* file.sql.39 change */ NUMBER
168 , x_shipping_quantity OUT NOCOPY /* file.sql.39 change */ NUMBER
169 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
170 , x_msg_count OUT NOCOPY /* file.sql.39 change */ VARCHAR2
171 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
172 );
173
174 -- Start of Comments
175 -- API name : Update_Shipping_Interface
176 -- Type : Public
177 -- Pre-reqs : None.
178 -- Function : This procedure will be called by shipping to update the
179 -- shipping_interface_flag on a line.
180 -- Parameters : p_api_version_number IN NUMBER Required
181 -- p_line_id IN NUMBER Required
182 -- line id of the line which needs to be updated.
183 -- p_shipping_interfaced_flag IN VARCHAR2 Required
184 -- Value of the shipping interface flag.
185 -- Version : Current version = 1.0
186 -- Initial version = 1.0
187 -- End of Comments
188 --
189 PROCEDURE Update_Shipping_Interface
190 (
191 p_api_version_number IN NUMBER
192 , p_line_id IN NUMBER
193 , p_shipping_interfaced_flag IN VARCHAR2
194 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
195 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
196 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
197 );
198
199 -- Start of Comments
200 -- API name : Get_Max_Quantity_Remaining
201 -- Type : Public
202 -- Pre-reqs : None.
203 -- Function : This procedure will be called by to get the min and max quantity
204 -- remaining to be shipped for a line.
205 -- Parameters : p_api_version_number IN NUMBER Required
206 -- p_line_id IN NUMBER Required
207 -- line id of the line for which the remaining quantity
208 -- is requested.
209 -- Version : Current version = 1.0
210 -- Initial version = 1.0
211 -- End of Comments
212 --
213 -- HW Added Qty2 for OPM
214 PROCEDURE Get_Min_Max_Tolerance_Quantity
215 (
216 p_api_version_number IN NUMBER
217 , p_line_id IN NUMBER
218 , x_min_remaining_quantity OUT NOCOPY /* file.sql.39 change */ NUMBER
219 , x_max_remaining_quantity OUT NOCOPY /* file.sql.39 change */ NUMBER
220 , x_min_remaining_quantity2 OUT NOCOPY /* file.sql.39 change */ NUMBER
221 , x_max_remaining_quantity2 OUT NOCOPY /* file.sql.39 change */ NUMBER
222 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
223 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
224 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
225 );
226
227 FUNCTION Check_Import_Pending_Lines
228 ( p_header_id IN NUMBER
229 ,p_ship_set_id IN NUMBER
230 ,p_top_model_line_id IN NUMBER
231 ,p_transactable_flag IN VARCHAR2
232 ,x_return_status OUT NOCOPY VARCHAR2)
233 RETURN BOOLEAN;
234
235 PROCEDURE ATO_Config_Line_Ship_Notified( p_application_id IN NUMBER,
236 p_entity_short_name in VARCHAR2,
237 p_validation_entity_short_name in VARCHAR2,
238 p_validation_tmplt_short_name in VARCHAR2,
239 p_record_set_tmplt_short_name in VARCHAR2,
240 p_scope in VARCHAR2,
241 p_result OUT NOCOPY NUMBER );
242
243 END OE_Shipping_Integration_PUB;