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 163: VV_CONTENT_CODE BNE_CONTENTS_B.CONTENT_CODE%TYPE;

159: P_USER_ID IN NUMBER,
160: P_CONTENT_CODE OUT NOCOPY VARCHAR2,
161: P_ONCE_ONLY_DOWNLOAD_FLAG IN VARCHAR2 DEFAULT 'N')
162: IS
163: VV_CONTENT_CODE BNE_CONTENTS_B.CONTENT_CODE%TYPE;
164:
165: BEGIN
166:
167: -- Only create the Content if the OBJECT_CODE supplied is VALID.

Line 183: FROM BNE_CONTENTS_B

179:
180: BEGIN
181: SELECT CONTENT_CODE
182: INTO VV_CONTENT_CODE
183: FROM BNE_CONTENTS_B
184: WHERE APPLICATION_ID = P_APPLICATION_ID
185: AND CONTENT_CODE = P_CONTENT_CODE
186: AND INTEGRATOR_APP_ID = P_APPLICATION_ID
187: AND INTEGRATOR_CODE = P_INTEGRATOR_CODE;

Line 196: -- Insert a new record into BNE_CONTENTS_B

192: -- If this is a new Content, create it, otherwise Update it.
193:
194: IF (VV_CONTENT_CODE IS NULL) THEN
195:
196: -- Insert a new record into BNE_CONTENTS_B
197:
198: INSERT INTO BNE_CONTENTS_B
199: (APPLICATION_ID, CONTENT_CODE, INTEGRATOR_APP_ID, INTEGRATOR_CODE, OBJECT_VERSION_NUMBER,
200: CONTENT_CLASS, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, ONCE_ONLY_DOWNLOAD_FLAG)

Line 198: INSERT INTO BNE_CONTENTS_B

194: IF (VV_CONTENT_CODE IS NULL) THEN
195:
196: -- Insert a new record into BNE_CONTENTS_B
197:
198: INSERT INTO BNE_CONTENTS_B
199: (APPLICATION_ID, CONTENT_CODE, INTEGRATOR_APP_ID, INTEGRATOR_CODE, OBJECT_VERSION_NUMBER,
200: CONTENT_CLASS, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, ONCE_ONLY_DOWNLOAD_FLAG)
201: VALUES
202: (P_APPLICATION_ID, P_CONTENT_CODE, P_APPLICATION_ID, P_INTEGRATOR_CODE, 1,

Line 214: -- Update table BNE_CONTENTS_B

210: VALUES
211: (P_APPLICATION_ID, P_CONTENT_CODE, P_LANGUAGE, P_SOURCE_LANGUAGE, P_DESCRIPTION, P_USER_ID, SYSDATE,
212: P_USER_ID, SYSDATE);
213: ELSE
214: -- Update table BNE_CONTENTS_B
215:
216: UPDATE BNE_CONTENTS_B
217: SET OBJECT_VERSION_NUMBER = (OBJECT_VERSION_NUMBER + 1),
218: CONTENT_CLASS = P_CONTENT_CLASS,

Line 216: UPDATE BNE_CONTENTS_B

212: P_USER_ID, SYSDATE);
213: ELSE
214: -- Update table BNE_CONTENTS_B
215:
216: UPDATE BNE_CONTENTS_B
217: SET OBJECT_VERSION_NUMBER = (OBJECT_VERSION_NUMBER + 1),
218: CONTENT_CLASS = P_CONTENT_CLASS,
219: LAST_UPDATED_BY = P_USER_ID,
220: LAST_UPDATE_DATE = SYSDATE

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

239:
240: --------------------------------------------------------------------------------
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. --

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

275: P_CONTENT_CODE := NULL;
276: VN_PARAM_LIST_APP_ID := 231;
277: VV_PARAM_LIST_CODE := 'CONT_TEXT_FILE1';
278:
279: -- Create or update the record in the BNE_CONTENTS_B/TL tables
280:
281: CREATE_CONTENT(P_APPLICATION_ID,
282: P_OBJECT_CODE,
283: P_INTEGRATOR_CODE,

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

429:
430: --------------------------------------------------------------------------------
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 --

Line 462: VV_CONTENT_CODE BNE_CONTENTS_B.CONTENT_CODE%TYPE;

458: P_USER_ID IN NUMBER,
459: P_CONTENT_CODE OUT NOCOPY VARCHAR2,
460: P_ONCE_ONLY_DOWNLOAD_FLAG IN VARCHAR2 DEFAULT 'N')
461: IS
462: VV_CONTENT_CODE BNE_CONTENTS_B.CONTENT_CODE%TYPE;
463: VN_COL_NUM NUMBER;
464: VN_CURR_POS NUMBER;
465: VN_PREV_POS NUMBER;
466: VN_START_POS NUMBER;

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

469:
470: BEGIN
471: P_CONTENT_CODE := NULL;
472:
473: -- Create or update the record in the BNE_CONTENTS_B/TL tables
474:
475: CREATE_CONTENT(P_APPLICATION_ID,
476: P_OBJECT_CODE,
477: P_INTEGRATOR_CODE,

Line 795: VV_CONTENT_CODE BNE_CONTENTS_B.CONTENT_CODE%TYPE;

791: P_USER_ID IN NUMBER,
792: P_INTERFACE_CODE OUT NOCOPY VARCHAR2,
793: P_MAPPING_CODE OUT NOCOPY VARCHAR2)
794: IS
795: VV_CONTENT_CODE BNE_CONTENTS_B.CONTENT_CODE%TYPE;
796: BEGIN
797:
798: IF BNE_INTEGRATOR_UTILS.IS_VALID_APPL_ID(P_APPLICATION_ID) AND
799: BNE_INTEGRATOR_UTILS.IS_VALID_OBJECT_CODE(P_OBJECT_CODE) THEN

Line 808: FROM BNE_CONTENTS_B

804:
805: BEGIN
806: SELECT CONTENT_CODE
807: INTO VV_CONTENT_CODE
808: FROM BNE_CONTENTS_B
809: WHERE APPLICATION_ID = P_APPLICATION_ID
810: AND CONTENT_CODE = P_CONTENT_CODE
811: AND INTEGRATOR_APP_ID = P_APPLICATION_ID
812: AND INTEGRATOR_CODE = P_INTEGRATOR_CODE;

Line 1196: FROM BNE_CONTENTS_B

1192:
1193: BEGIN
1194: SELECT CONTENT_CODE
1195: INTO VV_CONTENT_CODE
1196: FROM BNE_CONTENTS_B
1197: WHERE APPLICATION_ID = P_CONTENT_APP_ID
1198: AND CONTENT_CODE = P_CONTENT_CODE;
1199: EXCEPTION
1200: WHEN NO_DATA_FOUND THEN NULL;

Line 1221: UPDATE BNE_CONTENTS_B

1217: -- Only assign the Parameter List to the Content if they both exist
1218:
1219: IF (VV_CONTENT_CODE IS NOT NULL) AND (VV_PARAM_LIST_CODE IS NOT NULL) THEN
1220:
1221: UPDATE BNE_CONTENTS_B
1222: SET PARAM_LIST_APP_ID = P_PARAM_LIST_APP_ID,
1223: PARAM_LIST_CODE = P_PARAM_LIST_CODE,
1224: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
1225: WHERE APPLICATION_ID = P_CONTENT_APP_ID