[Home] [Help]
1145: BEGIN
1146:
1147: l_schema_name := FII_UTIL.get_schema_name('FII');
1148: EXECUTE IMMEDIATE 'truncate table '||l_schema_name||'.fii_pmv_aggrt_gt';
1149: EXECUTE IMMEDIATE 'truncate table '||l_schema_name||'.fii_pmv_non_aggrt_gt';
1150:
1151: /* We set this variable to yes, (whenever current procedure is invoked from EA page portlets) OR
1152: (view by <> UD1/UD2 AND param values for Fin category, UD1, UD2, ledger are 'All' */
1153:
1478: cc_id_aggrt_plsql(y),par_fin_cat_id_aggrt_plsql(y),fin_cat_id_aggrt_plsql(y),
1479: par_fud1_id_aggrt_plsql(y),fud1_id_aggrt_plsql(y),fud2_id_aggrt_plsql(y),
1480: aggrt_viewbydescription(y), sort_order_aggrt_plsql(y));
1481: FORALL z in 1..g_non_aggrt_gt_record_count
1482: INSERT INTO fii_pmv_non_aggrt_gt VALUES (comp_id_nonaggrt_plsql(z),cc_id_nonaggrt_plsql(z),fin_cat_id_nonaggrt_plsql(z),
1483: fud1_id_nonaggrt_plsql(z),fud2_id_nonaggrt_plsql(z),nonaggrt_viewbydescription(z),sort_order_nonaggrt_plsql(z));
1484:
1485: IF l_debug_mode = 'Y' THEN
1486: insert_into_debug_tables;
1511: cc_id_aggrt_plsql(y),par_fin_cat_id_aggrt_plsql(y),fin_cat_id_aggrt_plsql(y),
1512: par_fud1_id_aggrt_plsql(y),fud1_id_aggrt_plsql(y),fud2_id_aggrt_plsql(y),
1513: aggrt_viewbydescription(y), sort_order_aggrt_plsql(y));
1514: FORALL z in 1..g_non_aggrt_gt_record_count
1515: INSERT INTO fii_pmv_non_aggrt_gt VALUES (comp_id_nonaggrt_plsql(z),cc_id_nonaggrt_plsql(z),fin_cat_id_nonaggrt_plsql(z),
1516: fud1_id_nonaggrt_plsql(z),fud2_id_nonaggrt_plsql(z),nonaggrt_viewbydescription(z),sort_order_nonaggrt_plsql(z));
1517:
1518: IF l_debug_mode = 'Y' THEN
1519: insert_into_debug_tables;
1552: cc_id_aggrt_plsql(y),par_fin_cat_id_aggrt_plsql(y),fin_cat_id_aggrt_plsql(y),
1553: par_fud1_id_aggrt_plsql(y),fud1_id_aggrt_plsql(y),fud2_id_aggrt_plsql(y),
1554: aggrt_viewbydescription(y), sort_order_aggrt_plsql(y));
1555: FORALL i in 1..g_non_aggrt_gt_record_count
1556: INSERT INTO fii_pmv_non_aggrt_gt VALUES (comp_id_nonaggrt_plsql(i),cc_id_nonaggrt_plsql(i),fin_cat_id_nonaggrt_plsql(i),
1557: fud1_id_nonaggrt_plsql(i),fud2_id_nonaggrt_plsql(i),nonaggrt_viewbydescription(i),sort_order_nonaggrt_plsql(i));
1558:
1559: IF l_debug_mode = 'Y' THEN
1560: insert_into_debug_tables;
1595: cc_id_aggrt_plsql(y),par_fin_cat_id_aggrt_plsql(y),fin_cat_id_aggrt_plsql(y),
1596: par_fud1_id_aggrt_plsql(y),fud1_id_aggrt_plsql(y),fud2_id_aggrt_plsql(y),
1597: aggrt_viewbydescription(y), sort_order_aggrt_plsql(y));
1598: FORALL i in 1..g_non_aggrt_gt_record_count
1599: INSERT INTO fii_pmv_non_aggrt_gt VALUES (comp_id_nonaggrt_plsql(i),cc_id_nonaggrt_plsql(i),fin_cat_id_nonaggrt_plsql(i),
1600: fud1_id_nonaggrt_plsql(i),fud2_id_nonaggrt_plsql(i),nonaggrt_viewbydescription(i),sort_order_nonaggrt_plsql(i));
1601:
1602: IF l_debug_mode = 'Y' THEN
1603: insert_into_debug_tables;
1625: l_non_agrt_table_count NUMBER := 0;
1626: l_schema_name VARCHAR2(10) := FII_UTIL.get_schema_name('FII');
1627:
1628: BEGIN
1629: -- g_aggrt_gt_record_count and g_non_aggrt_gt_record_count are the number of records in fii_pmv_aggrt_gt and fii_pmv_non_aggrt_gt tables respectively
1630:
1631: IF g_aggrt_gt_record_count > 0 THEN -- it means that fii_pmv_aggrt_gt has been populated so only now, we should insert records into fii_debug_agrt table
1632:
1633: BEGIN
1690: '||g_session_id||','''||g_region_code||'''
1691: FROM fii_pmv_aggrt_gt gt';
1692: END IF;
1693:
1694: IF g_non_aggrt_gt_record_count > 0 THEN -- it means that fii_pmv_non_aggrt_gt has been populated so only now, we should insert records into fii_debug_non_agrt table
1695:
1696: BEGIN
1697:
1698: SELECT 1 INTO l_non_agrt_table_count
1737: gt.fud2_id,
1738: gt.viewby,
1739: gt.sort_order,
1740: '||g_session_id||','''||g_region_code||'''
1741: FROM fii_pmv_non_aggrt_gt gt';
1742: END IF;
1743:
1744: END insert_into_debug_tables;
1745: