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_FIN_CAT_MAINTAIN_PKG dependencies on FII_FIN_CAT_TYPE_ASSGNS

Line 1304: -- Populate the table FII_FIN_CAT_TYPE_ASSGNS from FII_FC_TYPE_NORM_ASSIGN

1300: END Check_rules_denorm;
1301:
1302:
1303: -- **************************************************************************
1304: -- Populate the table FII_FIN_CAT_TYPE_ASSGNS from FII_FC_TYPE_NORM_ASSIGN
1305: -- by traveraling the dimension hierarchy table
1306:
1307: Procedure Populate_FCT_denorm (p_initial_load VARCHAR2) IS
1308:

Line 1349: FII_UTIL.truncate_table ('FII_FIN_CAT_TYPE_ASSGNS', 'FII', g_retcode);

1345: --Check if there is any Financial Category type assignment in the system
1346: g_phase := 'Check if there is any Financial Category type assignment';
1347:
1348: if l_sql_rowcount = 0 then
1349: FII_UTIL.truncate_table ('FII_FIN_CAT_TYPE_ASSGNS', 'FII', g_retcode);
1350: raise FINDIM_NO_FC_TYPE_ASGN;
1351: end if;
1352:
1353: --Insert a new internal type (EXP) that contains a distinct list

Line 1439: g_phase := 'truncate FII_FIN_CAT_TYPE_ASSGNS';

1435: g_phase := 'Write TMP table to final denorm table based on load mode';
1436:
1437: IF p_initial_load = 'Y' THEN --initial load
1438:
1439: g_phase := 'truncate FII_FIN_CAT_TYPE_ASSGNS';
1440:
1441: FII_UTIL.truncate_table ('FII_FIN_CAT_TYPE_ASSGNS', 'FII', g_retcode);
1442:
1443: g_phase := 'INSERT INTO FII_FIN_CAT_TYPE_ASSGNS';

Line 1441: FII_UTIL.truncate_table ('FII_FIN_CAT_TYPE_ASSGNS', 'FII', g_retcode);

1437: IF p_initial_load = 'Y' THEN --initial load
1438:
1439: g_phase := 'truncate FII_FIN_CAT_TYPE_ASSGNS';
1440:
1441: FII_UTIL.truncate_table ('FII_FIN_CAT_TYPE_ASSGNS', 'FII', g_retcode);
1442:
1443: g_phase := 'INSERT INTO FII_FIN_CAT_TYPE_ASSGNS';
1444:
1445: INSERT /*+ APPEND */ INTO FII_FIN_CAT_TYPE_ASSGNS

Line 1443: g_phase := 'INSERT INTO FII_FIN_CAT_TYPE_ASSGNS';

1439: g_phase := 'truncate FII_FIN_CAT_TYPE_ASSGNS';
1440:
1441: FII_UTIL.truncate_table ('FII_FIN_CAT_TYPE_ASSGNS', 'FII', g_retcode);
1442:
1443: g_phase := 'INSERT INTO FII_FIN_CAT_TYPE_ASSGNS';
1444:
1445: INSERT /*+ APPEND */ INTO FII_FIN_CAT_TYPE_ASSGNS
1446: (fin_cat_type_code,
1447: fin_category_id,

Line 1445: INSERT /+ APPEND / INTO FII_FIN_CAT_TYPE_ASSGNS

1441: FII_UTIL.truncate_table ('FII_FIN_CAT_TYPE_ASSGNS', 'FII', g_retcode);
1442:
1443: g_phase := 'INSERT INTO FII_FIN_CAT_TYPE_ASSGNS';
1444:
1445: INSERT /*+ APPEND */ INTO FII_FIN_CAT_TYPE_ASSGNS
1446: (fin_cat_type_code,
1447: fin_category_id,
1448: top_node_flag,
1449: creation_date,

Line 1465: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FIN_CAT_TYPE_ASSGNS');

1461: FII_LOGIN_ID
1462: FROM FII_FC_TYPE_ASSGNS_GT;
1463:
1464: IF (FIIDIM_Debug) THEN
1465: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FIN_CAT_TYPE_ASSGNS');
1466: END IF;
1467:
1468: ELSE --incremental update
1469:

Line 1470: g_phase := 'DELETE FROM FII_FIN_CAT_TYPE_ASSGNS';

1466: END IF;
1467:
1468: ELSE --incremental update
1469:
1470: g_phase := 'DELETE FROM FII_FIN_CAT_TYPE_ASSGNS';
1471:
1472: DELETE FROM FII_FIN_CAT_TYPE_ASSGNS
1473: WHERE (fin_cat_type_code, fin_category_id, top_node_flag) IN
1474: (SELECT fin_cat_type_code, fin_category_id, top_node_flag

Line 1472: DELETE FROM FII_FIN_CAT_TYPE_ASSGNS

1468: ELSE --incremental update
1469:
1470: g_phase := 'DELETE FROM FII_FIN_CAT_TYPE_ASSGNS';
1471:
1472: DELETE FROM FII_FIN_CAT_TYPE_ASSGNS
1473: WHERE (fin_cat_type_code, fin_category_id, top_node_flag) IN
1474: (SELECT fin_cat_type_code, fin_category_id, top_node_flag
1475: FROM FII_FIN_CAT_TYPE_ASSGNS
1476: MINUS

Line 1475: FROM FII_FIN_CAT_TYPE_ASSGNS

1471:
1472: DELETE FROM FII_FIN_CAT_TYPE_ASSGNS
1473: WHERE (fin_cat_type_code, fin_category_id, top_node_flag) IN
1474: (SELECT fin_cat_type_code, fin_category_id, top_node_flag
1475: FROM FII_FIN_CAT_TYPE_ASSGNS
1476: MINUS
1477: SELECT fin_cat_type_code, fin_category_id, top_node_flag
1478: FROM FII_FC_TYPE_ASSGNS_GT);
1479:

Line 1481: FII_UTIL.Write_Log('Deleted ' || SQL%ROWCOUNT || ' rows from FII_FIN_CAT_TYPE_ASSGNS');

1477: SELECT fin_cat_type_code, fin_category_id, top_node_flag
1478: FROM FII_FC_TYPE_ASSGNS_GT);
1479:
1480: IF (FIIDIM_Debug) THEN
1481: FII_UTIL.Write_Log('Deleted ' || SQL%ROWCOUNT || ' rows from FII_FIN_CAT_TYPE_ASSGNS');
1482: END IF;
1483:
1484: g_phase := 'Insert into FII_FIN_CAT_TYPE_ASSGNS';
1485:

Line 1484: g_phase := 'Insert into FII_FIN_CAT_TYPE_ASSGNS';

1480: IF (FIIDIM_Debug) THEN
1481: FII_UTIL.Write_Log('Deleted ' || SQL%ROWCOUNT || ' rows from FII_FIN_CAT_TYPE_ASSGNS');
1482: END IF;
1483:
1484: g_phase := 'Insert into FII_FIN_CAT_TYPE_ASSGNS';
1485:
1486: Insert into FII_FIN_CAT_TYPE_ASSGNS(
1487: fin_cat_type_code,
1488: fin_category_id,

Line 1486: Insert into FII_FIN_CAT_TYPE_ASSGNS(

1482: END IF;
1483:
1484: g_phase := 'Insert into FII_FIN_CAT_TYPE_ASSGNS';
1485:
1486: Insert into FII_FIN_CAT_TYPE_ASSGNS(
1487: fin_cat_type_code,
1488: fin_category_id,
1489: top_node_flag,
1490: creation_date,

Line 1515: FROM FII_FIN_CAT_TYPE_ASSGNS);

1511: FII_USER_ID,
1512: SYSDATE,
1513: FII_USER_ID,
1514: FII_LOGIN_ID
1515: FROM FII_FIN_CAT_TYPE_ASSGNS);
1516:
1517: IF (FIIDIM_Debug) THEN
1518: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FIN_CAT_TYPE_ASSGNS');
1519: END IF;

Line 1518: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FIN_CAT_TYPE_ASSGNS');

1514: FII_LOGIN_ID
1515: FROM FII_FIN_CAT_TYPE_ASSGNS);
1516:
1517: IF (FIIDIM_Debug) THEN
1518: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FIN_CAT_TYPE_ASSGNS');
1519: END IF;
1520:
1521: END IF;
1522: -----------------------------------------

Line 1525: g_phase := 'gather_table_stats for FII_FIN_CAT_TYPE_ASSGNS';

1521: END IF;
1522: -----------------------------------------
1523:
1524: --Call FND_STATS to collect statistics after re-populating the tables.
1525: g_phase := 'gather_table_stats for FII_FIN_CAT_TYPE_ASSGNS';
1526:
1527: FND_STATS.gather_table_stats
1528: (ownname => g_schema_name,
1529: tabname => 'FII_FIN_CAT_TYPE_ASSGNS');

Line 1529: tabname => 'FII_FIN_CAT_TYPE_ASSGNS');

1525: g_phase := 'gather_table_stats for FII_FIN_CAT_TYPE_ASSGNS';
1526:
1527: FND_STATS.gather_table_stats
1528: (ownname => g_schema_name,
1529: tabname => 'FII_FIN_CAT_TYPE_ASSGNS');
1530:
1531: IF p_initial_load = 'Y' THEN
1532:
1533: g_phase := 'gather_table_stats for MLOG$_FII_FIN_CAT_TYPE_ASS';

Line 1589: FII_UTIL.truncate_table ('FII_FIN_CAT_TYPE_ASSGNS', 'FII', g_retcode);

1585:
1586: FII_UTIL.truncate_table ('FII_FULL_FIN_ITEM_HIERS', 'FII', g_retcode);
1587: FII_UTIL.truncate_table ('FII_FIN_ITEM_HIERARCHIES', 'FII', g_retcode);
1588: FII_UTIL.truncate_table ('FII_FIN_CAT_MAPPINGS', 'FII', g_retcode);
1589: FII_UTIL.truncate_table ('FII_FIN_CAT_TYPE_ASSGNS', 'FII', g_retcode);
1590: FII_UTIL.truncate_table ('FII_FIN_ITEM_LEAF_HIERS', 'FII', g_retcode);
1591: FII_UTIL.truncate_table ('FII_FIN_CAT_LEAF_MAPS', 'FII', g_retcode);
1592:
1593: IF (FIIDIM_Debug) THEN

Line 1918: FROM fii_fin_cat_type_assgns

1914:
1915: UPDATE FII_FIN_ITEM_LEAF_HIERS
1916: SET is_to_be_rolled_up_flag = 'Y'
1917: WHERE next_level_fin_cat_id in ( SELECT fin_category_id
1918: FROM fii_fin_cat_type_assgns
1919: WHERE top_node_flag = 'Y' and
1920: fin_cat_type_code in ('R','EXP')
1921: )
1922: OR parent_fin_cat_id in ( SELECT fin_category_id

Line 1923: FROM fii_fin_cat_type_assgns

1919: WHERE top_node_flag = 'Y' and
1920: fin_cat_type_code in ('R','EXP')
1921: )
1922: OR parent_fin_cat_id in ( SELECT fin_category_id
1923: FROM fii_fin_cat_type_assgns
1924: WHERE top_node_flag = 'Y' and
1925: fin_cat_type_code in ('R','EXP')
1926: );
1927:

Line 1933: WHERE next_level_fin_cat_id in (SELECT fin_category_id FROM fii_fin_cat_type_assgns

1929:
1930: -- Updating the records for Category type OE. We give precedence to OE over TE.
1931: UPDATE fii_fin_item_leaf_hiers
1932: SET top_node_fin_cat_type = 'OE'
1933: WHERE next_level_fin_cat_id in (SELECT fin_category_id FROM fii_fin_cat_type_assgns
1934: WHERE top_node_flag = 'Y' AND fin_cat_type_code = 'OE')
1935: AND next_level_fin_cat_id <> parent_fin_cat_id;
1936:
1937: g_phase := 'Update top_node_fin_cat_type flag for CGS';

Line 1943: where next_level_fin_cat_id in (SELECT fin_category_id FROM fii_fin_cat_type_assgns

1939: -- Updating the records for Category type OE. We give precedence to CGS over TE
1940: -- OE and CGS cannot be assigned to the same node so we need not worry about checking
1941: UPDATE fii_fin_item_leaf_hiers
1942: SET top_node_fin_cat_type = 'CGS'
1943: where next_level_fin_cat_id in (SELECT fin_category_id FROM fii_fin_cat_type_assgns
1944: WHERE top_node_flag = 'Y' AND fin_cat_type_code = 'CGS')
1945: and next_level_fin_cat_id <> parent_fin_cat_id;
1946:
1947: g_phase := 'Update top_node_fin_cat_type flag for other category types';

Line 1951: SET top_node_fin_cat_type = (SELECT fin_cat_type_code FROM fii_fin_cat_type_assgns

1947: g_phase := 'Update top_node_fin_cat_type flag for other category types';
1948:
1949: -- Updating the records for rest of the Category type.
1950: UPDATE fii_fin_item_leaf_hiers fin
1951: SET top_node_fin_cat_type = (SELECT fin_cat_type_code FROM fii_fin_cat_type_assgns
1952: WHERE fin_category_id = fin.next_level_fin_cat_id and fin_cat_type_code in ( 'R','TE'))
1953: WHERE (fin.next_level_fin_cat_id in (SELECT fin_category_id FROM fii_fin_cat_type_assgns
1954: WHERE top_node_flag = 'Y' AND fin_cat_type_code in ( 'R','TE'))
1955: AND fin.next_level_fin_cat_id not in (SELECT fin_category_id FROM fii_fin_cat_type_assgns

Line 1953: WHERE (fin.next_level_fin_cat_id in (SELECT fin_category_id FROM fii_fin_cat_type_assgns

1949: -- Updating the records for rest of the Category type.
1950: UPDATE fii_fin_item_leaf_hiers fin
1951: SET top_node_fin_cat_type = (SELECT fin_cat_type_code FROM fii_fin_cat_type_assgns
1952: WHERE fin_category_id = fin.next_level_fin_cat_id and fin_cat_type_code in ( 'R','TE'))
1953: WHERE (fin.next_level_fin_cat_id in (SELECT fin_category_id FROM fii_fin_cat_type_assgns
1954: WHERE top_node_flag = 'Y' AND fin_cat_type_code in ( 'R','TE'))
1955: AND fin.next_level_fin_cat_id not in (SELECT fin_category_id FROM fii_fin_cat_type_assgns
1956: WHERE top_node_flag = 'Y' AND fin_cat_type_code in ('OE', 'CGS')))
1957: AND next_level_fin_cat_id <> parent_fin_cat_id;

Line 1955: AND fin.next_level_fin_cat_id not in (SELECT fin_category_id FROM fii_fin_cat_type_assgns

1951: SET top_node_fin_cat_type = (SELECT fin_cat_type_code FROM fii_fin_cat_type_assgns
1952: WHERE fin_category_id = fin.next_level_fin_cat_id and fin_cat_type_code in ( 'R','TE'))
1953: WHERE (fin.next_level_fin_cat_id in (SELECT fin_category_id FROM fii_fin_cat_type_assgns
1954: WHERE top_node_flag = 'Y' AND fin_cat_type_code in ( 'R','TE'))
1955: AND fin.next_level_fin_cat_id not in (SELECT fin_category_id FROM fii_fin_cat_type_assgns
1956: WHERE top_node_flag = 'Y' AND fin_cat_type_code in ('OE', 'CGS')))
1957: AND next_level_fin_cat_id <> parent_fin_cat_id;
1958:
1959:

Line 2514: FROM fii_fin_cat_type_assgns

2510:
2511: UPDATE FII_FIN_ITEM_LEAF_HIERS
2512: SET is_to_be_rolled_up_flag = 'Y'
2513: WHERE (next_level_fin_cat_id in ( SELECT fin_category_id
2514: FROM fii_fin_cat_type_assgns
2515: WHERE top_node_flag = 'Y' and
2516: fin_cat_type_code in ('R','EXP')
2517: )
2518: OR parent_fin_cat_id in ( SELECT fin_category_id

Line 2519: FROM fii_fin_cat_type_assgns

2515: WHERE top_node_flag = 'Y' and
2516: fin_cat_type_code in ('R','EXP')
2517: )
2518: OR parent_fin_cat_id in ( SELECT fin_category_id
2519: FROM fii_fin_cat_type_assgns
2520: WHERE top_node_flag = 'Y' and
2521: fin_cat_type_code in ('R','EXP')
2522: ))
2523: AND is_to_be_rolled_up_flag <> 'Y' ;

Line 2534: WHERE next_level_fin_cat_id IN (SELECT fin_category_id FROM fii_fin_cat_type_assgns

2530:
2531: -- Updating the records for Category type OE. We give precedence to OE over TE.
2532: UPDATE fii_fin_item_leaf_hiers
2533: SET top_node_fin_cat_type = 'OE'
2534: WHERE next_level_fin_cat_id IN (SELECT fin_category_id FROM fii_fin_cat_type_assgns
2535: WHERE top_node_flag = 'Y' AND fin_cat_type_code = 'OE')
2536: AND next_level_fin_cat_id <> parent_fin_cat_id
2537: AND (top_node_fin_cat_type <> 'OE' OR top_node_fin_cat_type is null);
2538:

Line 2549: where next_level_fin_cat_id IN (SELECT fin_category_id FROM fii_fin_cat_type_assgns

2545: -- Updating the records for Category type OE. We give precedence to CGS over TE
2546: -- OE and CGS cannot be assigned to the same node so we need not worry about checking
2547: UPDATE fii_fin_item_leaf_hiers
2548: SET top_node_fin_cat_type = 'CGS'
2549: where next_level_fin_cat_id IN (SELECT fin_category_id FROM fii_fin_cat_type_assgns
2550: WHERE top_node_flag = 'Y' AND fin_cat_type_code = 'CGS')
2551: AND next_level_fin_cat_id <> parent_fin_cat_id
2552: AND (top_node_fin_cat_type <> 'CGS' OR top_node_fin_cat_type is null);
2553:

Line 2562: SET top_node_fin_cat_type = (SELECT fin_cat_type_code FROM fii_fin_cat_type_assgns

2558: g_phase := 'Update top_node_fin_cat_type flag for other category types';
2559:
2560: -- Updating the records for rest of the Category type.
2561: UPDATE fii_fin_item_leaf_hiers fin
2562: SET top_node_fin_cat_type = (SELECT fin_cat_type_code FROM fii_fin_cat_type_assgns
2563: WHERE fin_category_id = fin.next_level_fin_cat_id and fin_cat_type_code in ( 'R','TE'))
2564: WHERE (fin.next_level_fin_cat_id in (SELECT fin_category_id FROM fii_fin_cat_type_assgns
2565: WHERE top_node_flag = 'Y' AND fin_cat_type_code in ( 'R','TE'))
2566: AND fin.next_level_fin_cat_id not in (SELECT fin_category_id FROM fii_fin_cat_type_assgns

Line 2564: WHERE (fin.next_level_fin_cat_id in (SELECT fin_category_id FROM fii_fin_cat_type_assgns

2560: -- Updating the records for rest of the Category type.
2561: UPDATE fii_fin_item_leaf_hiers fin
2562: SET top_node_fin_cat_type = (SELECT fin_cat_type_code FROM fii_fin_cat_type_assgns
2563: WHERE fin_category_id = fin.next_level_fin_cat_id and fin_cat_type_code in ( 'R','TE'))
2564: WHERE (fin.next_level_fin_cat_id in (SELECT fin_category_id FROM fii_fin_cat_type_assgns
2565: WHERE top_node_flag = 'Y' AND fin_cat_type_code in ( 'R','TE'))
2566: AND fin.next_level_fin_cat_id not in (SELECT fin_category_id FROM fii_fin_cat_type_assgns
2567: WHERE top_node_flag = 'Y' AND fin_cat_type_code in ('OE', 'CGS')))
2568: AND next_level_fin_cat_id <> parent_fin_cat_id

Line 2566: AND fin.next_level_fin_cat_id not in (SELECT fin_category_id FROM fii_fin_cat_type_assgns

2562: SET top_node_fin_cat_type = (SELECT fin_cat_type_code FROM fii_fin_cat_type_assgns
2563: WHERE fin_category_id = fin.next_level_fin_cat_id and fin_cat_type_code in ( 'R','TE'))
2564: WHERE (fin.next_level_fin_cat_id in (SELECT fin_category_id FROM fii_fin_cat_type_assgns
2565: WHERE top_node_flag = 'Y' AND fin_cat_type_code in ( 'R','TE'))
2566: AND fin.next_level_fin_cat_id not in (SELECT fin_category_id FROM fii_fin_cat_type_assgns
2567: WHERE top_node_flag = 'Y' AND fin_cat_type_code in ('OE', 'CGS')))
2568: AND next_level_fin_cat_id <> parent_fin_cat_id
2569: AND (top_node_fin_cat_type <> (SELECT fin_cat_type_code FROM fii_fin_cat_type_assgns
2570: WHERE fin_category_id = fin.next_level_fin_cat_id and fin_cat_type_code in ( 'R','TE'))

Line 2569: AND (top_node_fin_cat_type <> (SELECT fin_cat_type_code FROM fii_fin_cat_type_assgns

2565: WHERE top_node_flag = 'Y' AND fin_cat_type_code in ( 'R','TE'))
2566: AND fin.next_level_fin_cat_id not in (SELECT fin_category_id FROM fii_fin_cat_type_assgns
2567: WHERE top_node_flag = 'Y' AND fin_cat_type_code in ('OE', 'CGS')))
2568: AND next_level_fin_cat_id <> parent_fin_cat_id
2569: AND (top_node_fin_cat_type <> (SELECT fin_cat_type_code FROM fii_fin_cat_type_assgns
2570: WHERE fin_category_id = fin.next_level_fin_cat_id and fin_cat_type_code in ( 'R','TE'))
2571: OR top_node_fin_cat_type is null);
2572:
2573:

Line 2581: SELECT fin_category_id FROM fii_fin_cat_type_assgns

2577: set top_node_fin_cat_type = NULL
2578: where next_level_fin_cat_id in (SELECT next_level_fin_cat_id from fii_fin_item_leaf_hiers
2579: WHERE top_node_fin_cat_type is not null
2580: MINUS
2581: SELECT fin_category_id FROM fii_fin_cat_type_assgns
2582: WHERE top_node_flag = 'Y' AND fin_cat_type_code in ( 'R','TE', 'OE', 'CGS')
2583: )
2584: AND next_level_fin_cat_id <> parent_fin_cat_id;
2585: