APPS.BNE_INTEGRATOR_UTILS dependencies on BNE_ATTRIBUTES

Line 234: -- BNE_ATTRIBUTES and BNE_PARAM_LIST_ITEMS. --

230: -- the API Parameters. --
231: -- If the Parameter List already exists, no new seed --
232: -- data will be generated. --
233: -- Inserts into tables BNE_PARAM_LISTS_B/TL, --
234: -- BNE_ATTRIBUTES and BNE_PARAM_LIST_ITEMS. --
235: -- --
236: -- PARAMETERS: --
237: -- --
238: -- MODIFICATION HISTORY --

Line 250: -- BNE_ATTRIBUTES table as customers will sometimes --

246: -- us a way of linking the Attributes to the Param --
247: -- List Items in order to insert ATTRIBUTE_ID in the --
248: -- BNE_PARAM_LIST_ITEMS table. --
249: -- 30-JUL-2002 KPEET Removed check for existing API call in --
250: -- BNE_ATTRIBUTES table as customers will sometimes --
251: -- need to define overloaded APIs. The check against --
252: -- BNE_PARAM_LIST is sufficient as this is based on --
253: -- the Integrator. --
254: -- 31-JUL-2002 KPEET Added ATTRIBUTE_ID to the insert statement which --

Line 310: VV_ATTRIBUTE_CODE BNE_ATTRIBUTES.ATTRIBUTE_CODE%TYPE;

306: AND A.PROCEDURE$ = CP_API_PROCEDURE_NAME
307: AND A.LEVEL# = 0
308: AND A.OVERLOAD# = CP_OVERLOAD;
309:
310: VV_ATTRIBUTE_CODE BNE_ATTRIBUTES.ATTRIBUTE_CODE%TYPE;
311: VV_TEMP_ATTRIBUTE_CODE BNE_ATTRIBUTES.ATTRIBUTE_CODE%TYPE;
312: VV_PERSISTENT BNE_PARAM_LISTS_B.PERSISTENT_FLAG%TYPE;
313: BEGIN
314: P_PARAM_LIST_CODE := NULL;

Line 311: VV_TEMP_ATTRIBUTE_CODE BNE_ATTRIBUTES.ATTRIBUTE_CODE%TYPE;

307: AND A.LEVEL# = 0
308: AND A.OVERLOAD# = CP_OVERLOAD;
309:
310: VV_ATTRIBUTE_CODE BNE_ATTRIBUTES.ATTRIBUTE_CODE%TYPE;
311: VV_TEMP_ATTRIBUTE_CODE BNE_ATTRIBUTES.ATTRIBUTE_CODE%TYPE;
312: VV_PERSISTENT BNE_PARAM_LISTS_B.PERSISTENT_FLAG%TYPE;
313: BEGIN
314: P_PARAM_LIST_CODE := NULL;
315: VV_ATTRIBUTE_CODE := NULL;

Line 364: FROM BNE_ATTRIBUTES

360:
361: BEGIN
362: SELECT DISTINCT ATTRIBUTE_CODE
363: INTO VV_TEMP_ATTRIBUTE_CODE
364: FROM BNE_ATTRIBUTES
365: WHERE APPLICATION_ID = P_APPLICATION_ID
366: AND ATTRIBUTE_CODE = VV_ATTRIBUTE_CODE;
367: EXCEPTION
368: WHEN NO_DATA_FOUND THEN NULL;

Line 396: INSERT INTO BNE_ATTRIBUTES

392:
393:
394: -- Insert the Attribute for the API Call
395:
396: INSERT INTO BNE_ATTRIBUTES
397: (APPLICATION_ID,
398: ATTRIBUTE_CODE,
399: OBJECT_VERSION_NUMBER,
400: ATTRIBUTE1,

Line 433: INSERT INTO BNE_ATTRIBUTES

429:
430:
431: -- Generate the Attributes for the API Parameters
432:
433: INSERT INTO BNE_ATTRIBUTES
434: (APPLICATION_ID,
435: ATTRIBUTE_CODE,
436: OBJECT_VERSION_NUMBER,
437: ATTRIBUTE1,

Line 5310: DELETE FROM BNE_ATTRIBUTES A

5306: IF VV_ATTRIBUTE_KEYS.COUNT > 0
5307: THEN
5308: FOR I IN 1..VV_ATTRIBUTE_KEYS.LAST
5309: LOOP
5310: DELETE FROM BNE_ATTRIBUTES A
5311: WHERE APPLICATION_ID = VV_ATTRIBUTE_KEYS(I).APP_ID
5312: AND ATTRIBUTE_CODE = VV_ATTRIBUTE_KEYS(I).CODE
5313: AND NOT EXISTS (SELECT 1 FROM BNE_PARAM_LISTS_B
5314: WHERE ATTRIBUTE_APP_ID = VV_ATTRIBUTE_KEYS(I).APP_ID