APPS.CSC_PROF_BLOCKS_PKG dependencies on CSC_PROF_BLOCKS_TL

Line 131: INSERT INTO CSC_PROF_BLOCKS_TL (

127:
128: -- assigning the out parameters
129: x_object_version_number := l_object_version_number;
130:
131: INSERT INTO CSC_PROF_BLOCKS_TL (
132: BLOCK_ID,
133: BLOCK_NAME,
134: DESCRIPTION,
135: CREATED_BY,

Line 157: FROM CSC_PROF_BLOCKS_TL T

153: FROM FND_LANGUAGES L
154: WHERE L.INSTALLED_FLAG in ('I', 'B')
155: AND not exists
156: (SELECT NULL
157: FROM CSC_PROF_BLOCKS_TL T
158: WHERE T.BLOCK_ID = PX_BLOCK_ID
159: AND T.LANGUAGE = L.LANGUAGE_CODE);
160:
161: End Insert_Row;

Line 219: UPDATE CSC_PROF_BLOCKS_TL

215: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
216: APPLICATION_ID = p_application_id
217: where BLOCK_ID = p_BLOCK_ID
218: RETURNING OBJECT_VERSION_NUMBER INTO px_OBJECT_VERSION_NUMBER;
219: UPDATE CSC_PROF_BLOCKS_TL
220: SET BLOCK_NAME = p_BLOCK_NAME,
221: DESCRIPTION = p_DESCRIPTION,
222: LAST_UPDATE_DATE = p_LAST_UPDATE_DATE,
223: LAST_UPDATED_BY = p_LAST_UPDATED_BY,

Line 249: from CSC_PROF_BLOCKS_TL

245:
246: cursor c1 is select
247: BLOCK_NAME,
248: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
249: from CSC_PROF_BLOCKS_TL
250: where BLOCK_ID = P_BLOCK_ID
251: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
252: for update of BLOCK_ID nowait;
253: begin

Line 270: delete from CSC_PROF_BLOCKS_TL

266: P_BLOCK_ID NUMBER,
267: P_OBJECT_VERSION_NUMBER NUMBER
268: ) is
269: begin
270: delete from CSC_PROF_BLOCKS_TL
271: where BLOCK_ID = P_BLOCK_ID;
272:
273: if (sql%notfound) then
274: raise no_data_found;

Line 289: delete from CSC_PROF_BLOCKS_TL T

285:
286: procedure ADD_LANGUAGE
287: is
288: begin
289: delete from CSC_PROF_BLOCKS_TL T
290: where not exists
291: (select NULL
292: from CSC_PROF_BLOCKS_B B
293: where B.BLOCK_ID = T.BLOCK_ID

Line 296: update CSC_PROF_BLOCKS_TL T set (

292: from CSC_PROF_BLOCKS_B B
293: where B.BLOCK_ID = T.BLOCK_ID
294: );
295:
296: update CSC_PROF_BLOCKS_TL T set (
297: BLOCK_NAME,
298: DESCRIPTION
299: ) = (select
300: B.BLOCK_NAME,

Line 302: from CSC_PROF_BLOCKS_TL B

298: DESCRIPTION
299: ) = (select
300: B.BLOCK_NAME,
301: B.DESCRIPTION
302: from CSC_PROF_BLOCKS_TL B
303: where B.BLOCK_ID = T.BLOCK_ID
304: and B.LANGUAGE = T.SOURCE_LANG)
305: where (
306: T.BLOCK_ID,

Line 311: from CSC_PROF_BLOCKS_TL SUBB, CSC_PROF_BLOCKS_TL SUBT

307: T.LANGUAGE
308: ) in (select
309: SUBT.BLOCK_ID,
310: SUBT.LANGUAGE
311: from CSC_PROF_BLOCKS_TL SUBB, CSC_PROF_BLOCKS_TL SUBT
312: where SUBB.BLOCK_ID = SUBT.BLOCK_ID
313: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
314: and (SUBB.BLOCK_NAME <> SUBT.BLOCK_NAME
315: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 320: insert into CSC_PROF_BLOCKS_TL (

316: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
317: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
318: ));
319:
320: insert into CSC_PROF_BLOCKS_TL (
321: BLOCK_ID,
322: BLOCK_NAME,
323: DESCRIPTION,
324: CREATED_BY,

Line 342: from CSC_PROF_BLOCKS_TL B, FND_LANGUAGES L

338: B.LAST_UPDATE_DATE,
339: B.LAST_UPDATE_LOGIN,
340: L.LANGUAGE_CODE,
341: B.SOURCE_LANG
342: from CSC_PROF_BLOCKS_TL B, FND_LANGUAGES L
343: where L.INSTALLED_FLAG in ('I', 'B')
344: and B.LANGUAGE = userenv('LANG')
345: and not exists
346: (select NULL

Line 347: from CSC_PROF_BLOCKS_TL T

343: where L.INSTALLED_FLAG in ('I', 'B')
344: and B.LANGUAGE = userenv('LANG')
345: and not exists
346: (select NULL
347: from CSC_PROF_BLOCKS_TL T
348: where T.BLOCK_ID = B.BLOCK_ID
349: and T.LANGUAGE = L.LANGUAGE_CODE);
350: end ADD_LANGUAGE;
351:

Line 359: Update Csc_Prof_Blocks_TL set

355: p_description VARCHAR2,
356: p_owner VARCHAR2)
357: IS
358: Begin
359: Update Csc_Prof_Blocks_TL set
360: block_name = nvl(p_block_name,block_name),
361: description = nvl(p_description,description),
362: last_update_date = sysdate,
363: last_updated_by = fnd_load_util.owner_id(p_owner),