APPS.AHL_PRD_SERN_CHANGE_PVT dependencies on FND_LOOKUPS

Line 142: l_lookup_code fnd_lookups.lookup_code%TYPE DEFAULT NULL;

138: AND meaning = p_lookup_meaning
139: AND TRUNC(SYSDATE) >= TRUNC(NVL(start_date_active, SYSDATE))
140: AND TRUNC(SYSDATE) < TRUNC(NVL(end_date_active, SYSDATE+1));
141:
142: l_lookup_code fnd_lookups.lookup_code%TYPE DEFAULT NULL;
143: l_return_val BOOLEAN DEFAULT TRUE;
144:
145: BEGIN
146:

Line 498: l_lookup_code fnd_lookups.lookup_code%TYPE;

494: l_serialnum_change_rec Sernum_Change_Rec_Type := p_serialnum_change_rec;
495: l_instance_dtls_rec c_instance_details%ROWTYPE;
496: l_get_workorder_rec get_workorder_csr%ROWTYPE;
497: l_mtl_system_items_rec mtl_system_items_csr%ROWTYPE;
498: l_lookup_code fnd_lookups.lookup_code%TYPE;
499: l_item_instance_id NUMBER;
500: l_return_val BOOLEAN;
501: l_attribute_value_id NUMBER;
502: l_object_version_number NUMBER;