APPS.FII_CC_MAINTAIN_PKG dependencies on FII_DIM_HIER_HELP_GT

Line 608: /* Inserting parent in a gt table: FII_DIM_HIER_HELP_GT */

604: and flex_value = p_root_node;
605:
606: l_flex_value_set_id := p_vset_id;
607:
608: /* Inserting parent in a gt table: FII_DIM_HIER_HELP_GT */
609:
610: g_index := g_index+1;
611:
612: insert into FII_DIM_HIER_HELP_GT

Line 612: insert into FII_DIM_HIER_HELP_GT

608: /* Inserting parent in a gt table: FII_DIM_HIER_HELP_GT */
609:
610: g_index := g_index+1;
611:
612: insert into FII_DIM_HIER_HELP_GT
613: ( IDX,
614: FLEX_VALUE_ID,
615: FLEX_VALUE_SET_ID,
616: NEXT_LEVEL_FLEX_VALUE_ID, SORT_ORDER)

Line 623: update FII_DIM_HIER_HELP_GT

619: l_flex_value_id,
620: l_flex_value_set_id,
621: l_flex_value_id, l_sort_order);
622:
623: update FII_DIM_HIER_HELP_GT
624: set NEXT_LEVEL_FLEX_VALUE_ID= l_flex_value_id,
625: SORT_ORDER= l_sort_order
626: where IDX = g_index - 1;
627:

Line 659: FROM FII_DIM_HIER_HELP_GT pp;

655: pp.next_level_flex_value_id),
656: decode(pp.idx, g_index,
657: direct_children_rec.sort_order,
658: pp.sort_order)
659: FROM FII_DIM_HIER_HELP_GT pp;
660:
661: --Recursive Call.
662: INSERT_IMM_CHILD_NODES (direct_children_rec.flex_value_set_id,
663: direct_children_rec.flex_value);

Line 668: delete from FII_DIM_HIER_HELP_GT where idx = g_index;

664:
665: END LOOP;
666:
667: /* Deleting parent from the gt table */
668: delete from FII_DIM_HIER_HELP_GT where idx = g_index;
669:
670: g_index := g_index-1;
671:
672: FND_CONCURRENT.Af_Commit;