APPS.AHL_UC_INSTANCE_PVT dependencies on FND_LOOKUPS

Line 1320: l_lookup_code fnd_lookups.lookup_code%TYPE;

1316: l_serial_number_control NUMBER;
1317: l_mfg_date csi_iea_values.attribute_value%TYPE;
1318: l_mfg_date_rec_found VARCHAR2(1) DEFAULT 'Y';
1319: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%TYPE;
1320: l_lookup_code fnd_lookups.lookup_code%TYPE;
1321: l_item_assoc_id NUMBER;
1322: l_end_date DATE;
1323:
1324: --Variables needed for CSI API call

Line 2281: l_position_ref_meaning fnd_lookups.meaning%TYPE;

2277: l_new_instance_id NUMBER;
2278: l_new_csi_instance_ovn NUMBER;
2279: l_parent_uc_header_id NUMBER;
2280: l_parent_instance_id NUMBER;
2281: l_position_ref_meaning fnd_lookups.meaning%TYPE;
2282: l_interchange_type_code ahl_item_associations_b.interchange_type_code%TYPE;
2283:
2284: --Variables needed for CSI API call
2285: l_csi_instance_rec csi_datastructures_pub.instance_rec;

Line 3140: fnd_lookups f

3136: ELSIF l_interchange_type_code = '1-WAY INTERCHANGEABLE' THEN
3137: FND_MESSAGE.set_name('AHL', 'AHL_UC_1WAY_ITEM_INSTALLED');
3138: SELECT f.meaning INTO l_position_ref_meaning
3139: FROM ahl_mc_relationships a,
3140: fnd_lookups f
3141: WHERE a.relationship_id = p_x_uc_instance_rec.relationship_id
3142: AND f.lookup_code (+) = A.position_ref_code
3143: AND f.lookup_type (+) = 'AHL_POSITION_REFERENCE' ;
3144: --Here always use p_x_uc_instance_rec.relationship_id instead of l_top_relationship_id because

Line 3330: l_meaning fnd_lookups.meaning%TYPE;

3326: i NUMBER := 0;
3327: l_subscript NUMBER DEFAULT 0;
3328: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%TYPE;
3329: l_item_assoc_id NUMBER;
3330: l_meaning fnd_lookups.meaning%TYPE;
3331: l_parent_uc_header_id NUMBER;
3332: l_parent_instance_id NUMBER;
3333: l_root_uc_header_id NUMBER;
3334: l_root_instance_id NUMBER;

Line 3342: l_position_ref_meaning fnd_lookups.meaning%TYPE;

3338: l_root_instance_ou NUMBER;
3339: l_instance_ou NUMBER;
3340: l_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
3341: l_active_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
3342: l_position_ref_meaning fnd_lookups.meaning%TYPE;
3343: l_interchange_type_code ahl_item_associations_b.interchange_type_code%TYPE;
3344:
3345: --Variables needed for CSI API call
3346: l_csi_party_rec csi_datastructures_pub.party_rec;

Line 4268: fnd_lookups f

4264: ELSIF l_interchange_type_code = '1-WAY INTERCHANGEABLE' THEN
4265: FND_MESSAGE.set_name('AHL', 'AHL_UC_1WAY_ITEM_INSTALLED');
4266: SELECT f.meaning INTO l_position_ref_meaning
4267: FROM ahl_mc_relationships a,
4268: fnd_lookups f
4269: WHERE a.relationship_id = p_relationship_id
4270: AND f.lookup_code (+) = A.position_ref_code
4271: AND f.lookup_type (+) = 'AHL_POSITION_REFERENCE' ;
4272: FND_MESSAGE.set_token('POSITION', l_position_ref_meaning);