APPS.CSC_PROF_CHECKS_PKG dependencies on CSC_PROF_CHECKS_TL

Line 120: INSERT INTO CSC_PROF_CHECKS_TL(

116: l_OBJECT_VERSION_NUMBER,
117: decode( p_APPLICATION_ID,G_MISS_NUM, NULL, p_APPLICATION_ID) );
118:
119:
120: INSERT INTO CSC_PROF_CHECKS_TL(
121: CHECK_ID,
122: CHECK_NAME,
123: DESCRIPTION,
124: CREATED_BY,

Line 146: from CSC_PROF_CHECKS_TL T

142: FROM FND_LANGUAGES L
143: WHERE L.INSTALLED_FLAG in ('I', 'B')
144: AND not exists
145: (select NULL
146: from CSC_PROF_CHECKS_TL T
147: where T.CHECK_ID = Px_CHECK_ID
148: and T.LANGUAGE = L.LANGUAGE_CODE);
149:
150: --set out parameters

Line 202: UPDATE CSC_PROF_CHECKS_TL SET

198: APPLICATION_ID= p_APPLICATION_ID
199: WHERE CHECK_ID = p_CHECK_ID
200: RETURNING OBJECT_VERSION_NUMBER INTO px_object_version_number;
201:
202: UPDATE CSC_PROF_CHECKS_TL SET
203: CHECK_NAME = p_CHECK_NAME,
204: DESCRIPTION = p_DESCRIPTION,
205: LAST_UPDATED_BY = p_LAST_UPDATED_BY,
206: LAST_UPDATE_DATE = p_LAST_UPDATE_DATE,

Line 245: from CSC_PROF_CHECKS_TL

241:
242: cursor c1 is select
243: CHECK_NAME,
244: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
245: from CSC_PROF_CHECKS_TL
246: where CHECK_ID = P_CHECK_ID
247: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
248: for update of CHECK_ID nowait;
249: begin

Line 266: delete from CSC_PROF_CHECKS_TL

262: P_CHECK_ID NUMBER,
263: P_OBJECT_VERSION_NUMBER NUMBER
264: ) is
265: begin
266: delete from CSC_PROF_CHECKS_TL
267: where CHECK_ID = P_CHECK_ID;
268:
269: if (sql%notfound) then
270: raise no_data_found;

Line 285: delete from CSC_PROF_CHECKS_TL T

281:
282: procedure ADD_LANGUAGE
283: is
284: begin
285: delete from CSC_PROF_CHECKS_TL T
286: where not exists
287: (select NULL
288: from CSC_PROF_CHECKS_B B
289: where B.CHECK_ID = T.CHECK_ID

Line 292: update CSC_PROF_CHECKS_TL T set (

288: from CSC_PROF_CHECKS_B B
289: where B.CHECK_ID = T.CHECK_ID
290: );
291:
292: update CSC_PROF_CHECKS_TL T set (
293: CHECK_NAME,
294: DESCRIPTION
295: ) = (select
296: B.CHECK_NAME,

Line 298: from CSC_PROF_CHECKS_TL B

294: DESCRIPTION
295: ) = (select
296: B.CHECK_NAME,
297: B.DESCRIPTION
298: from CSC_PROF_CHECKS_TL B
299: where B.CHECK_ID = T.CHECK_ID
300: and B.LANGUAGE = T.SOURCE_LANG)
301: where (
302: T.CHECK_ID,

Line 307: from CSC_PROF_CHECKS_TL SUBB, CSC_PROF_CHECKS_TL SUBT

303: T.LANGUAGE
304: ) in (select
305: SUBT.CHECK_ID,
306: SUBT.LANGUAGE
307: from CSC_PROF_CHECKS_TL SUBB, CSC_PROF_CHECKS_TL SUBT
308: where SUBB.CHECK_ID = SUBT.CHECK_ID
309: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
310: and (SUBB.CHECK_NAME <> SUBT.CHECK_NAME
311: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 316: insert into CSC_PROF_CHECKS_TL (

312: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
313: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
314: ));
315:
316: insert into CSC_PROF_CHECKS_TL (
317: CHECK_ID,
318: CHECK_NAME,
319: DESCRIPTION,
320: CREATED_BY,

Line 338: from CSC_PROF_CHECKS_TL B, FND_LANGUAGES L

334: B.LAST_UPDATE_DATE,
335: B.LAST_UPDATE_LOGIN,
336: L.LANGUAGE_CODE,
337: B.SOURCE_LANG
338: from CSC_PROF_CHECKS_TL B, FND_LANGUAGES L
339: where L.INSTALLED_FLAG in ('I', 'B')
340: and B.LANGUAGE = userenv('LANG')
341: and not exists
342: (select NULL

Line 343: from CSC_PROF_CHECKS_TL T

339: where L.INSTALLED_FLAG in ('I', 'B')
340: and B.LANGUAGE = userenv('LANG')
341: and not exists
342: (select NULL
343: from CSC_PROF_CHECKS_TL T
344: where T.CHECK_ID = B.CHECK_ID
345: and T.LANGUAGE = L.LANGUAGE_CODE);
346: end ADD_LANGUAGE;
347:

Line 355: Update Csc_Prof_Checks_TL set

351: p_DESCRIPTION VARCHAR2,
352: p_owner varchar2)
353: IS
354: BEGIN
355: Update Csc_Prof_Checks_TL set
356: check_name = p_check_name,
357: description = nvl(p_description,description),
358: last_update_date = sysdate,
359: last_updated_by = fnd_load_util.owner_id(p_owner),