APPS.BNE_CONTENT_UTILS dependencies on BNE_CONTENTS_TL

Line 198: -- Insert a new record into BNE_CONTENTS_TL

194: VALUES
195: (P_APPLICATION_ID, P_CONTENT_CODE, P_APPLICATION_ID, P_INTEGRATOR_CODE, 1,
196: P_CONTENT_CLASS, P_USER_ID, SYSDATE, P_USER_ID, SYSDATE, P_ONCE_ONLY_DOWNLOAD_FLAG);
197:
198: -- Insert a new record into BNE_CONTENTS_TL
199:
200: INSERT INTO BNE_CONTENTS_TL
201: (APPLICATION_ID, CONTENT_CODE, LANGUAGE, SOURCE_LANG, USER_NAME, CREATED_BY, CREATION_DATE,
202: LAST_UPDATED_BY, LAST_UPDATE_DATE)

Line 200: INSERT INTO BNE_CONTENTS_TL

196: P_CONTENT_CLASS, P_USER_ID, SYSDATE, P_USER_ID, SYSDATE, P_ONCE_ONLY_DOWNLOAD_FLAG);
197:
198: -- Insert a new record into BNE_CONTENTS_TL
199:
200: INSERT INTO BNE_CONTENTS_TL
201: (APPLICATION_ID, CONTENT_CODE, LANGUAGE, SOURCE_LANG, USER_NAME, CREATED_BY, CREATION_DATE,
202: LAST_UPDATED_BY, LAST_UPDATE_DATE)
203: VALUES
204: (P_APPLICATION_ID, P_CONTENT_CODE, P_LANGUAGE, P_SOURCE_LANGUAGE, P_DESCRIPTION, P_USER_ID, SYSDATE,

Line 217: -- Update table BNE_CONTENTS_TL

213: LAST_UPDATE_DATE = SYSDATE
214: WHERE APPLICATION_ID = P_APPLICATION_ID
215: AND CONTENT_CODE = P_CONTENT_CODE;
216:
217: -- Update table BNE_CONTENTS_TL
218:
219: UPDATE BNE_CONTENTS_TL
220: SET LANGUAGE = P_LANGUAGE,
221: SOURCE_LANG = P_SOURCE_LANGUAGE,

Line 219: UPDATE BNE_CONTENTS_TL

215: AND CONTENT_CODE = P_CONTENT_CODE;
216:
217: -- Update table BNE_CONTENTS_TL
218:
219: UPDATE BNE_CONTENTS_TL
220: SET LANGUAGE = P_LANGUAGE,
221: SOURCE_LANG = P_SOURCE_LANGUAGE,
222: USER_NAME = P_DESCRIPTION,
223: LAST_UPDATED_BY = P_USER_ID,

Line 738: -- match the Content USER_NAME in the BNE_CONTENTS_TL --

734: -- Interface and Interface Columns, then creates a --
735: -- Mapping between the Content Cols and the Interface --
736: -- Cols. --
737: -- Both the Interface name and the Mapping Name will --
738: -- match the Content USER_NAME in the BNE_CONTENTS_TL --
739: -- table. --
740: -- --
741: -- MODIFICATION HISTORY --
742: -- Date Username Description --

Line 897: FROM BNE_CONTENTS_TL

893:
894: BEGIN
895: SELECT USER_NAME||' '||'Mapping'
896: INTO VV_MAPPING_USER_NAME
897: FROM BNE_CONTENTS_TL
898: WHERE APPLICATION_ID = P_APPLICATION_ID
899: AND CONTENT_CODE = P_CONTENT_CODE
900: AND LANGUAGE = P_LANGUAGE;
901: EXCEPTION

Line 1051: FROM BNE_CONTENTS_TL

1047:
1048: BEGIN
1049: SELECT USER_NAME||' '||'Mapping'
1050: INTO VV_MAPPING_USER_NAME
1051: FROM BNE_CONTENTS_TL
1052: WHERE APPLICATION_ID = P_APPLICATION_ID
1053: AND CONTENT_CODE = P_CONTENT_CODE
1054: AND LANGUAGE = P_LANGUAGE;
1055: EXCEPTION