APPS.AHL_UTIL_UC_PKG dependencies on FND_LOOKUPS

Line 705: l_pos_ref_code fnd_lookups.lookup_code%TYPE;

701: l_uom_rate NUMBER;
702: l_quantity NUMBER;
703: l_assoc_rec_found BOOLEAN DEFAULT FALSE;
704:
705: l_pos_ref_code fnd_lookups.lookup_code%TYPE;
706: l_pos_ref_meaning fnd_lookups.meaning%TYPE;
707: l_debug_key VARCHAR2(60) := 'ahl.plsql.AHL_UTIL_UC_PKG.Validate_for_Position';
708:
709: BEGIN

Line 706: l_pos_ref_meaning fnd_lookups.meaning%TYPE;

702: l_quantity NUMBER;
703: l_assoc_rec_found BOOLEAN DEFAULT FALSE;
704:
705: l_pos_ref_code fnd_lookups.lookup_code%TYPE;
706: l_pos_ref_meaning fnd_lookups.meaning%TYPE;
707: l_debug_key VARCHAR2(60) := 'ahl.plsql.AHL_UTIL_UC_PKG.Validate_for_Position';
708:
709: BEGIN
710: x_item_assoc_id := NULL;

Line 1021: FROM ahl_relationships_vl posn, fnd_lookups f

1017:
1018: -- Cursor to get position ref code.
1019: CURSOR ahl_relationships_csr1 (p_mc_relationship_id IN NUMBER) IS
1020: SELECT posn.position_ref_code, f.meaning
1021: FROM ahl_relationships_vl posn, fnd_lookups f
1022: WHERE posn.relationship_id = p_mc_relationship_id
1023: AND posn.position_ref_code = f.lookup_code;
1024:
1025: -- Define part record structure.

Line 1059: l_position_ref_meaning FND_LOOKUPS.meaning%TYPE;

1055: l_inventory_org_id NUMBER;
1056: l_quantity NUMBER;
1057: l_inventory_revision csi_item_instances.inventory_revision%TYPE;
1058: l_uom_code csi_item_instances.unit_of_measure%TYPE;
1059: l_position_ref_meaning FND_LOOKUPS.meaning%TYPE;
1060: l_item_assoc_id NUMBER;
1061: l_part_posn_ref_code FND_LOOKUPS.lookup_code%TYPE;
1062: l_instance_number csi_item_instances.instance_number%TYPE;
1063:

Line 1061: l_part_posn_ref_code FND_LOOKUPS.lookup_code%TYPE;

1057: l_inventory_revision csi_item_instances.inventory_revision%TYPE;
1058: l_uom_code csi_item_instances.unit_of_measure%TYPE;
1059: l_position_ref_meaning FND_LOOKUPS.meaning%TYPE;
1060: l_item_assoc_id NUMBER;
1061: l_part_posn_ref_code FND_LOOKUPS.lookup_code%TYPE;
1062: l_instance_number csi_item_instances.instance_number%TYPE;
1063:
1064: --l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AHL_API_FILE_DEBUG_ON'),'N');
1065: l_debug VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;