[Home] [Help]
PACKAGE: APPS.INL_SHIPMENT_PVT
Source
1 PACKAGE "INL_SHIPMENT_PVT" AS
2 /* $Header: INLVSHPS.pls 120.13.12010000.18 2009/01/09 12:17:50 aicosta ship $ */
3
4 G_MODULE_NAME CONSTANT VARCHAR2(200) := 'INL.PLSQL.INL_SHIPMENT_PVT.';
5 G_PKG_NAME CONSTANT VARCHAR2(30) := 'INL_SHIPMENT_PVT';
6
7 TYPE inl_Assoc_tp IS RECORD (
8 ship_header_id NUMBER ,
9 allocation_basis VARCHAR2(30) ,
10 allocation_uom_code VARCHAR2(3) ,
11 to_parent_table_name VARCHAR2(30) ,
12 to_parent_table_id NUMBER
13 );
14
15 TYPE inl_ChLn_Assoc_tp IS RECORD (
16 charge_line_num NUMBER ,
17 charge_line_type_id NUMBER ,
18 landed_cost_flag VARCHAR2(1) ,
19 parent_charge_line_id NUMBER ,
20 adjustment_num NUMBER ,
21 match_id NUMBER ,
22 match_amount_id NUMBER ,
23 charge_amt NUMBER ,
24 currency_code VARCHAR2(15) ,
25 currency_conversion_type VARCHAR2(30) ,
26 currency_conversion_date DATE ,
27 currency_conversion_rate NUMBER ,
28 party_id NUMBER ,
29 party_site_id NUMBER ,
30 trx_business_category VARCHAR2(240),
31 intended_use VARCHAR2(30) ,
32 product_fiscal_class VARCHAR2(240),
33 product_category VARCHAR2(240),
34 product_type VARCHAR2(240),
35 user_def_fiscal_class VARCHAR2(240),
36 tax_classification_code VARCHAR2(30) ,
37 assessable_value NUMBER ,
38 tax_already_calculated_flag VARCHAR2(1) ,
39 ship_from_party_id NUMBER ,
40 ship_from_party_site_id NUMBER ,
41 ship_to_organization_id NUMBER ,
42 ship_to_location_id NUMBER ,
43 bill_from_party_id NUMBER ,
44 bill_from_party_site_id NUMBER ,
45 bill_to_organization_id NUMBER ,
46 bill_to_location_id NUMBER ,
47 poa_party_id NUMBER ,
48 poa_party_site_id NUMBER ,
49 poo_organization_id NUMBER ,
50 poo_location_id NUMBER ,
51 inl_Assoc inl_Assoc_tp
52 );
53 TYPE inl_TxLn_Assoc_tp IS RECORD (
54 tax_line_num NUMBER ,
55 tax_code VARCHAR2(30) ,
56 parent_tax_line_id NUMBER ,
57 adjustment_num NUMBER ,
58 match_id NUMBER ,
59 match_amount_id NUMBER ,
60 source_parent_table_name VARCHAR2(30) ,
61 source_parent_table_id NUMBER ,
62 matched_amt NUMBER ,
63 nrec_tax_amt NUMBER ,
64 currency_code VARCHAR2(15) ,
65 currency_conversion_type VARCHAR2(30) ,
66 currency_conversion_date DATE ,
67 currency_conversion_rate NUMBER ,
68 tax_amt_included_flag VARCHAR2(1) ,
69 inl_Assoc inl_Assoc_tp
70 );
71
72 PROCEDURE Set_ToRevalidate(
73 p_api_version IN NUMBER,
74 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
75 p_commit IN VARCHAR2 := FND_API.G_FALSE,
76 p_ship_header_id IN NUMBER,
77 x_msg_count OUT NOCOPY NUMBER,
78 x_msg_data OUT NOCOPY VARCHAR2,
79 x_return_status OUT NOCOPY VARCHAR2
80 );
81
82 PROCEDURE Validate_Shipment(
83 p_api_version IN NUMBER,
84 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
85 p_commit IN VARCHAR2 := FND_API.G_FALSE,
86 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
87 p_ship_header_id IN NUMBER,
88 x_return_status OUT NOCOPY VARCHAR2,
89 x_msg_count OUT NOCOPY NUMBER,
90 x_msg_data OUT NOCOPY VARCHAR2
91 );
92
93 FUNCTION Validate_InvOpenPeriod(
94 x_trx_date IN VARCHAR2,
95 x_sob_id IN NUMBER,
96 x_org_id IN NUMBER,
97 x_return_status IN OUT NOCOPY VARCHAR2
98 ) RETURN VARCHAR2;
99
100 PROCEDURE Adjust_ShipLines(
101 p_api_version IN NUMBER,
102 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
103 p_commit IN VARCHAR2 := FND_API.G_FALSE,
104 p_match_id IN NUMBER,
105 p_adjustment_num IN NUMBER,
106 x_return_status OUT NOCOPY VARCHAR2,
107 x_msg_count OUT NOCOPY NUMBER,
108 x_msg_data OUT NOCOPY VARCHAR2
109 );
110
111 PROCEDURE Adjust_ChargeLines (
112 p_api_version IN NUMBER,
113 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
114 p_commit IN VARCHAR2 := FND_API.G_FALSE,
115 p_match_id IN NUMBER,
116 p_adjustment_num IN NUMBER,
117 x_return_status OUT NOCOPY VARCHAR2,
118 x_msg_count OUT NOCOPY NUMBER,
119 x_msg_data OUT NOCOPY VARCHAR2
120 );
121
122 PROCEDURE Adjust_ChargeLines (
123 p_api_version IN NUMBER,
124 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
125 p_commit IN VARCHAR2 := FND_API.G_FALSE,
126 p_match_amount_id IN NUMBER,
127 p_adjustment_num IN NUMBER,
128 x_return_status OUT NOCOPY VARCHAR2,
129 x_msg_count OUT NOCOPY NUMBER,
130 x_msg_data OUT NOCOPY VARCHAR2);
131
132 PROCEDURE Adjust_TaxLines (
133 p_api_version IN NUMBER,
134 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
135 p_commit IN VARCHAR2 := FND_API.G_FALSE,
136 p_match_id IN NUMBER,
137 p_adjustment_num IN NUMBER,
138 x_return_status OUT NOCOPY VARCHAR2,
139 x_msg_count OUT NOCOPY NUMBER,
140 x_msg_data OUT NOCOPY VARCHAR2
141 );
142
143 PROCEDURE Adjust_Lines (
144 p_api_version IN NUMBER,
145 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
146 p_commit IN VARCHAR2 := FND_API.G_FALSE,
147 p_ship_header_id IN NUMBER,
148 x_return_status OUT NOCOPY VARCHAR2,
149 x_msg_count OUT NOCOPY NUMBER,
150 x_msg_data OUT NOCOPY VARCHAR2
151 );
152
153 PROCEDURE Get_1ary2aryQty (
154 p_api_version IN NUMBER,
155 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
156 p_commit IN VARCHAR2 := FND_API.G_FALSE,
157 p_inventory_item_id IN NUMBER,
158 p_organization_id IN NUMBER,
159 p_uom_code IN VARCHAR2,
160 p_qty IN NUMBER,
161 x_1ary_uom_code OUT NOCOPY VARCHAR2,
162 x_1ary_qty OUT NOCOPY NUMBER,
163 x_2ary_uom_code OUT NOCOPY VARCHAR2,
164 x_2ary_qty OUT NOCOPY NUMBER,
165 x_return_status OUT NOCOPY VARCHAR2,
166 x_msg_count OUT NOCOPY NUMBER,
167 x_msg_data OUT NOCOPY VARCHAR2
168 );
169
170 FUNCTION Get_SrcAvailableQty(
171 p_ship_line_src_type_code IN VARCHAR2,
172 p_parent_id IN NUMBER
173 ) RETURN NUMBER;
174
175 PROCEDURE ProcessAction(
176 p_api_version IN NUMBER,
177 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
178 p_commit IN VARCHAR2 := FND_API.G_FALSE,
179 p_ship_header_id IN NUMBER,
180 p_task_code IN VARCHAR2,
181 x_return_status OUT NOCOPY VARCHAR2,
182 x_msg_count OUT NOCOPY NUMBER,
183 x_msg_data OUT NOCOPY VARCHAR2
184 );
185
186 PROCEDURE Complete_PendingShipment (
187 errbuf OUT NOCOPY VARCHAR2,
188 retcode OUT NOCOPY VARCHAR2,
189 p_organization_id IN NUMBER,
190 p_ship_header_id IN NUMBER
191 );
192
193 PROCEDURE Update_PendingMatchingFlag (
194 p_ship_header_id IN NUMBER,
195 p_pending_matching_flag IN VARCHAR,
196 x_return_status OUT NOCOPY VARCHAR2
197 );
198
199 PROCEDURE Delete_ChargeAssoc(
200 p_api_version IN NUMBER,
201 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
202 p_commit IN VARCHAR2 := FND_API.G_FALSE,
203 p_ship_header_id IN NUMBER,
204 p_charge_line_id IN NUMBER,
205 x_return_status OUT NOCOPY VARCHAR2,
206 x_msg_count OUT NOCOPY NUMBER,
207 x_msg_data OUT NOCOPY VARCHAR2
208 );
209
210 PROCEDURE Check_PoTolerances(
211 p_api_version IN NUMBER,
212 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
213 p_commit IN VARCHAR2 := FND_API.G_FALSE,
214 p_ship_header_id IN NUMBER,
215 p_ship_line_id IN NUMBER,
216 p_organization_id IN NUMBER,
217 p_ship_line_num IN NUMBER,
218 p_ship_line_src_id IN NUMBER,
219 p_inventory_item_id IN NUMBER,
220 p_primary_qty IN NUMBER,
221 p_primary_uom_code IN VARCHAR2,
222 p_pri_unit_price IN NUMBER,
223 p_currency_code IN VARCHAR2,
224 p_currency_conversion_type IN VARCHAR2,
225 p_currency_conversion_date IN DATE,
226 p_currency_conversion_rate IN NUMBER,
227 x_return_status OUT NOCOPY VARCHAR2,
228 x_msg_count OUT NOCOPY NUMBER,
229 x_msg_data OUT NOCOPY VARCHAR2
230 );
231
232 PROCEDURE Complete_Shipment (
233 p_api_version IN NUMBER,
234 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
235 p_commit IN VARCHAR2 := FND_API.G_FALSE,
236 p_ship_header_id IN NUMBER,
237 p_pending_matching_flag IN VARCHAR2,
238 p_organization_id IN NUMBER,
239 x_return_status OUT NOCOPY VARCHAR2,
240 x_msg_count OUT NOCOPY NUMBER,
241 x_msg_data OUT NOCOPY VARCHAR2
242 );
243
244 END INL_SHIPMENT_PVT;