eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BNE_CONTENT_UTILS dependencies on BNE_CONTENT_COLS_B

Line 30: -- BNE_CONTENT_COLS_B/_TL table. --

26: --------------------------------------------------------------------------------
27: -- PROCEDURE: UPSERT_CONTENT_COL --
28: -- --
29: -- DESCRIPTION: Procedure inserts or updates a single column in the --
30: -- BNE_CONTENT_COLS_B/_TL table. --
31: -- This procedure will only update the COL_NAME, --
32: -- and USER_NAME column values. --
33: -- The column to be inserted/updated will be determined by --
34: -- the APPLICATION_ID, CONTENT_CODE and SEQUENCE_NUM --

Line 55: -- Check the BNE_CONTENT_COLS_B table to ensure that the Content Column

51: P_READ_ONLY_FLAG IN VARCHAR2)
52: IS
53: VN_NO_RECORD_FLAG NUMBER;
54: BEGIN
55: -- Check the BNE_CONTENT_COLS_B table to ensure that the Content Column
56: -- does not already exist
57:
58: VN_NO_RECORD_FLAG := 0;
59:

Line 63: FROM BNE_CONTENT_COLS_B

59:
60: BEGIN
61: SELECT 1
62: INTO VN_NO_RECORD_FLAG
63: FROM BNE_CONTENT_COLS_B
64: WHERE APPLICATION_ID = P_APPLICATION_ID
65: AND CONTENT_CODE = P_CONTENT_CODE
66: AND SEQUENCE_NUM = P_SEQUENCE_NUM;
67: EXCEPTION

Line 75: -- Insert the required row in BNE_CONTENT_COLS_B

71: -- If the Content Column was not found then insert it
72:
73: IF (VN_NO_RECORD_FLAG = 0) THEN
74:
75: -- Insert the required row in BNE_CONTENT_COLS_B
76:
77: INSERT INTO BNE_CONTENT_COLS_B
78: (APPLICATION_ID, CONTENT_CODE, SEQUENCE_NUM, OBJECT_VERSION_NUMBER, COL_NAME,
79: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN,

Line 77: INSERT INTO BNE_CONTENT_COLS_B

73: IF (VN_NO_RECORD_FLAG = 0) THEN
74:
75: -- Insert the required row in BNE_CONTENT_COLS_B
76:
77: INSERT INTO BNE_CONTENT_COLS_B
78: (APPLICATION_ID, CONTENT_CODE, SEQUENCE_NUM, OBJECT_VERSION_NUMBER, COL_NAME,
79: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN,
80: READ_ONLY_FLAG)
81: VALUES

Line 99: -- Update the required row in BNE_CONTENT_COLS_B

95: P_USER_ID, SYSDATE, P_USER_ID, SYSDATE, P_USER_ID);
96:
97: END IF;
98: ELSE
99: -- Update the required row in BNE_CONTENT_COLS_B
100:
101: UPDATE BNE_CONTENT_COLS_B
102: SET OBJECT_VERSION_NUMBER = (OBJECT_VERSION_NUMBER + 1),
103: COL_NAME = P_COL_NAME,

Line 101: UPDATE BNE_CONTENT_COLS_B

97: END IF;
98: ELSE
99: -- Update the required row in BNE_CONTENT_COLS_B
100:
101: UPDATE BNE_CONTENT_COLS_B
102: SET OBJECT_VERSION_NUMBER = (OBJECT_VERSION_NUMBER + 1),
103: COL_NAME = P_COL_NAME,
104: LAST_UPDATED_BY = P_USER_ID,
105: LAST_UPDATE_DATE = SYSDATE,

Line 238: -- BNE_CONTENT_COLS_B/TL tables if columns do not --

234: -- PROCEDURE: CREATE_CONTENT_TEXT --
235: -- --
236: -- DESCRIPTION: Inserts or updates records in the BNE_CONTENTS_B/TL --
237: -- tables and inserts records into the --
238: -- BNE_CONTENT_COLS_B/TL tables if columns do not --
239: -- already exist for the APPLICATION_ID and --
240: -- CONTENT_CODE. --
241: -- --
242: -- MODIFICATION HISTORY --

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 428: -- BNE_CONTENT_COLS_B/TL tables from a comma delimited --

424: -- PROCEDURE: CREATE_CONTENT_DYNAMIC_SQL --
425: -- --
426: -- DESCRIPTION: Inserts or updates records in the BNE_CONTENTS_B/TL --
427: -- tables and inserts records into the --
428: -- BNE_CONTENT_COLS_B/TL tables from a comma delimited --
429: -- list of columns. Columns are only inserted if they --
430: -- do not already exist for the APPLICATION_ID and --
431: -- CONTENT_CODE. --
432: -- --

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 583: VV_CONTENT_CODE BNE_CONTENT_COLS_B.CONTENT_CODE%TYPE;

579: P_LANGUAGE IN VARCHAR2,
580: P_SOURCE_LANGUAGE IN VARCHAR2,
581: P_USER_ID IN NUMBER)
582: IS
583: VV_CONTENT_CODE BNE_CONTENT_COLS_B.CONTENT_CODE%TYPE;
584: VV_ORACLE_USER VARCHAR2(20);
585: BEGIN
586:
587: -- Check for existing Content Cols for the Content

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 621: -- Insert new record into BNE_CONTENT_COLS_B table

617:
618: -- If new Content, then Create
619: IF (VV_CONTENT_CODE IS NULL) THEN
620:
621: -- Insert new record into BNE_CONTENT_COLS_B table
622:
623: INSERT INTO BNE_CONTENT_COLS_B
624: (APPLICATION_ID, CONTENT_CODE, OBJECT_VERSION_NUMBER, SEQUENCE_NUM, COL_NAME,
625: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE)

Line 623: INSERT INTO BNE_CONTENT_COLS_B

619: IF (VV_CONTENT_CODE IS NULL) THEN
620:
621: -- Insert new record into BNE_CONTENT_COLS_B table
622:
623: INSERT INTO BNE_CONTENT_COLS_B
624: (APPLICATION_ID, CONTENT_CODE, OBJECT_VERSION_NUMBER, SEQUENCE_NUM, COL_NAME,
625: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE)
626: SELECT P_APPLICATION_ID APPLICATION_ID,
627: P_CONTENT_CODE CONTENT_CODE,

Line 854: FROM BNE_CONTENT_COLS_B CC,

850: CC.SEQUENCE_NUM CONTENT_SEQ_NUM,
851: IC.APPLICATION_ID INTERFACE_APP_ID,
852: IC.INTERFACE_CODE,
853: IC.SEQUENCE_NUM INTERFACE_SEQ_NUM
854: FROM BNE_CONTENT_COLS_B CC,
855: BNE_INTERFACE_COLS_B IC
856: WHERE CC.APPLICATION_ID = IC.APPLICATION_ID
857: AND CC.APPLICATION_ID = CP_APPLICATION_ID
858: AND CC.COL_NAME = IC.INTERFACE_COL_NAME

Line 1007: FROM BNE_CONTENT_COLS_B CC,

1003: CC.SEQUENCE_NUM CONTENT_SEQ_NUM,
1004: IC.APPLICATION_ID INTERFACE_APP_ID,
1005: IC.INTERFACE_CODE,
1006: IC.SEQUENCE_NUM INTERFACE_SEQ_NUM
1007: FROM BNE_CONTENT_COLS_B CC,
1008: BNE_INTERFACE_COLS_B IC
1009: WHERE CC.APPLICATION_ID = IC.APPLICATION_ID
1010: AND CC.APPLICATION_ID = CP_APPLICATION_ID
1011: AND ( CC.COL_NAME = IC.INTERFACE_COL_NAME