DBA Data[Home] [Help]

APPS.AHL_UC_TREE_PVT dependencies on FND_LOOKUP_VALUES

Line 582: fnd_lookup_values_vl F

578: l_pos_necessity_meaning fnd_lookups.meaning%TYPE;
579: CURSOR get_position_necessity(c_relationship_id NUMBER) IS
580: SELECT F.meaning
581: FROM ahl_mc_relationships A,
582: fnd_lookup_values_vl F
583: WHERE A.relationship_id = c_relationship_id
584: AND A.position_necessity_code = F.lookup_code (+)
585: AND F.lookup_type (+) = 'AHL_POSITION_NECESSITY';
586: BEGIN

Line 1089: l_mc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;

1085: l_relationship_id NUMBER;
1086: l_mc_header_id NUMBER;
1087: l_mc_name ahl_mc_headers_b.name%TYPE;
1088: l_mc_revision ahl_mc_headers_b.revision%TYPE;
1089: l_mc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
1090: l_root_instance_id NUMBER;
1091: l_root_relationship_id NUMBER;
1092: l_mc_top_rel_id NUMBER;
1093: l_parent_uc_header_id NUMBER;

Line 1111: l_root_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;

1107: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
1108: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
1109: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
1110: l_root_uc_header_id NUMBER;
1111: l_root_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
1112: l_root_active_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
1113: l_root_uc_ovn NUMBER;
1114: l_new_relationship_id NUMBER;
1115: --In order to check whether the instance belongs to a sub unit or an extra node branch

Line 1112: l_root_active_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;

1108: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
1109: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
1110: l_root_uc_header_id NUMBER;
1111: l_root_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
1112: l_root_active_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
1113: l_root_uc_ovn NUMBER;
1114: l_new_relationship_id NUMBER;
1115: --In order to check whether the instance belongs to a sub unit or an extra node branch
1116: CURSOR check_subuc_extra(c_instance_id NUMBER, c_top_instance_id NUMBER) IS