APPS.BNE_INTEGRATOR_UTILS dependencies on BNE_ATTRIBUTES

Line 235: -- BNE_ATTRIBUTES and BNE_PARAM_LIST_ITEMS. --

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

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

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

Line 311: VV_ATTRIBUTE_CODE BNE_ATTRIBUTES.ATTRIBUTE_CODE%TYPE;

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

Line 312: VV_TEMP_ATTRIBUTE_CODE BNE_ATTRIBUTES.ATTRIBUTE_CODE%TYPE;

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

Line 365: FROM BNE_ATTRIBUTES

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

Line 397: INSERT INTO BNE_ATTRIBUTES

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

Line 434: INSERT INTO BNE_ATTRIBUTES

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

Line 5219: DELETE FROM BNE_ATTRIBUTES A

5215: IF VV_ATTRIBUTE_KEYS.COUNT > 0
5216: THEN
5217: FOR I IN 1..VV_ATTRIBUTE_KEYS.LAST
5218: LOOP
5219: DELETE FROM BNE_ATTRIBUTES A
5220: WHERE APPLICATION_ID = VV_ATTRIBUTE_KEYS(I).APP_ID
5221: AND ATTRIBUTE_CODE = VV_ATTRIBUTE_KEYS(I).CODE
5222: AND NOT EXISTS (SELECT 1 FROM BNE_PARAM_LISTS_B
5223: WHERE ATTRIBUTE_APP_ID = VV_ATTRIBUTE_KEYS(I).APP_ID