APPS.CSI_COUNTER_PROPERTIES_PKG dependencies on CSI_COUNTER_PROPERTIES_TL

Line 135: INSERT INTO CSI_COUNTER_PROPERTIES_TL(

131: ,decode(p_PROPERTY_LOV_TYPE, FND_API.G_MISS_CHAR, NULL, p_PROPERTY_LOV_TYPE)
132: ,decode(p_CREATE_FROM_CTR_PROP_TMPL_ID, FND_API.G_MISS_CHAR, NULL, p_CREATE_FROM_CTR_PROP_TMPL_ID)
133: );
134:
135: INSERT INTO CSI_COUNTER_PROPERTIES_TL(
136: COUNTER_PROPERTY_ID
137: ,NAME
138: ,DESCRIPTION
139: ,LANGUAGE

Line 164: FROM CSI_COUNTER_PROPERTIES_TL cct

160: ,decode(p_migrated_flag, fnd_api.g_miss_char, NULL, p_migrated_flag)
161: FROM fnd_languages L
162: WHERE L.installed_flag IN ('I','B')
163: AND NOT EXISTS (SELECT 'x'
164: FROM CSI_COUNTER_PROPERTIES_TL cct
165: WHERE cct.counter_property_id = px_counter_property_id
166: AND cct.language = L.language_code);
167: END Insert_Row;
168:

Line 249: UPDATE CSI_COUNTER_PROPERTIES_TL

245: ,PROPERTY_LOV_TYPE = decode(p_PROPERTY_LOV_TYPE, NULL, PROPERTY_LOV_TYPE, FND_API.G_MISS_CHAR, NULL, p_PROPERTY_LOV_TYPE)
246: ,CREATED_FROM_CTR_PROP_TMPL_ID = decode(p_CREATE_FROM_CTR_PROP_TMPL_ID, NULL, CREATED_FROM_CTR_PROP_TMPL_ID, FND_API.G_MISS_NUM, NULL, p_CREATE_FROM_CTR_PROP_TMPL_ID)
247: WHERE COUNTER_PROPERTY_ID = p_COUNTER_PROPERTY_ID;
248:
249: UPDATE CSI_COUNTER_PROPERTIES_TL
250: SET source_lang = userenv('LANG'),
251: name = decode(p_name, NULL, name, fnd_api.g_miss_char, NULL, p_name),
252: description = decode(p_description, NULL, description, fnd_api.g_miss_char, NULL, p_description),
253: created_by = decode( p_created_by, NULL,created_by, fnd_api.g_miss_num,created_by, p_created_by),

Line 320: FROM CSI_COUNTER_PROPERTIES_TL

316: CURSOR C2 IS
317: SELECT name,
318: description,
319: decode(language, userenv('LANG'), 'Y', 'N') baselang
320: FROM CSI_COUNTER_PROPERTIES_TL
321: WHERE COUNTER_PROPERTY_ID = p_COUNTER_PROPERTY_ID
322: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG)
323: FOR UPDATE of COUNTER_PROPERTY_ID NOWAIT;
324: BEGIN

Line 371: DELETE FROM CSI_COUNTER_PROPERTIES_TL t

367: END Delete_Row;
368:
369: PROCEDURE add_language IS
370: BEGIN
371: DELETE FROM CSI_COUNTER_PROPERTIES_TL t
372: WHERE NOT EXISTS (SELECT NULL
373: FROM CSI_COUNTER_PROPERTIES_B b
374: WHERE b.COUNTER_PROPERTY_ID = t.COUNTER_PROPERTY_ID);
375:

Line 376: UPDATE CSI_COUNTER_PROPERTIES_TL t

372: WHERE NOT EXISTS (SELECT NULL
373: FROM CSI_COUNTER_PROPERTIES_B b
374: WHERE b.COUNTER_PROPERTY_ID = t.COUNTER_PROPERTY_ID);
375:
376: UPDATE CSI_COUNTER_PROPERTIES_TL t
377: SET (name,description) = (SELECT b.name,
378: b.description
379: FROM CSI_COUNTER_PROPERTIES_TL b
380: WHERE b.COUNTER_PROPERTY_ID = t.COUNTER_PROPERTY_ID

Line 379: FROM CSI_COUNTER_PROPERTIES_TL b

375:
376: UPDATE CSI_COUNTER_PROPERTIES_TL t
377: SET (name,description) = (SELECT b.name,
378: b.description
379: FROM CSI_COUNTER_PROPERTIES_TL b
380: WHERE b.COUNTER_PROPERTY_ID = t.COUNTER_PROPERTY_ID
381: AND b.language = t.source_lang)
382: WHERE (t.COUNTER_PROPERTY_ID, t.language)
383: IN (SELECT subt.COUNTER_PROPERTY_ID,

Line 385: FROM CSI_COUNTER_PROPERTIES_TL subb, CSI_COUNTER_PROPERTIES_TL subt

381: AND b.language = t.source_lang)
382: WHERE (t.COUNTER_PROPERTY_ID, t.language)
383: IN (SELECT subt.COUNTER_PROPERTY_ID,
384: subt.language
385: FROM CSI_COUNTER_PROPERTIES_TL subb, CSI_COUNTER_PROPERTIES_TL subt
386: WHERE subb.COUNTER_PROPERTY_ID = subt.COUNTER_PROPERTY_ID
387: AND subb.language = subt.source_lang
388: AND (subb.name <> subt.name
389: OR subb.description <> subt.description

Line 395: INSERT INTO CSI_COUNTER_PROPERTIES_TL(

391: OR (subb.description iS NOT NULL AND subt.description IS NULL)
392: )
393: );
394:
395: INSERT INTO CSI_COUNTER_PROPERTIES_TL(
396: COUNTER_PROPERTY_ID,
397: name,
398: description,
399: last_update_date,

Line 417: FROM CSI_COUNTER_PROPERTIES_TL b, fnd_languages l

413: b.created_by,
414: b.last_update_login,
415: l.language_code,
416: b.source_lang
417: FROM CSI_COUNTER_PROPERTIES_TL b, fnd_languages l
418: WHERE l.installed_flag in ('I', 'B')
419: AND b.language = userenv('LANG')
420: AND NOT EXISTS (SELECT NULL
421: FROM CSI_COUNTER_PROPERTIES_TL t

Line 421: FROM CSI_COUNTER_PROPERTIES_TL t

417: FROM CSI_COUNTER_PROPERTIES_TL b, fnd_languages l
418: WHERE l.installed_flag in ('I', 'B')
419: AND b.language = userenv('LANG')
420: AND NOT EXISTS (SELECT NULL
421: FROM CSI_COUNTER_PROPERTIES_TL t
422: WHERE t.counter_property_id = b.counter_property_id
423: AND t.language = l.language_code);
424: END add_language;
425:

Line 433: UPDATE CSI_COUNTER_PROPERTIES_TL

429: ,p_description VARCHAR2
430: ,p_owner VARCHAR2
431: ) IS
432: BEGIN
433: UPDATE CSI_COUNTER_PROPERTIES_TL
434: SET name = p_name,
435: description = p_description,
436: last_update_date = sysdate,
437: last_updated_by = decode(p_owner, 'SEED', 1, 0),