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 FND_LOOKUP_VALUES

Line 596: fnd_lookup_values_vl F

592: l_pos_necessity_meaning fnd_lookups.meaning%TYPE;
593: CURSOR get_position_necessity(c_relationship_id NUMBER) IS
594: SELECT F.meaning
595: FROM ahl_mc_relationships A,
596: fnd_lookup_values_vl F
597: WHERE A.relationship_id = c_relationship_id
598: AND A.position_necessity_code = F.lookup_code (+)
599: AND F.lookup_type (+) = 'AHL_POSITION_NECESSITY';
600: BEGIN

Line 1131: l_mc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;

1127: l_relationship_id NUMBER;
1128: l_mc_header_id NUMBER;
1129: l_mc_name ahl_mc_headers_b.name%TYPE;
1130: l_mc_revision ahl_mc_headers_b.revision%TYPE;
1131: l_mc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
1132: l_root_instance_id NUMBER;
1133: l_root_relationship_id NUMBER;
1134: l_mc_top_rel_id NUMBER;
1135: l_parent_uc_header_id NUMBER;

Line 1153: l_root_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;

1149: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
1150: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
1151: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
1152: l_root_uc_header_id NUMBER;
1153: l_root_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
1154: l_root_active_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
1155: l_root_uc_ovn NUMBER;
1156: l_new_relationship_id NUMBER;
1157: --In order to check whether the instance belongs to a sub unit or an extra node branch

Line 1154: l_root_active_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;

1150: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
1151: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
1152: l_root_uc_header_id NUMBER;
1153: l_root_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
1154: l_root_active_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
1155: l_root_uc_ovn NUMBER;
1156: l_new_relationship_id NUMBER;
1157: --In order to check whether the instance belongs to a sub unit or an extra node branch
1158: CURSOR check_subuc_extra(c_instance_id NUMBER, c_top_instance_id NUMBER) IS