APPS.AHL_UTIL_UC_PKG dependencies on FND_LOOKUPS

Line 700: l_pos_ref_code fnd_lookups.lookup_code%TYPE;

696: l_uom_rate NUMBER;
697: l_quantity NUMBER;
698: l_assoc_rec_found BOOLEAN DEFAULT FALSE;
699:
700: l_pos_ref_code fnd_lookups.lookup_code%TYPE;
701: l_pos_ref_meaning fnd_lookups.meaning%TYPE;
702: l_debug_key VARCHAR2(60) := 'ahl.plsql.AHL_UTIL_UC_PKG.Validate_for_Position';
703:
704: BEGIN

Line 701: l_pos_ref_meaning fnd_lookups.meaning%TYPE;

697: l_quantity NUMBER;
698: l_assoc_rec_found BOOLEAN DEFAULT FALSE;
699:
700: l_pos_ref_code fnd_lookups.lookup_code%TYPE;
701: l_pos_ref_meaning fnd_lookups.meaning%TYPE;
702: l_debug_key VARCHAR2(60) := 'ahl.plsql.AHL_UTIL_UC_PKG.Validate_for_Position';
703:
704: BEGIN
705: x_item_assoc_id := NULL;

Line 1016: FROM ahl_relationships_vl posn, fnd_lookups f

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

Line 1054: l_position_ref_meaning FND_LOOKUPS.meaning%TYPE;

1050: l_inventory_org_id NUMBER;
1051: l_quantity NUMBER;
1052: l_inventory_revision csi_item_instances.inventory_revision%TYPE;
1053: l_uom_code csi_item_instances.unit_of_measure%TYPE;
1054: l_position_ref_meaning FND_LOOKUPS.meaning%TYPE;
1055: l_item_assoc_id NUMBER;
1056: l_part_posn_ref_code FND_LOOKUPS.lookup_code%TYPE;
1057: l_instance_number csi_item_instances.instance_number%TYPE;
1058:

Line 1056: l_part_posn_ref_code FND_LOOKUPS.lookup_code%TYPE;

1052: l_inventory_revision csi_item_instances.inventory_revision%TYPE;
1053: l_uom_code csi_item_instances.unit_of_measure%TYPE;
1054: l_position_ref_meaning FND_LOOKUPS.meaning%TYPE;
1055: l_item_assoc_id NUMBER;
1056: l_part_posn_ref_code FND_LOOKUPS.lookup_code%TYPE;
1057: l_instance_number csi_item_instances.instance_number%TYPE;
1058:
1059: --l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AHL_API_FILE_DEBUG_ON'),'N');
1060: l_debug VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;