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_CONTENTS_B

Line 156: VV_CONTENT_CODE BNE_CONTENTS_B.CONTENT_CODE%TYPE;

152: P_USER_ID IN NUMBER,
153: P_CONTENT_CODE OUT NOCOPY VARCHAR2,
154: P_ONCE_ONLY_DOWNLOAD_FLAG IN VARCHAR2 DEFAULT 'N')
155: IS
156: VV_CONTENT_CODE BNE_CONTENTS_B.CONTENT_CODE%TYPE;
157:
158: BEGIN
159:
160: -- Only create the Content if the OBJECT_CODE supplied is VALID.

Line 176: FROM BNE_CONTENTS_B

172:
173: BEGIN
174: SELECT CONTENT_CODE
175: INTO VV_CONTENT_CODE
176: FROM BNE_CONTENTS_B
177: WHERE APPLICATION_ID = P_APPLICATION_ID
178: AND CONTENT_CODE = P_CONTENT_CODE
179: AND INTEGRATOR_APP_ID = P_APPLICATION_ID
180: AND INTEGRATOR_CODE = P_INTEGRATOR_CODE;

Line 189: -- Insert a new record into BNE_CONTENTS_B

185: -- If this is a new Content, create it, otherwise Update it.
186:
187: IF (VV_CONTENT_CODE IS NULL) THEN
188:
189: -- Insert a new record into BNE_CONTENTS_B
190:
191: INSERT INTO BNE_CONTENTS_B
192: (APPLICATION_ID, CONTENT_CODE, INTEGRATOR_APP_ID, INTEGRATOR_CODE, OBJECT_VERSION_NUMBER,
193: CONTENT_CLASS, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, ONCE_ONLY_DOWNLOAD_FLAG)

Line 191: INSERT INTO BNE_CONTENTS_B

187: IF (VV_CONTENT_CODE IS NULL) THEN
188:
189: -- Insert a new record into BNE_CONTENTS_B
190:
191: INSERT INTO BNE_CONTENTS_B
192: (APPLICATION_ID, CONTENT_CODE, INTEGRATOR_APP_ID, INTEGRATOR_CODE, OBJECT_VERSION_NUMBER,
193: CONTENT_CLASS, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, ONCE_ONLY_DOWNLOAD_FLAG)
194: VALUES
195: (P_APPLICATION_ID, P_CONTENT_CODE, P_APPLICATION_ID, P_INTEGRATOR_CODE, 1,

Line 207: -- Update table BNE_CONTENTS_B

203: VALUES
204: (P_APPLICATION_ID, P_CONTENT_CODE, P_LANGUAGE, P_SOURCE_LANGUAGE, P_DESCRIPTION, P_USER_ID, SYSDATE,
205: P_USER_ID, SYSDATE);
206: ELSE
207: -- Update table BNE_CONTENTS_B
208:
209: UPDATE BNE_CONTENTS_B
210: SET OBJECT_VERSION_NUMBER = (OBJECT_VERSION_NUMBER + 1),
211: CONTENT_CLASS = P_CONTENT_CLASS,

Line 209: UPDATE BNE_CONTENTS_B

205: P_USER_ID, SYSDATE);
206: ELSE
207: -- Update table BNE_CONTENTS_B
208:
209: UPDATE BNE_CONTENTS_B
210: SET OBJECT_VERSION_NUMBER = (OBJECT_VERSION_NUMBER + 1),
211: CONTENT_CLASS = P_CONTENT_CLASS,
212: LAST_UPDATED_BY = P_USER_ID,
213: LAST_UPDATE_DATE = SYSDATE

Line 236: -- DESCRIPTION: Inserts or updates records in the BNE_CONTENTS_B/TL --

232:
233: --------------------------------------------------------------------------------
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. --

Line 272: -- Create or update the record in the BNE_CONTENTS_B/TL tables

268: P_CONTENT_CODE := NULL;
269: VN_PARAM_LIST_APP_ID := 231;
270: VV_PARAM_LIST_CODE := 'CONT_TEXT_FILE1';
271:
272: -- Create or update the record in the BNE_CONTENTS_B/TL tables
273:
274: CREATE_CONTENT(P_APPLICATION_ID,
275: P_OBJECT_CODE,
276: P_INTEGRATOR_CODE,

Line 426: -- DESCRIPTION: Inserts or updates records in the BNE_CONTENTS_B/TL --

422:
423: --------------------------------------------------------------------------------
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 --

Line 455: VV_CONTENT_CODE BNE_CONTENTS_B.CONTENT_CODE%TYPE;

451: P_USER_ID IN NUMBER,
452: P_CONTENT_CODE OUT NOCOPY VARCHAR2,
453: P_ONCE_ONLY_DOWNLOAD_FLAG IN VARCHAR2 DEFAULT 'N')
454: IS
455: VV_CONTENT_CODE BNE_CONTENTS_B.CONTENT_CODE%TYPE;
456: VN_COL_NUM NUMBER;
457: VN_CURR_POS NUMBER;
458: VN_PREV_POS NUMBER;
459: VN_START_POS NUMBER;

Line 466: -- Create or update the record in the BNE_CONTENTS_B/TL tables

462:
463: BEGIN
464: P_CONTENT_CODE := NULL;
465:
466: -- Create or update the record in the BNE_CONTENTS_B/TL tables
467:
468: CREATE_CONTENT(P_APPLICATION_ID,
469: P_OBJECT_CODE,
470: P_INTEGRATOR_CODE,

Line 757: VV_CONTENT_CODE BNE_CONTENTS_B.CONTENT_CODE%TYPE;

753: P_USER_ID IN NUMBER,
754: P_INTERFACE_CODE OUT NOCOPY VARCHAR2,
755: P_MAPPING_CODE OUT NOCOPY VARCHAR2)
756: IS
757: VV_CONTENT_CODE BNE_CONTENTS_B.CONTENT_CODE%TYPE;
758: BEGIN
759:
760: IF BNE_INTEGRATOR_UTILS.IS_VALID_APPL_ID(P_APPLICATION_ID) AND
761: BNE_INTEGRATOR_UTILS.IS_VALID_OBJECT_CODE(P_OBJECT_CODE) THEN

Line 770: FROM BNE_CONTENTS_B

766:
767: BEGIN
768: SELECT CONTENT_CODE
769: INTO VV_CONTENT_CODE
770: FROM BNE_CONTENTS_B
771: WHERE APPLICATION_ID = P_APPLICATION_ID
772: AND CONTENT_CODE = P_CONTENT_CODE
773: AND INTEGRATOR_APP_ID = P_APPLICATION_ID
774: AND INTEGRATOR_CODE = P_INTEGRATOR_CODE;

Line 1158: FROM BNE_CONTENTS_B

1154:
1155: BEGIN
1156: SELECT CONTENT_CODE
1157: INTO VV_CONTENT_CODE
1158: FROM BNE_CONTENTS_B
1159: WHERE APPLICATION_ID = P_CONTENT_APP_ID
1160: AND CONTENT_CODE = P_CONTENT_CODE;
1161: EXCEPTION
1162: WHEN NO_DATA_FOUND THEN NULL;

Line 1183: UPDATE BNE_CONTENTS_B

1179: -- Only assign the Parameter List to the Content if they both exist
1180:
1181: IF (VV_CONTENT_CODE IS NOT NULL) AND (VV_PARAM_LIST_CODE IS NOT NULL) THEN
1182:
1183: UPDATE BNE_CONTENTS_B
1184: SET PARAM_LIST_APP_ID = P_PARAM_LIST_APP_ID,
1185: PARAM_LIST_CODE = P_PARAM_LIST_CODE,
1186: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
1187: WHERE APPLICATION_ID = P_CONTENT_APP_ID