APPS.FII_FIN_CAT_MAINTAIN_PKG dependencies on FII_DIM_HIER_HELP_GT

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

632: and flex_value = p_root_node;
633:
634: l_flex_value_set_id := p_vset_id;
635:
636: /* Inserting parent in a gt table: FII_DIM_HIER_HELP_GT */
637: g_index := g_index + 1;
638: insert into FII_DIM_HIER_HELP_GT
639: ( IDX,
640: FLEX_VALUE_ID,

Line 638: insert into FII_DIM_HIER_HELP_GT

634: l_flex_value_set_id := p_vset_id;
635:
636: /* Inserting parent in a gt table: FII_DIM_HIER_HELP_GT */
637: g_index := g_index + 1;
638: insert into FII_DIM_HIER_HELP_GT
639: ( IDX,
640: FLEX_VALUE_ID,
641: FLEX_VALUE_SET_ID,
642: NEXT_LEVEL_FLEX_VALUE_ID, SORT_ORDER)

Line 649: update FII_DIM_HIER_HELP_GT

645: l_flex_value_id,
646: l_flex_value_set_id,
647: l_flex_value_id, l_sort_order);
648:
649: update FII_DIM_HIER_HELP_GT
650: set NEXT_LEVEL_FLEX_VALUE_ID= l_flex_value_id,
651: SORT_ORDER= l_sort_order
652: where IDX = g_index - 1;
653:

Line 685: FROM FII_DIM_HIER_HELP_GT pp;

681: pp.next_level_flex_value_id),
682: decode(pp.idx, g_index,
683: direct_children_rec.sort_order,
684: pp.sort_order)
685: FROM FII_DIM_HIER_HELP_GT pp;
686:
687: --Recursive Call.
688: INSERT_IMM_CHILD_NODES (direct_children_rec.flex_value_set_id,
689: direct_children_rec.flex_value);

Line 694: delete from FII_DIM_HIER_HELP_GT where idx = g_index;

690:
691: END LOOP;
692:
693: /* Deleting parent from the gt table */
694: delete from FII_DIM_HIER_HELP_GT where idx = g_index;
695: g_index := g_index - 1;
696:
697: FND_CONCURRENT.Af_Commit;
698: