APPS.MSD_HIERARCHIES_PKG dependencies on MSD_HIERARCHY_LEVELS

Line 253: where exists(select 1 from msd_hierarchy_levels

249:
250: -- check if any hierarchy levels exist that were updated by !seed
251: begin
252: select 1 into h_mod from dual
253: where exists(select 1 from msd_hierarchy_levels
254: where hierarchy_id = to_number(x_HIERARCHY_id)
255: and nvl( plan_type,-1) = nvl( to_char(x_plan_type),-1)
256: and last_updated_by <> 1);
257: exception

Line 265: from MSD_HIERARCHY_LEVELS

261:
262: begin
263: select LAST_UPDATED_BY, LAST_UPDATE_DATE
264: into db_luby, db_ludate
265: from MSD_HIERARCHY_LEVELS
266: where HIERARCHY_ID = to_number(x_HIERARCHY_id)
267: and level_id = to_number(x_level_id)
268: and parent_level_id = to_number(x_parent_level_id)
269: and nvl( plan_type,-1) = nvl( to_char(x_plan_type),-1) ;

Line 281: update MSD_HIERARCHY_LEVELS set

277: if ((x_custom_mode = 'FORCE') or
278: ((f_luby = 0) and (db_luby = 1)) or
279: ((f_luby = db_luby) and (f_ludate > db_ludate)))
280: then
281: update MSD_HIERARCHY_LEVELS set
282: relationship_view = x_RELATIONSHIP_VIEW,
283: level_value_column = x_LEVEL_VALUE_COLUMN,
284: level_value_pk_column = x_LEVEL_VALUE_PK_COLUMN,
285: level_value_desc_column = x_LEVEL_VALUE_DESC_COLUMN,

Line 310: insert into MSD_HIERARCHY_LEVELS(

306: running in FORCE mode */
307: if ((x_custom_mode = 'FORCE') or
308: not(is_hierarchy_complete(to_number(X_HIERARCHY_ID),to_char(x_plan_type))))
309: then
310: insert into MSD_HIERARCHY_LEVELS(
311: HIERARCHY_ID,
312: PLAN_TYPE ,
313: LEVEL_ID,
314: PARENT_LEVEL_ID,

Line 350: not exists(select level_id from msd_hierarchy_levels

346: (x_custom_mode = 'FORCE')
347: OR
348: (
349: /* child level does not already have a parent */
350: not exists(select level_id from msd_hierarchy_levels
351: where HIERARCHY_ID = to_number(x_HIERARCHY_id)
352: and nvl(plan_type,-1) =nvl( to_char(x_plan_type),-1)
353: and level_id = to_number(x_level_id))
354: AND

Line 356: not exists(select level_id from msd_hierarchy_levels

352: and nvl(plan_type,-1) =nvl( to_char(x_plan_type),-1)
353: and level_id = to_number(x_level_id))
354: AND
355: /* parent level does not already have a child */
356: not exists(select level_id from msd_hierarchy_levels
357: where HIERARCHY_ID = to_number(x_HIERARCHY_id)
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

Line 390: from msd_hierarchy_levels

386: begin
387: /* get bound on hierarchy levels */
388: select count(*)
389: into hcount
390: from msd_hierarchy_levels
391: where hierarchy_id = hid
392: and nvl(plan_type,-1) =nvl( p_plan_type,-1) ;
393:
394: /* get bottom level */

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)