APPS.FII_LOB_MAINTAIN_PKG dependencies on FII_DIM_HIER_HELP_GT

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

640: and flex_value = p_root_node;
641:
642: l_flex_value_set_id := p_vset_id;
643:
644: /* Inserting parent in a gt table: FII_DIM_HIER_HELP_GT */
645: g_index := g_index + 1;
646: insert into FII_DIM_HIER_HELP_GT
647: ( IDX,
648: FLEX_VALUE_ID,

Line 646: insert into FII_DIM_HIER_HELP_GT

642: l_flex_value_set_id := p_vset_id;
643:
644: /* Inserting parent in a gt table: FII_DIM_HIER_HELP_GT */
645: g_index := g_index + 1;
646: insert into FII_DIM_HIER_HELP_GT
647: ( IDX,
648: FLEX_VALUE_ID,
649: FLEX_VALUE_SET_ID,
650: NEXT_LEVEL_FLEX_VALUE_ID)

Line 657: update FII_DIM_HIER_HELP_GT

653: l_flex_value_id,
654: l_flex_value_set_id,
655: l_flex_value_id);
656:
657: update FII_DIM_HIER_HELP_GT
658: set NEXT_LEVEL_FLEX_VALUE_ID = l_flex_value_id
659: where IDX = g_index - 1;
660:
661: FOR direct_children_rec IN direct_children_csr(p_vset_id, p_root_node)

Line 688: FROM FII_DIM_HIER_HELP_GT pp;

684: direct_children_rec.flex_value_set_id,
685: decode(pp.idx, g_index,
686: direct_children_rec.flex_value_id,
687: pp.next_level_flex_value_id)
688: FROM FII_DIM_HIER_HELP_GT pp;
689:
690: --Recursive Call.
691: INSERT_IMM_CHILD_NODES (direct_children_rec.flex_value_set_id,
692: direct_children_rec.flex_value);

Line 697: delete from FII_DIM_HIER_HELP_GT where idx = g_index;

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