APPS.CSI_SYSTEMS_B_PKG dependencies on CSI_SYSTEMS_TL

Line 164: INSERT INTO csi_systems_tl(

160: decode( p_program_id, fnd_api.g_miss_num, NULL, p_program_id),
161: decode( p_program_update_date, fnd_api.g_miss_date, to_date(NULL), p_program_update_date)
162: );
163:
164: INSERT INTO csi_systems_tl(
165: system_id ,
166: language ,
167: source_lang ,
168: name ,

Line 191: FROM csi_systems_tl T

187: FROM fnd_languages L
188: WHERE L.installed_flag IN ('I','B')
189: AND NOT EXISTS
190: (SELECT NULL
191: FROM csi_systems_tl T
192: WHERE T.system_id=px_system_id
193: AND T.language = L.language_code);
194:
195: END insert_row;

Line 293: UPDATE csi_systems_tl

289: program_id = decode(p_program_id,fnd_api.g_miss_num,program_id,p_program_id),
290: program_update_date = decode( p_program_update_date, fnd_api.g_miss_date, program_update_date, p_program_update_date)
291: WHERE system_id = p_system_id;
292:
293: UPDATE csi_systems_tl
294: SET source_lang = userenv('LANG'),
295: name = decode( p_name, fnd_api.g_miss_char, name, p_name),
296: description = decode( p_description, fnd_api.g_miss_char, description, p_description),
297: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),

Line 407: UPDATE csi_systems_tl

403: program_id = decode(p_program_id,fnd_api.g_miss_num,program_id,p_program_id),
404: program_update_date = decode( p_program_update_date, fnd_api.g_miss_date, program_update_date, p_program_update_date)
405: WHERE system_id = p_system_id;
406:
407: UPDATE csi_systems_tl
408: SET source_lang = userenv('LANG'),
409: name = decode( p_name, fnd_api.g_miss_char, name, p_name),
410: description = decode( p_description, fnd_api.g_miss_char, description, p_description),
411: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),

Line 489: FROM csi_systems_tl

485: CURSOR c1 IS
486: SELECT name,
487: description,
488: decode(language, userenv('LANG'), 'Y', 'N') baselang
489: FROM csi_systems_tl
490: WHERE system_id = p_system_id
491: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG)
492: FOR UPDATE OF system_id NOWAIT;
493: BEGIN

Line 534: DELETE FROM csi_systems_tl t

530: PROCEDURE add_language
531: IS
532: BEGIN
533: /********* COMMENTED FOR BUG 4238439 (Refer 3723612 for solution)
534: DELETE FROM csi_systems_tl t
535: WHERE NOT EXISTS
536: (SELECT NULL
537: FROM csi_systems_b b
538: WHERE b.system_id = t.system_id

Line 541: UPDATE csi_systems_tl t

537: FROM csi_systems_b b
538: WHERE b.system_id = t.system_id
539: );
540:
541: UPDATE csi_systems_tl t
542: SET (name,description) =
543: (SELECT b.name,
544: b.description
545: FROM csi_systems_tl b

Line 545: FROM csi_systems_tl b

541: UPDATE csi_systems_tl t
542: SET (name,description) =
543: (SELECT b.name,
544: b.description
545: FROM csi_systems_tl b
546: WHERE b.system_id = t.system_id
547: AND b.language = t.source_lang)
548: WHERE (t.system_id,t.language) IN
549: (SELECT subt.system_id,

Line 551: FROM csi_systems_tl subb, csi_systems_tl subt

547: AND b.language = t.source_lang)
548: WHERE (t.system_id,t.language) IN
549: (SELECT subt.system_id,
550: subt.language
551: FROM csi_systems_tl subb, csi_systems_tl subt
552: WHERE subb.system_id = subt.system_id
553: AND subb.language = subt.source_lang
554: AND (subb.name <> subt.name
555: OR subb.description <> subt.description

Line 562: INSERT /*+ append parallel(tt) */ INTO csi_systems_tl tt (system_id,

558: )
559: );
560: *********** END OF COMMENT **********/
561:
562: INSERT /*+ append parallel(tt) */ INTO csi_systems_tl tt (system_id,
563: name,
564: description,
565: last_update_date,
566: last_updated_by,

Line 584: FROM csi_systems_tl b, fnd_languages l

580: b.created_by,
581: b.last_update_login,
582: l.language_code,
583: b.source_lang
584: FROM csi_systems_tl b, fnd_languages l
585: WHERE l.installed_flag in ('I', 'B')
586: AND b.language = userenv('LANG')
587: ) v, csi_systems_tl t
588: WHERE t.system_id(+) = v.system_id

Line 587: ) v, csi_systems_tl t

583: b.source_lang
584: FROM csi_systems_tl b, fnd_languages l
585: WHERE l.installed_flag in ('I', 'B')
586: AND b.language = userenv('LANG')
587: ) v, csi_systems_tl t
588: WHERE t.system_id(+) = v.system_id
589: AND t.language(+) = v.language_code
590: AND t.system_id IS NULL;
591: /***** COMMENTED AND NOT EXISTS

Line 593: FROM csi_systems_tl t

589: AND t.language(+) = v.language_code
590: AND t.system_id IS NULL;
591: /***** COMMENTED AND NOT EXISTS
592: (SELECT NULL
593: FROM csi_systems_tl t
594: WHERE t.system_id = b.system_id
595: AND t.language = l.language_code); *****/
596: END add_language;
597:

Line 605: UPDATE csi_systems_tl

601: p_description IN VARCHAR2,
602: p_owner IN VARCHAR2
603: ) IS
604: BEGIN
605: UPDATE csi_systems_tl
606: SET name = p_name,
607: description = p_description,
608: last_update_date = sysdate,
609: last_updated_by = decode(p_owner, 'SEED', 1, 0),