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_FC_TYPE_ASSGNS_GT

Line 1186: from FII_FC_TYPE_ASSGNS_GT

1182:
1183: -- Bug 4152798. Removed literal and introduced a parameter.
1184: Cursor rev_nodes_cur (p_cat_type VARCHAR2) IS
1185: select FIN_CATEGORY_ID
1186: from FII_FC_TYPE_ASSGNS_GT
1187: where FIN_CAT_TYPE_CODE = p_cat_type;
1188:
1189: Cursor Invalid_Asg_Cur (p_rev_cat_id NUMBER) IS
1190: select FIN_CATEGORY_ID, FIN_CAT_TYPE_CODE

Line 1191: from FII_FC_TYPE_ASSGNS_GT

1187: where FIN_CAT_TYPE_CODE = p_cat_type;
1188:
1189: Cursor Invalid_Asg_Cur (p_rev_cat_id NUMBER) IS
1190: select FIN_CATEGORY_ID, FIN_CAT_TYPE_CODE
1191: from FII_FC_TYPE_ASSGNS_GT
1192: where FIN_CATEGORY_ID = p_rev_cat_id
1193: and FIN_CAT_TYPE_CODE in ('OE', 'TE', 'PE', 'CGS');
1194:
1195: -- Bug 4152798. Removed the cursor as this cursor and rev_nodes_cur cursor

Line 1200: -- from FII_FC_TYPE_ASSGNS_GT

1196: -- are same after removal of the literal.
1197: -- 2 cursors to check business rule for DR
1198: -- Cursor def_rev_nodes_cur IS
1199: -- select FIN_CATEGORY_ID
1200: -- from FII_FC_TYPE_ASSGNS_GT
1201: -- where FIN_CAT_TYPE_CODE = 'DR';
1202:
1203: Cursor Conflict_Asg_Cur (p_rev_cat_id NUMBER, p_cat_type VARCHAR2) IS
1204: select FIN_CATEGORY_ID, FIN_CAT_TYPE_CODE

Line 1205: from FII_FC_TYPE_ASSGNS_GT

1201: -- where FIN_CAT_TYPE_CODE = 'DR';
1202:
1203: Cursor Conflict_Asg_Cur (p_rev_cat_id NUMBER, p_cat_type VARCHAR2) IS
1204: select FIN_CATEGORY_ID, FIN_CAT_TYPE_CODE
1205: from FII_FC_TYPE_ASSGNS_GT
1206: where FIN_CATEGORY_ID = p_rev_cat_id
1207: and FIN_CAT_TYPE_CODE <> p_cat_type;
1208:
1209: l_rev_cat_id NUMBER(15);

Line 1318: g_phase := 'Truncate FII_FC_TYPE_ASSGNS_GT';

1314: FII_MESSAGE.Func_Ent(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Populate_FTC_denorm');
1315: END IF;
1316:
1317: --clean up the denorm TMP table
1318: g_phase := 'Truncate FII_FC_TYPE_ASSGNS_GT';
1319:
1320: FII_UTIL.truncate_table ('FII_FC_TYPE_ASSGNS_GT', 'FII', g_retcode);
1321:
1322: --First, insert records into the denorm TMP table

Line 1320: FII_UTIL.truncate_table ('FII_FC_TYPE_ASSGNS_GT', 'FII', g_retcode);

1316:
1317: --clean up the denorm TMP table
1318: g_phase := 'Truncate FII_FC_TYPE_ASSGNS_GT';
1319:
1320: FII_UTIL.truncate_table ('FII_FC_TYPE_ASSGNS_GT', 'FII', g_retcode);
1321:
1322: --First, insert records into the denorm TMP table
1323: --Note that we need to use DISTINCT here since both parent-child
1324: --can be assigned to same type in FII_FC_TYPE_NORM_ASSIGN

Line 1327: Insert into FII_FC_TYPE_ASSGNS_GT

1323: --Note that we need to use DISTINCT here since both parent-child
1324: --can be assigned to same type in FII_FC_TYPE_NORM_ASSIGN
1325: g_phase := 'insert records into the denorm TMP table';
1326:
1327: Insert into FII_FC_TYPE_ASSGNS_GT
1328: (fin_cat_type_code,
1329: fin_category_id,
1330: top_node_flag)
1331: select distinct

Line 1342: FII_UTIL.Write_Log('Inserted ' || l_sql_rowcount || ' rows into FII_FC_TYPE_ASSGNS_GT');

1338:
1339: l_sql_rowcount := SQL%ROWCOUNT;
1340:
1341: IF (FIIDIM_Debug) THEN
1342: FII_UTIL.Write_Log('Inserted ' || l_sql_rowcount || ' rows into FII_FC_TYPE_ASSGNS_GT');
1343: END IF;
1344:
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';

Line 1370: Insert into FII_FC_TYPE_ASSGNS_GT

1366: --....................................................................
1367:
1368: g_phase := 'Insert a new internal type (EXP)';
1369:
1370: Insert into FII_FC_TYPE_ASSGNS_GT
1371: (fin_cat_type_code,
1372: fin_category_id,
1373: top_node_flag)
1374: select distinct

Line 1378: from FII_FC_TYPE_ASSGNS_GT fct

1374: select distinct
1375: 'EXP',
1376: fct.fin_category_id,
1377: 'N'
1378: from FII_FC_TYPE_ASSGNS_GT fct
1379: where fct.fin_cat_type_code IN ('OE', 'TE', 'PE', 'CGS');
1380:
1381: IF (FIIDIM_Debug) THEN
1382: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FC_TYPE_ASSGNS_GT');

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

1378: from FII_FC_TYPE_ASSGNS_GT fct
1379: where fct.fin_cat_type_code IN ('OE', 'TE', 'PE', 'CGS');
1380:
1381: IF (FIIDIM_Debug) THEN
1382: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FC_TYPE_ASSGNS_GT');
1383: END IF;
1384:
1385: --Call FND_STATS to collect statistics after populating the table
1386: g_phase := 'gather_table_stats for FII_FC_TYPE_ASSGNS_GT';

Line 1386: g_phase := 'gather_table_stats for FII_FC_TYPE_ASSGNS_GT';

1382: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FC_TYPE_ASSGNS_GT');
1383: END IF;
1384:
1385: --Call FND_STATS to collect statistics after populating the table
1386: g_phase := 'gather_table_stats for FII_FC_TYPE_ASSGNS_GT';
1387:
1388: FND_STATS.gather_table_stats
1389: (ownname => g_schema_name,
1390: tabname => 'FII_FC_TYPE_ASSGNS_GT');

Line 1390: tabname => 'FII_FC_TYPE_ASSGNS_GT');

1386: g_phase := 'gather_table_stats for FII_FC_TYPE_ASSGNS_GT';
1387:
1388: FND_STATS.gather_table_stats
1389: (ownname => g_schema_name,
1390: tabname => 'FII_FC_TYPE_ASSGNS_GT');
1391:
1392: --Now to update the column TOP_NODE_FLAG
1393: --For a node with certain fin cat type, look at all nodes in the
1394: --hierarchy that have the node as the child. If there is only one

Line 1401: --UPDATE FII_FC_TYPE_ASSGNS_GT tab1

1397: g_phase := 'update the column TOP_NODE_FLAG';
1398:
1399: --Per suggestion from performance team,
1400: --rewrite the update statement
1401: --UPDATE FII_FC_TYPE_ASSGNS_GT tab1
1402: -- SET tab1.TOP_NODE_FLAG = 'Y'
1403: -- WHERE 1 = (select count(*)
1404: -- from FII_FC_TYPE_ASSGNS_GT tab2,
1405: -- FII_FULL_FIN_ITEM_HIERS hier

Line 1404: -- from FII_FC_TYPE_ASSGNS_GT tab2,

1400: --rewrite the update statement
1401: --UPDATE FII_FC_TYPE_ASSGNS_GT tab1
1402: -- SET tab1.TOP_NODE_FLAG = 'Y'
1403: -- WHERE 1 = (select count(*)
1404: -- from FII_FC_TYPE_ASSGNS_GT tab2,
1405: -- FII_FULL_FIN_ITEM_HIERS hier
1406: -- where tab2.fin_cat_type_code = tab1.fin_cat_type_code
1407: -- and hier.child_fin_cat_id = tab1.fin_category_id
1408: -- and hier.parent_fin_cat_id = tab2.fin_category_id );

Line 1410: UPDATE FII_FC_TYPE_ASSGNS_GT tab1

1406: -- where tab2.fin_cat_type_code = tab1.fin_cat_type_code
1407: -- and hier.child_fin_cat_id = tab1.fin_category_id
1408: -- and hier.parent_fin_cat_id = tab2.fin_category_id );
1409:
1410: UPDATE FII_FC_TYPE_ASSGNS_GT tab1
1411: SET tab1.TOP_NODE_FLAG = 'Y'
1412: WHERE (tab1.fin_cat_type_code,tab1.fin_category_id) IN
1413: (select /*+ ordered parallel(hier) */
1414: tab3.fin_cat_type_code,tab3.fin_category_id

Line 1415: from FII_FC_TYPE_ASSGNS_GT tab3,

1411: SET tab1.TOP_NODE_FLAG = 'Y'
1412: WHERE (tab1.fin_cat_type_code,tab1.fin_category_id) IN
1413: (select /*+ ordered parallel(hier) */
1414: tab3.fin_cat_type_code,tab3.fin_category_id
1415: from FII_FC_TYPE_ASSGNS_GT tab3,
1416: FII_FULL_FIN_ITEM_HIERS hier,
1417: FII_FC_TYPE_ASSGNS_GT tab2
1418: where tab2.fin_cat_type_code = tab3.fin_cat_type_code
1419: and hier.child_fin_cat_id = tab3.fin_category_id

Line 1417: FII_FC_TYPE_ASSGNS_GT tab2

1413: (select /*+ ordered parallel(hier) */
1414: tab3.fin_cat_type_code,tab3.fin_category_id
1415: from FII_FC_TYPE_ASSGNS_GT tab3,
1416: FII_FULL_FIN_ITEM_HIERS hier,
1417: FII_FC_TYPE_ASSGNS_GT tab2
1418: where tab2.fin_cat_type_code = tab3.fin_cat_type_code
1419: and hier.child_fin_cat_id = tab3.fin_category_id
1420: and hier.parent_fin_cat_id = tab2.fin_category_id
1421: group by tab3.fin_cat_type_code,

Line 1426: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_FC_TYPE_ASSGNS_GT');

1422: tab3.fin_category_id
1423: having count(*) = 1);
1424:
1425: IF (FIIDIM_Debug) THEN
1426: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_FC_TYPE_ASSGNS_GT');
1427: END IF;
1428:
1429: --Validate the denorm table by 2 business rules
1430: g_phase := 'Validate the denorm table by 2 business rules';

Line 1462: FROM FII_FC_TYPE_ASSGNS_GT;

1458: FII_USER_ID,
1459: SYSDATE,
1460: FII_USER_ID,
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;

Line 1478: FROM FII_FC_TYPE_ASSGNS_GT);

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:
1480: IF (FIIDIM_Debug) THEN
1481: FII_UTIL.Write_Log('Deleted ' || SQL%ROWCOUNT || ' rows from FII_FIN_CAT_TYPE_ASSGNS');
1482: END IF;

Line 1504: FROM FII_FC_TYPE_ASSGNS_GT

1500: FII_USER_ID,
1501: SYSDATE,
1502: FII_USER_ID,
1503: FII_LOGIN_ID
1504: FROM FII_FC_TYPE_ASSGNS_GT
1505: MINUS
1506: SELECT
1507: fin_cat_type_code,
1508: fin_category_id,