DBA Data[Home] [Help]

APPS.BNE_INTEGRATOR_UTILS dependencies on BNE_PARAM_LISTS_TL

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

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

Line 387: INSERT INTO BNE_PARAM_LISTS_TL

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

Line 5141: DELETE FROM BNE_PARAM_LISTS_TL

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
5142: WHERE APPLICATION_ID = P_APPLICATION_ID
5143: AND PARAM_LIST_CODE = P_PARAM_LIST_CODE;
5144:
5145: DELETE FROM BNE_PARAM_LIST_ITEMS