[Home] [Help]
PACKAGE: APPS.GMD_FORMULA_COMMON_PUB
Source
1 PACKAGE GMD_FORMULA_COMMON_PUB AUTHID CURRENT_USER AS
2 /* $Header: GMDPFMCS.pls 120.3.12020000.2 2012/09/29 09:27:50 yanpewan ship $ */
3
4 /* Record type define the action to be taken */
5 /* by default Insert are 'I' and Updates are 'U' */
6 /* If the user wants to define a DELETE Pl/sql table */
7 /* the user must pass a 'D' for the record type */
8
9 TYPE formula_update_rec_type IS RECORD
10 (
11 RECORD_TYPE VARCHAR2(1) := 'U'
12 ,FORMULA_NO VARCHAR2(32)
13 ,FORMULA_VERS NUMBER
14 ,FORMULA_TYPE NUMBER
15 ,FORMULA_DESC1 LM_FORM_MST.FORMULA_DESC1%TYPE -- Bug# 14480509
16 ,FORMULA_DESC2 LM_FORM_MST.FORMULA_DESC2%TYPE -- Bug# 14480509
17 ,FORMULA_CLASS VARCHAR2(32)
18 ,FMCONTROL_CLASS VARCHAR2(32)
19 ,INACTIVE_IND NUMBER
20 ,OWNER_ORGANIZATION_ID NUMBER
21 ,TOTAL_INPUT_QTY NUMBER
22 ,TOTAL_OUTPUT_QTY NUMBER
23 ,YIELD_UOM VARCHAR2(3)
24 ,FORMULA_STATUS VARCHAR2(30)
25 ,OWNER_ID NUMBER(15)
26 ,FORMULA_ID NUMBER
27 ,FORMULALINE_ID NUMBER
28 ,LINE_TYPE NUMBER
29 ,LINE_NO NUMBER
30 ,ITEM_NO VARCHAR2(2000)
31 ,INVENTORY_ITEM_ID NUMBER
32 ,REVISION VARCHAR2(3)
33 ,QTY NUMBER
34 ,DETAIL_UOM VARCHAR2(3)
35 ,RELEASE_TYPE NUMBER
36 ,SCRAP_FACTOR NUMBER
37 ,SCALE_TYPE_HDR NUMBER
38 ,SCALE_TYPE_DTL NUMBER
39 ,COST_ALLOC NUMBER
40 ,PHANTOM_TYPE NUMBER
41 ,REWORK_TYPE NUMBER
42 ,BUFFER_IND NUMBER
43 /*Bug 2509076 - Thomas Daniel New field for Quality integration */
44 ,BY_PRODUCT_TYPE VARCHAR2(1)
45 ,INGREDIENT_END_DATE DATE --Bug 4479101
46 ,ATTRIBUTE1 VARCHAR2(240)
47 ,ATTRIBUTE2 VARCHAR2(240)
48 ,ATTRIBUTE3 VARCHAR2(240)
49 ,ATTRIBUTE4 VARCHAR2(240)
50 ,ATTRIBUTE5 VARCHAR2(240)
51 ,ATTRIBUTE6 VARCHAR2(240)
52 ,ATTRIBUTE7 VARCHAR2(240)
53 ,ATTRIBUTE8 VARCHAR2(240)
54 ,ATTRIBUTE9 VARCHAR2(240)
55 ,ATTRIBUTE10 VARCHAR2(240)
56 ,ATTRIBUTE11 VARCHAR2(240)
57 ,ATTRIBUTE12 VARCHAR2(240)
58 ,ATTRIBUTE13 VARCHAR2(240)
59 ,ATTRIBUTE14 VARCHAR2(240)
60 ,ATTRIBUTE15 VARCHAR2(240)
61 ,ATTRIBUTE16 VARCHAR2(240)
62 ,ATTRIBUTE17 VARCHAR2(240)
63 ,ATTRIBUTE18 VARCHAR2(240)
64 ,ATTRIBUTE19 VARCHAR2(240)
65 ,ATTRIBUTE20 VARCHAR2(240)
66 ,ATTRIBUTE21 VARCHAR2(240)
67 ,ATTRIBUTE22 VARCHAR2(240)
68 ,ATTRIBUTE23 VARCHAR2(240)
69 ,ATTRIBUTE24 VARCHAR2(240)
70 ,ATTRIBUTE25 VARCHAR2(240)
71 ,ATTRIBUTE26 VARCHAR2(240)
72 ,ATTRIBUTE27 VARCHAR2(240)
73 ,ATTRIBUTE28 VARCHAR2(240)
74 ,ATTRIBUTE29 VARCHAR2(240)
75 ,ATTRIBUTE30 VARCHAR2(240)
76 ,DTL_ATTRIBUTE1 VARCHAR2(240)
77 ,DTL_ATTRIBUTE2 VARCHAR2(240)
78 ,DTL_ATTRIBUTE3 VARCHAR2(240)
79 ,DTL_ATTRIBUTE4 VARCHAR2(240)
80 ,DTL_ATTRIBUTE5 VARCHAR2(240)
81 ,DTL_ATTRIBUTE6 VARCHAR2(240)
82 ,DTL_ATTRIBUTE7 VARCHAR2(240)
83 ,DTL_ATTRIBUTE8 VARCHAR2(240)
84 ,DTL_ATTRIBUTE9 VARCHAR2(240)
85 ,DTL_ATTRIBUTE10 VARCHAR2(240)
86 ,DTL_ATTRIBUTE11 VARCHAR2(240)
87 ,DTL_ATTRIBUTE12 VARCHAR2(240)
88 ,DTL_ATTRIBUTE13 VARCHAR2(240)
89 ,DTL_ATTRIBUTE14 VARCHAR2(240)
90 ,DTL_ATTRIBUTE15 VARCHAR2(240)
91 ,DTL_ATTRIBUTE16 VARCHAR2(240)
92 ,DTL_ATTRIBUTE17 VARCHAR2(240)
93 ,DTL_ATTRIBUTE18 VARCHAR2(240)
94 ,DTL_ATTRIBUTE19 VARCHAR2(240)
95 ,DTL_ATTRIBUTE20 VARCHAR2(240)
96 ,DTL_ATTRIBUTE21 VARCHAR2(240)
97 ,DTL_ATTRIBUTE22 VARCHAR2(240)
98 ,DTL_ATTRIBUTE23 VARCHAR2(240)
99 ,DTL_ATTRIBUTE24 VARCHAR2(240)
100 ,DTL_ATTRIBUTE25 VARCHAR2(240)
101 ,DTL_ATTRIBUTE26 VARCHAR2(240)
102 ,DTL_ATTRIBUTE27 VARCHAR2(240)
103 ,DTL_ATTRIBUTE28 VARCHAR2(240)
104 ,DTL_ATTRIBUTE29 VARCHAR2(240)
105 ,DTL_ATTRIBUTE30 VARCHAR2(240)
106 ,DTL_ATTRIBUTE_CATEGORY VARCHAR2(30)
107 ,ATTRIBUTE_CATEGORY VARCHAR2(30)
108 ,TPFORMULA_ID NUMBER
109 ,IAFORMULA_ID NUMBER
110 ,SCALE_MULTIPLE NUMBER
111 ,CONTRIBUTE_YIELD_IND VARCHAR2(1)
112 ,SCALE_UOM VARCHAR2(4)
113 ,CONTRIBUTE_STEP_QTY_IND VARCHAR2(1)
114 ,SCALE_ROUNDING_VARIANCE NUMBER
115 ,ROUNDING_DIRECTION NUMBER
116 ,TEXT_CODE_HDR NUMBER
117 ,TEXT_CODE_DTL NUMBER
118 ,CREATION_DATE DATE
119 ,CREATED_BY NUMBER(15)
120 ,LAST_UPDATED_BY NUMBER(15)
121 ,LAST_UPDATE_DATE DATE
122 ,LAST_UPDATE_LOGIN NUMBER(15)
123 ,DELETE_MARK NUMBER
124 ,USER_ID NUMBER
125 ,USER_NAME VARCHAR2(100)
126 ,AUTO_PRODUCT_CALC VARCHAR2(1) -- Bug# 5716318
127 ,PROD_PERCENT NUMBER
128 );
129
130 TYPE formula_insert_rec_type IS RECORD
131 (
132 RECORD_TYPE VARCHAR2(1) := 'I'
133 ,FORMULA_NO VARCHAR2(32)
134 ,FORMULA_VERS NUMBER
135 ,FORMULA_TYPE NUMBER := 0
136 ,FORMULA_DESC1 LM_FORM_MST.FORMULA_DESC1%TYPE -- Bug# 14480509
137 ,FORMULA_DESC2 LM_FORM_MST.FORMULA_DESC2%TYPE -- Bug# 14480509
138 ,FORMULA_CLASS VARCHAR2(32)
139 ,FMCONTROL_CLASS VARCHAR2(32)
140 ,INACTIVE_IND NUMBER := 0
141 ,OWNER_ORGANIZATION_ID NUMBER
142 ,TOTAL_INPUT_QTY NUMBER := 0
143 ,TOTAL_OUTPUT_QTY NUMBER := 0
144 ,YIELD_UOM VARCHAR2(3)
145 ,FORMULA_STATUS VARCHAR2(30) := '100'
146 ,OWNER_ID NUMBER(15)
147 ,FORMULA_ID NUMBER
148 ,FORMULALINE_ID NUMBER
149 ,LINE_TYPE NUMBER := 1
150 ,LINE_NO NUMBER
151 ,ITEM_NO VARCHAR2(2000)
152 ,INVENTORY_ITEM_ID NUMBER
153 ,REVISION VARCHAR2(3)
154 ,QTY NUMBER
155 ,DETAIL_UOM VARCHAR2(3)
156 ,MASTER_FORMULA_ID NUMBER
157 ,RELEASE_TYPE NUMBER := 0
158 ,SCRAP_FACTOR NUMBER := 0
159 ,SCALE_TYPE_HDR NUMBER := 1
160 ,SCALE_TYPE_DTL NUMBER := 1
161 ,COST_ALLOC NUMBER := 0
162 ,PHANTOM_TYPE NUMBER := 0
163 ,REWORK_TYPE NUMBER := 0
164 ,BUFFER_IND NUMBER := 0
165 /*Bug 2509076 - Thomas Daniel New field for Quality integration */
166 ,BY_PRODUCT_TYPE VARCHAR2(1)
167 ,INGREDIENT_END_DATE DATE --Bug 4479101
168 ,ATTRIBUTE1 VARCHAR2(240)
169 ,ATTRIBUTE2 VARCHAR2(240)
170 ,ATTRIBUTE3 VARCHAR2(240)
171 ,ATTRIBUTE4 VARCHAR2(240)
172 ,ATTRIBUTE5 VARCHAR2(240)
173 ,ATTRIBUTE6 VARCHAR2(240)
174 ,ATTRIBUTE7 VARCHAR2(240)
175 ,ATTRIBUTE8 VARCHAR2(240)
176 ,ATTRIBUTE9 VARCHAR2(240)
177 ,ATTRIBUTE10 VARCHAR2(240)
178 ,ATTRIBUTE11 VARCHAR2(240)
179 ,ATTRIBUTE12 VARCHAR2(240)
180 ,ATTRIBUTE13 VARCHAR2(240)
181 ,ATTRIBUTE14 VARCHAR2(240)
182 ,ATTRIBUTE15 VARCHAR2(240)
183 ,ATTRIBUTE16 VARCHAR2(240)
184 ,ATTRIBUTE17 VARCHAR2(240)
185 ,ATTRIBUTE18 VARCHAR2(240)
186 ,ATTRIBUTE19 VARCHAR2(240)
187 ,ATTRIBUTE20 VARCHAR2(240)
188 ,ATTRIBUTE21 VARCHAR2(240)
189 ,ATTRIBUTE22 VARCHAR2(240)
190 ,ATTRIBUTE23 VARCHAR2(240)
191 ,ATTRIBUTE24 VARCHAR2(240)
192 ,ATTRIBUTE25 VARCHAR2(240)
193 ,ATTRIBUTE26 VARCHAR2(240)
194 ,ATTRIBUTE27 VARCHAR2(240)
195 ,ATTRIBUTE28 VARCHAR2(240)
196 ,ATTRIBUTE29 VARCHAR2(240)
197 ,ATTRIBUTE30 VARCHAR2(240)
198 ,DTL_ATTRIBUTE1 VARCHAR2(240)
199 ,DTL_ATTRIBUTE2 VARCHAR2(240)
200 ,DTL_ATTRIBUTE3 VARCHAR2(240)
201 ,DTL_ATTRIBUTE4 VARCHAR2(240)
202 ,DTL_ATTRIBUTE5 VARCHAR2(240)
203 ,DTL_ATTRIBUTE6 VARCHAR2(240)
204 ,DTL_ATTRIBUTE7 VARCHAR2(240)
205 ,DTL_ATTRIBUTE8 VARCHAR2(240)
206 ,DTL_ATTRIBUTE9 VARCHAR2(240)
207 ,DTL_ATTRIBUTE10 VARCHAR2(240)
208 ,DTL_ATTRIBUTE11 VARCHAR2(240)
209 ,DTL_ATTRIBUTE12 VARCHAR2(240)
210 ,DTL_ATTRIBUTE13 VARCHAR2(240)
211 ,DTL_ATTRIBUTE14 VARCHAR2(240)
212 ,DTL_ATTRIBUTE15 VARCHAR2(240)
213 ,DTL_ATTRIBUTE16 VARCHAR2(240)
214 ,DTL_ATTRIBUTE17 VARCHAR2(240)
215 ,DTL_ATTRIBUTE18 VARCHAR2(240)
216 ,DTL_ATTRIBUTE19 VARCHAR2(240)
217 ,DTL_ATTRIBUTE20 VARCHAR2(240)
218 ,DTL_ATTRIBUTE21 VARCHAR2(240)
219 ,DTL_ATTRIBUTE22 VARCHAR2(240)
220 ,DTL_ATTRIBUTE23 VARCHAR2(240)
221 ,DTL_ATTRIBUTE24 VARCHAR2(240)
222 ,DTL_ATTRIBUTE25 VARCHAR2(240)
223 ,DTL_ATTRIBUTE26 VARCHAR2(240)
224 ,DTL_ATTRIBUTE27 VARCHAR2(240)
225 ,DTL_ATTRIBUTE28 VARCHAR2(240)
226 ,DTL_ATTRIBUTE29 VARCHAR2(240)
227 ,DTL_ATTRIBUTE30 VARCHAR2(240)
228 ,ATTRIBUTE_CATEGORY VARCHAR2(30)
229 ,DTL_ATTRIBUTE_CATEGORY VARCHAR2(30)
230 ,TPFORMULA_ID NUMBER
231 ,IAFORMULA_ID NUMBER
232 ,SCALE_MULTIPLE NUMBER
233 ,CONTRIBUTE_YIELD_IND VARCHAR2(1) := 'Y'
234 ,SCALE_UOM VARCHAR2(4)
235 ,CONTRIBUTE_STEP_QTY_IND VARCHAR2(1) := 'Y'
236 ,SCALE_ROUNDING_VARIANCE NUMBER
237 ,ROUNDING_DIRECTION NUMBER
238 ,TEXT_CODE_HDR NUMBER
239 ,TEXT_CODE_DTL NUMBER
240 ,USER_ID NUMBER
241 ,CREATION_DATE DATE
242 ,CREATED_BY NUMBER(15)
243 ,LAST_UPDATED_BY NUMBER(15)
244 ,LAST_UPDATE_DATE DATE
245 ,LAST_UPDATE_LOGIN NUMBER(15)
246 ,USER_NAME VARCHAR2(100)
247 ,DELETE_MARK NUMBER := 0
248 ,AUTO_PRODUCT_CALC VARCHAR2(1) -- Bug# 5716318
249 ,PROD_PERCENT NUMBER
250 );
251
252 END GMD_FORMULA_COMMON_PUB;