eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_UC_TREE_PVT dependencies on AHL_MC_PATH_POSITION_PVT

Line 700: -- API ahl_mc_path_position_pvt.get_posref_for_uc need not be called for root

696: -- SATHAPLI::Enigma code changes, 02-Sep-2008 - populate the ata_code for the root
697: x_uc_descendant_tbl(total_i).ata_code := l_root_ata_code;
698:
699: -- rbhavsar::FP Bug# 6268202, performance tuning
700: -- API ahl_mc_path_position_pvt.get_posref_for_uc need not be called for root
701: -- x_uc_descendant_tbl(total_i).position_reference := ahl_mc_path_position_pvt.get_posref_for_uc(l_uc_header_id, l_root_relationship_id);
702: OPEN get_pos_ref_csr(l_root_relationship_id);
703: FETCH get_pos_ref_csr INTO l_pos_ref;
704: CLOSE get_pos_ref_csr;

Line 701: -- x_uc_descendant_tbl(total_i).position_reference := ahl_mc_path_position_pvt.get_posref_for_uc(l_uc_header_id, l_root_relationship_id);

697: x_uc_descendant_tbl(total_i).ata_code := l_root_ata_code;
698:
699: -- rbhavsar::FP Bug# 6268202, performance tuning
700: -- API ahl_mc_path_position_pvt.get_posref_for_uc need not be called for root
701: -- x_uc_descendant_tbl(total_i).position_reference := ahl_mc_path_position_pvt.get_posref_for_uc(l_uc_header_id, l_root_relationship_id);
702: OPEN get_pos_ref_csr(l_root_relationship_id);
703: FETCH get_pos_ref_csr INTO l_pos_ref;
704: CLOSE get_pos_ref_csr;
705: x_uc_descendant_tbl(total_i).position_reference := l_pos_ref;

Line 820: -- API ahl_mc_path_position_pvt.get_posref_for_uc need not be called if

816: -- SATHAPLI::Enigma code changes, 02-Sep-2008 - populate the ata_code for the non-extra node
817: x_uc_descendant_tbl(total_i).ata_code := l_get_mc_child.ata_code;
818:
819: -- rbhavsar::FP Bug# 6268202, performance tuning
820: -- API ahl_mc_path_position_pvt.get_posref_for_uc need not be called if
821: -- this relationship belongs to the root MC.
822: IF (l_get_mc_child.mc_header_id = l_root_mc_hdr_id) THEN
823: x_uc_descendant_tbl(total_i).position_reference := l_get_mc_child.pos_ref_meaning;
824: ELSE

Line 826: ahl_mc_path_position_pvt.get_posref_for_uc(l_uc_header_id, l_child_rel_tbl(i));

822: IF (l_get_mc_child.mc_header_id = l_root_mc_hdr_id) THEN
823: x_uc_descendant_tbl(total_i).position_reference := l_get_mc_child.pos_ref_meaning;
824: ELSE
825: x_uc_descendant_tbl(total_i).position_reference :=
826: ahl_mc_path_position_pvt.get_posref_for_uc(l_uc_header_id, l_child_rel_tbl(i));
827: END IF;
828:
829: x_uc_descendant_tbl(total_i).position_necessity := l_get_mc_child.pos_necessity;
830: x_uc_descendant_tbl(total_i).part_info := l_child_partinfo_tbl(i);

Line 886: -- API ahl_mc_path_position_pvt.get_posref_for_uc need not be called if

882: -- SATHAPLI::Enigma code changes, 02-Sep-2008 - populate the ata_code for the non-extra node
883: x_uc_descendant_tbl(total_i).ata_code := l_get_mc_child.ata_code;
884:
885: -- rbhavsar::FP Bug# 6268202, performance tuning
886: -- API ahl_mc_path_position_pvt.get_posref_for_uc need not be called if
887: -- this relationship belongs to the root MC.
888: IF (l_get_mc_child.mc_header_id = l_root_mc_hdr_id) THEN
889: l_root_mc_part := TRUE;
890: x_uc_descendant_tbl(total_i).position_reference := l_get_mc_child.pos_ref_meaning;

Line 894: ahl_mc_path_position_pvt.get_posref_for_uc(l_uc_header_id, l_get_mc_child.relationship_id);

890: x_uc_descendant_tbl(total_i).position_reference := l_get_mc_child.pos_ref_meaning;
891: ELSE
892: l_root_mc_part := FALSE;
893: x_uc_descendant_tbl(total_i).position_reference :=
894: ahl_mc_path_position_pvt.get_posref_for_uc(l_uc_header_id, l_get_mc_child.relationship_id);
895: END IF;
896:
897: x_uc_descendant_tbl(total_i).position_necessity := l_get_mc_child.pos_necessity;
898: x_uc_descendant_tbl(total_i).part_info := NULL;

Line 936: -- API ahl_mc_path_position_pvt.get_posref_for_uc need not be called if

932: -- SATHAPLI::Enigma code changes, 02-Sep-2008 - populate the ata_code for the non-extra node
933: x_uc_descendant_tbl(total_i).ata_code := l_get_mc_descendant.ata_code;
934:
935: -- rbhavsar::FP Bug# 6268202, performance tuning
936: -- API ahl_mc_path_position_pvt.get_posref_for_uc need not be called if
937: -- the ancestor relationship belongs to the root MC.
938: IF (l_root_mc_part) THEN
939: x_uc_descendant_tbl(total_i).position_reference := l_get_mc_descendant.pos_ref_meaning;
940: ELSE

Line 942: ahl_mc_path_position_pvt.get_posref_for_uc(l_uc_header_id, l_get_mc_descendant.relationship_id);

938: IF (l_root_mc_part) THEN
939: x_uc_descendant_tbl(total_i).position_reference := l_get_mc_descendant.pos_ref_meaning;
940: ELSE
941: x_uc_descendant_tbl(total_i).position_reference :=
942: ahl_mc_path_position_pvt.get_posref_for_uc(l_uc_header_id, l_get_mc_descendant.relationship_id);
943: END IF;
944:
945: x_uc_descendant_tbl(total_i).position_necessity := l_get_mc_descendant.pos_necessity;
946: x_uc_descendant_tbl(total_i).part_info := NULL;

Line 986: -- ahl_mc_path_position_pvt.get_posref_for_uc(l_uc_header_id, l_uc_children_tbl(i).relationship_id);

982: x_uc_descendant_tbl(total_i).parent_instance_id := l_non_leaf_node.instance_id;
983: x_uc_descendant_tbl(total_i).parent_rel_id := l_non_leaf_node.relationship_id;
984: x_uc_descendant_tbl(total_i).node_type := 'X';
985: x_uc_descendant_tbl(total_i).position_reference := NULL;
986: -- ahl_mc_path_position_pvt.get_posref_for_uc(l_uc_header_id, l_uc_children_tbl(i).relationship_id);
987: x_uc_descendant_tbl(total_i).position_necessity := NULL;
988: x_uc_descendant_tbl(total_i).part_info := l_child_partinfo_tbl(i);
989:
990: -- rbhavsar::FP Bug# 6268202, performance tuning

Line 1025: -- ahl_mc_path_position_pvt.get_posref_for_uc(l_uc_header_id, l_get_csi_child.relationship_id);

1021: x_uc_descendant_tbl(total_i).relationship_id := l_get_csi_child.relationship_id;
1022: x_uc_descendant_tbl(total_i).parent_instance_id := l_non_leaf_node.instance_id;
1023: x_uc_descendant_tbl(total_i).parent_rel_id := NULL;
1024: x_uc_descendant_tbl(total_i).position_reference := NULL;
1025: -- ahl_mc_path_position_pvt.get_posref_for_uc(l_uc_header_id, l_get_csi_child.relationship_id);
1026: x_uc_descendant_tbl(total_i).position_necessity := NULL;
1027: x_uc_descendant_tbl(total_i).part_info := l_get_csi_child.part_info;
1028:
1029: -- rbhavsar::FP Bug# 6268202, performance tuning