APPS.MSD_HIERARCHIES_PKG dependencies on MSD_LEVELS

Line 362: not exists(select level_id from msd_levels

358: and nvl(plan_type,-1) =nvl( to_char(x_plan_type),-1)
359: and parent_level_id = to_number(x_parent_level_id))
360: AND
361: /* child level is not topmost */
362: not exists(select level_id from msd_levels
363: where level_id = to_number(x_level_id)
364: and level_type_code = '1'
365: and nvl(plan_type,-1) =nvl( to_char(x_plan_type),-1) )
366: AND

Line 368: not exists(select level_id from msd_levels

364: and level_type_code = '1'
365: and nvl(plan_type,-1) =nvl( to_char(x_plan_type),-1) )
366: AND
367: /* parent level is not bottom-most */
368: not exists(select level_id from msd_levels
369: where level_id = to_number(x_parent_level_id)
370: and level_type_code = '2'
371: and nvl(plan_type,-1) =nvl( to_char(x_plan_type),-1) )
372: );

Line 382: lvl_type msd_levels.level_type_code%TYPE;

378:
379: function is_hierarchy_complete(hid number, p_plan_type varchar2 ) return boolean is
380:
381: lvl number;
382: lvl_type msd_levels.level_type_code%TYPE;
383: hcount number;
384: ctr number := 0;
385:
386: begin

Line 398: from msd_levels l, msd_hierarchies h

394: /* get bottom level */
395: begin
396: select l.level_id
397: into lvl
398: from msd_levels l, msd_hierarchies h
399: where h.hierarchy_id = hid
400: and l.dimension_code = h.dimension_code
401: and l.level_type_code = 2
402: and nvl(h.plan_type,-1) = nvl( p_plan_type,-1)

Line 419: from msd_hierarchy_levels mhl, msd_levels l

415: /* get parent of level in this hierarchy */
416: begin
417: select l.level_id, l.level_type_code
418: into lvl, lvl_type
419: from msd_hierarchy_levels mhl, msd_levels l
420: where mhl.level_id = lvl
421: and mhl.hierarchy_id = hid
422: and mhl.parent_level_id = l.level_id
423: and nvl(mhl.plan_type,-1) = nvl( p_plan_type,-1)