APPS.BNE_CONTENT_UTILS dependencies on BNE_CONTENT_COLS_TL

Line 93: -- Insert the required row in BNE_CONTENT_COLS_TL only where P_LANGUAGE is populated

89: (P_APPLICATION_ID, P_CONTENT_CODE, P_SEQUENCE_NUM, 1, P_COL_NAME,
90: P_USER_ID, SYSDATE, P_USER_ID, SYSDATE, P_USER_ID,
91: P_READ_ONLY_FLAG);
92:
93: -- Insert the required row in BNE_CONTENT_COLS_TL only where P_LANGUAGE is populated
94:
95: IF (P_LANGUAGE IS NOT NULL) THEN
96:
97: INSERT INTO BNE_CONTENT_COLS_TL

Line 97: INSERT INTO BNE_CONTENT_COLS_TL

93: -- Insert the required row in BNE_CONTENT_COLS_TL only where P_LANGUAGE is populated
94:
95: IF (P_LANGUAGE IS NOT NULL) THEN
96:
97: INSERT INTO BNE_CONTENT_COLS_TL
98: (APPLICATION_ID, CONTENT_CODE, SEQUENCE_NUM, LANGUAGE, SOURCE_LANG, USER_NAME,
99: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)
100: VALUES
101: (P_APPLICATION_ID, P_CONTENT_CODE, P_SEQUENCE_NUM, P_LANGUAGE, P_SOURCE_LANGUAGE, P_DESCRIPTION,

Line 119: -- Update the required row in BNE_CONTENT_COLS_TL ONLY WHERE P_LANGUAGE POPULATED

115: WHERE APPLICATION_ID = P_APPLICATION_ID
116: AND CONTENT_CODE = P_CONTENT_CODE
117: AND SEQUENCE_NUM = P_SEQUENCE_NUM;
118:
119: -- Update the required row in BNE_CONTENT_COLS_TL ONLY WHERE P_LANGUAGE POPULATED
120:
121: IF (P_LANGUAGE IS NOT NULL) THEN
122:
123: UPDATE BNE_CONTENT_COLS_TL

Line 123: UPDATE BNE_CONTENT_COLS_TL

119: -- Update the required row in BNE_CONTENT_COLS_TL ONLY WHERE P_LANGUAGE POPULATED
120:
121: IF (P_LANGUAGE IS NOT NULL) THEN
122:
123: UPDATE BNE_CONTENT_COLS_TL
124: SET USER_NAME = P_DESCRIPTION,
125: LAST_UPDATED_BY = P_USER_ID,
126: LAST_UPDATE_DATE = SYSDATE,
127: LAST_UPDATE_LOGIN = P_USER_ID

Line 298: FROM BNE_CONTENT_COLS_B A, BNE_CONTENT_COLS_TL B

294:
295: BEGIN
296: SELECT DISTINCT A.CONTENT_CODE
297: INTO VV_CONTENT_CODE
298: FROM BNE_CONTENT_COLS_B A, BNE_CONTENT_COLS_TL B
299: WHERE A.APPLICATION_ID = B.APPLICATION_ID
300: AND A.CONTENT_CODE = B.CONTENT_CODE
301: AND A.APPLICATION_ID = P_APPLICATION_ID
302: AND A.CONTENT_CODE = P_CONTENT_CODE

Line 493: FROM BNE_CONTENT_COLS_B A, BNE_CONTENT_COLS_TL B

489:
490: BEGIN
491: SELECT DISTINCT A.CONTENT_CODE
492: INTO VV_CONTENT_CODE
493: FROM BNE_CONTENT_COLS_B A, BNE_CONTENT_COLS_TL B
494: WHERE A.APPLICATION_ID = B.APPLICATION_ID
495: AND A.CONTENT_CODE = B.CONTENT_CODE
496: AND A.APPLICATION_ID = P_APPLICATION_ID
497: AND A.CONTENT_CODE = P_CONTENT_CODE

Line 541: -- insert the column into BNE_CONTENT_COLS_B and BNE_CONTENT_COLS_TL

537: SELECT TRIM(' ' FROM (SUBSTR(P_COL_LIST, VN_START_POS, (VN_CURR_POS - VN_PREV_POS - 1))))
538: INTO VV_COL_NAME
539: FROM SYS.DUAL;
540:
541: -- insert the column into BNE_CONTENT_COLS_B and BNE_CONTENT_COLS_TL
542:
543: UPSERT_CONTENT_COL(P_APPLICATION_ID,
544: P_CONTENT_CODE,
545: VN_COL_NUM,

Line 600: FROM BNE_CONTENT_COLS_B A, BNE_CONTENT_COLS_TL B

596: VV_CONTENT_CODE := NULL;
597: BEGIN
598: SELECT DISTINCT A.CONTENT_CODE
599: INTO VV_CONTENT_CODE
600: FROM BNE_CONTENT_COLS_B A, BNE_CONTENT_COLS_TL B
601: WHERE A.APPLICATION_ID = B.APPLICATION_ID
602: AND A.CONTENT_CODE = B.CONTENT_CODE
603: AND A.SEQUENCE_NUM = B.SEQUENCE_NUM
604: AND A.APPLICATION_ID = P_APPLICATION_ID

Line 662: -- Insert new record into BNE_CONTENT_COLS_TL table

658: WHERE ATC.VIEW_ID=TAB.VIEW_ID
659: AND TAB.VIEW_NAME=P_VIEW_NAME;
660:
661:
662: -- Insert new record into BNE_CONTENT_COLS_TL table
663:
664: INSERT INTO BNE_CONTENT_COLS_TL
665: (APPLICATION_ID, CONTENT_CODE, SEQUENCE_NUM, LANGUAGE, SOURCE_LANG, USER_NAME,
666: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE)

Line 664: INSERT INTO BNE_CONTENT_COLS_TL

660:
661:
662: -- Insert new record into BNE_CONTENT_COLS_TL table
663:
664: INSERT INTO BNE_CONTENT_COLS_TL
665: (APPLICATION_ID, CONTENT_CODE, SEQUENCE_NUM, LANGUAGE, SOURCE_LANG, USER_NAME,
666: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE)
667: SELECT P_APPLICATION_ID APPLICATION_ID,
668: P_CONTENT_CODE CONTENT_CODE,