APPS.BNE_CONTENT_UTILS dependencies on BNE_CONTENT_COLS_TL

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

82: (P_APPLICATION_ID, P_CONTENT_CODE, P_SEQUENCE_NUM, 1, P_COL_NAME,
83: P_USER_ID, SYSDATE, P_USER_ID, SYSDATE, P_USER_ID,
84: P_READ_ONLY_FLAG);
85:
86: -- Insert the required row in BNE_CONTENT_COLS_TL only where P_LANGUAGE is populated
87:
88: IF (P_LANGUAGE IS NOT NULL) THEN
89:
90: INSERT INTO BNE_CONTENT_COLS_TL

Line 90: INSERT INTO BNE_CONTENT_COLS_TL

86: -- Insert the required row in BNE_CONTENT_COLS_TL only where P_LANGUAGE is populated
87:
88: IF (P_LANGUAGE IS NOT NULL) THEN
89:
90: INSERT INTO BNE_CONTENT_COLS_TL
91: (APPLICATION_ID, CONTENT_CODE, SEQUENCE_NUM, LANGUAGE, SOURCE_LANG, USER_NAME,
92: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)
93: VALUES
94: (P_APPLICATION_ID, P_CONTENT_CODE, P_SEQUENCE_NUM, P_LANGUAGE, P_SOURCE_LANGUAGE, P_DESCRIPTION,

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

108: WHERE APPLICATION_ID = P_APPLICATION_ID
109: AND CONTENT_CODE = P_CONTENT_CODE
110: AND SEQUENCE_NUM = P_SEQUENCE_NUM;
111:
112: -- Update the required row in BNE_CONTENT_COLS_TL ONLY WHERE P_LANGUAGE POPULATED
113:
114: IF (P_LANGUAGE IS NOT NULL) THEN
115:
116: UPDATE BNE_CONTENT_COLS_TL

Line 116: UPDATE BNE_CONTENT_COLS_TL

112: -- Update the required row in BNE_CONTENT_COLS_TL ONLY WHERE P_LANGUAGE POPULATED
113:
114: IF (P_LANGUAGE IS NOT NULL) THEN
115:
116: UPDATE BNE_CONTENT_COLS_TL
117: SET USER_NAME = P_DESCRIPTION,
118: LAST_UPDATED_BY = P_USER_ID,
119: LAST_UPDATE_DATE = SYSDATE,
120: LAST_UPDATE_LOGIN = P_USER_ID

Line 291: FROM BNE_CONTENT_COLS_B A, BNE_CONTENT_COLS_TL B

287:
288: BEGIN
289: SELECT DISTINCT A.CONTENT_CODE
290: INTO VV_CONTENT_CODE
291: FROM BNE_CONTENT_COLS_B A, BNE_CONTENT_COLS_TL B
292: WHERE A.APPLICATION_ID = B.APPLICATION_ID
293: AND A.CONTENT_CODE = B.CONTENT_CODE
294: AND A.APPLICATION_ID = P_APPLICATION_ID
295: AND A.CONTENT_CODE = P_CONTENT_CODE

Line 486: FROM BNE_CONTENT_COLS_B A, BNE_CONTENT_COLS_TL B

482:
483: BEGIN
484: SELECT DISTINCT A.CONTENT_CODE
485: INTO VV_CONTENT_CODE
486: FROM BNE_CONTENT_COLS_B A, BNE_CONTENT_COLS_TL B
487: WHERE A.APPLICATION_ID = B.APPLICATION_ID
488: AND A.CONTENT_CODE = B.CONTENT_CODE
489: AND A.APPLICATION_ID = P_APPLICATION_ID
490: AND A.CONTENT_CODE = P_CONTENT_CODE

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

530: SELECT TRIM(' ' FROM (SUBSTR(P_COL_LIST, VN_START_POS, (VN_CURR_POS - VN_PREV_POS - 1))))
531: INTO VV_COL_NAME
532: FROM SYS.DUAL;
533:
534: -- insert the column into BNE_CONTENT_COLS_B and BNE_CONTENT_COLS_TL
535:
536: UPSERT_CONTENT_COL(P_APPLICATION_ID,
537: P_CONTENT_CODE,
538: VN_COL_NUM,

Line 593: FROM BNE_CONTENT_COLS_B A, BNE_CONTENT_COLS_TL B

589: VV_CONTENT_CODE := NULL;
590: BEGIN
591: SELECT DISTINCT A.CONTENT_CODE
592: INTO VV_CONTENT_CODE
593: FROM BNE_CONTENT_COLS_B A, BNE_CONTENT_COLS_TL B
594: WHERE A.APPLICATION_ID = B.APPLICATION_ID
595: AND A.CONTENT_CODE = B.CONTENT_CODE
596: AND A.SEQUENCE_NUM = B.SEQUENCE_NUM
597: AND A.APPLICATION_ID = P_APPLICATION_ID

Line 640: -- Insert new record into BNE_CONTENT_COLS_TL table

636: WHERE ATC.OWNER = VV_ORACLE_USER
637: AND ATC.TABLE_NAME = P_VIEW_NAME;
638:
639:
640: -- Insert new record into BNE_CONTENT_COLS_TL table
641:
642: INSERT INTO BNE_CONTENT_COLS_TL
643: (APPLICATION_ID, CONTENT_CODE, SEQUENCE_NUM, LANGUAGE, SOURCE_LANG, USER_NAME,
644: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE)

Line 642: INSERT INTO BNE_CONTENT_COLS_TL

638:
639:
640: -- Insert new record into BNE_CONTENT_COLS_TL table
641:
642: INSERT INTO BNE_CONTENT_COLS_TL
643: (APPLICATION_ID, CONTENT_CODE, SEQUENCE_NUM, LANGUAGE, SOURCE_LANG, USER_NAME,
644: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE)
645: SELECT P_APPLICATION_ID APPLICATION_ID,
646: P_CONTENT_CODE CONTENT_CODE,