APPS.FII_GL_COMCCH_C dependencies on FII_COM_CC_MAPPINGS1_GT

Line 266: g_phase := 'Insert into FII_COM_CC_MAPPINGS1_GT by INCREMENTAL_LOAD';

262: If g_debug_flag = 'Y' then
263: FII_MESSAGE.Func_Ent('FII_GL_COMCCH_C.INCREMENTAL_LOAD');
264: END IF;
265:
266: g_phase := 'Insert into FII_COM_CC_MAPPINGS1_GT by INCREMENTAL_LOAD';
267:
268: INSERT /*+ append*/ INTO FII_COM_CC_MAPPINGS1_GT
269: ( COMPANY_COST_CENTER_ORG_ID ,
270: COST_CENTER_ID ,

Line 268: INSERT /*+ append*/ INTO FII_COM_CC_MAPPINGS1_GT

264: END IF;
265:
266: g_phase := 'Insert into FII_COM_CC_MAPPINGS1_GT by INCREMENTAL_LOAD';
267:
268: INSERT /*+ append*/ INTO FII_COM_CC_MAPPINGS1_GT
269: ( COMPANY_COST_CENTER_ORG_ID ,
270: COST_CENTER_ID ,
271: COMPANY_ID ,
272: MANAGER_ID ,

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

288: WHERE dim.company_cost_center_org_id <> -1
289: and dim.company_cost_center_org_id = ct.CCC_ORG_ID (+);
290:
291: If g_debug_flag = 'Y' then
292: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_COM_CC_MAPPINGS1_GT');
293: END IF;
294:
295: COMMIT;
296:

Line 487: UPDATE FII_COM_CC_MAPPINGS1_GT dim

483: If g_debug_flag = 'Y' then
484: fii_util.write_log('Update LOB_ID for DBI50');
485: End if;
486:
487: UPDATE FII_COM_CC_MAPPINGS1_GT dim
488: SET dim.LOB_ID = NVL(
489: (SELECT NVL(x.c ,-1 )
490: FROM
491: (select lob.LINE_OF_BUSINESS a ,

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

502: AND x.b = dim.COMPANY_COST_CENTER_ORG_ID), dim.LOB_ID)
503: WHERE dim.lob_id = G_UNASSIGNED_LOB_ID ;
504:
505: If g_debug_flag = 'Y' then
506: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_COM_CC_MAPPINGS1_GT');
507: END IF;
508:
509: else
510:

Line 521: UPDATE FII_COM_CC_MAPPINGS1_GT dim

517: If g_debug_flag = 'Y' then
518: fii_util.write_log('Update LOB_ID for DBI60 and above');
519: End if;
520:
521: UPDATE FII_COM_CC_MAPPINGS1_GT dim
522: SET dim.LOB_ID = NVL(
523: (select decode (lob.b, 'GL_BALANCING', dim.company_id, dim.cost_center_id)
524: from FII_COM_CC_MAPPINGS_GT dim1,
525: (select map.chart_of_accounts_id a,

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

542: ), dim.LOB_ID)
543: WHERE dim.lob_id = G_UNASSIGNED_LOB_ID ;
544:
545: If g_debug_flag = 'Y' then
546: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_COM_CC_MAPPINGS1_GT');
547: END IF;
548:
549: end if;
550:

Line 554: Update FII_COM_CC_MAPPINGS1_GT dim

550:
551: g_phase := 'Update parent_manager_id by INCREMENTAL_LOAD_LOB_MERGE';
552:
553: -- Update parent_manager_id
554: Update FII_COM_CC_MAPPINGS1_GT dim
555: Set dim.parent_manager_id =
556: NVL((select mgr.mgr_id
557: from FII_CC_MGR_HIER_GT mgr
558: where mgr.mgr_level = G_AGGREGATION_LEVELS

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

558: where mgr.mgr_level = G_AGGREGATION_LEVELS
559: and mgr.emp_id = dim.manager_id), dim.manager_id);
560:
561: If g_debug_flag = 'Y' then
562: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_COM_CC_MAPPINGS1_GT');
563: END IF;
564:
565: g_phase := 'Update parent_lob_id by INCREMENTAL_LOAD_LOB_MERGE';
566:

Line 569: Update FII_COM_CC_MAPPINGS1_GT dim

565: g_phase := 'Update parent_lob_id by INCREMENTAL_LOAD_LOB_MERGE';
566:
567: -- Update parent_lob_id, we pick the parent with max level
568: -- (the nearest parent in pruned hierarchy)
569: Update FII_COM_CC_MAPPINGS1_GT dim
570: Set dim.parent_lob_id =
571: NVL((select v.parent_lob_id
572: from (select flob.parent_lob_id, flob.child_lob_id, lob.child_level
573: from fii_full_lob_hiers flob,

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

577: where v.child_lob_id = dim.lob_id
578: and rownum = 1), dim.lob_id);
579:
580: If g_debug_flag = 'Y' then
581: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_COM_CC_MAPPINGS1_GT');
582: END IF;
583:
584: --Incrementally populate fii_com_cc_mappings for both new and old lob assignments
585:

Line 597: from FII_COM_CC_MAPPINGS1_GT

593: VALID_MGR_FLAG ,
594: LOB_ID,
595: PARENT_MANAGER_ID,
596: PARENT_LOB_ID
597: from FII_COM_CC_MAPPINGS1_GT
598: minus
599: select COMPANY_COST_CENTER_ORG_ID ,
600: COST_CENTER_ID ,
601: COMPANY_ID ,