[Home] [Help]
60: fudb.personal_flag,
61: fudb.read_only_flag,
62: fudb.object_version_number
63: FROM fem_user_dim1_b fudb,
64: fem_user_dim1_hier fudh
65: WHERE fudh.hierarchy_obj_def_id = l_hierarchy_obj_def_id
66: AND fudh.parent_id <> fudh.child_id
67: AND fudh.parent_value_set_id = fudb.value_set_id
68: AND fudb.user_dim1_id = fudh.parent_id
339: sysdate,
340: g_fnd_login_id ,
341: 1,
342: 'N'
343: FROM fem_user_dim1_hier fudh,
344: fem_user_dim1_b fudb,
345: fem_user_dim1_b fudb1
346: WHERE fudh.hierarchy_obj_def_id = l_hierarchy_obj_def_id
347: AND fudh.parent_id <> fudh.child_id
417: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
418: fnd_log.STRING(fnd_log.level_procedure,
419: g_pkg_name || '.' || l_api_name,
420: 'Insert existing hierarchy members '
421: ||' into fem_user_dim1_hier_T ');
422: END IF;
423:
424: INSERT INTO fem_user_dim1_hier_t
425: (hierarchy_object_name,
420: 'Insert existing hierarchy members '
421: ||' into fem_user_dim1_hier_T ');
422: END IF;
423:
424: INSERT INTO fem_user_dim1_hier_t
425: (hierarchy_object_name,
426: hierarchy_obj_def_display_name,
427: parent_display_code,
428: parent_value_set_display_code,
439: l_vs_display_code,
440: 1,
441: 'LOAD',
442: USERENV('LANG')
443: FROM fem_user_dim1_hier fudh,
444: fem_object_definition_tl fodt,
445: fem_object_catalog_tl foct,
446: fem_user_dim1_b parent,
447: fem_user_dim1_b child
458:
459: l_submit_req := SQL%ROWCOUNT;
460: g_no_rows := NVL(SQL%ROWCOUNT,0);
461:
462: INSERT INTO fem_user_dim1_hier_t
463: (hierarchy_object_name,
464: hierarchy_obj_def_display_name,
465: parent_display_code,
466: parent_value_set_display_code,
478: l_vs_display_code ,
479: 1,
480: 'LOAD',
481: USERENV('LANG')
482: FROM fem_user_dim1_hier_t fudh
483: WHERE fudh.hierarchy_object_name = p_hierarchy_name
484: AND fudh.hierarchy_obj_def_display_name = p_version_name
485: AND fudh.parent_display_code <> fudh.child_display_code
486: AND fudh.parent_value_set_display_code = fudh.child_value_set_display_code;