APPS.CSI_COUNTERS_PKG dependencies on CSI_COUNTERS_TL

Line 255: INSERT INTO CSI_COUNTERS_TL(

251: ,decode(p_EAM_REQUIRED_FLAG, FND_API.G_MISS_CHAR, NULL,p_EAM_REQUIRED_FLAG)
252: ,decode(p_COMMENTS, FND_API.G_MISS_CHAR, NULL,p_COMMENTS)
253: );
254:
255: INSERT INTO CSI_COUNTERS_TL(
256: COUNTER_ID
257: ,NAME
258: ,DESCRIPTION
259: ,LANGUAGE

Line 280: FROM csi_counters_tl cct

276: ,decode( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login)
277: FROM fnd_languages L
278: WHERE L.installed_flag IN ('I','B')
279: AND NOT EXISTS (SELECT NULL
280: FROM csi_counters_tl cct
281: WHERE cct.counter_id = px_counter_id
282: AND cct.language = L.language_code);
283: End Insert_Row;
284:

Line 445: UPDATE csi_counters_tl

441: ,EAM_REQUIRED_FLAG = decode(p_EAM_REQUIRED_FLAG, NULL, EAM_REQUIRED_FLAG, FND_API.G_MISS_CHAR, NULL, p_EAM_REQUIRED_FLAG)
442: ,COMMENTS = decode(p_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, p_COMMENTS )
443: WHERE COUNTER_ID = p_COUNTER_ID;
444:
445: UPDATE csi_counters_tl
446: SET source_lang = userenv('LANG'),
447: name = decode( p_name, NULL, name, fnd_api.g_miss_char, NULL, p_name),
448: description = decode( p_description, NULL, description, fnd_api.g_miss_char, NULL, p_description),
449: created_by = decode( p_created_by, NULL,created_by, fnd_api.g_miss_num,created_by, p_created_by),

Line 563: FROM csi_counters_tl

559: CURSOR c2 IS
560: SELECT name,
561: description,
562: decode(language, userenv('LANG'), 'Y', 'N') baselang
563: FROM csi_counters_tl
564: WHERE counter_id = p_counter_id
565: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG)
566: FOR UPDATE OF counter_id NOWAIT;
567: BEGIN

Line 605: DELETE FROM csi_counters_tl t

601: END Lock_Row;
602:
603: PROCEDURE add_language IS
604: BEGIN
605: DELETE FROM csi_counters_tl t
606: WHERE NOT EXISTS (SELECT NULL
607: FROM csi_counters_b b
608: WHERE b.counter_id = t.counter_id);
609:

Line 610: UPDATE csi_counters_tl t

606: WHERE NOT EXISTS (SELECT NULL
607: FROM csi_counters_b b
608: WHERE b.counter_id = t.counter_id);
609:
610: UPDATE csi_counters_tl t
611: SET (name,description) = (SELECT b.name,
612: b.description
613: FROM csi_counters_tl b
614: WHERE b.counter_id = t.counter_id

Line 613: FROM csi_counters_tl b

609:
610: UPDATE csi_counters_tl t
611: SET (name,description) = (SELECT b.name,
612: b.description
613: FROM csi_counters_tl b
614: WHERE b.counter_id = t.counter_id
615: AND b.language = t.source_lang)
616: WHERE (t.counter_id,t.language) IN (SELECT subt.counter_id,
617: subt.language

Line 618: FROM csi_counters_tl subb, csi_counters_tl subt

614: WHERE b.counter_id = t.counter_id
615: AND b.language = t.source_lang)
616: WHERE (t.counter_id,t.language) IN (SELECT subt.counter_id,
617: subt.language
618: FROM csi_counters_tl subb, csi_counters_tl subt
619: WHERE subb.counter_id = subt.counter_id
620: AND subb.language = subt.source_lang
621: AND (subb.name <> subt.name
622: OR subb.description <> subt.description

Line 628: INSERT INTO csi_counters_tl(

624: OR (subb.description iS NOT NULL AND subt.description IS NULL)
625: )
626: );
627:
628: INSERT INTO csi_counters_tl(
629: counter_id,
630: name,
631: description,
632: last_update_date,

Line 650: FROM csi_counters_tl b, fnd_languages l

646: b.created_by,
647: b.last_update_login,
648: l.language_code,
649: b.source_lang
650: FROM csi_counters_tl b, fnd_languages l
651: WHERE l.installed_flag in ('I', 'B')
652: AND b.language = userenv('LANG')
653: AND NOT EXISTS (SELECT NULL
654: FROM csi_counters_tl t

Line 654: FROM csi_counters_tl t

650: FROM csi_counters_tl b, fnd_languages l
651: WHERE l.installed_flag in ('I', 'B')
652: AND b.language = userenv('LANG')
653: AND NOT EXISTS (SELECT NULL
654: FROM csi_counters_tl t
655: WHERE t.counter_id = b.counter_id
656: AND t.language = l.language_code);
657: END add_language;
658:

Line 665: UPDATE csi_counters_tl

661: p_name IN VARCHAR2,
662: p_description IN VARCHAR2,
663: p_owner IN VARCHAR2) IS
664: BEGIN
665: UPDATE csi_counters_tl
666: SET name = p_name,
667: description = p_description,
668: last_update_date = sysdate,
669: last_updated_by = decode(p_owner, 'SEED', 1, 0),