DBA Data[Home] [Help]

APPS.BNE_INTEGRATOR_UTILS dependencies on BNE_PARAM_LISTS_TL

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 384: -- Insert a new record into the BNE_PARAM_LISTS_TL table

380: (P_APPLICATION_ID, P_PARAM_LIST_CODE, 1, VV_PERSISTENT, P_PARAM_LIST_NAME,
381: P_APPLICATION_ID, VV_ATTRIBUTE_CODE, P_USER_ID, SYSDATE,
382: P_USER_ID, SYSDATE);
383:
384: -- Insert a new record into the BNE_PARAM_LISTS_TL table
385:
386: INSERT INTO BNE_PARAM_LISTS_TL
387: (APPLICATION_ID, PARAM_LIST_CODE, LANGUAGE, SOURCE_LANG, USER_NAME,
388: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE)

Line 386: INSERT INTO BNE_PARAM_LISTS_TL

382: P_USER_ID, SYSDATE);
383:
384: -- Insert a new record into the BNE_PARAM_LISTS_TL table
385:
386: INSERT INTO BNE_PARAM_LISTS_TL
387: (APPLICATION_ID, PARAM_LIST_CODE, LANGUAGE, SOURCE_LANG, USER_NAME,
388: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE)
389: VALUES
390: (P_APPLICATION_ID, P_PARAM_LIST_CODE, P_LANGUAGE, P_SOURCE_LANG, P_PARAM_LIST_NAME,

Line 5232: DELETE FROM BNE_PARAM_LISTS_TL

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
5233: WHERE APPLICATION_ID = P_APPLICATION_ID
5234: AND PARAM_LIST_CODE = P_PARAM_LIST_CODE;
5235:
5236: DELETE FROM BNE_PARAM_LIST_ITEMS