APPS.FII_UDD1_MAINTAIN_PKG dependencies on FII_DIM_HIER_HELP_GT

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

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

Line 617: insert into FII_DIM_HIER_HELP_GT

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

Line 628: update FII_DIM_HIER_HELP_GT

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

Line 664: FROM FII_DIM_HIER_HELP_GT pp;

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

Line 673: delete from FII_DIM_HIER_HELP_GT where idx = g_index;

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