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.FII_GL_JE_B_C dependencies on FII_ENCUM_TYPE_MAPPINGS

Line 1431: fii_encum_type_mappings etype,

1427: WHERE slga.je_rule_set_id = rule.je_rule_set_id (+)
1428: AND slga.source_ledger_group_id = fslg.source_ledger_group_id
1429: AND fslg.usage_code = g_usage_code) fset,
1430: gl_je_headers jeh,
1431: fii_encum_type_mappings etype,
1432: fii_gl_processed_header_ids fgph,
1433: gl_periods per2,
1434: gl_ledgers_public_v s2
1435: WHERE jeh.ledger_id = fset.ledger_id

Line 1771: -- Truncate fii_encum_type_mappings

1767: FII_UTIL.put_line('');
1768: END IF;
1769:
1770: ---------------------------------------------------------------------------
1771: -- Truncate fii_encum_type_mappings
1772: ---------------------------------------------------------------------------
1773: IF g_debug_flag = 'Y' THEN
1774: fii_util.put_line(' ');
1775: fii_util.put_line('Truncate fii_encum_type_mappings...');

Line 1775: fii_util.put_line('Truncate fii_encum_type_mappings...');

1771: -- Truncate fii_encum_type_mappings
1772: ---------------------------------------------------------------------------
1773: IF g_debug_flag = 'Y' THEN
1774: fii_util.put_line(' ');
1775: fii_util.put_line('Truncate fii_encum_type_mappings...');
1776: END IF;
1777: TRUNCATE_TABLE('FII_ENCUM_TYPE_MAPPINGS');
1778:
1779: INSERT INTO fii_encum_type_mappings

Line 1777: TRUNCATE_TABLE('FII_ENCUM_TYPE_MAPPINGS');

1773: IF g_debug_flag = 'Y' THEN
1774: fii_util.put_line(' ');
1775: fii_util.put_line('Truncate fii_encum_type_mappings...');
1776: END IF;
1777: TRUNCATE_TABLE('FII_ENCUM_TYPE_MAPPINGS');
1778:
1779: INSERT INTO fii_encum_type_mappings
1780: (encumbrance_type_id,
1781: encumbrance_type,

Line 1779: INSERT INTO fii_encum_type_mappings

1775: fii_util.put_line('Truncate fii_encum_type_mappings...');
1776: END IF;
1777: TRUNCATE_TABLE('FII_ENCUM_TYPE_MAPPINGS');
1778:
1779: INSERT INTO fii_encum_type_mappings
1780: (encumbrance_type_id,
1781: encumbrance_type,
1782: last_update_date,
1783: last_updated_by,

Line 1804: fii_util.put_line('Inserted '||SQL%ROWCOUNT||' rows into fii_encum_type_mappings');

1800: AND a.language = userenv('LANG')
1801: AND upper(a.lookup_code) = upper(b.encumbrance_type);
1802:
1803: IF g_debug_flag = 'Y' THEN
1804: fii_util.put_line('Inserted '||SQL%ROWCOUNT||' rows into fii_encum_type_mappings');
1805: fii_util.stop_timer;
1806: fii_util.print_timer('Duration');
1807: END IF;
1808:

Line 1830: fii_util.put_line('The mapping table between GL Encumrbance Type and FII Encumbrance bucket (fii_encum_type_mappings) is empty. Please enter the encumbrance type mappings.');

1826: END LOOP;
1827:
1828: -- Raise an error if the mapping table is empty
1829: IF (SQL%ROWCOUNT = 0) THEN
1830: fii_util.put_line('The mapping table between GL Encumrbance Type and FII Encumbrance bucket (fii_encum_type_mappings) is empty. Please enter the encumbrance type mappings.');
1831: raise G_MISSING_ENCUM_MAPPING;
1832: END IF;
1833:
1834: commit;

Line 2040: fii_encum_type_mappings etype,

2036: FROM gl_ledgers_public_v s,
2037: gl_periods p,
2038: gl_periods p2,
2039: gl_je_headers jeh,
2040: fii_encum_type_mappings etype,
2041: (SELECT /*+ no_merge */ DISTINCT
2042: slga.ledger_id,
2043: DECODE(slga.je_rule_set_id, NULL, '-1', rule.JE_SOURCE_NAME) je_source_name,
2044: DECODE(slga.je_rule_set_id, NULL, '-1', rule.JE_CATEGORY_NAME) je_category_name