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 686: -- API ahl_mc_path_position_pvt.get_posref_for_uc need not be called for root

682: -- SATHAPLI::Enigma code changes, 02-Sep-2008 - populate the ata_code for the root
683: x_uc_descendant_tbl(total_i).ata_code := l_root_ata_code;
684:
685: -- rbhavsar::FP Bug# 6268202, performance tuning
686: -- API ahl_mc_path_position_pvt.get_posref_for_uc need not be called for root
687: -- 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);
688: OPEN get_pos_ref_csr(l_root_relationship_id);
689: FETCH get_pos_ref_csr INTO l_pos_ref;
690: CLOSE get_pos_ref_csr;

Line 687: -- 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);

683: x_uc_descendant_tbl(total_i).ata_code := l_root_ata_code;
684:
685: -- rbhavsar::FP Bug# 6268202, performance tuning
686: -- API ahl_mc_path_position_pvt.get_posref_for_uc need not be called for root
687: -- 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);
688: OPEN get_pos_ref_csr(l_root_relationship_id);
689: FETCH get_pos_ref_csr INTO l_pos_ref;
690: CLOSE get_pos_ref_csr;
691: x_uc_descendant_tbl(total_i).position_reference := l_pos_ref;

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

774: -- SATHAPLI::Enigma code changes, 02-Sep-2008 - populate the ata_code for the non-extra node
775: x_uc_descendant_tbl(total_i).ata_code := l_get_mc_child.ata_code;
776:
777: -- rbhavsar::FP Bug# 6268202, performance tuning
778: -- API ahl_mc_path_position_pvt.get_posref_for_uc need not be called if
779: -- this relationship belongs to the root MC.
780: IF (l_get_mc_child.mc_header_id = l_root_mc_hdr_id) THEN
781: x_uc_descendant_tbl(total_i).position_reference := l_get_mc_child.pos_ref_meaning;
782: ELSE

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

780: IF (l_get_mc_child.mc_header_id = l_root_mc_hdr_id) THEN
781: x_uc_descendant_tbl(total_i).position_reference := l_get_mc_child.pos_ref_meaning;
782: ELSE
783: x_uc_descendant_tbl(total_i).position_reference :=
784: ahl_mc_path_position_pvt.get_posref_for_uc(l_uc_header_id, l_child_rel_tbl(i));
785: END IF;
786:
787: x_uc_descendant_tbl(total_i).position_necessity := l_get_mc_child.pos_necessity;
788: x_uc_descendant_tbl(total_i).part_info := l_child_partinfo_tbl(i);

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

840: -- SATHAPLI::Enigma code changes, 02-Sep-2008 - populate the ata_code for the non-extra node
841: x_uc_descendant_tbl(total_i).ata_code := l_get_mc_child.ata_code;
842:
843: -- rbhavsar::FP Bug# 6268202, performance tuning
844: -- API ahl_mc_path_position_pvt.get_posref_for_uc need not be called if
845: -- this relationship belongs to the root MC.
846: IF (l_get_mc_child.mc_header_id = l_root_mc_hdr_id) THEN
847: l_root_mc_part := TRUE;
848: x_uc_descendant_tbl(total_i).position_reference := l_get_mc_child.pos_ref_meaning;

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

848: x_uc_descendant_tbl(total_i).position_reference := l_get_mc_child.pos_ref_meaning;
849: ELSE
850: l_root_mc_part := FALSE;
851: x_uc_descendant_tbl(total_i).position_reference :=
852: ahl_mc_path_position_pvt.get_posref_for_uc(l_uc_header_id, l_get_mc_child.relationship_id);
853: END IF;
854:
855: x_uc_descendant_tbl(total_i).position_necessity := l_get_mc_child.pos_necessity;
856: x_uc_descendant_tbl(total_i).part_info := NULL;

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

890: -- SATHAPLI::Enigma code changes, 02-Sep-2008 - populate the ata_code for the non-extra node
891: x_uc_descendant_tbl(total_i).ata_code := l_get_mc_descendant.ata_code;
892:
893: -- rbhavsar::FP Bug# 6268202, performance tuning
894: -- API ahl_mc_path_position_pvt.get_posref_for_uc need not be called if
895: -- the ancestor relationship belongs to the root MC.
896: IF (l_root_mc_part) THEN
897: x_uc_descendant_tbl(total_i).position_reference := l_get_mc_descendant.pos_ref_meaning;
898: ELSE

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

896: IF (l_root_mc_part) THEN
897: x_uc_descendant_tbl(total_i).position_reference := l_get_mc_descendant.pos_ref_meaning;
898: ELSE
899: x_uc_descendant_tbl(total_i).position_reference :=
900: ahl_mc_path_position_pvt.get_posref_for_uc(l_uc_header_id, l_get_mc_descendant.relationship_id);
901: END IF;
902:
903: x_uc_descendant_tbl(total_i).position_necessity := l_get_mc_descendant.pos_necessity;
904: x_uc_descendant_tbl(total_i).part_info := NULL;

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

940: x_uc_descendant_tbl(total_i).parent_instance_id := l_non_leaf_node.instance_id;
941: x_uc_descendant_tbl(total_i).parent_rel_id := l_non_leaf_node.relationship_id;
942: x_uc_descendant_tbl(total_i).node_type := 'X';
943: x_uc_descendant_tbl(total_i).position_reference := NULL;
944: -- ahl_mc_path_position_pvt.get_posref_for_uc(l_uc_header_id, l_uc_children_tbl(i).relationship_id);
945: x_uc_descendant_tbl(total_i).position_necessity := NULL;
946: x_uc_descendant_tbl(total_i).part_info := l_child_partinfo_tbl(i);
947:
948: -- rbhavsar::FP Bug# 6268202, performance tuning

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

979: x_uc_descendant_tbl(total_i).relationship_id := l_get_csi_child.relationship_id;
980: x_uc_descendant_tbl(total_i).parent_instance_id := l_non_leaf_node.instance_id;
981: x_uc_descendant_tbl(total_i).parent_rel_id := NULL;
982: x_uc_descendant_tbl(total_i).position_reference := NULL;
983: -- ahl_mc_path_position_pvt.get_posref_for_uc(l_uc_header_id, l_get_csi_child.relationship_id);
984: x_uc_descendant_tbl(total_i).position_necessity := NULL;
985: x_uc_descendant_tbl(total_i).part_info := l_get_csi_child.part_info;
986:
987: -- rbhavsar::FP Bug# 6268202, performance tuning