APPS.BNE_CONTENT_UTILS dependencies on BNE_CONTENTS_TL

Line 205: -- Insert a new record into BNE_CONTENTS_TL

201: VALUES
202: (P_APPLICATION_ID, P_CONTENT_CODE, P_APPLICATION_ID, P_INTEGRATOR_CODE, 1,
203: P_CONTENT_CLASS, P_USER_ID, SYSDATE, P_USER_ID, SYSDATE, P_ONCE_ONLY_DOWNLOAD_FLAG);
204:
205: -- Insert a new record into BNE_CONTENTS_TL
206:
207: INSERT INTO BNE_CONTENTS_TL
208: (APPLICATION_ID, CONTENT_CODE, LANGUAGE, SOURCE_LANG, USER_NAME, CREATED_BY, CREATION_DATE,
209: LAST_UPDATED_BY, LAST_UPDATE_DATE)

Line 207: INSERT INTO BNE_CONTENTS_TL

203: P_CONTENT_CLASS, P_USER_ID, SYSDATE, P_USER_ID, SYSDATE, P_ONCE_ONLY_DOWNLOAD_FLAG);
204:
205: -- Insert a new record into BNE_CONTENTS_TL
206:
207: INSERT INTO BNE_CONTENTS_TL
208: (APPLICATION_ID, CONTENT_CODE, LANGUAGE, SOURCE_LANG, USER_NAME, CREATED_BY, CREATION_DATE,
209: LAST_UPDATED_BY, LAST_UPDATE_DATE)
210: VALUES
211: (P_APPLICATION_ID, P_CONTENT_CODE, P_LANGUAGE, P_SOURCE_LANGUAGE, P_DESCRIPTION, P_USER_ID, SYSDATE,

Line 224: -- Update table BNE_CONTENTS_TL

220: LAST_UPDATE_DATE = SYSDATE
221: WHERE APPLICATION_ID = P_APPLICATION_ID
222: AND CONTENT_CODE = P_CONTENT_CODE;
223:
224: -- Update table BNE_CONTENTS_TL
225:
226: UPDATE BNE_CONTENTS_TL
227: SET LANGUAGE = P_LANGUAGE,
228: SOURCE_LANG = P_SOURCE_LANGUAGE,

Line 226: UPDATE BNE_CONTENTS_TL

222: AND CONTENT_CODE = P_CONTENT_CODE;
223:
224: -- Update table BNE_CONTENTS_TL
225:
226: UPDATE BNE_CONTENTS_TL
227: SET LANGUAGE = P_LANGUAGE,
228: SOURCE_LANG = P_SOURCE_LANGUAGE,
229: USER_NAME = P_DESCRIPTION,
230: LAST_UPDATED_BY = P_USER_ID,

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

772: -- Interface and Interface Columns, then creates a --
773: -- Mapping between the Content Cols and the Interface --
774: -- Cols. --
775: -- Both the Interface name and the Mapping Name will --
776: -- match the Content USER_NAME in the BNE_CONTENTS_TL --
777: -- table. --
778: -- --
779: -- MODIFICATION HISTORY --
780: -- Date Username Description --

Line 935: FROM BNE_CONTENTS_TL

931:
932: BEGIN
933: SELECT USER_NAME||' '||'Mapping'
934: INTO VV_MAPPING_USER_NAME
935: FROM BNE_CONTENTS_TL
936: WHERE APPLICATION_ID = P_APPLICATION_ID
937: AND CONTENT_CODE = P_CONTENT_CODE
938: AND LANGUAGE = P_LANGUAGE;
939: EXCEPTION

Line 1089: FROM BNE_CONTENTS_TL

1085:
1086: BEGIN
1087: SELECT USER_NAME||' '||'Mapping'
1088: INTO VV_MAPPING_USER_NAME
1089: FROM BNE_CONTENTS_TL
1090: WHERE APPLICATION_ID = P_APPLICATION_ID
1091: AND CONTENT_CODE = P_CONTENT_CODE
1092: AND LANGUAGE = P_LANGUAGE;
1093: EXCEPTION