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_RULES_TL

Line 199: l_rule_name csr_rules_tl.rule_name%TYPE;

195: --
196: CURSOR c_lookups IS
197: SELECT meaning FROM fnd_lookups
198: WHERE lookup_type = 'JTF_NOTE_TYPE' AND lookup_code = 'CN_SYSGEN';
199: l_rule_name csr_rules_tl.rule_name%TYPE;
200: BEGIN
201: l_rule_name := p_rule_name;
202:
203: IF p_enabled_flag = 'S' THEN

Line 250: INSERT INTO csr_rules_tl (

246: )
247: RETURNING rule_id INTO l_new_rule_id;
248:
249: -- Insert the Rule's Translated Attributes
250: INSERT INTO csr_rules_tl (
251: rule_id
252: , language
253: , source_lang
254: , rule_name

Line 275: SELECT 1 FROM csr_rules_tl tl

271: , fnd_global.login_id
272: FROM fnd_languages l
273: WHERE l.installed_flag in ('I','B')
274: AND NOT EXISTS (
275: SELECT 1 FROM csr_rules_tl tl
276: WHERE tl.rule_id = l_new_rule_id
277: AND tl.language = l.language_code
278: );
279:

Line 416: l_valid_base_rule_name csr_rules_tl.rule_name%TYPE;

412: l_base_bind1 NUMBER;
413: l_base_bind2 VARCHAR2(30);
414: l_base_eligibilty_type VARCHAR2(10);
415: l_valid_base_rule_id NUMBER;
416: l_valid_base_rule_name csr_rules_tl.rule_name%TYPE;
417: c_rules SYS_REFCURSOR;
418: BEGIN
419: IF l_debug = 'Y' THEN
420: debug('Validating Rule', l_api_name, fnd_log.level_event);

Line 1025: FROM csr_rules_b b, csr_rules_tl t

1021: , b.rule_rank
1022: , b.rule_doc
1023: , t.rule_name
1024: , t.description
1025: FROM csr_rules_b b, csr_rules_tl t
1026: WHERE b.rule_id = p_rule_id
1027: AND b.rule_id = t.rule_id
1028: AND t.language = userenv('LANG')
1029: FOR UPDATE NOWAIT;

Line 1148: UPDATE csr_rules_tl

1144: -- Update the Rule's Translatable Attributes
1145: IF l_rule.rule_name <> p_rule_name
1146: OR NVL(p_description, '@@') <> NVL(l_rule.description, '@@')
1147: THEN
1148: UPDATE csr_rules_tl
1149: SET rule_name = NVL(p_rule_name, rule_name)
1150: , description = NVL(p_description, description)
1151: , last_updated_by = fnd_global.user_id
1152: , last_update_date = SYSDATE

Line 1295: DELETE csr_rules_tl WHERE rule_id = v_child_rule.rule_id;

1291: RAISE fnd_api.g_exc_error;
1292: END IF;
1293: END LOOP;
1294:
1295: DELETE csr_rules_tl WHERE rule_id = v_child_rule.rule_id;
1296: DELETE csr_rules_b WHERE rule_id = v_child_rule.rule_id;
1297: END LOOP;
1298:
1299: IF fnd_api.to_boolean(p_commit) THEN

Line 1692: FROM csr_rules_b b, csr_rules_tl t

1688: l_parent_dom_node DBMS_XMLDOM.DOMNode;
1689: --
1690: CURSOR c_rule_details IS
1691: SELECT b.rule_doc, b.rule_rank, t.rule_name, t.description
1692: FROM csr_rules_b b, csr_rules_tl t
1693: WHERE b.rule_id = p_rule_id
1694: FOR UPDATE OF b.rule_doc, t.rule_name NOWAIT;
1695: l_rule c_rule_details%ROWTYPE;
1696: l_new_rule_doc CLOB;

Line 1890: DELETE FROM csr_rules_tl t

1886: END process_webadi_action;
1887:
1888: PROCEDURE add_language IS
1889: BEGIN
1890: DELETE FROM csr_rules_tl t
1891: WHERE NOT EXISTS (SELECT NULL FROM csr_rules_b b WHERE b.rule_id = t.rule_id);
1892:
1893: UPDATE csr_rules_tl csrt
1894: SET (csrt.rule_name, csrt.description) = (

Line 1893: UPDATE csr_rules_tl csrt

1889: BEGIN
1890: DELETE FROM csr_rules_tl t
1891: WHERE NOT EXISTS (SELECT NULL FROM csr_rules_b b WHERE b.rule_id = t.rule_id);
1892:
1893: UPDATE csr_rules_tl csrt
1894: SET (csrt.rule_name, csrt.description) = (
1895: SELECT csrtl.rule_name, csrtl.description
1896: FROM csr_rules_tl csrtl
1897: WHERE csrtl.rule_id = csrt.rule_id

Line 1896: FROM csr_rules_tl csrtl

1892:
1893: UPDATE csr_rules_tl csrt
1894: SET (csrt.rule_name, csrt.description) = (
1895: SELECT csrtl.rule_name, csrtl.description
1896: FROM csr_rules_tl csrtl
1897: WHERE csrtl.rule_id = csrt.rule_id
1898: AND csrtl.language = csrt.source_lang
1899: )
1900: WHERE (csrt.rule_id, csrt.language) IN (

Line 1902: FROM csr_rules_tl subb, csr_rules_tl subt

1898: AND csrtl.language = csrt.source_lang
1899: )
1900: WHERE (csrt.rule_id, csrt.language) IN (
1901: SELECT subt.rule_id, subt.language
1902: FROM csr_rules_tl subb, csr_rules_tl subt
1903: WHERE subb.rule_id = subt.rule_id
1904: AND subb.language = subt.source_lang
1905: AND (
1906: subb.rule_name <> subt.rule_name

Line 1913: INSERT INTO csr_rules_tl (

1909: OR (subb.description IS NOT NULL AND subt.description IS NULL)
1910: )
1911: );
1912:
1913: INSERT INTO csr_rules_tl (
1914: rule_id
1915: , rule_name
1916: , description
1917: , created_by

Line 1935: FROM csr_rules_tl csrt

1931: , csrt.last_update_date
1932: , csrt.last_update_login
1933: , l.language_code
1934: , csrt.source_lang
1935: FROM csr_rules_tl csrt
1936: , fnd_languages l
1937: WHERE l.installed_flag IN ('I', 'B')
1938: AND csrt.language = userenv('LANG')
1939: AND NOT EXISTS (

Line 1941: FROM csr_rules_tl t

1937: WHERE l.installed_flag IN ('I', 'B')
1938: AND csrt.language = userenv('LANG')
1939: AND NOT EXISTS (
1940: SELECT NULL
1941: FROM csr_rules_tl t
1942: WHERE t.rule_id = csrt.rule_id
1943: AND t.language = l.language_code
1944: );
1945: