APPS.CSI_CTR_PROPERTY_TEMPLATE_PKG dependencies on CSI_CTR_PROPERTY_TEMPLATE_TL

Line 132: INSERT INTO CSI_CTR_PROPERTY_TEMPLATE_TL(

128: ,decode(p_PROPERTY_LOV_TYPE, FND_API.G_MISS_CHAR, NULL, p_PROPERTY_LOV_TYPE)
129: ,decode(p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM, NULL,p_SECURITY_GROUP_ID)
130: );
131:
132: INSERT INTO CSI_CTR_PROPERTY_TEMPLATE_TL(
133: COUNTER_PROPERTY_ID
134: ,NAME
135: ,DESCRIPTION
136: ,LANGUAGE

Line 159: FROM csi_ctr_property_template_tl cct

155: ,decode(p_migrated_flag, fnd_api.g_miss_char, NULL, p_migrated_flag)
156: FROM fnd_languages L
157: WHERE L.installed_flag IN ('I','B')
158: AND NOT EXISTS (SELECT 'x'
159: FROM csi_ctr_property_template_tl cct
160: WHERE cct.counter_property_id = px_counter_property_id
161: AND cct.language = L.language_code);
162: End Insert_Row;
163:

Line 244: UPDATE CSI_CTR_PROPERTY_TEMPLATE_TL

240: ,PROPERTY_LOV_TYPE = decode(p_PROPERTY_LOV_TYPE, NULL, PROPERTY_LOV_TYPE, FND_API.G_MISS_CHAR, NULL, p_PROPERTY_LOV_TYPE)
241: ,SECURITY_GROUP_ID = decode(p_SECURITY_GROUP_ID, NULL, SECURITY_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_SECURITY_GROUP_ID)
242: WHERE COUNTER_PROPERTY_ID = p_COUNTER_PROPERTY_ID;
243:
244: UPDATE CSI_CTR_PROPERTY_TEMPLATE_TL
245: SET source_lang = userenv('LANG'),
246: name = decode(p_name, NULL, name, fnd_api.g_miss_char, NULL, p_name),
247: description = decode(p_description, NULL, description, fnd_api.g_miss_char, NULL, p_description),
248: created_by = decode(p_created_by, NULL, created_by, fnd_api.g_miss_num, NULL, p_created_by),

Line 322: FROM CSI_CTR_PROPERTY_TEMPLATE_TL

318: CURSOR c2 IS
319: SELECT name,
320: description,
321: decode(language, userenv('LANG'), 'Y', 'N') baselang
322: FROM CSI_CTR_PROPERTY_TEMPLATE_TL
323: WHERE counter_property_id = p_counter_property_id
324: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG)
325: FOR UPDATE OF counter_property_id NOWAIT;
326: BEGIN

Line 364: DELETE FROM CSI_CTR_PROPERTY_TEMPLATE_TL t

360: END Lock_Row;
361:
362: PROCEDURE add_language IS
363: BEGIN
364: DELETE FROM CSI_CTR_PROPERTY_TEMPLATE_TL t
365: WHERE NOT EXISTS (SELECT NULL
366: FROM CSI_CTR_PROPERTY_TEMPLATE_B b
367: WHERE b.counter_property_id = t.counter_property_id);
368:

Line 369: UPDATE CSI_CTR_PROPERTY_TEMPLATE_TL t

365: WHERE NOT EXISTS (SELECT NULL
366: FROM CSI_CTR_PROPERTY_TEMPLATE_B b
367: WHERE b.counter_property_id = t.counter_property_id);
368:
369: UPDATE CSI_CTR_PROPERTY_TEMPLATE_TL t
370: SET (name,description) = (SELECT b.name,
371: b.description
372: FROM CSI_CTR_PROPERTY_TEMPLATE_TL b
373: WHERE b.counter_property_id = t.counter_property_id

Line 372: FROM CSI_CTR_PROPERTY_TEMPLATE_TL b

368:
369: UPDATE CSI_CTR_PROPERTY_TEMPLATE_TL t
370: SET (name,description) = (SELECT b.name,
371: b.description
372: FROM CSI_CTR_PROPERTY_TEMPLATE_TL b
373: WHERE b.counter_property_id = t.counter_property_id
374: AND b.language = t.source_lang)
375: WHERE (t.counter_property_id,t.language) IN (SELECT subt.counter_property_id,
376: subt.language

Line 377: FROM CSI_CTR_PROPERTY_TEMPLATE_TL subb, CSI_CTR_PROPERTY_TEMPLATE_TL subt

373: WHERE b.counter_property_id = t.counter_property_id
374: AND b.language = t.source_lang)
375: WHERE (t.counter_property_id,t.language) IN (SELECT subt.counter_property_id,
376: subt.language
377: FROM CSI_CTR_PROPERTY_TEMPLATE_TL subb, CSI_CTR_PROPERTY_TEMPLATE_TL subt
378: WHERE subb.counter_property_id = subt.counter_property_id
379: AND subb.language = subt.source_lang
380: AND (subb.name <> subt.name
381: OR subb.description <> subt.description

Line 387: INSERT INTO CSI_CTR_PROPERTY_TEMPLATE_TL(

383: OR (subb.description iS NOT NULL AND subt.description IS NULL)
384: )
385: );
386:
387: INSERT INTO CSI_CTR_PROPERTY_TEMPLATE_TL(
388: counter_property_id,
389: name,
390: description,
391: last_update_date,

Line 409: FROM CSI_CTR_PROPERTY_TEMPLATE_TL b, fnd_languages l

405: b.created_by,
406: b.last_update_login,
407: l.language_code,
408: b.source_lang
409: FROM CSI_CTR_PROPERTY_TEMPLATE_TL b, fnd_languages l
410: WHERE l.installed_flag in ('I', 'B')
411: AND b.language = userenv('LANG')
412: AND NOT EXISTS (SELECT NULL
413: FROM CSI_CTR_PROPERTY_TEMPLATE_TL t

Line 413: FROM CSI_CTR_PROPERTY_TEMPLATE_TL t

409: FROM CSI_CTR_PROPERTY_TEMPLATE_TL b, fnd_languages l
410: WHERE l.installed_flag in ('I', 'B')
411: AND b.language = userenv('LANG')
412: AND NOT EXISTS (SELECT NULL
413: FROM CSI_CTR_PROPERTY_TEMPLATE_TL t
414: WHERE t.counter_property_id = b.counter_property_id
415: AND t.language = l.language_code);
416: END add_language;
417:

Line 424: UPDATE CSI_CTR_PROPERTY_TEMPLATE_TL

420: ,p_name IN VARCHAR2
421: ,p_description IN VARCHAR2
422: ,p_owner IN VARCHAR2) IS
423: BEGIN
424: UPDATE CSI_CTR_PROPERTY_TEMPLATE_TL
425: SET name = p_name,
426: description = p_description,
427: last_update_date = sysdate,
428: last_updated_by = decode(p_owner, 'SEED', 1, 0),