[Home] [Help]
1758: 'FII_PSI_ENCUM_TYPES_COMMITMENT')
1759: AND a.view_application_id = 450
1760: AND a.language = userenv('LANG')
1761: AND upper(a.lookup_code) not in (select upper(encumbrance_type)
1762: from gl_encumbrance_types);
1763: BEGIN
1764:
1765: IF g_debug_flag = 'Y' THEN
1766: FII_UTIL.put_line('In procedure POPULATE_ENCUM_MAPPING():');
1792: sysdate,
1793: g_fii_user_id,
1794: g_fii_login_id
1795: FROM fnd_lookup_values a,
1796: gl_encumbrance_types b
1797: WHERE a.lookup_type in ( 'FII_PSI_ENCUM_TYPES_OBLIGATION',
1798: 'FII_PSI_ENCUM_TYPES_COMMITMENT')
1799: AND a.view_application_id = 450
1800: AND a.language = userenv('LANG')
1806: fii_util.print_timer('Duration');
1807: END IF;
1808:
1809: -- Print a warning message if there is any lookup_code that does not match the
1810: -- encumbrance_type defined in gl_encumbrance_types
1811: l_count := 0;
1812: FOR invalid_lookup_codes in invalid_lookup_cur LOOP
1813: IF (l_count = 0) THEN
1814: fii_util.put_line(' ');
1813: IF (l_count = 0) THEN
1814: fii_util.put_line(' ');
1815: fii_util.put_line(
1816: 'WARNING: Invalid lookup codes found in the encumbrance type mappings. ');
1817: fii_util.put_line('Please make sure these lookup codes are valid GL Encumbrance Types.');
1818: fii_util.put_line('Lookup Type Lookup Code ');
1819: fii_util.put_line('----------- -----------');
1820: l_count := l_count + 1;
1821: END IF;
2920:
2921: -- Find out the encumbrance type ID for the seeded encumbrance types
2922: SELECT encumbrance_type_id
2923: INTO l_obtype_id
2924: FROM gl_encumbrance_types
2925: WHERE encumbrance_type = 'Obligation';
2926:
2927: SELECT encumbrance_type_id
2928: INTO l_comtype_id
2925: WHERE encumbrance_type = 'Obligation';
2926:
2927: SELECT encumbrance_type_id
2928: INTO l_comtype_id
2929: FROM gl_encumbrance_types
2930: WHERE encumbrance_type = 'Commitment';
2931:
2932: l_tmpstmt :=
2933: 'INSERT /*+ append parallel(fii_gl_enc_carryfwd_t) */ '||