DBA Data[Home] [Help]

APPS.HZ_HIERARCHY_PUB dependencies on HZ_HIERARCHY_NODES_PKG

Line 271: hz_utility_v2pub.debug(p_message=>'HZ_HIERARCHY_NODES_PKG.insert_row (+) l_tp = '||l_tp||' l_lc = '||l_lc ,

267: end if;
268:
269: -- Debug info.
270: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
271: hz_utility_v2pub.debug(p_message=>'HZ_HIERARCHY_NODES_PKG.insert_row (+) l_tp = '||l_tp||' l_lc = '||l_lc ,
272: p_prefix=>l_debug_prefix,
273: p_msg_level=>fnd_log.level_procedure);
274: END IF;
275:

Line 276: HZ_HIERARCHY_NODES_PKG.Insert_Row(

272: p_prefix=>l_debug_prefix,
273: p_msg_level=>fnd_log.level_procedure);
274: END IF;
275:
276: HZ_HIERARCHY_NODES_PKG.Insert_Row(
277: X_ROWID => l_rowid,
278: X_HIERARCHY_TYPE => p_hierarchy_type,
279: X_PARENT_ID => p_node_id,
280: X_PARENT_TABLE_NAME => p_table_name,

Line 480: hz_utility_v2pub.debug(p_message=> 'HZ_HIERARCHY_NODES_PKG.insert_row (+) l_tp = '||l_tp||' l_lc = '||l_lc,

476: l_line_number := 19;
477:
478: -- Debug info.
479: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
480: hz_utility_v2pub.debug(p_message=> 'HZ_HIERARCHY_NODES_PKG.insert_row (+) l_tp = '||l_tp||' l_lc = '||l_lc,
481: p_prefix=>l_debug_prefix,
482: p_msg_level=>fnd_log.level_procedure);
483: END IF;
484:

Line 486: HZ_HIERARCHY_NODES_PKG.Insert_Row(

482: p_msg_level=>fnd_log.level_procedure);
483: END IF;
484:
485:
486: HZ_HIERARCHY_NODES_PKG.Insert_Row(
487: X_ROWID => l_rowid,
488: X_HIERARCHY_TYPE => p_hierarchy_type,
489: X_PARENT_ID => p_node_id,
490: X_PARENT_TABLE_NAME => p_table_name,

Line 766: HZ_HIERARCHY_NODES_PKG.Insert_Row(

762: -- Insert the direct link between AAA->BBB.
763: -- Since no duplicate record will be sent to this API, there is no need to check for the
764: -- existance of a record with same parent/child, even if there is one, it will have a
765: -- different period of time.
766: HZ_HIERARCHY_NODES_PKG.Insert_Row(
767: X_ROWID => l_direct_link_rowid,
768: X_HIERARCHY_TYPE => p_hierarchy_node_rec.hierarchy_type,
769: X_PARENT_ID => p_hierarchy_node_rec.parent_id,
770: X_PARENT_TABLE_NAME => p_hierarchy_node_rec.parent_table_name,

Line 940: HZ_HIERARCHY_NODES_PKG.Insert_Row(

936: -- X_STATUS value changed from NULL to l_status to insert row along with
937: -- actual relationship status.
938: IF l_level_number > 1 THEN
939: -- now insert the XXX->YYY link
940: HZ_HIERARCHY_NODES_PKG.Insert_Row(
941: X_ROWID => l_rowid,
942: X_HIERARCHY_TYPE => p_hierarchy_node_rec.hierarchy_type,
943: X_PARENT_ID => r_get_all_parents.parent_id,
944: X_PARENT_TABLE_NAME => r_get_all_parents.parent_table_name,