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: l_interchange_reason ahl_item_associations_tl.interchange_reason%TYPE;
2284:
2285: --Variables needed for CSI API call

Line 3147: fnd_lookups f

3143: ELSIF l_interchange_type_code = '1-WAY INTERCHANGEABLE' THEN
3144: FND_MESSAGE.set_name('AHL', 'AHL_UC_1WAY_ITEM_INSTALLED');
3145: SELECT f.meaning INTO l_position_ref_meaning
3146: FROM ahl_mc_relationships a,
3147: fnd_lookups f
3148: WHERE a.relationship_id = p_x_uc_instance_rec.relationship_id
3149: AND f.lookup_code (+) = A.position_ref_code
3150: AND f.lookup_type (+) = 'AHL_POSITION_REFERENCE' ;
3151: --Here always use p_x_uc_instance_rec.relationship_id instead of l_top_relationship_id because

Line 3340: l_meaning fnd_lookups.meaning%TYPE;

3336: i NUMBER := 0;
3337: l_subscript NUMBER DEFAULT 0;
3338: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%TYPE;
3339: l_item_assoc_id NUMBER;
3340: l_meaning fnd_lookups.meaning%TYPE;
3341: l_parent_uc_header_id NUMBER;
3342: l_parent_instance_id NUMBER;
3343: l_root_uc_header_id NUMBER;
3344: l_root_instance_id NUMBER;

Line 3352: l_position_ref_meaning fnd_lookups.meaning%TYPE;

3348: l_root_instance_ou NUMBER;
3349: l_instance_ou NUMBER;
3350: l_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
3351: l_active_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
3352: l_position_ref_meaning fnd_lookups.meaning%TYPE;
3353: l_interchange_type_code ahl_item_associations_b.interchange_type_code%TYPE;
3354: l_interchange_reason ahl_item_associations_tl.interchange_reason%TYPE;
3355:
3356: --Variables needed for CSI API call

Line 4289: fnd_lookups f

4285: ELSIF l_interchange_type_code = '1-WAY INTERCHANGEABLE' THEN
4286: FND_MESSAGE.set_name('AHL', 'AHL_UC_1WAY_ITEM_INSTALLED');
4287: SELECT f.meaning INTO l_position_ref_meaning
4288: FROM ahl_mc_relationships a,
4289: fnd_lookups f
4290: WHERE a.relationship_id = p_relationship_id
4291: AND f.lookup_code (+) = A.position_ref_code
4292: AND f.lookup_type (+) = 'AHL_POSITION_REFERENCE' ;
4293: FND_MESSAGE.set_token('POSITION', l_position_ref_meaning);