APPS.BNE_INTEGRATOR_UTILS dependencies on BNE_PARAM_LISTS_B

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

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

Line 313: VV_PERSISTENT BNE_PARAM_LISTS_B.PERSISTENT_FLAG%TYPE;

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

Line 334: FROM BNE_PARAM_LISTS_B A, BNE_PARAM_LISTS_TL B

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

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

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

Line 376: INSERT INTO BNE_PARAM_LISTS_B

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

Line 5074: FROM BNE_PARAM_LISTS_B

5070: VV_QUERY_CODE VARCHAR2(30);
5071: BEGIN
5072: SELECT COUNT(*)
5073: INTO VV_COUNT
5074: FROM BNE_PARAM_LISTS_B
5075: WHERE APPLICATION_ID = P_APPLICATION_ID
5076: AND PARAM_LIST_CODE = P_PARAM_LIST_CODE;
5077:
5078: IF VV_COUNT = 0

Line 5089: FROM BNE_PARAM_LISTS_B

5085: SELECT ATTRIBUTE_APP_ID, ATTRIBUTE_CODE
5086: BULK COLLECT
5087: INTO VV_ATTRIBUTE_KEYS
5088: FROM (SELECT ATTRIBUTE_APP_ID, ATTRIBUTE_CODE
5089: FROM BNE_PARAM_LISTS_B
5090: WHERE APPLICATION_ID = P_APPLICATION_ID
5091: AND PARAM_LIST_CODE = P_PARAM_LIST_CODE
5092: AND ATTRIBUTE_APP_ID IS NOT NULL
5093: AND ATTRIBUTE_CODE IS NOT NULL

Line 5137: DELETE FROM BNE_PARAM_LISTS_B

5133: WHEN NO_DATA_FOUND THEN NULL;
5134: END;
5135:
5136:
5137: DELETE FROM BNE_PARAM_LISTS_B
5138: WHERE APPLICATION_ID = P_APPLICATION_ID
5139: AND PARAM_LIST_CODE = P_PARAM_LIST_CODE;
5140:
5141: DELETE FROM BNE_PARAM_LISTS_TL

Line 5222: AND NOT EXISTS (SELECT 1 FROM BNE_PARAM_LISTS_B

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

Line 5588: FROM bne_param_lists_b

5584:
5585: SELECT APPLICATION_ID, PARAM_LIST_CODE
5586: BULK COLLECT
5587: INTO VV_LIST_KEYS
5588: FROM bne_param_lists_b
5589: WHERE application_id
5590: || ':'
5591: || param_list_code IN
5592: (SELECT String_value