164:
165: ----------------------------------------------------------------------------------
166: -- FUNCTION: CREATE_ATTRIBUTES --
167: -- --
168: -- DESCRIPTION:Inserts into BNE_ATTRIBUTES. The attribute id given --
169: -- should be assigned to a parameter list or a parameter. --
170: -- It is suggested that you call GET_NEXT_ATTRIBUTE_SEQ --
171: -- add to BNE_PARAM_LIST or BNE_PARAM_DEFN using the --
172: -- using the value returned from GET_NEXT_ATTRIBUTE_SEQ --
172: -- using the value returned from GET_NEXT_ATTRIBUTE_SEQ --
173: -- as the attribute id. --
174: -- --
175: -- --
176: -- PARAMETERS: P_ATTRIBUTE_ID = BNE_ATTRIBUTES.ATTRIBUTE_ID --
177: -- P_ATTRIBUTE1 = BNE_ATTRIBUTES.ATTRIBUTE1 --
178: -- to --
179: -- P_ATTRIBUTE30 = BNE_ATTRIBUTES.ATTRIBUTE30 --
180: -- --
173: -- as the attribute id. --
174: -- --
175: -- --
176: -- PARAMETERS: P_ATTRIBUTE_ID = BNE_ATTRIBUTES.ATTRIBUTE_ID --
177: -- P_ATTRIBUTE1 = BNE_ATTRIBUTES.ATTRIBUTE1 --
178: -- to --
179: -- P_ATTRIBUTE30 = BNE_ATTRIBUTES.ATTRIBUTE30 --
180: -- --
181: -- --
175: -- --
176: -- PARAMETERS: P_ATTRIBUTE_ID = BNE_ATTRIBUTES.ATTRIBUTE_ID --
177: -- P_ATTRIBUTE1 = BNE_ATTRIBUTES.ATTRIBUTE1 --
178: -- to --
179: -- P_ATTRIBUTE30 = BNE_ATTRIBUTES.ATTRIBUTE30 --
180: -- --
181: -- --
182: -- RETURN: attribute key. E.g. 101:CODE --
183: -- --
188: -- 7-Oct-02 KDOBINSO UPDATED FOR WEB ADI REPOSITORY CHANGE --
189: ----------------------------------------------------------------------------------
190:
191:
192: FUNCTION CREATE_ATTRIBUTES (P_APPLICATION_ID in BNE_ATTRIBUTES.APPLICATION_ID%type,
193: P_ATTRIBUTE_CODE in BNE_ATTRIBUTES.ATTRIBUTE_CODE%type,
194: P_ATTRIBUTE1 in BNE_ATTRIBUTES.ATTRIBUTE1%type,
195: P_ATTRIBUTE2 in BNE_ATTRIBUTES.ATTRIBUTE2%type,
196: P_ATTRIBUTE3 in BNE_ATTRIBUTES.ATTRIBUTE3%type,
189: ----------------------------------------------------------------------------------
190:
191:
192: FUNCTION CREATE_ATTRIBUTES (P_APPLICATION_ID in BNE_ATTRIBUTES.APPLICATION_ID%type,
193: P_ATTRIBUTE_CODE in BNE_ATTRIBUTES.ATTRIBUTE_CODE%type,
194: P_ATTRIBUTE1 in BNE_ATTRIBUTES.ATTRIBUTE1%type,
195: P_ATTRIBUTE2 in BNE_ATTRIBUTES.ATTRIBUTE2%type,
196: P_ATTRIBUTE3 in BNE_ATTRIBUTES.ATTRIBUTE3%type,
197: P_ATTRIBUTE4 in BNE_ATTRIBUTES.ATTRIBUTE4%type,
190:
191:
192: FUNCTION CREATE_ATTRIBUTES (P_APPLICATION_ID in BNE_ATTRIBUTES.APPLICATION_ID%type,
193: P_ATTRIBUTE_CODE in BNE_ATTRIBUTES.ATTRIBUTE_CODE%type,
194: P_ATTRIBUTE1 in BNE_ATTRIBUTES.ATTRIBUTE1%type,
195: P_ATTRIBUTE2 in BNE_ATTRIBUTES.ATTRIBUTE2%type,
196: P_ATTRIBUTE3 in BNE_ATTRIBUTES.ATTRIBUTE3%type,
197: P_ATTRIBUTE4 in BNE_ATTRIBUTES.ATTRIBUTE4%type,
198: P_ATTRIBUTE5 in BNE_ATTRIBUTES.ATTRIBUTE5%type,
191:
192: FUNCTION CREATE_ATTRIBUTES (P_APPLICATION_ID in BNE_ATTRIBUTES.APPLICATION_ID%type,
193: P_ATTRIBUTE_CODE in BNE_ATTRIBUTES.ATTRIBUTE_CODE%type,
194: P_ATTRIBUTE1 in BNE_ATTRIBUTES.ATTRIBUTE1%type,
195: P_ATTRIBUTE2 in BNE_ATTRIBUTES.ATTRIBUTE2%type,
196: P_ATTRIBUTE3 in BNE_ATTRIBUTES.ATTRIBUTE3%type,
197: P_ATTRIBUTE4 in BNE_ATTRIBUTES.ATTRIBUTE4%type,
198: P_ATTRIBUTE5 in BNE_ATTRIBUTES.ATTRIBUTE5%type,
199: P_ATTRIBUTE6 in BNE_ATTRIBUTES.ATTRIBUTE6%type,
192: FUNCTION CREATE_ATTRIBUTES (P_APPLICATION_ID in BNE_ATTRIBUTES.APPLICATION_ID%type,
193: P_ATTRIBUTE_CODE in BNE_ATTRIBUTES.ATTRIBUTE_CODE%type,
194: P_ATTRIBUTE1 in BNE_ATTRIBUTES.ATTRIBUTE1%type,
195: P_ATTRIBUTE2 in BNE_ATTRIBUTES.ATTRIBUTE2%type,
196: P_ATTRIBUTE3 in BNE_ATTRIBUTES.ATTRIBUTE3%type,
197: P_ATTRIBUTE4 in BNE_ATTRIBUTES.ATTRIBUTE4%type,
198: P_ATTRIBUTE5 in BNE_ATTRIBUTES.ATTRIBUTE5%type,
199: P_ATTRIBUTE6 in BNE_ATTRIBUTES.ATTRIBUTE6%type,
200: P_ATTRIBUTE7 in BNE_ATTRIBUTES.ATTRIBUTE7%type,
193: P_ATTRIBUTE_CODE in BNE_ATTRIBUTES.ATTRIBUTE_CODE%type,
194: P_ATTRIBUTE1 in BNE_ATTRIBUTES.ATTRIBUTE1%type,
195: P_ATTRIBUTE2 in BNE_ATTRIBUTES.ATTRIBUTE2%type,
196: P_ATTRIBUTE3 in BNE_ATTRIBUTES.ATTRIBUTE3%type,
197: P_ATTRIBUTE4 in BNE_ATTRIBUTES.ATTRIBUTE4%type,
198: P_ATTRIBUTE5 in BNE_ATTRIBUTES.ATTRIBUTE5%type,
199: P_ATTRIBUTE6 in BNE_ATTRIBUTES.ATTRIBUTE6%type,
200: P_ATTRIBUTE7 in BNE_ATTRIBUTES.ATTRIBUTE7%type,
201: P_ATTRIBUTE8 in BNE_ATTRIBUTES.ATTRIBUTE8%type,
194: P_ATTRIBUTE1 in BNE_ATTRIBUTES.ATTRIBUTE1%type,
195: P_ATTRIBUTE2 in BNE_ATTRIBUTES.ATTRIBUTE2%type,
196: P_ATTRIBUTE3 in BNE_ATTRIBUTES.ATTRIBUTE3%type,
197: P_ATTRIBUTE4 in BNE_ATTRIBUTES.ATTRIBUTE4%type,
198: P_ATTRIBUTE5 in BNE_ATTRIBUTES.ATTRIBUTE5%type,
199: P_ATTRIBUTE6 in BNE_ATTRIBUTES.ATTRIBUTE6%type,
200: P_ATTRIBUTE7 in BNE_ATTRIBUTES.ATTRIBUTE7%type,
201: P_ATTRIBUTE8 in BNE_ATTRIBUTES.ATTRIBUTE8%type,
202: P_ATTRIBUTE9 in BNE_ATTRIBUTES.ATTRIBUTE9%type,
195: P_ATTRIBUTE2 in BNE_ATTRIBUTES.ATTRIBUTE2%type,
196: P_ATTRIBUTE3 in BNE_ATTRIBUTES.ATTRIBUTE3%type,
197: P_ATTRIBUTE4 in BNE_ATTRIBUTES.ATTRIBUTE4%type,
198: P_ATTRIBUTE5 in BNE_ATTRIBUTES.ATTRIBUTE5%type,
199: P_ATTRIBUTE6 in BNE_ATTRIBUTES.ATTRIBUTE6%type,
200: P_ATTRIBUTE7 in BNE_ATTRIBUTES.ATTRIBUTE7%type,
201: P_ATTRIBUTE8 in BNE_ATTRIBUTES.ATTRIBUTE8%type,
202: P_ATTRIBUTE9 in BNE_ATTRIBUTES.ATTRIBUTE9%type,
203: P_ATTRIBUTE10 in BNE_ATTRIBUTES.ATTRIBUTE10%type,
196: P_ATTRIBUTE3 in BNE_ATTRIBUTES.ATTRIBUTE3%type,
197: P_ATTRIBUTE4 in BNE_ATTRIBUTES.ATTRIBUTE4%type,
198: P_ATTRIBUTE5 in BNE_ATTRIBUTES.ATTRIBUTE5%type,
199: P_ATTRIBUTE6 in BNE_ATTRIBUTES.ATTRIBUTE6%type,
200: P_ATTRIBUTE7 in BNE_ATTRIBUTES.ATTRIBUTE7%type,
201: P_ATTRIBUTE8 in BNE_ATTRIBUTES.ATTRIBUTE8%type,
202: P_ATTRIBUTE9 in BNE_ATTRIBUTES.ATTRIBUTE9%type,
203: P_ATTRIBUTE10 in BNE_ATTRIBUTES.ATTRIBUTE10%type,
204: P_ATTRIBUTE11 in BNE_ATTRIBUTES.ATTRIBUTE11%type,
197: P_ATTRIBUTE4 in BNE_ATTRIBUTES.ATTRIBUTE4%type,
198: P_ATTRIBUTE5 in BNE_ATTRIBUTES.ATTRIBUTE5%type,
199: P_ATTRIBUTE6 in BNE_ATTRIBUTES.ATTRIBUTE6%type,
200: P_ATTRIBUTE7 in BNE_ATTRIBUTES.ATTRIBUTE7%type,
201: P_ATTRIBUTE8 in BNE_ATTRIBUTES.ATTRIBUTE8%type,
202: P_ATTRIBUTE9 in BNE_ATTRIBUTES.ATTRIBUTE9%type,
203: P_ATTRIBUTE10 in BNE_ATTRIBUTES.ATTRIBUTE10%type,
204: P_ATTRIBUTE11 in BNE_ATTRIBUTES.ATTRIBUTE11%type,
205: P_ATTRIBUTE12 in BNE_ATTRIBUTES.ATTRIBUTE12%type,
198: P_ATTRIBUTE5 in BNE_ATTRIBUTES.ATTRIBUTE5%type,
199: P_ATTRIBUTE6 in BNE_ATTRIBUTES.ATTRIBUTE6%type,
200: P_ATTRIBUTE7 in BNE_ATTRIBUTES.ATTRIBUTE7%type,
201: P_ATTRIBUTE8 in BNE_ATTRIBUTES.ATTRIBUTE8%type,
202: P_ATTRIBUTE9 in BNE_ATTRIBUTES.ATTRIBUTE9%type,
203: P_ATTRIBUTE10 in BNE_ATTRIBUTES.ATTRIBUTE10%type,
204: P_ATTRIBUTE11 in BNE_ATTRIBUTES.ATTRIBUTE11%type,
205: P_ATTRIBUTE12 in BNE_ATTRIBUTES.ATTRIBUTE12%type,
206: P_ATTRIBUTE13 in BNE_ATTRIBUTES.ATTRIBUTE13%type,
199: P_ATTRIBUTE6 in BNE_ATTRIBUTES.ATTRIBUTE6%type,
200: P_ATTRIBUTE7 in BNE_ATTRIBUTES.ATTRIBUTE7%type,
201: P_ATTRIBUTE8 in BNE_ATTRIBUTES.ATTRIBUTE8%type,
202: P_ATTRIBUTE9 in BNE_ATTRIBUTES.ATTRIBUTE9%type,
203: P_ATTRIBUTE10 in BNE_ATTRIBUTES.ATTRIBUTE10%type,
204: P_ATTRIBUTE11 in BNE_ATTRIBUTES.ATTRIBUTE11%type,
205: P_ATTRIBUTE12 in BNE_ATTRIBUTES.ATTRIBUTE12%type,
206: P_ATTRIBUTE13 in BNE_ATTRIBUTES.ATTRIBUTE13%type,
207: P_ATTRIBUTE14 in BNE_ATTRIBUTES.ATTRIBUTE14%type,
200: P_ATTRIBUTE7 in BNE_ATTRIBUTES.ATTRIBUTE7%type,
201: P_ATTRIBUTE8 in BNE_ATTRIBUTES.ATTRIBUTE8%type,
202: P_ATTRIBUTE9 in BNE_ATTRIBUTES.ATTRIBUTE9%type,
203: P_ATTRIBUTE10 in BNE_ATTRIBUTES.ATTRIBUTE10%type,
204: P_ATTRIBUTE11 in BNE_ATTRIBUTES.ATTRIBUTE11%type,
205: P_ATTRIBUTE12 in BNE_ATTRIBUTES.ATTRIBUTE12%type,
206: P_ATTRIBUTE13 in BNE_ATTRIBUTES.ATTRIBUTE13%type,
207: P_ATTRIBUTE14 in BNE_ATTRIBUTES.ATTRIBUTE14%type,
208: P_ATTRIBUTE15 in BNE_ATTRIBUTES.ATTRIBUTE15%type,
201: P_ATTRIBUTE8 in BNE_ATTRIBUTES.ATTRIBUTE8%type,
202: P_ATTRIBUTE9 in BNE_ATTRIBUTES.ATTRIBUTE9%type,
203: P_ATTRIBUTE10 in BNE_ATTRIBUTES.ATTRIBUTE10%type,
204: P_ATTRIBUTE11 in BNE_ATTRIBUTES.ATTRIBUTE11%type,
205: P_ATTRIBUTE12 in BNE_ATTRIBUTES.ATTRIBUTE12%type,
206: P_ATTRIBUTE13 in BNE_ATTRIBUTES.ATTRIBUTE13%type,
207: P_ATTRIBUTE14 in BNE_ATTRIBUTES.ATTRIBUTE14%type,
208: P_ATTRIBUTE15 in BNE_ATTRIBUTES.ATTRIBUTE15%type,
209: P_ATTRIBUTE16 in BNE_ATTRIBUTES.ATTRIBUTE16%type,
202: P_ATTRIBUTE9 in BNE_ATTRIBUTES.ATTRIBUTE9%type,
203: P_ATTRIBUTE10 in BNE_ATTRIBUTES.ATTRIBUTE10%type,
204: P_ATTRIBUTE11 in BNE_ATTRIBUTES.ATTRIBUTE11%type,
205: P_ATTRIBUTE12 in BNE_ATTRIBUTES.ATTRIBUTE12%type,
206: P_ATTRIBUTE13 in BNE_ATTRIBUTES.ATTRIBUTE13%type,
207: P_ATTRIBUTE14 in BNE_ATTRIBUTES.ATTRIBUTE14%type,
208: P_ATTRIBUTE15 in BNE_ATTRIBUTES.ATTRIBUTE15%type,
209: P_ATTRIBUTE16 in BNE_ATTRIBUTES.ATTRIBUTE16%type,
210: P_ATTRIBUTE17 in BNE_ATTRIBUTES.ATTRIBUTE17%type,
203: P_ATTRIBUTE10 in BNE_ATTRIBUTES.ATTRIBUTE10%type,
204: P_ATTRIBUTE11 in BNE_ATTRIBUTES.ATTRIBUTE11%type,
205: P_ATTRIBUTE12 in BNE_ATTRIBUTES.ATTRIBUTE12%type,
206: P_ATTRIBUTE13 in BNE_ATTRIBUTES.ATTRIBUTE13%type,
207: P_ATTRIBUTE14 in BNE_ATTRIBUTES.ATTRIBUTE14%type,
208: P_ATTRIBUTE15 in BNE_ATTRIBUTES.ATTRIBUTE15%type,
209: P_ATTRIBUTE16 in BNE_ATTRIBUTES.ATTRIBUTE16%type,
210: P_ATTRIBUTE17 in BNE_ATTRIBUTES.ATTRIBUTE17%type,
211: P_ATTRIBUTE18 in BNE_ATTRIBUTES.ATTRIBUTE18%type,
204: P_ATTRIBUTE11 in BNE_ATTRIBUTES.ATTRIBUTE11%type,
205: P_ATTRIBUTE12 in BNE_ATTRIBUTES.ATTRIBUTE12%type,
206: P_ATTRIBUTE13 in BNE_ATTRIBUTES.ATTRIBUTE13%type,
207: P_ATTRIBUTE14 in BNE_ATTRIBUTES.ATTRIBUTE14%type,
208: P_ATTRIBUTE15 in BNE_ATTRIBUTES.ATTRIBUTE15%type,
209: P_ATTRIBUTE16 in BNE_ATTRIBUTES.ATTRIBUTE16%type,
210: P_ATTRIBUTE17 in BNE_ATTRIBUTES.ATTRIBUTE17%type,
211: P_ATTRIBUTE18 in BNE_ATTRIBUTES.ATTRIBUTE18%type,
212: P_ATTRIBUTE19 in BNE_ATTRIBUTES.ATTRIBUTE19%type,
205: P_ATTRIBUTE12 in BNE_ATTRIBUTES.ATTRIBUTE12%type,
206: P_ATTRIBUTE13 in BNE_ATTRIBUTES.ATTRIBUTE13%type,
207: P_ATTRIBUTE14 in BNE_ATTRIBUTES.ATTRIBUTE14%type,
208: P_ATTRIBUTE15 in BNE_ATTRIBUTES.ATTRIBUTE15%type,
209: P_ATTRIBUTE16 in BNE_ATTRIBUTES.ATTRIBUTE16%type,
210: P_ATTRIBUTE17 in BNE_ATTRIBUTES.ATTRIBUTE17%type,
211: P_ATTRIBUTE18 in BNE_ATTRIBUTES.ATTRIBUTE18%type,
212: P_ATTRIBUTE19 in BNE_ATTRIBUTES.ATTRIBUTE19%type,
213: P_ATTRIBUTE20 in BNE_ATTRIBUTES.ATTRIBUTE20%type,
206: P_ATTRIBUTE13 in BNE_ATTRIBUTES.ATTRIBUTE13%type,
207: P_ATTRIBUTE14 in BNE_ATTRIBUTES.ATTRIBUTE14%type,
208: P_ATTRIBUTE15 in BNE_ATTRIBUTES.ATTRIBUTE15%type,
209: P_ATTRIBUTE16 in BNE_ATTRIBUTES.ATTRIBUTE16%type,
210: P_ATTRIBUTE17 in BNE_ATTRIBUTES.ATTRIBUTE17%type,
211: P_ATTRIBUTE18 in BNE_ATTRIBUTES.ATTRIBUTE18%type,
212: P_ATTRIBUTE19 in BNE_ATTRIBUTES.ATTRIBUTE19%type,
213: P_ATTRIBUTE20 in BNE_ATTRIBUTES.ATTRIBUTE20%type,
214: P_ATTRIBUTE21 in BNE_ATTRIBUTES.ATTRIBUTE21%type,
207: P_ATTRIBUTE14 in BNE_ATTRIBUTES.ATTRIBUTE14%type,
208: P_ATTRIBUTE15 in BNE_ATTRIBUTES.ATTRIBUTE15%type,
209: P_ATTRIBUTE16 in BNE_ATTRIBUTES.ATTRIBUTE16%type,
210: P_ATTRIBUTE17 in BNE_ATTRIBUTES.ATTRIBUTE17%type,
211: P_ATTRIBUTE18 in BNE_ATTRIBUTES.ATTRIBUTE18%type,
212: P_ATTRIBUTE19 in BNE_ATTRIBUTES.ATTRIBUTE19%type,
213: P_ATTRIBUTE20 in BNE_ATTRIBUTES.ATTRIBUTE20%type,
214: P_ATTRIBUTE21 in BNE_ATTRIBUTES.ATTRIBUTE21%type,
215: P_ATTRIBUTE22 in BNE_ATTRIBUTES.ATTRIBUTE22%type,
208: P_ATTRIBUTE15 in BNE_ATTRIBUTES.ATTRIBUTE15%type,
209: P_ATTRIBUTE16 in BNE_ATTRIBUTES.ATTRIBUTE16%type,
210: P_ATTRIBUTE17 in BNE_ATTRIBUTES.ATTRIBUTE17%type,
211: P_ATTRIBUTE18 in BNE_ATTRIBUTES.ATTRIBUTE18%type,
212: P_ATTRIBUTE19 in BNE_ATTRIBUTES.ATTRIBUTE19%type,
213: P_ATTRIBUTE20 in BNE_ATTRIBUTES.ATTRIBUTE20%type,
214: P_ATTRIBUTE21 in BNE_ATTRIBUTES.ATTRIBUTE21%type,
215: P_ATTRIBUTE22 in BNE_ATTRIBUTES.ATTRIBUTE22%type,
216: P_ATTRIBUTE23 in BNE_ATTRIBUTES.ATTRIBUTE23%type,
209: P_ATTRIBUTE16 in BNE_ATTRIBUTES.ATTRIBUTE16%type,
210: P_ATTRIBUTE17 in BNE_ATTRIBUTES.ATTRIBUTE17%type,
211: P_ATTRIBUTE18 in BNE_ATTRIBUTES.ATTRIBUTE18%type,
212: P_ATTRIBUTE19 in BNE_ATTRIBUTES.ATTRIBUTE19%type,
213: P_ATTRIBUTE20 in BNE_ATTRIBUTES.ATTRIBUTE20%type,
214: P_ATTRIBUTE21 in BNE_ATTRIBUTES.ATTRIBUTE21%type,
215: P_ATTRIBUTE22 in BNE_ATTRIBUTES.ATTRIBUTE22%type,
216: P_ATTRIBUTE23 in BNE_ATTRIBUTES.ATTRIBUTE23%type,
217: P_ATTRIBUTE24 in BNE_ATTRIBUTES.ATTRIBUTE24%type,
210: P_ATTRIBUTE17 in BNE_ATTRIBUTES.ATTRIBUTE17%type,
211: P_ATTRIBUTE18 in BNE_ATTRIBUTES.ATTRIBUTE18%type,
212: P_ATTRIBUTE19 in BNE_ATTRIBUTES.ATTRIBUTE19%type,
213: P_ATTRIBUTE20 in BNE_ATTRIBUTES.ATTRIBUTE20%type,
214: P_ATTRIBUTE21 in BNE_ATTRIBUTES.ATTRIBUTE21%type,
215: P_ATTRIBUTE22 in BNE_ATTRIBUTES.ATTRIBUTE22%type,
216: P_ATTRIBUTE23 in BNE_ATTRIBUTES.ATTRIBUTE23%type,
217: P_ATTRIBUTE24 in BNE_ATTRIBUTES.ATTRIBUTE24%type,
218: P_ATTRIBUTE25 in BNE_ATTRIBUTES.ATTRIBUTE25%type,
211: P_ATTRIBUTE18 in BNE_ATTRIBUTES.ATTRIBUTE18%type,
212: P_ATTRIBUTE19 in BNE_ATTRIBUTES.ATTRIBUTE19%type,
213: P_ATTRIBUTE20 in BNE_ATTRIBUTES.ATTRIBUTE20%type,
214: P_ATTRIBUTE21 in BNE_ATTRIBUTES.ATTRIBUTE21%type,
215: P_ATTRIBUTE22 in BNE_ATTRIBUTES.ATTRIBUTE22%type,
216: P_ATTRIBUTE23 in BNE_ATTRIBUTES.ATTRIBUTE23%type,
217: P_ATTRIBUTE24 in BNE_ATTRIBUTES.ATTRIBUTE24%type,
218: P_ATTRIBUTE25 in BNE_ATTRIBUTES.ATTRIBUTE25%type,
219: P_ATTRIBUTE26 in BNE_ATTRIBUTES.ATTRIBUTE26%type,
212: P_ATTRIBUTE19 in BNE_ATTRIBUTES.ATTRIBUTE19%type,
213: P_ATTRIBUTE20 in BNE_ATTRIBUTES.ATTRIBUTE20%type,
214: P_ATTRIBUTE21 in BNE_ATTRIBUTES.ATTRIBUTE21%type,
215: P_ATTRIBUTE22 in BNE_ATTRIBUTES.ATTRIBUTE22%type,
216: P_ATTRIBUTE23 in BNE_ATTRIBUTES.ATTRIBUTE23%type,
217: P_ATTRIBUTE24 in BNE_ATTRIBUTES.ATTRIBUTE24%type,
218: P_ATTRIBUTE25 in BNE_ATTRIBUTES.ATTRIBUTE25%type,
219: P_ATTRIBUTE26 in BNE_ATTRIBUTES.ATTRIBUTE26%type,
220: P_ATTRIBUTE27 in BNE_ATTRIBUTES.ATTRIBUTE27%type,
213: P_ATTRIBUTE20 in BNE_ATTRIBUTES.ATTRIBUTE20%type,
214: P_ATTRIBUTE21 in BNE_ATTRIBUTES.ATTRIBUTE21%type,
215: P_ATTRIBUTE22 in BNE_ATTRIBUTES.ATTRIBUTE22%type,
216: P_ATTRIBUTE23 in BNE_ATTRIBUTES.ATTRIBUTE23%type,
217: P_ATTRIBUTE24 in BNE_ATTRIBUTES.ATTRIBUTE24%type,
218: P_ATTRIBUTE25 in BNE_ATTRIBUTES.ATTRIBUTE25%type,
219: P_ATTRIBUTE26 in BNE_ATTRIBUTES.ATTRIBUTE26%type,
220: P_ATTRIBUTE27 in BNE_ATTRIBUTES.ATTRIBUTE27%type,
221: P_ATTRIBUTE28 in BNE_ATTRIBUTES.ATTRIBUTE28%type,
214: P_ATTRIBUTE21 in BNE_ATTRIBUTES.ATTRIBUTE21%type,
215: P_ATTRIBUTE22 in BNE_ATTRIBUTES.ATTRIBUTE22%type,
216: P_ATTRIBUTE23 in BNE_ATTRIBUTES.ATTRIBUTE23%type,
217: P_ATTRIBUTE24 in BNE_ATTRIBUTES.ATTRIBUTE24%type,
218: P_ATTRIBUTE25 in BNE_ATTRIBUTES.ATTRIBUTE25%type,
219: P_ATTRIBUTE26 in BNE_ATTRIBUTES.ATTRIBUTE26%type,
220: P_ATTRIBUTE27 in BNE_ATTRIBUTES.ATTRIBUTE27%type,
221: P_ATTRIBUTE28 in BNE_ATTRIBUTES.ATTRIBUTE28%type,
222: P_ATTRIBUTE29 in BNE_ATTRIBUTES.ATTRIBUTE29%type,
215: P_ATTRIBUTE22 in BNE_ATTRIBUTES.ATTRIBUTE22%type,
216: P_ATTRIBUTE23 in BNE_ATTRIBUTES.ATTRIBUTE23%type,
217: P_ATTRIBUTE24 in BNE_ATTRIBUTES.ATTRIBUTE24%type,
218: P_ATTRIBUTE25 in BNE_ATTRIBUTES.ATTRIBUTE25%type,
219: P_ATTRIBUTE26 in BNE_ATTRIBUTES.ATTRIBUTE26%type,
220: P_ATTRIBUTE27 in BNE_ATTRIBUTES.ATTRIBUTE27%type,
221: P_ATTRIBUTE28 in BNE_ATTRIBUTES.ATTRIBUTE28%type,
222: P_ATTRIBUTE29 in BNE_ATTRIBUTES.ATTRIBUTE29%type,
223: P_ATTRIBUTE30 in BNE_ATTRIBUTES.ATTRIBUTE30%type )
216: P_ATTRIBUTE23 in BNE_ATTRIBUTES.ATTRIBUTE23%type,
217: P_ATTRIBUTE24 in BNE_ATTRIBUTES.ATTRIBUTE24%type,
218: P_ATTRIBUTE25 in BNE_ATTRIBUTES.ATTRIBUTE25%type,
219: P_ATTRIBUTE26 in BNE_ATTRIBUTES.ATTRIBUTE26%type,
220: P_ATTRIBUTE27 in BNE_ATTRIBUTES.ATTRIBUTE27%type,
221: P_ATTRIBUTE28 in BNE_ATTRIBUTES.ATTRIBUTE28%type,
222: P_ATTRIBUTE29 in BNE_ATTRIBUTES.ATTRIBUTE29%type,
223: P_ATTRIBUTE30 in BNE_ATTRIBUTES.ATTRIBUTE30%type )
224:
217: P_ATTRIBUTE24 in BNE_ATTRIBUTES.ATTRIBUTE24%type,
218: P_ATTRIBUTE25 in BNE_ATTRIBUTES.ATTRIBUTE25%type,
219: P_ATTRIBUTE26 in BNE_ATTRIBUTES.ATTRIBUTE26%type,
220: P_ATTRIBUTE27 in BNE_ATTRIBUTES.ATTRIBUTE27%type,
221: P_ATTRIBUTE28 in BNE_ATTRIBUTES.ATTRIBUTE28%type,
222: P_ATTRIBUTE29 in BNE_ATTRIBUTES.ATTRIBUTE29%type,
223: P_ATTRIBUTE30 in BNE_ATTRIBUTES.ATTRIBUTE30%type )
224:
225: RETURN BNE_ATTRIBUTES.ATTRIBUTE_CODE%type as VN_KEY BNE_ATTRIBUTES.ATTRIBUTE_CODE%type;
218: P_ATTRIBUTE25 in BNE_ATTRIBUTES.ATTRIBUTE25%type,
219: P_ATTRIBUTE26 in BNE_ATTRIBUTES.ATTRIBUTE26%type,
220: P_ATTRIBUTE27 in BNE_ATTRIBUTES.ATTRIBUTE27%type,
221: P_ATTRIBUTE28 in BNE_ATTRIBUTES.ATTRIBUTE28%type,
222: P_ATTRIBUTE29 in BNE_ATTRIBUTES.ATTRIBUTE29%type,
223: P_ATTRIBUTE30 in BNE_ATTRIBUTES.ATTRIBUTE30%type )
224:
225: RETURN BNE_ATTRIBUTES.ATTRIBUTE_CODE%type as VN_KEY BNE_ATTRIBUTES.ATTRIBUTE_CODE%type;
226:
219: P_ATTRIBUTE26 in BNE_ATTRIBUTES.ATTRIBUTE26%type,
220: P_ATTRIBUTE27 in BNE_ATTRIBUTES.ATTRIBUTE27%type,
221: P_ATTRIBUTE28 in BNE_ATTRIBUTES.ATTRIBUTE28%type,
222: P_ATTRIBUTE29 in BNE_ATTRIBUTES.ATTRIBUTE29%type,
223: P_ATTRIBUTE30 in BNE_ATTRIBUTES.ATTRIBUTE30%type )
224:
225: RETURN BNE_ATTRIBUTES.ATTRIBUTE_CODE%type as VN_KEY BNE_ATTRIBUTES.ATTRIBUTE_CODE%type;
226:
227: VN_OBJECT_VERSION_NUM BNE_ATTRIBUTES.OBJECT_VERSION_NUMBER%type;
221: P_ATTRIBUTE28 in BNE_ATTRIBUTES.ATTRIBUTE28%type,
222: P_ATTRIBUTE29 in BNE_ATTRIBUTES.ATTRIBUTE29%type,
223: P_ATTRIBUTE30 in BNE_ATTRIBUTES.ATTRIBUTE30%type )
224:
225: RETURN BNE_ATTRIBUTES.ATTRIBUTE_CODE%type as VN_KEY BNE_ATTRIBUTES.ATTRIBUTE_CODE%type;
226:
227: VN_OBJECT_VERSION_NUM BNE_ATTRIBUTES.OBJECT_VERSION_NUMBER%type;
228: VV_ATTRIBUTE_CODE BNE_ATTRIBUTES.ATTRIBUTE_CODE%type;
229:
223: P_ATTRIBUTE30 in BNE_ATTRIBUTES.ATTRIBUTE30%type )
224:
225: RETURN BNE_ATTRIBUTES.ATTRIBUTE_CODE%type as VN_KEY BNE_ATTRIBUTES.ATTRIBUTE_CODE%type;
226:
227: VN_OBJECT_VERSION_NUM BNE_ATTRIBUTES.OBJECT_VERSION_NUMBER%type;
228: VV_ATTRIBUTE_CODE BNE_ATTRIBUTES.ATTRIBUTE_CODE%type;
229:
230: BEGIN
231:
224:
225: RETURN BNE_ATTRIBUTES.ATTRIBUTE_CODE%type as VN_KEY BNE_ATTRIBUTES.ATTRIBUTE_CODE%type;
226:
227: VN_OBJECT_VERSION_NUM BNE_ATTRIBUTES.OBJECT_VERSION_NUMBER%type;
228: VV_ATTRIBUTE_CODE BNE_ATTRIBUTES.ATTRIBUTE_CODE%type;
229:
230: BEGIN
231:
232: -- defaults
238:
239: -- create a key
240: VN_KEY := P_APPLICATION_ID || ':' || VV_ATTRIBUTE_CODE;
241:
242: INSERT INTO BNE_ATTRIBUTES ( APPLICATION_ID,
243: ATTRIBUTE_CODE,
244: OBJECT_VERSION_NUMBER,
245: ATTRIBUTE1,
246: ATTRIBUTE2,
291:
292: --------------------------------------------------------------------------------
293: -- FUNCTION: CREATE_ATTRIBUTES_MINIMAL --
294: -- --
295: -- DESCRIPTION: Inserts 10 ATTRIBUTES into BNE_ATTRIBUTES --
296: -- Uses FND_GLOBAL.RESP_APPL_ID for the APPLICATION_ID --
297: -- --
298: -- PARAMETERS: P_ATTRIBUTE_ID = BNE_ATTRIBUTES.ATTRIBUTE_ID --
299: -- P_ATTRIBUTE1 = BNE_ATTRIBUTES.ATTRIBUTE1 --
294: -- --
295: -- DESCRIPTION: Inserts 10 ATTRIBUTES into BNE_ATTRIBUTES --
296: -- Uses FND_GLOBAL.RESP_APPL_ID for the APPLICATION_ID --
297: -- --
298: -- PARAMETERS: P_ATTRIBUTE_ID = BNE_ATTRIBUTES.ATTRIBUTE_ID --
299: -- P_ATTRIBUTE1 = BNE_ATTRIBUTES.ATTRIBUTE1 --
300: -- to --
301: -- P_ATTRIBUTE10 = BNE_ATTRIBUTES.ATTRIBUTE10 --
302: -- --
295: -- DESCRIPTION: Inserts 10 ATTRIBUTES into BNE_ATTRIBUTES --
296: -- Uses FND_GLOBAL.RESP_APPL_ID for the APPLICATION_ID --
297: -- --
298: -- PARAMETERS: P_ATTRIBUTE_ID = BNE_ATTRIBUTES.ATTRIBUTE_ID --
299: -- P_ATTRIBUTE1 = BNE_ATTRIBUTES.ATTRIBUTE1 --
300: -- to --
301: -- P_ATTRIBUTE10 = BNE_ATTRIBUTES.ATTRIBUTE10 --
302: -- --
303: -- RETURN: attribute key. E.g. 101:CODE --
297: -- --
298: -- PARAMETERS: P_ATTRIBUTE_ID = BNE_ATTRIBUTES.ATTRIBUTE_ID --
299: -- P_ATTRIBUTE1 = BNE_ATTRIBUTES.ATTRIBUTE1 --
300: -- to --
301: -- P_ATTRIBUTE10 = BNE_ATTRIBUTES.ATTRIBUTE10 --
302: -- --
303: -- RETURN: attribute key. E.g. 101:CODE --
304: -- --
305: -- --
308: -- 8-May-02 KDOBINSO CREATED --
309: -- 7-Oct-02 KDOBINSO UPDATED FOR WEB ADI REPOSITORY CHANGE --
310: --------------------------------------------------------------------------------
311:
312: FUNCTION CREATE_ATTRIBUTES_MINIMAL (P_ATTRIBUTE_CODE in BNE_ATTRIBUTES.ATTRIBUTE_CODE%type,
313: P_ATTRIBUTE1 in BNE_ATTRIBUTES.ATTRIBUTE1%type,
314: P_ATTRIBUTE2 in BNE_ATTRIBUTES.ATTRIBUTE2%type,
315: P_ATTRIBUTE3 in BNE_ATTRIBUTES.ATTRIBUTE3%type,
316: P_ATTRIBUTE4 in BNE_ATTRIBUTES.ATTRIBUTE4%type,
309: -- 7-Oct-02 KDOBINSO UPDATED FOR WEB ADI REPOSITORY CHANGE --
310: --------------------------------------------------------------------------------
311:
312: FUNCTION CREATE_ATTRIBUTES_MINIMAL (P_ATTRIBUTE_CODE in BNE_ATTRIBUTES.ATTRIBUTE_CODE%type,
313: P_ATTRIBUTE1 in BNE_ATTRIBUTES.ATTRIBUTE1%type,
314: P_ATTRIBUTE2 in BNE_ATTRIBUTES.ATTRIBUTE2%type,
315: P_ATTRIBUTE3 in BNE_ATTRIBUTES.ATTRIBUTE3%type,
316: P_ATTRIBUTE4 in BNE_ATTRIBUTES.ATTRIBUTE4%type,
317: P_ATTRIBUTE5 in BNE_ATTRIBUTES.ATTRIBUTE5%type,
310: --------------------------------------------------------------------------------
311:
312: FUNCTION CREATE_ATTRIBUTES_MINIMAL (P_ATTRIBUTE_CODE in BNE_ATTRIBUTES.ATTRIBUTE_CODE%type,
313: P_ATTRIBUTE1 in BNE_ATTRIBUTES.ATTRIBUTE1%type,
314: P_ATTRIBUTE2 in BNE_ATTRIBUTES.ATTRIBUTE2%type,
315: P_ATTRIBUTE3 in BNE_ATTRIBUTES.ATTRIBUTE3%type,
316: P_ATTRIBUTE4 in BNE_ATTRIBUTES.ATTRIBUTE4%type,
317: P_ATTRIBUTE5 in BNE_ATTRIBUTES.ATTRIBUTE5%type,
318: P_ATTRIBUTE6 in BNE_ATTRIBUTES.ATTRIBUTE6%type,
311:
312: FUNCTION CREATE_ATTRIBUTES_MINIMAL (P_ATTRIBUTE_CODE in BNE_ATTRIBUTES.ATTRIBUTE_CODE%type,
313: P_ATTRIBUTE1 in BNE_ATTRIBUTES.ATTRIBUTE1%type,
314: P_ATTRIBUTE2 in BNE_ATTRIBUTES.ATTRIBUTE2%type,
315: P_ATTRIBUTE3 in BNE_ATTRIBUTES.ATTRIBUTE3%type,
316: P_ATTRIBUTE4 in BNE_ATTRIBUTES.ATTRIBUTE4%type,
317: P_ATTRIBUTE5 in BNE_ATTRIBUTES.ATTRIBUTE5%type,
318: P_ATTRIBUTE6 in BNE_ATTRIBUTES.ATTRIBUTE6%type,
319: P_ATTRIBUTE7 in BNE_ATTRIBUTES.ATTRIBUTE7%type,
312: FUNCTION CREATE_ATTRIBUTES_MINIMAL (P_ATTRIBUTE_CODE in BNE_ATTRIBUTES.ATTRIBUTE_CODE%type,
313: P_ATTRIBUTE1 in BNE_ATTRIBUTES.ATTRIBUTE1%type,
314: P_ATTRIBUTE2 in BNE_ATTRIBUTES.ATTRIBUTE2%type,
315: P_ATTRIBUTE3 in BNE_ATTRIBUTES.ATTRIBUTE3%type,
316: P_ATTRIBUTE4 in BNE_ATTRIBUTES.ATTRIBUTE4%type,
317: P_ATTRIBUTE5 in BNE_ATTRIBUTES.ATTRIBUTE5%type,
318: P_ATTRIBUTE6 in BNE_ATTRIBUTES.ATTRIBUTE6%type,
319: P_ATTRIBUTE7 in BNE_ATTRIBUTES.ATTRIBUTE7%type,
320: P_ATTRIBUTE8 in BNE_ATTRIBUTES.ATTRIBUTE8%type,
313: P_ATTRIBUTE1 in BNE_ATTRIBUTES.ATTRIBUTE1%type,
314: P_ATTRIBUTE2 in BNE_ATTRIBUTES.ATTRIBUTE2%type,
315: P_ATTRIBUTE3 in BNE_ATTRIBUTES.ATTRIBUTE3%type,
316: P_ATTRIBUTE4 in BNE_ATTRIBUTES.ATTRIBUTE4%type,
317: P_ATTRIBUTE5 in BNE_ATTRIBUTES.ATTRIBUTE5%type,
318: P_ATTRIBUTE6 in BNE_ATTRIBUTES.ATTRIBUTE6%type,
319: P_ATTRIBUTE7 in BNE_ATTRIBUTES.ATTRIBUTE7%type,
320: P_ATTRIBUTE8 in BNE_ATTRIBUTES.ATTRIBUTE8%type,
321: P_ATTRIBUTE9 in BNE_ATTRIBUTES.ATTRIBUTE9%type,
314: P_ATTRIBUTE2 in BNE_ATTRIBUTES.ATTRIBUTE2%type,
315: P_ATTRIBUTE3 in BNE_ATTRIBUTES.ATTRIBUTE3%type,
316: P_ATTRIBUTE4 in BNE_ATTRIBUTES.ATTRIBUTE4%type,
317: P_ATTRIBUTE5 in BNE_ATTRIBUTES.ATTRIBUTE5%type,
318: P_ATTRIBUTE6 in BNE_ATTRIBUTES.ATTRIBUTE6%type,
319: P_ATTRIBUTE7 in BNE_ATTRIBUTES.ATTRIBUTE7%type,
320: P_ATTRIBUTE8 in BNE_ATTRIBUTES.ATTRIBUTE8%type,
321: P_ATTRIBUTE9 in BNE_ATTRIBUTES.ATTRIBUTE9%type,
322: P_ATTRIBUTE10 in BNE_ATTRIBUTES.ATTRIBUTE10%type )
315: P_ATTRIBUTE3 in BNE_ATTRIBUTES.ATTRIBUTE3%type,
316: P_ATTRIBUTE4 in BNE_ATTRIBUTES.ATTRIBUTE4%type,
317: P_ATTRIBUTE5 in BNE_ATTRIBUTES.ATTRIBUTE5%type,
318: P_ATTRIBUTE6 in BNE_ATTRIBUTES.ATTRIBUTE6%type,
319: P_ATTRIBUTE7 in BNE_ATTRIBUTES.ATTRIBUTE7%type,
320: P_ATTRIBUTE8 in BNE_ATTRIBUTES.ATTRIBUTE8%type,
321: P_ATTRIBUTE9 in BNE_ATTRIBUTES.ATTRIBUTE9%type,
322: P_ATTRIBUTE10 in BNE_ATTRIBUTES.ATTRIBUTE10%type )
323:
316: P_ATTRIBUTE4 in BNE_ATTRIBUTES.ATTRIBUTE4%type,
317: P_ATTRIBUTE5 in BNE_ATTRIBUTES.ATTRIBUTE5%type,
318: P_ATTRIBUTE6 in BNE_ATTRIBUTES.ATTRIBUTE6%type,
319: P_ATTRIBUTE7 in BNE_ATTRIBUTES.ATTRIBUTE7%type,
320: P_ATTRIBUTE8 in BNE_ATTRIBUTES.ATTRIBUTE8%type,
321: P_ATTRIBUTE9 in BNE_ATTRIBUTES.ATTRIBUTE9%type,
322: P_ATTRIBUTE10 in BNE_ATTRIBUTES.ATTRIBUTE10%type )
323:
324: RETURN BNE_ATTRIBUTES.ATTRIBUTE_CODE%type as VN_KEY BNE_ATTRIBUTES.ATTRIBUTE_CODE%type;
317: P_ATTRIBUTE5 in BNE_ATTRIBUTES.ATTRIBUTE5%type,
318: P_ATTRIBUTE6 in BNE_ATTRIBUTES.ATTRIBUTE6%type,
319: P_ATTRIBUTE7 in BNE_ATTRIBUTES.ATTRIBUTE7%type,
320: P_ATTRIBUTE8 in BNE_ATTRIBUTES.ATTRIBUTE8%type,
321: P_ATTRIBUTE9 in BNE_ATTRIBUTES.ATTRIBUTE9%type,
322: P_ATTRIBUTE10 in BNE_ATTRIBUTES.ATTRIBUTE10%type )
323:
324: RETURN BNE_ATTRIBUTES.ATTRIBUTE_CODE%type as VN_KEY BNE_ATTRIBUTES.ATTRIBUTE_CODE%type;
325:
318: P_ATTRIBUTE6 in BNE_ATTRIBUTES.ATTRIBUTE6%type,
319: P_ATTRIBUTE7 in BNE_ATTRIBUTES.ATTRIBUTE7%type,
320: P_ATTRIBUTE8 in BNE_ATTRIBUTES.ATTRIBUTE8%type,
321: P_ATTRIBUTE9 in BNE_ATTRIBUTES.ATTRIBUTE9%type,
322: P_ATTRIBUTE10 in BNE_ATTRIBUTES.ATTRIBUTE10%type )
323:
324: RETURN BNE_ATTRIBUTES.ATTRIBUTE_CODE%type as VN_KEY BNE_ATTRIBUTES.ATTRIBUTE_CODE%type;
325:
326: BEGIN
320: P_ATTRIBUTE8 in BNE_ATTRIBUTES.ATTRIBUTE8%type,
321: P_ATTRIBUTE9 in BNE_ATTRIBUTES.ATTRIBUTE9%type,
322: P_ATTRIBUTE10 in BNE_ATTRIBUTES.ATTRIBUTE10%type )
323:
324: RETURN BNE_ATTRIBUTES.ATTRIBUTE_CODE%type as VN_KEY BNE_ATTRIBUTES.ATTRIBUTE_CODE%type;
325:
326: BEGIN
327:
328: VN_KEY := CREATE_ATTRIBUTES(FND_GLOBAL.RESP_APPL_ID, P_ATTRIBUTE_CODE,P_ATTRIBUTE1, P_ATTRIBUTE2, P_ATTRIBUTE3, P_ATTRIBUTE4,