APPS.FII_UDD2_MAINTAIN_PKG dependencies on FII_DIM_HIER_HELP_GT

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

610: and flex_value = p_root_node;
611:
612: l_flex_value_set_id := p_vset_id;
613:
614: /* Inserting parent in a gt table: FII_DIM_HIER_HELP_GT */
615:
616: g_index := g_index+1;
617:
618: insert into FII_DIM_HIER_HELP_GT

Line 618: insert into FII_DIM_HIER_HELP_GT

614: /* Inserting parent in a gt table: FII_DIM_HIER_HELP_GT */
615:
616: g_index := g_index+1;
617:
618: insert into FII_DIM_HIER_HELP_GT
619: ( IDX,
620: FLEX_VALUE_ID,
621: FLEX_VALUE_SET_ID,
622: NEXT_LEVEL_FLEX_VALUE_ID, SORT_ORDER)

Line 629: update FII_DIM_HIER_HELP_GT

625: l_flex_value_id,
626: l_flex_value_set_id,
627: l_flex_value_id, l_sort_order);
628:
629: update FII_DIM_HIER_HELP_GT
630: set NEXT_LEVEL_FLEX_VALUE_ID= l_flex_value_id,
631: SORT_ORDER= l_sort_order
632: where IDX = g_index - 1;
633:

Line 665: FROM FII_DIM_HIER_HELP_GT pp;

661: pp.next_level_flex_value_id),
662: decode(pp.idx, g_index,
663: direct_children_rec.sort_order,
664: pp.sort_order)
665: FROM FII_DIM_HIER_HELP_GT pp;
666:
667: --Recursive Call.
668: INSERT_IMM_CHILD_NODES (direct_children_rec.flex_value_set_id,
669: direct_children_rec.flex_value);

Line 674: delete from FII_DIM_HIER_HELP_GT where idx = g_index;

670:
671: END LOOP;
672:
673: /* Deleting parent from the gt table */
674: delete from FII_DIM_HIER_HELP_GT where idx = g_index;
675:
676: g_index := g_index-1;
677:
678: FND_CONCURRENT.Af_Commit; --commit