APPS.CSI_COUNTER_TEMPLATE_PKG dependencies on CSI_COUNTER_TEMPLATE_TL

Line 252: INSERT INTO CSI_COUNTER_TEMPLATE_TL(

248: ,decode(p_TIME_BASED_MANUAL_ENTRY, FND_API.G_MISS_CHAR, NULL,p_TIME_BASED_MANUAL_ENTRY)
249: ,decode(p_EAM_REQUIRED_FLAG, FND_API.G_MISS_CHAR, NULL,p_EAM_REQUIRED_FLAG)
250: );
251:
252: INSERT INTO CSI_COUNTER_TEMPLATE_TL(
253: COUNTER_ID
254: ,NAME
255: ,DESCRIPTION
256: ,LANGUAGE

Line 277: FROM csi_counter_template_tl cct

273: ,decode(p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login)
274: FROM fnd_languages l
275: WHERE l.installed_flag IN ('I','B')
276: AND NOT EXISTS (SELECT 'x'
277: FROM csi_counter_template_tl cct
278: WHERE cct.counter_id = px_counter_id
279: AND cct.language = l.language_code);
280: End Insert_Row;
281:

Line 438: UPDATE csi_counter_template_tl

434: ,TIME_BASED_MANUAL_ENTRY = decode(p_TIME_BASED_MANUAL_ENTRY, NULL, TIME_BASED_MANUAL_ENTRY, FND_API.G_MISS_CHAR, NULL, p_TIME_BASED_MANUAL_ENTRY)
435: ,EAM_REQUIRED_FLAG = decode(p_EAM_REQUIRED_FLAG, NULL, EAM_REQUIRED_FLAG, FND_API.G_MISS_CHAR, NULL, p_EAM_REQUIRED_FLAG)
436: WHERE COUNTER_ID = p_COUNTER_ID;
437:
438: UPDATE csi_counter_template_tl
439: SET source_lang = userenv('LANG'),
440: name = decode( p_name, NULL, name, fnd_api.g_miss_char, NULL, p_name),
441: description = decode( p_description, NULL, description, fnd_api.g_miss_char, NULL, p_description),
442: created_by = decode( p_created_by, NULL, created_by, fnd_api.g_miss_num, created_by, p_created_by),

Line 555: FROM csi_counter_template_tl

551: CURSOR c2 IS
552: SELECT name,
553: description,
554: decode(language, userenv('LANG'), 'Y', 'N') baselang
555: FROM csi_counter_template_tl
556: WHERE counter_id = p_counter_id
557: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG)
558: FOR UPDATE OF counter_id NOWAIT;
559: BEGIN

Line 596: DELETE FROM csi_counter_template_tl t

592: END lock_row;
593:
594: PROCEDURE add_language IS
595: BEGIN
596: DELETE FROM csi_counter_template_tl t
597: WHERE NOT EXISTS (SELECT NULL
598: FROM csi_counter_template_b b
599: WHERE b.counter_id = t.counter_id);
600:

Line 601: UPDATE csi_counter_template_tl t

597: WHERE NOT EXISTS (SELECT NULL
598: FROM csi_counter_template_b b
599: WHERE b.counter_id = t.counter_id);
600:
601: UPDATE csi_counter_template_tl t
602: SET (name,description) = (SELECT b.name,
603: b.description
604: FROM csi_counter_template_tl b
605: WHERE b.counter_id = t.counter_id

Line 604: FROM csi_counter_template_tl b

600:
601: UPDATE csi_counter_template_tl t
602: SET (name,description) = (SELECT b.name,
603: b.description
604: FROM csi_counter_template_tl b
605: WHERE b.counter_id = t.counter_id
606: AND b.language = t.source_lang)
607: WHERE (t.counter_id,t.language) IN (SELECT subt.counter_id,
608: subt.language

Line 609: FROM csi_counter_template_tl subb, csi_counter_template_tl subt

605: WHERE b.counter_id = t.counter_id
606: AND b.language = t.source_lang)
607: WHERE (t.counter_id,t.language) IN (SELECT subt.counter_id,
608: subt.language
609: FROM csi_counter_template_tl subb, csi_counter_template_tl subt
610: WHERE subb.counter_id = subt.counter_id
611: AND subb.language = subt.source_lang
612: AND (subb.name <> subt.name
613: OR subb.description <> subt.description

Line 619: INSERT INTO csi_counter_template_tl(

615: OR (subb.description iS NOT NULL AND subt.description IS NULL)
616: )
617: );
618:
619: INSERT INTO csi_counter_template_tl(
620: counter_id,
621: name,
622: description,
623: last_update_date,

Line 641: FROM csi_counter_template_tl b, fnd_languages l

637: b.created_by,
638: b.last_update_login,
639: l.language_code,
640: b.source_lang
641: FROM csi_counter_template_tl b, fnd_languages l
642: WHERE l.installed_flag in ('I', 'B')
643: AND b.language = userenv('LANG')
644: AND NOT EXISTS (SELECT NULL
645: FROM csi_counter_template_tl t

Line 645: FROM csi_counter_template_tl t

641: FROM csi_counter_template_tl b, fnd_languages l
642: WHERE l.installed_flag in ('I', 'B')
643: AND b.language = userenv('LANG')
644: AND NOT EXISTS (SELECT NULL
645: FROM csi_counter_template_tl t
646: WHERE t.counter_id = b.counter_id
647: AND t.language = l.language_code);
648: END add_language;
649:

Line 656: UPDATE csi_counter_template_tl

652: p_name IN VARCHAR2,
653: p_description IN VARCHAR2,
654: p_owner IN VARCHAR2) IS
655: BEGIN
656: UPDATE csi_counter_template_tl
657: SET name = p_name,
658: description = p_description,
659: last_update_date = sysdate,
660: last_updated_by = decode(p_owner, 'SEED', 1, 0),