APPS.AR_CMGT_DP_TABLE_HANDLER dependencies on AR_CMGT_DATA_POINTS_TL

Line 67: INSERT INTO AR_CMGT_DATA_POINTS_TL

63: p_data_point_sub_category,
64: p_data_point_code
65: );
66:
67: INSERT INTO AR_CMGT_DATA_POINTS_TL
68: ( data_point_id,
69: data_point_name,
70: description,
71: LANGUAGE,

Line 93: from AR_CMGT_DATA_POINTS_TL t

89: p_application_id
90: from fnd_languages l
91: where l.installed_flag in ('B','I')
92: and not exists (select NULL
93: from AR_CMGT_DATA_POINTS_TL t
94: where T.data_point_id = p_data_point_id
95: and T.LANGUAGE = L.LANGUAGE_CODE);
96:
97:

Line 168: INSERT INTO AR_CMGT_DATA_POINTS_TL

164: p_return_date_format,
165: p_data_point_code
166: );
167:
168: INSERT INTO AR_CMGT_DATA_POINTS_TL
169: ( data_point_id,
170: data_point_name,
171: description,
172: LANGUAGE,

Line 195: from AR_CMGT_DATA_POINTS_TL t

191: p_application_id
192: from fnd_languages l
193: where l.installed_flag in ('B','I')
194: and not exists (select NULL
195: from AR_CMGT_DATA_POINTS_TL t
196: where T.data_point_id = p_data_point_id
197: and T.LANGUAGE = L.LANGUAGE_CODE);
198:
199:

Line 245: update ar_cmgt_data_points_tl

241:
242: if (sql%notfound) then
243: raise no_data_found;
244: end if;
245: update ar_cmgt_data_points_tl
246: set data_point_name = p_DATA_POINT_NAME,
247: description = p_DESCRIPTION,
248: application_id = p_application_id,
249: last_update_date = sysdate,

Line 303: update ar_cmgt_data_points_tl

299:
300: if (sql%notfound) then
301: raise no_data_found;
302: end if;
303: update ar_cmgt_data_points_tl
304: set data_point_name = p_DATA_POINT_NAME,
305: description = p_description,
306: application_id = p_application_id,
307: last_update_date = sysdate,

Line 330: delete from ar_cmgt_data_points_tl

326: if (sql%notfound) then
327: raise no_data_found;
328: end if;
329:
330: delete from ar_cmgt_data_points_tl
331: where data_point_id = p_data_point_id;
332:
333: if (sql%notfound) then
334: raise no_data_found;

Line 341: delete from AR_CMGT_DATA_POINTS_TL T

337:
338: procedure ADD_LANGUAGE
339: is
340: begin
341: delete from AR_CMGT_DATA_POINTS_TL T
342: where not exists
343: (select NULL
344: from AR_CMGT_DATA_POINTS_B B
345: where B.DATA_POINT_ID = T.DATA_POINT_ID

Line 348: update AR_CMGT_DATA_POINTS_TL T set (

344: from AR_CMGT_DATA_POINTS_B B
345: where B.DATA_POINT_ID = T.DATA_POINT_ID
346: );
347:
348: update AR_CMGT_DATA_POINTS_TL T set (
349: data_point_NAME,
350: DESCRIPTION
351: ) = (select
352: B.data_point_NAME,

Line 354: from AR_CMGT_DATA_POINTS_TL B

350: DESCRIPTION
351: ) = (select
352: B.data_point_NAME,
353: B.DESCRIPTION
354: from AR_CMGT_DATA_POINTS_TL B
355: where B.data_point_id = T.data_point_id
356: and B.LANGUAGE = T.SOURCE_LANG)
357: where (
358: T.data_point_ID,

Line 363: from AR_CMGT_DATA_POINTS_TL SUBB, AR_CMGT_DATA_POINTS_TL SUBT

359: T.LANGUAGE
360: ) in (select
361: SUBT.data_point_ID,
362: SUBT.LANGUAGE
363: from AR_CMGT_DATA_POINTS_TL SUBB, AR_CMGT_DATA_POINTS_TL SUBT
364: where SUBB.data_point_id = SUBT.data_point_ID
365: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
366: and (SUBB.DATA_POINT_NAME <> SUBT.DATA_POINT_NAME
367: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 372: INSERT INTO AR_CMGT_DATA_POINTS_TL

368: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
369: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
370: ));
371:
372: INSERT INTO AR_CMGT_DATA_POINTS_TL
373: ( data_point_id,
374: data_point_name,
375: description,
376: LANGUAGE,

Line 395: FROM ar_cmgt_data_points_tl t, fnd_languages l

391: t.last_update_date,
392: t.created_by,
393: t.creation_date,
394: t.last_update_login
395: FROM ar_cmgt_data_points_tl t, fnd_languages l
396: WHERE l.installed_flag in ( 'I', 'B')
397: AND t.language = userenv('LANG')
398: AND not exists ( select NULL FROM
399: ar_cmgt_data_points_tl t1

Line 399: ar_cmgt_data_points_tl t1

395: FROM ar_cmgt_data_points_tl t, fnd_languages l
396: WHERE l.installed_flag in ( 'I', 'B')
397: AND t.language = userenv('LANG')
398: AND not exists ( select NULL FROM
399: ar_cmgt_data_points_tl t1
400: where t1.data_point_id = t.data_point_id
401: and t1.language = l.language_code);
402: end ADD_LANGUAGE;
403:

Line 413: update AR_CMGT_DATA_POINTS_TL

409: begin
410:
411: -- only update rows that have not been altered by user
412:
413: update AR_CMGT_DATA_POINTS_TL
414: set description = p_description,
415: DATA_POINT_NAME = p_data_point_name,
416: source_lang = userenv('LANG'),
417: last_update_date = sysdate,

Line 503: update AR_CMGT_DATA_POINTS_TL

499: begin
500:
501: -- only update rows that have not been altered by user
502:
503: update AR_CMGT_DATA_POINTS_TL
504: set description = p_description,
505: data_point_name = p_data_point_name,
506: source_lang = userenv('LANG'),
507: last_update_date = sysdate,