eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSR_RULES_PVT dependencies on CSR_RULE_WINDOWS_TL

Line 600: SELECT csr_rule_windows_tl_s.NEXTVAL INTO l_window_id FROM dual;

596: l_windows_id_list.extend;
597: l_windows_id_list(i):=l_window_id;
598: IF l_window_id < 0 THEN
599:
600: SELECT csr_rule_windows_tl_s.NEXTVAL INTO l_window_id FROM dual;
601: l_windows_id_list(i):=l_window_id;
602:
603: INSERT INTO csr_rule_windows_tl (
604: window_id

Line 603: INSERT INTO csr_rule_windows_tl (

599:
600: SELECT csr_rule_windows_tl_s.NEXTVAL INTO l_window_id FROM dual;
601: l_windows_id_list(i):=l_window_id;
602:
603: INSERT INTO csr_rule_windows_tl (
604: window_id
605: , language
606: , source_lang
607: , window_name

Line 630: UPDATE csr_rule_windows_tl

626: WHERE l.installed_flag in ('I','B');
627:
628: DBMS_XMLDOM.setNodeValue(l_window_id_node, l_window_id);
629: ELSE
630: UPDATE csr_rule_windows_tl
631: SET window_name = p_window_names(i)
632: , description = p_window_descriptions(i)
633: , last_updated_by = fnd_global.user_id
634: , last_update_date = SYSDATE

Line 642: -- Document, then we have to delete the Window Names in CSR_RULE_WINDOWS_TL

638: END IF;
639: END LOOP;
640:
641: -- If there is any Window not defined in the New Document, but defined in the Old
642: -- Document, then we have to delete the Window Names in CSR_RULE_WINDOWS_TL
643: -- to avoid Dangling References.
644: IF p_old_rule_doc IS NOT NULL THEN
645: l_rule_document := DBMS_XMLDOM.newDOMDocument(p_old_rule_doc);
646: l_root_element := DBMS_XMLDOM.getDocumentElement(l_rule_document);

Line 662: DELETE csr_rule_windows_tl WHERE window_id = l_window_id;

658: IF NOT check_element(l_windows_id_list,l_window_id) THEN
659: IF l_debug = 'Y' THEN
660: debug('removing TL table records for window with window ID '||l_window_id , l_api_name, fnd_log.level_statement);
661: END IF;
662: DELETE csr_rule_windows_tl WHERE window_id = l_window_id;
663: END IF;
664: END LOOP;
665: END IF;
666: END handle_rule_windows;

Line 1946: DELETE FROM CSR_RULE_WINDOWS_TL t

1942: WHERE t.rule_id = csrt.rule_id
1943: AND t.language = l.language_code
1944: );
1945:
1946: DELETE FROM CSR_RULE_WINDOWS_TL t
1947: WHERE NOT EXISTS (SELECT NULL FROM CSR_RULE_WINDOWS_TL b WHERE b.window_id = t.window_id);
1948:
1949: UPDATE CSR_RULE_WINDOWS_TL csrt
1950: SET (csrt.window_name, csrt.description) = (

Line 1947: WHERE NOT EXISTS (SELECT NULL FROM CSR_RULE_WINDOWS_TL b WHERE b.window_id = t.window_id);

1943: AND t.language = l.language_code
1944: );
1945:
1946: DELETE FROM CSR_RULE_WINDOWS_TL t
1947: WHERE NOT EXISTS (SELECT NULL FROM CSR_RULE_WINDOWS_TL b WHERE b.window_id = t.window_id);
1948:
1949: UPDATE CSR_RULE_WINDOWS_TL csrt
1950: SET (csrt.window_name, csrt.description) = (
1951: SELECT csrtl.window_name, csrtl.description

Line 1949: UPDATE CSR_RULE_WINDOWS_TL csrt

1945:
1946: DELETE FROM CSR_RULE_WINDOWS_TL t
1947: WHERE NOT EXISTS (SELECT NULL FROM CSR_RULE_WINDOWS_TL b WHERE b.window_id = t.window_id);
1948:
1949: UPDATE CSR_RULE_WINDOWS_TL csrt
1950: SET (csrt.window_name, csrt.description) = (
1951: SELECT csrtl.window_name, csrtl.description
1952: FROM CSR_RULE_WINDOWS_TL csrtl
1953: WHERE csrtl.window_id = csrt.window_id

Line 1952: FROM CSR_RULE_WINDOWS_TL csrtl

1948:
1949: UPDATE CSR_RULE_WINDOWS_TL csrt
1950: SET (csrt.window_name, csrt.description) = (
1951: SELECT csrtl.window_name, csrtl.description
1952: FROM CSR_RULE_WINDOWS_TL csrtl
1953: WHERE csrtl.window_id = csrt.window_id
1954: AND csrtl.language = csrt.source_lang
1955: )
1956: WHERE (csrt.window_id, csrt.language) IN (

Line 1958: FROM CSR_RULE_WINDOWS_TL subb, CSR_RULE_WINDOWS_TL subt

1954: AND csrtl.language = csrt.source_lang
1955: )
1956: WHERE (csrt.window_id, csrt.language) IN (
1957: SELECT subt.window_id, subt.language
1958: FROM CSR_RULE_WINDOWS_TL subb, CSR_RULE_WINDOWS_TL subt
1959: WHERE subb.window_id = subt.window_id
1960: AND subb.language = subt.source_lang
1961: AND (
1962: subb.window_name <> subt.window_name

Line 1969: INSERT INTO CSR_RULE_WINDOWS_TL (

1965: OR (subb.description IS NOT NULL AND subt.description IS NULL)
1966: )
1967: );
1968:
1969: INSERT INTO CSR_RULE_WINDOWS_TL (
1970: window_id
1971: , window_name
1972: , description
1973: , created_by

Line 1991: FROM CSR_RULE_WINDOWS_TL csrt

1987: , csrt.last_update_date
1988: , csrt.last_update_login
1989: , l.language_code
1990: , csrt.source_lang
1991: FROM CSR_RULE_WINDOWS_TL csrt
1992: , fnd_languages l
1993: WHERE l.installed_flag IN ('I', 'B')
1994: AND csrt.language = userenv('LANG')
1995: AND NOT EXISTS (

Line 1997: FROM CSR_RULE_WINDOWS_TL t

1993: WHERE l.installed_flag IN ('I', 'B')
1994: AND csrt.language = userenv('LANG')
1995: AND NOT EXISTS (
1996: SELECT NULL
1997: FROM CSR_RULE_WINDOWS_TL t
1998: WHERE t.window_id = csrt.window_id
1999: AND t.language = l.language_code
2000: );
2001: END add_language;