[Home] [Help]
PACKAGE: APPS.OKE_FORM_DD250
Source
1 PACKAGE OKE_FORM_DD250 AUTHID CURRENT_USER AS
2 /* $Header: OKEMIRRS.pls 115.9 2003/11/20 20:21:20 alaw ship $ */
3
4 --
5 -- This record type is used to specify header level information of an
6 -- DD250
7 --
8 TYPE Hdr_Rec_Type IS RECORD
9 ( --
10 -- Either the ID or Number / Type / Intent must be provided for
11 -- contract header. If both are provided, the ID value will be used.
12 --
13 -- For delivery orders, use the notion <BOA Number>/<Order Number>
14 -- for Contract_Number
15 --
16 Contract_Number oke_k_headers.k_number_disp%TYPE := NULL
17 , Buy_Or_Sell okc_k_headers_b.buy_or_sell%TYPE := NULL
18 , K_Type_Code oke_k_headers.k_type_code%TYPE := NULL
19 , Contract_Header_ID okc_k_headers_b.id%TYPE := NULL
20 --
21 -- Shipment Number can be used for updating an existing DD250.
22 -- The API will return error is the Shipment Number is not given.
23 --
24 , Shipment_Number oke_k_form_headers.form_header_number%TYPE
25 , Shipment_Date DATE
26 , Bill_of_Lading VARCHAR2(2000)
27 , Transport_Ctrl_Num VARCHAR2(2000)
28 , Ship_Method VARCHAR2(80)
29 , Discount_Terms VARCHAR2(80)
30 , Acceptance_Method VARCHAR2(80)
31 , Acceptance_Point VARCHAR2(80)
32 , Inspection_Point VARCHAR2(80)
33 , Customer VARCHAR2(2000)
34 , Customer_Code VARCHAR2(80)
35 , Contractor VARCHAR2(2000)
36 , Contractor_Code VARCHAR2(80)
37 , Ship_From VARCHAR2(2000)
38 , Ship_From_Code VARCHAR2(80)
39 , FOB VARCHAR2(80)
40 , Ship_To VARCHAR2(2000)
41 , Ship_To_Code VARCHAR2(80)
42 , Paid_By VARCHAR2(2000)
43 , Paid_By_Code VARCHAR2(80)
44 , Mark_For VARCHAR2(2000)
45 , Mark_For_Code VARCHAR2(80)
46 , Gross_Weight NUMBER
47 , Net_Weight NUMBER
48 , Weight_UOM_Code VARCHAR2(3)
49 , Volume NUMBER
50 , Volume_UOM_Code VARCHAR2(3)
51 , Num_of_Containers NUMBER
52 , Remarks VARCHAR2(2000)
53 , Reference1 VARCHAR2(240)
54 , Reference2 VARCHAR2(240)
55 , Reference3 VARCHAR2(240)
56 , Reference4 VARCHAR2(240)
57 , Reference5 VARCHAR2(240)
58 );
59
60 --
61 -- This record type is used to specify line level information of an
62 -- DD250
63 --
64 TYPE Line_Rec_Type IS RECORD
65 ( Line_Number VARCHAR2(500)
66 , Item_Number VARCHAR2(240)
67 , Natl_Stock_Number VARCHAR2(30)
68 , Item_Description VARCHAR2(240)
69 , Line_Description VARCHAR2(2000)
70 , Line_Comments VARCHAR2(2000)
71 , UOM VARCHAR2(3)
72 , Shipped_Quantity NUMBER
73 , Unit_Price NUMBER
74 , Amount NUMBER
75 , Reference1 VARCHAR2(240)
76 , Reference2 VARCHAR2(240)
77 , Reference3 VARCHAR2(240)
78 , Reference4 VARCHAR2(240)
79 , Reference5 VARCHAR2(240)
80 );
81
82 TYPE Line_Tbl_Type IS TABLE OF Line_Rec_Type
83 INDEX BY BINARY_INTEGER;
84
85 --
86 -- Public Procedures
87 --
88
89 --
90 -- Name : Create_DD250
91 -- Pre-reqs : None
92 -- Function : This procedure creates a copy of DD250
93 --
94 --
95 -- Parameters :
96 -- IN : P_COMMIT VARCHAR2
97 -- P_HEADER_REC HDR_REC_TYPE
98 -- P_LINE_TBL LINE_TBL_TYPE
99 -- OUT : X_RETURN_STATUS VARCHAR2
100 -- X_MSG_COUNT NUMBER
101 -- X_MSG_DATA VARCHAR2
102 --
103 -- Returns : None
104 --
105
106 PROCEDURE Create_DD250
107 ( P_Commit IN VARCHAR2
108 , P_Hdr_Rec IN Hdr_Rec_Type
109 , P_Line_Tbl IN Line_Tbl_Type
110 , X_Msg_Count OUT NOCOPY NUMBER
111 , X_Msg_Data OUT NOCOPY VARCHAR2
112 , X_Return_Status OUT NOCOPY VARCHAR2
113 );
114
115
116 --
117 -- Name : Create_DD250_From_Delivery
118 -- Pre-reqs : None
119 -- Function : This procedure creates a copy of DD250 for a delivery
120 --
121 --
122 -- Parameters :
123 -- IN : P_DELIVERY_ID NUMBER
124 -- OUT : X_RETURN_STATUS VARCHAR2
125 -- X_MSG_COUNT NUMBER
126 -- X_MSG_DATA VARCHAR2
127 --
128 -- Returns : None
129 --
130
131 PROCEDURE Create_DD250_From_Delivery
132 ( P_Delivery_ID IN NUMBER
133 , X_Msg_Count OUT NOCOPY NUMBER
134 , X_Msg_Data OUT NOCOPY VARCHAR2
135 , X_Return_Status OUT NOCOPY VARCHAR2
136 );
137
138
139 --
140 -- Name : Create_DD250_Conc
141 -- Pre-reqs : run as concurrent request
142 -- Function : This procedure creates a copy of DD250 for a delivery
143 --
144 --
145 -- Parameters :
146 -- IN : P_DELIVERY_ID NUMBER
147 -- OUT : ERRBUF VARCHAR2
148 -- RETCODE NUMBER
149 --
150 -- Returns : None
151 --
152
153 PROCEDURE Create_DD250_Conc
154 ( ErrBuf OUT NOCOPY VARCHAR2
155 , RetCode OUT NOCOPY NUMBER
156 , P_Delivery_ID IN NUMBER
157 , P_Unused01 IN VARCHAR2 DEFAULT NULL
158 , P_Unused02 IN VARCHAR2 DEFAULT NULL
159 , P_Unused03 IN VARCHAR2 DEFAULT NULL
160 , P_Unused04 IN VARCHAR2 DEFAULT NULL
161 , P_Unused05 IN VARCHAR2 DEFAULT NULL
162 , P_Unused06 IN VARCHAR2 DEFAULT NULL
163 , P_Unused07 IN VARCHAR2 DEFAULT NULL
164 , P_Unused08 IN VARCHAR2 DEFAULT NULL
165 , P_Unused09 IN VARCHAR2 DEFAULT NULL
166 , P_Unused10 IN VARCHAR2 DEFAULT NULL
167 , P_Unused11 IN VARCHAR2 DEFAULT NULL
168 , P_Unused12 IN VARCHAR2 DEFAULT NULL
169 , P_Unused13 IN VARCHAR2 DEFAULT NULL
170 , P_Unused14 IN VARCHAR2 DEFAULT NULL
171 , P_Unused15 IN VARCHAR2 DEFAULT NULL
172 , P_Unused16 IN VARCHAR2 DEFAULT NULL
173 , P_Unused17 IN VARCHAR2 DEFAULT NULL
174 , P_Unused18 IN VARCHAR2 DEFAULT NULL
175 , P_Unused19 IN VARCHAR2 DEFAULT NULL
176 , P_Unused20 IN VARCHAR2 DEFAULT NULL
177 , P_Unused21 IN VARCHAR2 DEFAULT NULL
178 , P_Unused22 IN VARCHAR2 DEFAULT NULL
179 , P_Unused23 IN VARCHAR2 DEFAULT NULL
180 , P_Unused24 IN VARCHAR2 DEFAULT NULL
181 , P_Unused25 IN VARCHAR2 DEFAULT NULL
182 , P_Unused26 IN VARCHAR2 DEFAULT NULL
183 , P_Unused27 IN VARCHAR2 DEFAULT NULL
184 , P_Unused28 IN VARCHAR2 DEFAULT NULL
185 , P_Unused29 IN VARCHAR2 DEFAULT NULL
186 , P_Unused30 IN VARCHAR2 DEFAULT NULL
187 , P_Unused31 IN VARCHAR2 DEFAULT NULL
188 , P_Unused32 IN VARCHAR2 DEFAULT NULL
189 , P_Unused33 IN VARCHAR2 DEFAULT NULL
190 , P_Unused34 IN VARCHAR2 DEFAULT NULL
191 , P_Unused35 IN VARCHAR2 DEFAULT NULL
192 , P_Unused36 IN VARCHAR2 DEFAULT NULL
193 , P_Unused37 IN VARCHAR2 DEFAULT NULL
194 , P_Unused38 IN VARCHAR2 DEFAULT NULL
195 , P_Unused39 IN VARCHAR2 DEFAULT NULL
196 , P_Unused40 IN VARCHAR2 DEFAULT NULL
197 , P_Unused41 IN VARCHAR2 DEFAULT NULL
198 , P_Unused42 IN VARCHAR2 DEFAULT NULL
199 , P_Unused43 IN VARCHAR2 DEFAULT NULL
200 , P_Unused44 IN VARCHAR2 DEFAULT NULL
201 , P_Unused45 IN VARCHAR2 DEFAULT NULL
202 , P_Unused46 IN VARCHAR2 DEFAULT NULL
203 , P_Unused47 IN VARCHAR2 DEFAULT NULL
204 , P_Unused48 IN VARCHAR2 DEFAULT NULL
205 , P_Unused49 IN VARCHAR2 DEFAULT NULL
206 , P_Unused50 IN VARCHAR2 DEFAULT NULL
207 , P_Unused51 IN VARCHAR2 DEFAULT NULL
208 , P_Unused52 IN VARCHAR2 DEFAULT NULL
209 , P_Unused53 IN VARCHAR2 DEFAULT NULL
210 , P_Unused54 IN VARCHAR2 DEFAULT NULL
211 , P_Unused55 IN VARCHAR2 DEFAULT NULL
212 , P_Unused56 IN VARCHAR2 DEFAULT NULL
213 , P_Unused57 IN VARCHAR2 DEFAULT NULL
214 , P_Unused58 IN VARCHAR2 DEFAULT NULL
215 , P_Unused59 IN VARCHAR2 DEFAULT NULL
216 , P_Unused60 IN VARCHAR2 DEFAULT NULL
217 , P_Unused61 IN VARCHAR2 DEFAULT NULL
218 , P_Unused62 IN VARCHAR2 DEFAULT NULL
219 , P_Unused63 IN VARCHAR2 DEFAULT NULL
220 , P_Unused64 IN VARCHAR2 DEFAULT NULL
221 , P_Unused65 IN VARCHAR2 DEFAULT NULL
222 , P_Unused66 IN VARCHAR2 DEFAULT NULL
223 , P_Unused67 IN VARCHAR2 DEFAULT NULL
224 , P_Unused68 IN VARCHAR2 DEFAULT NULL
225 , P_Unused69 IN VARCHAR2 DEFAULT NULL
226 , P_Unused70 IN VARCHAR2 DEFAULT NULL
227 , P_Unused71 IN VARCHAR2 DEFAULT NULL
228 , P_Unused72 IN VARCHAR2 DEFAULT NULL
229 , P_Unused73 IN VARCHAR2 DEFAULT NULL
230 , P_Unused74 IN VARCHAR2 DEFAULT NULL
231 , P_Unused75 IN VARCHAR2 DEFAULT NULL
232 , P_Unused76 IN VARCHAR2 DEFAULT NULL
233 , P_Unused77 IN VARCHAR2 DEFAULT NULL
234 , P_Unused78 IN VARCHAR2 DEFAULT NULL
235 , P_Unused79 IN VARCHAR2 DEFAULT NULL
236 , P_Unused80 IN VARCHAR2 DEFAULT NULL
237 , P_Unused81 IN VARCHAR2 DEFAULT NULL
238 , P_Unused82 IN VARCHAR2 DEFAULT NULL
239 , P_Unused83 IN VARCHAR2 DEFAULT NULL
240 , P_Unused84 IN VARCHAR2 DEFAULT NULL
241 , P_Unused85 IN VARCHAR2 DEFAULT NULL
242 , P_Unused86 IN VARCHAR2 DEFAULT NULL
243 , P_Unused87 IN VARCHAR2 DEFAULT NULL
244 , P_Unused88 IN VARCHAR2 DEFAULT NULL
245 , P_Unused89 IN VARCHAR2 DEFAULT NULL
246 , P_Unused90 IN VARCHAR2 DEFAULT NULL
247 , P_Unused91 IN VARCHAR2 DEFAULT NULL
248 , P_Unused92 IN VARCHAR2 DEFAULT NULL
249 , P_Unused93 IN VARCHAR2 DEFAULT NULL
250 , P_Unused94 IN VARCHAR2 DEFAULT NULL
251 , P_Unused95 IN VARCHAR2 DEFAULT NULL
252 , P_Unused96 IN VARCHAR2 DEFAULT NULL
253 , P_Unused97 IN VARCHAR2 DEFAULT NULL
254 , P_Unused98 IN VARCHAR2 DEFAULT NULL
255 , P_Unused99 IN VARCHAR2 DEFAULT NULL
256 );
257
258
259 END OKE_FORM_DD250;