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 37: -- BNE_CONTENT_COLS_B/_TL table. --

33: --------------------------------------------------------------------------------
34: -- PROCEDURE: UPSERT_CONTENT_COL --
35: -- --
36: -- DESCRIPTION: Procedure inserts or updates a single column in the --
37: -- BNE_CONTENT_COLS_B/_TL table. --
38: -- This procedure will only update the COL_NAME, --
39: -- and USER_NAME column values. --
40: -- The column to be inserted/updated will be determined by --
41: -- the APPLICATION_ID, CONTENT_CODE and SEQUENCE_NUM --

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

58: P_READ_ONLY_FLAG IN VARCHAR2)
59: IS
60: VN_NO_RECORD_FLAG NUMBER;
61: BEGIN
62: -- Check the BNE_CONTENT_COLS_B table to ensure that the Content Column
63: -- does not already exist
64:
65: VN_NO_RECORD_FLAG := 0;
66:

Line 70: FROM BNE_CONTENT_COLS_B

66:
67: BEGIN
68: SELECT 1
69: INTO VN_NO_RECORD_FLAG
70: FROM BNE_CONTENT_COLS_B
71: WHERE APPLICATION_ID = P_APPLICATION_ID
72: AND CONTENT_CODE = P_CONTENT_CODE
73: AND SEQUENCE_NUM = P_SEQUENCE_NUM;
74: EXCEPTION

Line 82: -- Insert the required row in BNE_CONTENT_COLS_B

78: -- If the Content Column was not found then insert it
79:
80: IF (VN_NO_RECORD_FLAG = 0) THEN
81:
82: -- Insert the required row in BNE_CONTENT_COLS_B
83:
84: INSERT INTO BNE_CONTENT_COLS_B
85: (APPLICATION_ID, CONTENT_CODE, SEQUENCE_NUM, OBJECT_VERSION_NUMBER, COL_NAME,
86: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN,

Line 84: INSERT INTO BNE_CONTENT_COLS_B

80: IF (VN_NO_RECORD_FLAG = 0) THEN
81:
82: -- Insert the required row in BNE_CONTENT_COLS_B
83:
84: INSERT INTO BNE_CONTENT_COLS_B
85: (APPLICATION_ID, CONTENT_CODE, SEQUENCE_NUM, OBJECT_VERSION_NUMBER, COL_NAME,
86: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN,
87: READ_ONLY_FLAG)
88: VALUES

Line 106: -- Update the required row in BNE_CONTENT_COLS_B

102: P_USER_ID, SYSDATE, P_USER_ID, SYSDATE, P_USER_ID);
103:
104: END IF;
105: ELSE
106: -- Update the required row in BNE_CONTENT_COLS_B
107:
108: UPDATE BNE_CONTENT_COLS_B
109: SET OBJECT_VERSION_NUMBER = (OBJECT_VERSION_NUMBER + 1),
110: COL_NAME = P_COL_NAME,

Line 108: UPDATE BNE_CONTENT_COLS_B

104: END IF;
105: ELSE
106: -- Update the required row in BNE_CONTENT_COLS_B
107:
108: UPDATE BNE_CONTENT_COLS_B
109: SET OBJECT_VERSION_NUMBER = (OBJECT_VERSION_NUMBER + 1),
110: COL_NAME = P_COL_NAME,
111: LAST_UPDATED_BY = P_USER_ID,
112: LAST_UPDATE_DATE = SYSDATE,

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

241: -- PROCEDURE: CREATE_CONTENT_TEXT --
242: -- --
243: -- DESCRIPTION: Inserts or updates records in the BNE_CONTENTS_B/TL --
244: -- tables and inserts records into the --
245: -- BNE_CONTENT_COLS_B/TL tables if columns do not --
246: -- already exist for the APPLICATION_ID and --
247: -- CONTENT_CODE. --
248: -- --
249: -- MODIFICATION HISTORY --

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

431: -- PROCEDURE: CREATE_CONTENT_DYNAMIC_SQL --
432: -- --
433: -- DESCRIPTION: Inserts or updates records in the BNE_CONTENTS_B/TL --
434: -- tables and inserts records into the --
435: -- BNE_CONTENT_COLS_B/TL tables from a comma delimited --
436: -- list of columns. Columns are only inserted if they --
437: -- do not already exist for the APPLICATION_ID and --
438: -- CONTENT_CODE. --
439: -- --

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

586: P_LANGUAGE IN VARCHAR2,
587: P_SOURCE_LANGUAGE IN VARCHAR2,
588: P_USER_ID IN NUMBER)
589: IS
590: VV_CONTENT_CODE BNE_CONTENT_COLS_B.CONTENT_CODE%TYPE;
591: VV_ORACLE_USER VARCHAR2(20);
592: BEGIN
593:
594: -- Check for existing Content Cols for the Content

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

624:
625: -- If new Content, then Create
626: IF (VV_CONTENT_CODE IS NULL) THEN
627:
628: -- Insert new record into BNE_CONTENT_COLS_B table
629:
630: INSERT INTO BNE_CONTENT_COLS_B
631: (APPLICATION_ID, CONTENT_CODE, OBJECT_VERSION_NUMBER, SEQUENCE_NUM, COL_NAME,
632: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE)

Line 630: INSERT INTO BNE_CONTENT_COLS_B

626: IF (VV_CONTENT_CODE IS NULL) THEN
627:
628: -- Insert new record into BNE_CONTENT_COLS_B table
629:
630: INSERT INTO BNE_CONTENT_COLS_B
631: (APPLICATION_ID, CONTENT_CODE, OBJECT_VERSION_NUMBER, SEQUENCE_NUM, COL_NAME,
632: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE)
633: SELECT P_APPLICATION_ID APPLICATION_ID,
634: P_CONTENT_CODE CONTENT_CODE,

Line 892: FROM BNE_CONTENT_COLS_B CC,

888: CC.SEQUENCE_NUM CONTENT_SEQ_NUM,
889: IC.APPLICATION_ID INTERFACE_APP_ID,
890: IC.INTERFACE_CODE,
891: IC.SEQUENCE_NUM INTERFACE_SEQ_NUM
892: FROM BNE_CONTENT_COLS_B CC,
893: BNE_INTERFACE_COLS_B IC
894: WHERE CC.APPLICATION_ID = IC.APPLICATION_ID
895: AND CC.APPLICATION_ID = CP_APPLICATION_ID
896: AND CC.COL_NAME = IC.INTERFACE_COL_NAME

Line 1045: FROM BNE_CONTENT_COLS_B CC,

1041: CC.SEQUENCE_NUM CONTENT_SEQ_NUM,
1042: IC.APPLICATION_ID INTERFACE_APP_ID,
1043: IC.INTERFACE_CODE,
1044: IC.SEQUENCE_NUM INTERFACE_SEQ_NUM
1045: FROM BNE_CONTENT_COLS_B CC,
1046: BNE_INTERFACE_COLS_B IC
1047: WHERE CC.APPLICATION_ID = IC.APPLICATION_ID
1048: AND CC.APPLICATION_ID = CP_APPLICATION_ID
1049: AND ( CC.COL_NAME = IC.INTERFACE_COL_NAME