APPS.BNE_INTEGRATOR_UTILS dependencies on BNE_PARAM_LISTS_B

Line 233: -- Inserts into tables BNE_PARAM_LISTS_B/TL, --

229: -- the API Parameters and the Parameter List Items for --
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: -- --

Line 312: VV_PERSISTENT BNE_PARAM_LISTS_B.PERSISTENT_FLAG%TYPE;

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;
316: VV_TEMP_ATTRIBUTE_CODE := NULL;

Line 333: FROM BNE_PARAM_LISTS_B A, BNE_PARAM_LISTS_TL B

329:
330: BEGIN
331: SELECT A.PARAM_LIST_CODE
332: INTO P_PARAM_LIST_CODE
333: FROM BNE_PARAM_LISTS_B A, BNE_PARAM_LISTS_TL B
334: WHERE A.APPLICATION_ID = B.APPLICATION_ID
335: AND A.PARAM_LIST_CODE = B.PARAM_LIST_CODE
336: AND B.LANGUAGE = P_LANGUAGE
337: AND A.APPLICATION_ID = P_APPLICATION_ID

Line 373: -- Insert a new record into the BNE_PARAM_LISTS_B table

369: END;
370:
371: IF (VV_TEMP_ATTRIBUTE_CODE IS NULL) THEN
372:
373: -- Insert a new record into the BNE_PARAM_LISTS_B table
374:
375: INSERT INTO BNE_PARAM_LISTS_B
376: (APPLICATION_ID, PARAM_LIST_CODE, OBJECT_VERSION_NUMBER, PERSISTENT_FLAG, COMMENTS,
377: ATTRIBUTE_APP_ID, ATTRIBUTE_CODE, CREATED_BY, CREATION_DATE,

Line 375: INSERT INTO BNE_PARAM_LISTS_B

371: IF (VV_TEMP_ATTRIBUTE_CODE IS NULL) THEN
372:
373: -- Insert a new record into the BNE_PARAM_LISTS_B table
374:
375: INSERT INTO BNE_PARAM_LISTS_B
376: (APPLICATION_ID, PARAM_LIST_CODE, OBJECT_VERSION_NUMBER, PERSISTENT_FLAG, COMMENTS,
377: ATTRIBUTE_APP_ID, ATTRIBUTE_CODE, CREATED_BY, CREATION_DATE,
378: LAST_UPDATED_BY, LAST_UPDATE_DATE)
379: VALUES

Line 5165: FROM BNE_PARAM_LISTS_B

5161: VV_QUERY_CODE VARCHAR2(30);
5162: BEGIN
5163: SELECT COUNT(*)
5164: INTO VV_COUNT
5165: FROM BNE_PARAM_LISTS_B
5166: WHERE APPLICATION_ID = P_APPLICATION_ID
5167: AND PARAM_LIST_CODE = P_PARAM_LIST_CODE;
5168:
5169: IF VV_COUNT = 0

Line 5180: FROM BNE_PARAM_LISTS_B

5176: SELECT ATTRIBUTE_APP_ID, ATTRIBUTE_CODE
5177: BULK COLLECT
5178: INTO VV_ATTRIBUTE_KEYS
5179: FROM (SELECT ATTRIBUTE_APP_ID, ATTRIBUTE_CODE
5180: FROM BNE_PARAM_LISTS_B
5181: WHERE APPLICATION_ID = P_APPLICATION_ID
5182: AND PARAM_LIST_CODE = P_PARAM_LIST_CODE
5183: AND ATTRIBUTE_APP_ID IS NOT NULL
5184: AND ATTRIBUTE_CODE IS NOT NULL

Line 5228: DELETE FROM BNE_PARAM_LISTS_B

5224: WHEN NO_DATA_FOUND THEN NULL;
5225: END;
5226:
5227:
5228: DELETE FROM BNE_PARAM_LISTS_B
5229: WHERE APPLICATION_ID = P_APPLICATION_ID
5230: AND PARAM_LIST_CODE = P_PARAM_LIST_CODE;
5231:
5232: DELETE FROM BNE_PARAM_LISTS_TL

Line 5313: AND NOT EXISTS (SELECT 1 FROM BNE_PARAM_LISTS_B

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
5315: AND ATTRIBUTE_CODE = VV_ATTRIBUTE_KEYS(I).CODE)
5316: AND NOT EXISTS (SELECT 1
5317: FROM BNE_PARAM_GROUPS_B